本文共 4529 字，大约阅读时间需要 15 分钟。

思路：搭建环境–》导入MyBatis–》编写代码–》测试

2.1：搭建环境

搭建数据库

CREATE DATABASE `mybatis`;USE `mybatis`;CREATE TABLE `user`( `id` INT(20) NOT NULL  PRIMARY KEY, `name` VARCHAR(30) DEFAULT NULL, `pwd` VARCHAR(30) DEFAULT NULL) ENGINE=INNODB  DEFAULT CHARSET=utf8;INSERT INTO `mybatis`.`user` 	(`id`, 	`name`, 	`pwd`	)	VALUES	('1', '徐源', '123456'),	('2', '张三', '798456'),	('3', 	'李四', '456123')

新建项目

       
   
    org.example
       
   
    Mybatis-Study
       
   
    1.0-SNAPSHOT
   
       
           
            
                
     
      mysql
                 
     
      mysql-connector-java
                
     
      5.1.47
             
            
            
                
     
      junit
                 
     
      junit
                 
     
      4.11
                 
     
      test
             
            
            
                
     
      org.mybatis
                 
     
      mybatis
                 
     
      3.5.5
             
                    
   

2.2创建一个模块

2.2.1 编写mybatis的核心配置文件

2.2.2编写mybatis工具类

package com.xuyuan.Utils;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import java.io.IOException;import java.io.InputStream;//sqlsessionFactory--》sqlsessionpublic class Utils {
       private  static SqlSessionFactory sqlSessionFactory;    static{
   //获取SqlSessionFactory        try {
               String resources="mybatis-config.xml";            InputStream inputStream= Resources.getResourceAsStream(resources);            SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);        } catch (IOException e) {
               e.printStackTrace();        }    }    // //获取SqlSession连接    public static SqlSession getSqlSession(){
           return sqlSessionFactory.openSession();    }}

2.3编写代码

package com.xuyuan.Pojo;public class User {
       private  int id;    private  String name;    private  String pwd;    @Override    public String toString() {
           return "User{" +                "id=" + id +                ", name='" + name + '\'' +                ", pwd='" + pwd + '\'' +                '}';    }    public User(int id, String name, String pwd) {
           this.id = id;        this.name = name;        this.pwd = pwd;    }    public User() {
       }    public int getId() {
           return id;    }    public void setId(int id) {
           this.id = id;    }    public String getName() {
           return name;    }    public void setName(String name) {
           this.name = name;    }    public String getPwd() {
           return pwd;    }    public void setPwd(String pwd) {
           this.pwd = pwd;    }}

Dao接口

package com.xuyuan.Dao;import com.xuyuan.Pojo.User;import java.util.List;public interface UserDao {
       List
   
     getUserList();}
   

接口实现类

   
       
            select * from mybatis.user      
   

测试

package com.xuyaun.Dao;import com.xuyuan.Dao.UserDao;import com.xuyuan.Pojo.User;import com.xuyuan.Utils.Utils;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import java.util.List;public class UserDaoTest {
       @Test    public void getUserList() {
           SqlSession session = Utils.getSqlSession();        //方法一:        //List
   
     users = session.selectList("com.kuang.mapper.UserMapper.selectUser");        //方法二:        UserDao mapper = session.getMapper(UserDao.class);        List
    
      users = mapper.getUserList();        for (User user: users){
               System.out.println(user);        }        session.close();    }}
    
   

       
            
                 
      
       src/main/java
                  
                      
       
        **/*.properties
                       
       
        **/*.xml
                   
                  
      
       false
              
             
                 
      
       src/main/resources
                  
                      
       
        **/*.properties
                       
       
        **/*.xml
                   
                  
      
       false
              
         
    
   

转载地址：https://blog.csdn.net/answero/article/details/106753715 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！