mybatis注解开发

/**
 * 查询所有用户   * @return
 */
@Select("select * from user")
@Results(id = "userMap", value = {@Result(id = true, column = "id", property = "userId"), @Result(column = "username", property = "userName"), @Result(column = "sex", property = "userSex"), @Result(column = "address", property = "userAddress"), @Result(column = "birthday", property = "userBirthday")})
List<User> findAll();

/**
 * 根据 id 查询一个用户   * @param userId   * @return
 */
@Select("select * from user where id = #{uid} ")
@ResultMap("userMap")
User findById(Integer userId);

/**
 * 更新操作   * @param user   * @return
 */
@Update("update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id =#{id} ")
int updateUser(User user);

/**
 * 删除用户   * @param userId   * @return
 */
@Delete("delete from user where id = #{uid} ")
int deleteUser(Integer userId);

/**
 * 查询使用聚合函数   * @return
 */
@Select("select count(*) from user ")
int findTotal();

/**
 * 模糊查询   * @param name   * @return
 */
@Select("select * from user where username like #{username} ")
List<User> findByName(String name);