MyBatis的CRUD

1：namespace

namespace是Mapper接口的全限定类名

2：select

选择，查询语句：

id: namesapace中Mapper接口中的方法名

resultType: Sql执行的返回值

parameterType: 参数类型

根据id查询用户

UserMapper

User getUserById(int id);

UserMapper.xml

<?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.dong.mapper.UserMapper">
    <select id="getUserById" resultType="com.dong.pojo.User" parameterType="int">
    select * from user where id = #{id}
    </select>
</mapper>

测试

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

3：insert

UserMapper

void addUser(User user);

UserMapper.xml

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

测试

    @Test
    public void test2(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.addUser(new User(5,"迪丽热巴","666"));
        sqlSession.commit();//提交事务 不提交增加不上
        sqlSession.close();
    }

4：update

UserMapper

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

UserMapper.xml

<?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.dong.mapper.UserMapper">
    <update id="updateUser" parameterType="com.dong.pojo.User">
        update user set name = #{name},pwd = #{pwd}  where id = #{id};
    </update>
</mapper>

测试

 @Test
    public void test3(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.updateUser(new User(5,"迪丽热巴巴","888"));
        sqlSession.commit();
        sqlSession.close();
    }

5：delete

UserMapper

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

UserMapper.xml

<?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.dong.mapper.UserMapper">
    <delete id="deleteUser" parameterType="int">
        delete from user where id = #{id};
    </delete>
</mapper>

测试

  @Test
    public void test4(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.deleteUser(3);
        sqlSession.commit();
        sqlSession.close();
    }