sql语句返回结果是一个类

最新推荐文章于 2024-07-05 03:48:28 发布

一朵风中摇曳的水仙花

最新推荐文章于 2024-07-05 03:48:28 发布

阅读量717

点赞数

分类专栏： Java 数据库 mysql 文章标签： sql

本文链接：https://blog.csdn.net/u012045045/article/details/78791779

版权

Java 同时被 3 个专栏收录

189 篇文章 0 订阅

订阅专栏

mysql

97 篇文章 3 订阅

订阅专栏

数据库

69 篇文章 0 订阅

订阅专栏

mapper
如下所示：

<select id="selectActivityDoPagination" parameterType="java.lang.String"
  resultMap="activity">
  select
ID ,
ACTIVITY_CODE ,
ACTIVITY_DESCRIPTION ,
INDIRECT_RECOMMEND ,
to_char(CREATE_TIME,'yyyy-mm-dd  hh24:mi:ss') CREATE_TIME,
to_char(LAST_MODIFIED,'yyyy-mm-dd hh24:mi:ss') LAST_MODIFIED  ,
BANNER_PATH
  from
  ${tableName}
  where 1=1
  <!-- 支持模糊查询 -->
  <if test="activityCode  != null and activityCode != ''">
      and ACTIVITY_CODE=#{activityCode}
  </if>
  <if test="activityName != null and activityName != ''">
   and ACTIVITY_NAME=#{activityName}
  </if>
  <if test="indirectRecommend != null and indirectRecommend != ''">
   and INDIRECT_RECOMMEND=#{indirectRecommend}
  </if>
  <if test="createTime != null and createTime != ''">
   and TO_CHAR(CREATE_TIME,'YYYY-MM-DD') = '${createTime}'
  </if>
  <if test="lastModified != null and lastModified != ''">
   and TO_CHAR(LAST_MODIFIED,'YYYY-MM-DD') = '${lastModified}'
  </if>
  order by ID asc
 </select>

 <resultMap id="activity" type="com.smp.model.Activity">
  <id column="ID" property="id" jdbcType="INTEGER" />
  <result column="ACTIVITY_CODE" property="activityCode" jdbcType="VARCHAR" />
  <result column="ACTIVITY_NAME" property="activityName" jdbcType="VARCHAR" />
  <result column="ACTIVITY_DESCRIPTION" property="activityDescription" jdbcType="VARCHAR" />
  <result column="INDIRECT_RECOMMEND" property="indirectRecommend" jdbcType="VARCHAR" />
  <result column="CREATE_TIME" property="createTime" jdbcType="BIGINT" />
  <result column="LAST_MODIFIED" property="lastModified" jdbcType="BIGINT" />
  <result column="BANNER_PATH" property="bannerPath"  jdbcType="VARCHAR" />
 </resultMap>

其中com.smp.model.Activity 对应的是项目中的一个POJO的实体类