mybatis篇二：mybatis实现简单的curd

2 、mybatis curd

id对应接口的方法名 参数类型是user时 写全类名 ,增删改默认返回类型为int，其参数类型是全类名的时候，其属性可以直接拿

2.1、新增用户

userDao

//增加一个用户
int  insertUser(User user);

UserMapper.xml

<insert id="insertUser" parameterType="com.hq.pojo.User" >
        insert  into user(id,name,password) values (#{id},#{name},#{password})
</insert>

测试用例

@Test
public void  insertUser(){
    SqlSession  sqlSession = MybatisUtils.getSqlSession();
    //方式一 执行
    try {
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        int res = userDao.insertUser(new User(3,"hqq",11));
        if (res ==1){
            System.out.println("插入成功");
        }else {
            System.out.println("插入失败");
        }
        sqlSession.commit();

    }catch (Exception e){
        System.out.println(e);
    }finally {
        sqlSession.close();
    }
}

2.2 、删除用户

UserDao.java

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

UserMapper.xml

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

public void  deleteUser(){
    SqlSession  sqlSession = MybatisUtils.getSqlSession();
    //方式一 执行
    try {
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        int res = userDao.deleteUser(3);
        if (res ==1){
            System.out.println("删除成功");
        }else {
            System.out.println("删除失败");
        }
        sqlSession.commit();

    }catch (Exception e){
        System.out.println(e);
    }finally {
        sqlSession.close();
    }
}

2.3 、根据用户id查询用户

UserDao.java

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

UserMapper.xml

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

2.4、更新用户

UserDao.java

//用户更新
int updateUser(User user);

UserMapper.xml

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

2.5 查询所有用户

UserDao.java

//    获取全部用户
     List<User> getUserList();

UserMapper.xml

 <select id="getUserList" resultType="com.hq.pojo.User">
                select * from user
    </select>