起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

12
返回列表 发新帖
楼主: xjtfq

[结贴] 不管我选择每页显示多少,都显示402条数据

[复制链接]

43

主题

135

帖子

318

积分

中级会员

Rank: 3Rank: 3

积分
318
QQ
 楼主| 发表于 2018-7-2 17:03:05 | 显示全部楼层
本帖最后由 xjtfq 于 2018-7-3 20:48 编辑
jishuang 发表于 2018-7-2 16:52
那肯定设置不对,4楼发的设置后重启tomcat运行功能就能打出来执行的sql

现在有了


2018-07-02 17:00:01 结束-WINDOW生成中间文件: /UI2/shebeixinxi/sbjbxx/process/sbyxwh/sbbyjl.w
2018-07-02 17:00:01 开始-中间文件生成缓存文件: /UI2/shebeixinxi/sbjbxx/process/sbyxwh/sbbyjl.w
2018-07-02 17:00:01 结束-中间文件生成缓存文件: /UI2/shebeixinxi/sbjbxx/process/sbyxwh/sbbyjl.w
2018-07-02 17:00:01 加载模块:/shebeixinxi/sbjbxx/process/sbyxwh ...
2018-07-02 17:00:02 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT sop.sQQ,sop.sMobilePhone,sop.sName FROM Sa_opperson sop where sop.sID = :currentPersonID()
  --> sql:SELECT  sop.SQQ AS sQQ, sop.SMOBILEPHONE AS sMobilePhone, sop.SNAME AS sName FROM sa_opperson sop  WHERE sop.SID =  ?
--> binds:[S942i5ek2ED5TFTwGnn]
2018-07-02 17:00:02 [SQL Time]sql 执行时间:40ms, exec KSQL: SELECT jbxx.* FROM SH_SBJBXX jbxx where jbxx.fSZGQ = '葡北采油工区'  and ( jbxx.fSBGLFL = '机泵' OR jbxx.fSBGLFL = '压缩机' OR jbxx.fSBGLFL = '注水泵' OR jbxx.fSBGLFL = '抽油机' OR jbxx.fSBGLFL = '锅炉' OR jbxx.fSBGLFL = '导热油炉' )
  --> sql:SELECT  jbxx.fID AS jbxx, jbxx.VERSION AS version, jbxx.FSBMC AS fSBMC, jbxx.FSBZBH AS fSBZBH, jbxx.FSBERPBH AS fSBERPBH, jbxx.FSBXH AS fSBXH, jbxx.FSBCCBH AS fSBCCBH, jbxx.FSBCCRQ AS fSBCCRQ, jbxx.FSJDWMC AS fSJDWMC, jbxx.FSJDWZZJGDM AS fSJDWZZJGDM, jbxx.FSJDWDZ AS fSJDWDZ, jbxx.FSJDWYB AS fSJDWYB, jbxx.FZZDWMC AS fZZDWMC, jbxx.FZZDWZZJGDM AS fZZDWZZJGDM, jbxx.FZZDWDZ AS fZZDWDZ, jbxx.FZZDWYB AS fZZDWYB, jbxx.FCQDWMC AS fCQDWMC, jbxx.FCQDWZZJGDM AS fCQDWZZJGDM, jbxx.FCQDWDZ AS fCQDWDZ, jbxx.FCQDWYB AS fCQDWYB, jbxx.FGYSMC AS fGYSMC, jbxx.FGYSZZJGDM AS fGYSZZJGDM, jbxx.FGYSDZ AS fGYSDZ, jbxx.FGYSYB AS fGYSYB, jbxx.FZCBH AS fZCBH, jbxx.FZCYZ AS fZCYZ, jbxx.FXYNX AS fXYNX, jbxx.FCZL AS fCZL, jbxx.FABCLB AS fABCLB, jbxx.FSBRHFL AS fSBRHFL, jbxx.FSBGLFL AS fSBGLFL, jbxx.FTZSBBJ AS fTZSBBJ, jbxx.FSBZTJCFL AS fSBZTJCFL, jbxx.FSBJMFDS AS fSBJMFDS, jbxx.FSBDMFDS AS fSBDMFDS, jbxx.FSBJDRQ AS fSBJDRQ, jbxx.FGLJGXS AS fGLJGXS, jbxx.FSJGZYL AS fSJGZYL, jbxx.FXKSYYL AS fXKSYYL, jbxx.FEDCL AS fEDCL, jbxx.FJZCKWD AS fJZCKWD, jbxx.FJRFS AS fJRFS, jbxx.FRLZL AS fRLZL, jbxx.FGLYT AS fGLYT, jbxx.FSYZT AS fSYZT, jbxx.FRSFS AS fRSFS, jbxx.FSCLFS AS fSCLFS, jbxx.FCYFS AS fCYFS, jbxx.FCZFS AS fCZFS, jbxx.FXYCCFS AS fXYCCFS, jbxx.FDWSLSL AS fDWSLSL, jbxx.FSZRYSL AS fSZRYSL, jbxx.FRQNJ AS fRQNJ, jbxx.FTTCL AS fTTCL, jbxx.FFTCL AS fFTCL, jbxx.FNCCL AS fNCCL, jbxx.FJTCL AS fJTCL, jbxx.FTTHD AS fTTHD, jbxx.FFTHD AS fFTHD, jbxx.FNCHD AS fNCHD, jbxx.FJTHD AS fJTHD, jbxx.FRQRJ AS fRQRJ, jbxx.FRQG AS fRQG, jbxx.FKTZL AS fKTZL, jbxx.FNJZL AS fNJZL, jbxx.FCZZL AS fCZZL, jbxx.FYWBWJR AS fYWBWJR, jbxx.FKTSJYL AS fKTSJYL, jbxx.FKTSJWD AS fKTSJWD, jbxx.FKTZGYL AS fKTZGYL, jbxx.FGCSJYL AS fGCSJYL, jbxx.FGCSJWD AS fGCSJWD, jbxx.FGCZGYL AS fGCZGYL, jbxx.FJTSJYL AS fJTSJYL, jbxx.FJTSJWD AS fJTSJWD, jbxx.FJTZGYL AS fJTZGYL, jbxx.FKCJZ AS fKCJZ, jbxx.FGCJZ AS fGCJZ, jbxx.FJTJZ AS fJTJZ, jbxx.FYCZM AS fYCZM, jbxx.FYCKDDJ AS fYCKDDJ, jbxx.FYCCYFS AS fYCCYFS, jbxx.FGCPH AS fGCPH, jbxx.FGCJGXS AS fGCJGXS, jbxx.FGCDPHM AS fGCDPHM, jbxx.FJBPL AS fJBPL, jbxx.FJBPLDW AS fJBPLDW, jbxx.FJBXL AS fJBXL, jbxx.FJBNH AS fJBNH, jbxx.FJBNHDW AS fJBNHDW, jbxx.FJBNHZL AS fJBNHZL, jbxx.FJBZGL AS fJBZGL, jbxx.FJBGLDW AS fJBGLDW, jbxx.FJBCCGG AS fJBCCGG, jbxx.FZL AS fZL, jbxx.FJBZLDW AS fJBZLDW, jbxx.FJSZK AS fJSZK, jbxx.FSYQK AS fSYQK, jbxx.FKTSJLY AS fKTSJLY, jbxx.FSBGLJB AS fSBGLJB, jbxx.FZSBBJ AS fZSBBJ, jbxx.FSZGQ AS fSZGQ, jbxx.FAZQK AS fAZQK, jbxx.FAZWZ AS fAZWZ, jbxx.FSBTYRQ AS fSBTYRQ, jbxx.FATTACHMENTEDITOR AS fAttachmentEditor, jbxx.FSBZP AS fSBZP FROM SH_SBJBXX jbxx  WHERE  (jbxx.FSZGQ = ?) AND ( (jbxx.FSBGLFL = ?) OR (jbxx.FSBGLFL = ?) OR (jbxx.FSBGLFL = ?) OR (jbxx.FSBGLFL = ?) OR (jbxx.FSBGLFL = ?) OR (jbxx.FSBGLFL = ?) )
