81,094
社区成员
发帖
与我相关
我的任务
分享求助！mybatis between查询
<select id="listServerRole" parameterType="JfreeCharEntity" resultMap="jfreeCharEntityResultMap">
select count(id) as count,level from role
where level group by level
</select>
我要条件 level <= 30 这应该怎么写
select count(id) as count,level from role
where level group by level
</select>
我要条件 level <= 30 这应该怎么写
...全文
请发表友善的回复…
发表回复
yjflinchong 2012-06-27
- 打赏
- 举报
<if test="createTime1 !=null">
and mb.createTime >= #{createTime1}
</if>
<if test="createTime2 !=null">
and mb.createTime <= #{createTime2}
</if>
我项目中的一段配置。 供楼主参考吧
and mb.createTime >= #{createTime1}
</if>
<if test="createTime2 !=null">
and mb.createTime <= #{createTime2}
</if>
我项目中的一段配置。 供楼主参考吧
yjflinchong 2012-06-27
- 打赏
- 举报
level <= 30 这样就行了吧
beiouwolf 2012-06-27
- 打赏
- 举报
<select id="listServerRole" parameterType="JfreeCharEntity" resultMap="jfreeCharEntityResultMap">
<![CDATA[
select count(id) as count,level from role
where level <= 30 group by level
]]>
</select>
<![CDATA[
select count(id) as count,level from role
where level <= 30 group by level
]]>
</select>
