怎么把这个sql语句的条件加入下面的xml 本帖最后由 seener_wal 于 2012-02-29 20:05:46 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from aj_jbxx where slsj >= '201101' and slsj <= '201103'select * from aj_jbxx where slsj between '20120102' and '20120202'上面2条语句中 随便一条语句中的条件加进去就可以 <select id="getObjList" resultClass="cases" parameterClass="cases"> select AJBH,AJMC, SLSJ,dic_trans(AJLB,'类别') AJLB from aj_jbxx where 1 = 1 <isNotEmpty prepend="AND" property="AJMC"> AJMC like '%$AJMC$%' </isNotEmpty> <isNotEmpty prepend="AND" property="AJLB"> AJLB = #AJLB# </isNotEmpty> <isNotEmpty prepend="AND" property="slsjFrom"> slsj>= #slsjFrom# </isNotEmpty> <isNotEmpty prepend="AND" property="slsjTo"> slsj< #slsjTo# </isNotEmpty> </select>你的参数类cases要声明slsjFrom和slsjTo或者用Map来传参数,灵活性强 <isNotEmpty prepend="AND" property="slsjTo"> slsj< #slsjTo# </isNotEmpty> => <isNotEmpty prepend="AND" property="slsjTo"> slsj < #slsjTo# </isNotEmpty> xml里面写不了 <= 转义的话=号要转吗 诡异的404错误 我在htm中使用锚点链接很正常,到了jsp页面中就不行了,这是怎么回事呢? 一对多的问题~~~~ Integer.parseInt出错!!!! linux下发布程序出错请高手指点 不用bean调用类 怎么不行啊 如何将text标签中的值赋给同一JSP页面中的变量里,在线等待,谢谢。 请教一个BUG,在线 如何让weblogic中部署的jar和war文件自动加载? java web snmp协议远程电源管理开发的思路 急!请教一个类型转换的问题!!!!!!!!! 省市二级联动 如何做验证???
select AJBH,AJMC, SLSJ,dic_trans(AJLB,'类别') AJLB from aj_jbxx
where 1 = 1
<isNotEmpty prepend="AND" property="AJMC">
AJMC like '%$AJMC$%'
</isNotEmpty>
<isNotEmpty prepend="AND" property="AJLB">
AJLB = #AJLB#
</isNotEmpty>
<isNotEmpty prepend="AND" property="slsjFrom">
slsj>= #slsjFrom#
</isNotEmpty>
<isNotEmpty prepend="AND" property="slsjTo">
slsj< #slsjTo#
</isNotEmpty>
</select>
你的参数类cases要声明slsjFrom和slsjTo
或者用Map来传参数,灵活性强
slsj< #slsjTo#
</isNotEmpty>
=>
<isNotEmpty prepend="AND" property="slsjTo">
slsj < #slsjTo#
</isNotEmpty>
xml里面写不了 <= 转义的话=号要转吗