MyBatis学习（2）简单的增删改查CURD

查询select

添加Insert

修改update

删除delete

模糊查询

注意点

先写接口 然后再Mapper中写对应的SQL语句，最后在测试类中写测试语句

查询select

接口

    //查询全部用户
    List<User> getUserList();

Mapper.xml

    <!--select查询语句0-->
    <select id="getUserList" resultType="com.wu.pojo.User">
        select * from mybatis.user
    </select>

测试执行

    //查询一个用户
    @Test
    public void getuserById() {
        SqlSession sqlSession = Mybatisutils.getSqlSession();

        UserMapper userDao = sqlSession.getMapper(UserMapper.class);
        User user = userDao.getUserById(1);
        System.out.println(user);
        sqlSession.close();
    }

添加Insert

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

    <!--插入一条数据-->
    <insert id="addUser" parameterType="com.wu.pojo.User" >
        insert into mybatis.user (id, name, pwd) values (#{id},#{name},#{pwd})
    </insert>

    public void addUser(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int res = mapper.addUser(new User(4, "蔡佳鑫", "123456"));

        if (res>0){
            System.out.println("插入成功");
        }
        //提交事务
        sqlSession.commit();
        //关闭连接
        sqlSession.close();
    }

修改update

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

    <!--修改用户-->
    <update id="updateUser" parameterType="com.wu.pojo.User">
        update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id};
    </update>

    public void updateUser(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int res = mapper.updateUser(new User(4, "蔡佳鑫", "123456789"));

        if (res>0){
            System.out.println("修改成功");
        }
        sqlSession.commit();
        sqlSession.close();

    }

删除delete

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

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

    //删除用户
    @Test
    public void deleteUser(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.deleteUser(4);
        if (i>0){
            System.out.println("删除成功");
        }
        sqlSession.commit();
        sqlSession.close();
    }

模糊查询

    //模糊查询一个用户
    List<User> getUserlike(String value);

<!--模糊查询一个用户-->
    <select id="getUserlike" resultType="com.wu.pojo.User">
        select * from mybatis.user where name like "%"#{value}"%"
    </select>

    //模糊化查询
    @Test
    public void getUserlike() {
        //获取Session对象
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        //getMapper
        UserMapper userDao = sqlSession.getMapper(UserMapper.class);
        List<User> userList = userDao.getUserlike("吴");

        for (User user : userList){
            System.out.println(user);
        }

        sqlSession.close();
    }

注意点

增删改中需要提交事务 sqlSession.commit();