--
--> binds:[1000]
2018-07-02 17:00:06 [SQL Time]sql 执行时间:1ms, exec KSQL:
  --> sql:SELECT count(*) FROM SH_SBBYJL SH_SBBYJL  WHERE SH_SBBYJL.FSBBYJLSBZBH = ?
--> binds:[1000]
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2018-7-2 17:11:21 | 显示全部楼层
SELECT jbxx.* FROM SH_SBJBXX jbxx where jbxx.fSZGQ = '葡北采油工区'  and ( jbxx.fSBGLFL = '机泵' OR jbxx.fSBGLFL = '压缩机' OR jbxx.fSBGLFL = '注水泵' OR jbxx.fSBGLFL = '抽油机' OR jbxx.fSBGLFL = '锅炉' OR jbxx.fSBGLFL = '导热油炉' )

这个是你要执行的?确认是不是自己重写了queryAction,没有拼接limit去做分页查询
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

43

主题

135

帖子

318

积分

中级会员

Rank: 3Rank: 3

积分
318
QQ
 楼主| 发表于 2018-7-2 17:57:52 | 显示全部楼层
本帖最后由 xjtfq 于 2018-7-2 18:10 编辑
jishuang 发表于 2018-7-2 17:11
SELECT jbxx.* FROM SH_SBJBXX jbxx where jbxx.fSZGQ = '葡北采油工区'  and ( jbxx.fSBGLFL = '机泵' OR  ...

大概懂了,搜索怎么实现呢?
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2018-7-3 09:27:17 | 显示全部楼层
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

43

主题

135

帖子

318

积分

中级会员

Rank: 3Rank: 3

积分
318
QQ
 楼主| 发表于 2018-7-3 20:47:00 | 显示全部楼层
jishuang 发表于 2018-7-3 09:27
拼接filter,参考http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=54836&pid=165037992 ...

解决了,谢谢哈
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-7-13 23:20 , Processed in 0.055293 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表