打印sql配置:
#配置mybatis打印sql
mybatis:
configuration:
log-impl: org.apache.ibatis.logging.log4j2.Log4j2Impl
#全局配置下划线到驼峰的映射
map-underscore-to-camel-case: true
#mapper层debug模式
logging:
level:
com.modules.service: debug
使用@select 注解模式注意:sql前后一定要写 <script></script>标签,否则if等标签都不解析
/**
*用户分页列表
*/
/*@Results(
id = "userMap",
value = {
@Result(column = "id",property = "id",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "open_id",property = "openId",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "union_id",property = "unionId",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "avatar",property = "avatar",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "nickname",property = "nickname",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "age",property = "age",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "sex",property = "sex",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "user_name",property = "userName",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "user_tel",property = "userTel",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "wx_address",property = "wxAddress",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "real_province",property = "realProvince",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "real_city",property = "realCity",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "real_area",property = "realArea",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "status",property = "status",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "type",property = "type",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
@Result(column = "token",property = "token",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "remark",property = "remark",javaType = String.class,jdbcType = JdbcType.VARCHAR),
@Result(column = "create_time",property = "createTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
@Result(column = "update_time",property = "updateTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
@Result(column = "last_login_time",property = "lastLoginTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
}
)*/
@Select({
"<script>",
"select * from g_user ",
"<where>",
"<if test='requestPageBean.params != null'>",
"<if test='requestPageBean.params.userName != null and requestPageBean.params.userName != \"\"'> and user_name like concat('%',#{requestPageBean.params.userName},'%')</if>",
"<if test='requestPageBean.params.nickname != null and requestPageBean.params.nickname != \"\"'> and nickname like concat('%',#{requestPageBean.params.userName},'%')</if>",
"</if>",
"</where>",
"order by create_time desc limit #{requestPageBean.limitStart,jdbcType=INTEGER},#{requestPageBean.pageSize,jdbcType=INTEGER}",
"</script>"
})
List<UserDto> pageList(@Param("requestPageBean") RequestPageBean<UserDto> requestPageBean);