Mybatis学习2：实现增删改查操作CRUD

//根据id查询用户
User selectUserById(int id);

    <select id="selectUserById" resultType="com.kuang.pojo.User">
       select * from user where id = #{id}
   </select>

    @Test
   public void tsetSelectUserById() {
       SqlSession session = MybatisUtils.getSession(); //获取SqlSession连接
       UserMapper mapper = session.getMapper(UserMapper.class);
       User user = mapper.selectUserById(1);
       System.out.println(user);
       session.close();
   }

    //添加一个用户
    int addUser(User user);

   <insert id="addUser" parameterType="com.kuang.pojo.User">
       insert into user (id,name,pwd) values (#{id},#{name},#{pwd})
   </insert>

   @Test
   public void testAddUser() {
       SqlSession session = MybatisUtils.getSession();
       UserMapper mapper = session.getMapper(UserMapper.class);
       User user = new User(5,"王五","zxcvbn");
       int i = mapper.addUser(user);
       System.out.println(i);
       session.commit(); //提交事务,重点!不写的话不会提交到数据库
       session.close();
   }

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

   <update id="updateUser" parameterType="com.kuang.pojo.User">
       update user set name=#{name},pwd=#{pwd} where id = #{id}
   </update>

   @Test
   public void testUpdateUser() {
       SqlSession session = MybatisUtils.getSession();
       UserMapper mapper = session.getMapper(UserMapper.class);
       User user = mapper.selectUserById(1);
       user.setPwd("asdfgh");
       int i = mapper.updateUser(user);
       System.out.println(i);
       session.commit(); //提交事务,重点!不写的话不会提交到数据库
       session.close();
   }

    //根据id删除用户
    int deleteUser(int id);

   <delete id="deleteUser" parameterType="int">
       delete from user where id = #{id}
   </delete>

   @Test
   public void testDeleteUser() {
       SqlSession session = MybatisUtils.getSession();
       UserMapper mapper = session.getMapper(UserMapper.class);
       int i = mapper.deleteUser(5);
       System.out.println(i);
       session.commit(); //提交事务,重点!不写的话不会提交到数据库
       session.close();
   }