62,616
社区成员
发帖
与我相关
我的任务
分享
@Select({
"select",
"id, table_name, item_name, title, comment, status",
"from item_type",
"where id = #{id,jdbcType=BIGINT}"
})
@Results({
@Result(column="id", property="id", jdbcType=JdbcType.BIGINT, id=true),
@Result(column="table_name", property="tableName", jdbcType=JdbcType.VARCHAR),
@Result(column="item_name", property="itemName", jdbcType=JdbcType.VARCHAR),
@Result(column="title", property="title", jdbcType=JdbcType.VARCHAR),
@Result(column="comment", property="comment", jdbcType=JdbcType.VARCHAR),
@Result(column="status", property="status", jdbcType=JdbcType.VARCHAR)
})
ItemType selectByPrimaryKey(Long id);
@Select({
"select",
"id, table_name, item_name, title, comment, status",
"from item_type"
})
@Results({
@Result(column="id", property="id", jdbcType=JdbcType.BIGINT, id=true),
@Result(column="table_name", property="tableName", jdbcType=JdbcType.VARCHAR),
@Result(column="item_name", property="itemName", jdbcType=JdbcType.VARCHAR),
@Result(column="title", property="title", jdbcType=JdbcType.VARCHAR),
@Result(column="comment", property="comment", jdbcType=JdbcType.VARCHAR),
@Result(column="status", property="status", jdbcType=JdbcType.VARCHAR)
})
List<ItemType> selectAll();
#mybatis mapper驼峰映射
mybatis:
configuration:
mapUnderscoreToCamelCase: true