public interface UserMapper {
@Select("select * from user")
List<User> selectUsers();
@Select("select * from user limit #{startIndex}, #{offset}")
List<User> selectUsersByLimit(@Param("startIndex") int startIndex, @Param("offset") int offset);
@Insert("insert into user(name, address) values(#{name}, #{address})")
int insertUser(User user);
@Delete("delete from user where id = #{id}")
int deleteUserById(@Param("id") int id);
@Update("update user set name=#{name}, address=#{address} where id=#{id}")
int updateUser(User user);
}
${}
内保存的参数,需要在选形参列表中通过@Param
指出。当只有一个形参的时候,可以忽略