MyBatis_CRUD增删改查

壹.在Mapper接口中添加方法

贰.编写Mapper配置文件

<!--传入的参数中的属性可通过#{}直接取出 parameterType为参数类型(地址)-->
    <!--查询-->
    <select id="getUserByID" resultType="cn.alan.POJO.User" parameterType="int">
        select * from mybatis.user where id = #{ID};
    </select>
    <!--增加-->
    <insert id="insertUser" parameterType="cn.alan.POJO.User">
        insert into mybatis.user (id,name,password) values (#{ID},#{Name},#{Password});
    </insert>
    <!--修改-->
    <update id="updateUserByID" parameterType="cn.alan.POJO.User">
        update mybatis.user set name = #{Name},password = #{Password} where id = #{ID};
    </update>
    <!--删除-->
    <delete id="deleteUserByID" parameterType="int">
        delete from mybatis.user where id = #{ID};
    </delete>

叁.编写测试类

注：增删改需要进行提交 即.commit()

@Test
    public void getUserByID() {
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        User user = userMapper.getUserByID(1);
        System.out.println(user.toString());

        sqlSession.close();
    }

    @Test
    public void insertUser() {
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        userMapper.insertUser(new User("0","zero","123456"));

        //增删改需要进行提交
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void updataUserByID() {
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        userMapper.updataUserByID(new User("0","zerozero","123"));

        //增删改需要进行提交
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void deleteUserByID() {
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        userMapper.deleteUserByID(0);

        //增删改需要进行提交
        sqlSession.commit();
        sqlSession.close();
    }

运行效果

查

增

改

删

注：若想不使用实体类作为参数，可使用Map接口