MyBatis增删改查实现

增删改查

1. namespace：namespace的包名和Dao/Mapper接口的包名保持一致
2. select：选择查询

• id：就是对应的namespace中的方法名
• resultType：Sql语句执行的返回值
• parameterType：参数类型
• 接口：

 //根据Id查询
    User getUserById(int id);

• 实现：

<select id="getUserById" resultType="com.yf.pojo.User">
        select * from mybatis.user where id=#{id}
    </select>

• 测试：

 @Test
    public void test2(){
        SqlSession sqlSession=MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User userById = mapper.getUserById(2);
        System.out.println(userById);
        sqlSession.close();
}

3. insert

• 接口：

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

• 实现：

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

• 测试：

 @Test
    public void test3(){
        SqlSession sqlSession=MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.addUser(new User(4, "刘能", "654987"));
        sqlSession.commit();
        sqlSession.close();
}

4. update

• 接口：

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

• 实现：

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

• 测试：

@Test
    public void test4(){
        SqlSession sqlSession=MybatisUtils.getSqlSession();
        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        int user = mapper.updateUser(new User(6, "赵四", "445546"));
        if(user>0){
            System.out.println("修改成功");
            sqlSession.commit();
        }
        sqlSession.close();
    }

5. delete

• 接口：

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

• 实现：

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

• 测试：

public void test5(){
        SqlSession sqlSession=MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int user = mapper.deleteUser(5);
        if(user>0){
            System.out.println("删除成功");
            sqlSession.commit();
        }
        sqlSession.close();
    }