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

1. Mybatis核心配置文件

2. User类

User.java

package domain;public class User {       private int id;    private String username;    private String password;    @Override    public String toString() {           return "User{" +                "id=" + id +                ", username='" + username + '\'' +                ", password='" + password + '\'' +                '}';    }    public int getId() {           return id;    }    public void setId(int id) {           this.id = id;    }    public String getUsername() {           return username;    }    public void setUsername(String username) {           this.username = username;    }    public String getPassword() {           return password;    }    public void setPassword(String password) {           this.password = password;    }}

3. 映射约束文件

   
   
   
        
            select * from sys_user    
        
    
             insert into sys_user values(#{id},null,#{username},#{password},null)    
    
        
    
             update sys_user set username = #{username} where id = #{id}    
    
        
    
             delete from sys_user where id = #{id}    
    
   

4. 测试类

import domain.User;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 org.junit.Test;import java.io.IOException;import java.io.InputStream;import java.util.List;public class MyBatisTest1 {   	//查询操作    @Test    public void test1() throws IOException {           //获得核心配置文件        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");        //获得sqlSession工厂对象        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);        //获得session会话对象        SqlSession sqlSession = sqlSessionFactory.openSession();        //执行操作        List
   
     list = sqlSession.selectList("userMapper.findAll");        //打印数据        System.out.println(list);        //释放资源        sqlSession.close();    }	//插入操作    @Test    public void test2() throws IOException {           User user = new User();        user.setUsername("tom");        user.setPassword("123ads");        //获得核心配置文件        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");        //获得sqlSession工厂对象        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);        //获得session会话对象        SqlSession sqlSession = sqlSessionFactory.openSession();        //执行更新操作，需要手动提交事务        sqlSession.insert("userMapper.save",user);        sqlSession.commit();        //释放资源        sqlSession.close();    }	//更新操作    @Test    public void test3() throws IOException {           User user = new User();        user.setUsername("erhuo");        user.setPassword("123ads");        user.setId(6);        //获得核心配置文件        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");        //获得sqlSession工厂对象        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);        //获得session会话对象        SqlSession sqlSession = sqlSessionFactory.openSession();        //执行更新操作，需要手动提交事务        sqlSession.update("userMapper.update",user);        sqlSession.commit();        //释放资源        sqlSession.close();    }	//删除操作    @Test    public void test4() throws IOException {           //获得核心配置文件        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");        //获得sqlSession工厂对象        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);        //获得session会话对象        SqlSession sqlSession = sqlSessionFactory.openSession();        //执行更新操作，需要手动提交事务        sqlSession.delete("userMapper.delete",6);        sqlSession.commit();        //释放资源        sqlSession.close();    }}