publicinterfaceIUserDao{/**
* 查询所有用户
* @return
*/@Select("select * from user")
List<User>findAll();/**
* 保存用户
* @param user
*/@Insert("insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday})")voidsaveUser(User user);/**
* 更新用户
* @param user
*/@Update("update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}")voidupdateUser(User user);/**
* 删除用户
* @param userId
*/@Delete("delete from user where id=#{id} ")voiddeleteUser(Integer userId);/**
* 根据id查询用户
* @param userId
* @return
*/@Select("select * from user where id=#{id} ")
User findById(Integer userId);/**
* 根据用户名称模糊查询
* @param username
* @return
*/// @Select("select * from user where username like #{username} ")@Select("select * from user where username like '%${value}%' ")
List<User>findUserByName(String username);/**
* 查询总用户数量
* @return
*/@Select("select count(*) from user ")intfindTotalUser();}