增删改查实现

1.编写接口
// 查询全部用户 List<User> getUserList();

2. 编写mapper中对应sql语句
   <select id="getUserList" resultType="com.kuang.pojo.User"> select * from mybatis.user </select>
3. 测试

点击查看代码

@Test
    public void test(){
        // 第一步，获取sqlSession对象
            SqlSession sqlSession = MybatisUtils.getSqlSession();
        // 方式一：getMapper（拿到UserDao或者UserMapper的类）
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        List<User> userList = userDao.getUserList();
        for (User user : userList) {
            System.out.println(user);

        }
        sqlSession.close();

    }

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

insert

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

update

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

delete

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

注意点

• 增删改要提交事务