页面可以根据Name和address来模糊查询,然后对模糊查询的结果分页。这样该怎么在xml里面拼装sql语句?
我是这样写的,但是有异常:
<select id="searchPublishingHouseList" parameterMap="publishinghousepage" resultClass="PublishingHouse" resultMap="publishinghouse">
<![CDATA[
select * from {
select rownum rn,t.* from
{
select * from tbPublishingHouse
<dynamic prepend="where">
<isNotEmpty property="name" prepend="and">
name like '%'||#name#||'%'
</isNotEmpty>
<isNotEmpty property="address" prepend="and">
address like '%'||#address#||'%'
</isNotEmpty>
</dynamic>
order by id
}t where rownum <=#pageEnd#}
where rn>#pageBegin#
]]>
</select>
我是这样写的,但是有异常:
<select id="searchPublishingHouseList" parameterMap="publishinghousepage" resultClass="PublishingHouse" resultMap="publishinghouse">
<![CDATA[
select * from {
select rownum rn,t.* from
{
select * from tbPublishingHouse
<dynamic prepend="where">
<isNotEmpty property="name" prepend="and">
name like '%'||#name#||'%'
</isNotEmpty>
<isNotEmpty property="address" prepend="and">
address like '%'||#address#||'%'
</isNotEmpty>
</dynamic>
order by id
}t where rownum <=#pageEnd#}
where rn>#pageBegin#
]]>
</select>
解决方案 »
- 如何struts2坐连接启动javascript而不刷新页面
- struts2如何得到上传文件类型
- servlet问题
- 一台机器同时登录多个用户session互相冲突如何解决?
- 谁那有J2EE API的中文帮助文档(100分的题目)!!!!!!!!!!
- 求助!使用CXF服务器出错
- 各位朋友,有没有用struts写的翻页程序,可否给我一份,学习学习,谢谢!
- 请教高人~
- jbuiler8的注册码或注册文件(*.slip)??
- 怎么获取IP地址库,此贴得火~~标题要长~~造福大家~~
- VSS 使用方法
- EJB3在SessionBean外部调用实体中外键的Get方法时抛出LazyInitializationException异常
呵呵,低级失误啊。谢谢。