在写mapper接口时,遇到数据库字段与实体类字段名称不一致时,可以使用@Results 注解
@Results({
@Result(property = "userName", column = "username"),
@Result(property = "addTime", column = "add_time")
})
例如:
/**
* Created by weijuer
* on 2017/05/25.
*/
@Mapper
public interface UserMapper {
@Select("SELECT * FROM weijuer_user")
@Results({
@Result(property = "userName", column = "username"),
@Result(property = "addTime", column = "add_time")
})
List<User> findAll();
@Select("SELECT * FROM weijuer_user WHERE NAME = #{username}")
User findByName(@Param("username") String userName);
@Insert("INSERT INTO weijuer_user(userName, AGE) VALUES(#{userName}, #{age})")
int insert(@Param("userName") String userName, @Param("age") Integer age);
}