spring boot 整合mybatis 中用注解实现的查询

package com.bysj.dao;

import com.bysj.model.User;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * Created by cxj on 2016/11/25.
 */

@Mapper
public interface UserMapper {

    @Select("select * from user where username =#{username}")
    User findUsersByName(String username);

    @Delete("delete from  user where id =#{id}")
     int deleteUserById(int id);

    @Delete("delete from  user where username =#{username}")
    int deleteUserByUserName(String username);

    @Insert("insert into user(username, password,mail) values(#{username}, #{password},#{mail})")
     int insert(User user);

    @Select("select * from user")
     List<User> getAllUsers();

    @Select("select * from user  limit #{start},#{end} ")
     List<User> getPageUsers(int start,int end);
   
    //分页查询不能使用 需要用xml写  这个不太有用
    @Update("update user set password=#{password},mail=#{mail} where id=#{id}")
    int updateUser(User user);

}