public interface IUserDao {@Select("select *from user")List<User> findAll();@Insert("insert into user(username,password,address,birthday)values(#{username},#{password},#{address},#{birthday})")void saveUser(User user);@Delete("delete from user where id=#{id}")void deleteUser(Integer userId);@Select("select *from user where username id=#{id}")User fingdById(Integer userId);/*** 根據(jù)用戶名模糊查詢* @param username* @return*/@Select("select *from user where username like '%${value}%'")List<User> findUserByName(String username);/*** 查詢總用戶數(shù)量* @return*/@Select("select count(*) from user")int findTotalUser();
}