MyBatis的增删改查

1.查询用户

• 创建user表对应的实体类

public class
User {
    private int id;
    private String name;
    private String pwd;

    public User() {
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }
}

• 创建MyBatis工具类
  这三句代码每次使用都要写的，所以给封装成一个工具类，调用直接返回一个SqlSession对象。

public class MybatisUtils {

    private static SqlSessionFactory sqlSessionFactory;

    static{

        InputStream inputStream = null;
        try {
            String resource = "mybatis-config.xml";
            inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
    }
}

• 创建接口UserMapper，里面定义一个查询方法获取所有用户

public interface UserMapper {
    //查询所有用户
    public List<User> getUserList();

}

• 写接口对应的XML（UserMapper.xml）最好和接口放在同一包下
  namespace：写的是对应的接口的全限定名
  select标签常用属性
  • id：接口中的方法名
  • resultType：返回值类型，没有起别名需要写全限定名
  • parameterType：参数类型，可以是基本类型，引用类型，实体类
  • resultMap：配置Java实体类中属性名和数据库中表的字段名不一致问题

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kuang.dao.UserMapper">

    <!--查询所有用户-->
    <select id="getUserList" resultType="com.kuang.pojo.User">
        select * from user;
    </select>

</mapper>

• 写junit单元测试

    @org.junit.Test
    public void testSelectList(){
    	//获取sqlSession 对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
		
		//绑定UserMapper类就可以使用UserMapper类里的方法了
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = mapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }

        sqlSession.close();
    }

2.添加用户

• 先在UserMapper接口中定义添加用户方法

	//插入用户
	public int insertUser(User user);

• 在UserMapper.xml中绑定接口方法并写sql

    <!--插入用户-->
    <insert id="insertUser" parameterType="com.kuang.pojo.User">
        insert into user values(#{id},#{name},#{pwd});
    </insert>

• 写junit单元测试

    @org.junit.Test
    public void insertUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.insertUser(new User(4,"哈哈","999"));

		//提交事务
        sqlSession.commit();
        sqlSession.close();
    }

注意点：增、删、改操作需要提交事务！

3.修改用户

-先在UserMapper接口中定义修改用户方法

    //修改用户
    public int updateUser(User user);

• 再在UserMapper.xml中绑定修改用户的方法并写sql

    <!--更新用户-->
    <update id="updateUser" parameterType="com.kuang.pojo.User">
        update user set name = #{name},pwd=#{pwd} where id=#{id};
    </update>

• 写单元测试

    @org.junit.Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.updateUser(new User(4,"呜呜","666"));
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }

4.删除用户

• 先在UserMapper接口中定义删除用户方法
  基本类型的参数前面都加上@Param注解
  这样sql中获取直接通过对应的名字“uid”获取

    //删除用户
    public int deleteUser(@Param("uid") int id);

• 再在UserMapper.xml中绑定删除用户的方法并写sql

    <!--删除用户-->
    <delete id="deleteUser" parameterType="_int">
        delete from user where id = #{uid};
    </delete>

• 写单元测试

    @org.junit.Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.deleteUser(4);

        sqlSession.commit();
        sqlSession.close();
    }

5.项目结构图