分页配置

tlkj

当我在如图所示的路径把红框位置改为true以后，没有实现一次加载20条的效果。还是查询的所有。

jishuang

bizData的limit怎么设置的？

tlkj

jishuang 发表于 2017-2-7 14:08
bizData的limit怎么设置的？

是默认的，没修改过。

jishuang

http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035
把执行的sql语句打印出来看看

tlkj

2017-02-07 14:28:45 [SQL Time]sql 执行时间：268ms, exec KSQL: SELECT ZH_RYDAXX.*,ST_STJBXX.STMC as st_stmc  FROM ZH_RYDAXX ZH_RYDAXX  optional  join ST_STJBXX ST_STJBXX on ZH_RYDAXX.STBH = ST_STJBXX.STBH WHERE (ZH_RYDAXX.RYQF = 0) LIMIT 0, 20
  --> sql:SELECT 1,  ZH_RYDAXX.BZ AS BZ, ZH_RYDAXX.DLSJ AS DLSJ, ZH_RYDAXX.DLZ AS DLZ, ZH_RYDAXX.GMSFHM AS GMSFHM, ZH_RYDAXX.GWMC AS GWMC, ZH_RYDAXX.GXSJ AS GXSJ, ZH_RYDAXX.GXZ AS GXZ, ZH_RYDAXX.MZ AS MZ, ZH_RYDAXX.RYBH AS RYBH, ZH_RYDAXX.RYFL AS RYFL, ZH_RYDAXX.RYLB AS RYLB, ZH_RYDAXX.RYLBQF AS RYLBQF, ZH_RYDAXX.RYQF AS RYQF, ZH_RYDAXX.SJH AS SJH, ZH_RYDAXX.STBH AS STBH, ZH_RYDAXX.SZBM AS SZBM, ZH_RYDAXX.SZDW AS SZDW, ZH_RYDAXX.SZGW AS SZGW, ZH_RYDAXX.XB AS XB, ZH_RYDAXX.XM AS XM, ZH_RYDAXX.XMJP AS XMJP, ZH_RYDAXX.YGKH AS YGKH, ZH_RYDAXX.fID AS ZH_RYDAXX, ZH_RYDAXX.ZT AS ZT, ST_STJBXX.STMC AS st_stmc, ZH_RYDAXX.version AS version FROM zh_rydaxx ZH_RYDAXX LEFT JOIN st_stjbxx ST_STJBXX ON ZH_RYDAXX.STBH = ST_STJBXX.STBH  WHERE ZH_RYDAXX.RYQF = ? LIMIT 0,20
--> binds:[0]
2017-02-07 14:29:02 [SQL Time]sql 执行时间：17825ms, exec KSQL:
  --> sql:SELECT count(*) FROM zh_rydaxx ZH_RYDAXX LEFT JOIN st_stjbxx ST_STJBXX ON ZH_RYDAXX.STBH = ST_STJBXX.STBH  WHERE ZH_RYDAXX.RYQF = ?
--> binds:[0]
2017-02-07 14:29:02 [SQL Time]sql 执行时间：10ms, exec KSQL: SELECT DISTINCT ST_STJBXX.STBH as STBH,ST_STJBXX.STMC as STMC  FROM ST_STJBXX ST_STJBXX LIMIT 0, 1000
  --> sql:SELECT DISTINCT 1,    ST_STJBXX.STBH AS STBH, ST_STJBXX.STMC AS STMC FROM st_stjbxx ST_STJBXX LIMIT 0,1000
--> binds:[]
2017-02-07 14:29:02 [SQL Time]sql 执行时间：10ms, exec KSQL:
  --> sql:SELECT count(*) FROM (SELECT  DISTINCT  ST_STJBXX.STBH AS STBH, ST_STJBXX.STMC AS STMC FROM st_stjbxx ST_STJBXX) query_sentence
--> binds:[]
2017-02-07 14:29:03 [SQL Time]sql 执行时间：23ms, exec KSQL: SELECT DISTINCT T_soa_jg.jgmc as jgmc,T_soa_jg.treeid as treeid,T_soa_jg.ckjgid as ckjgid,T_soa_jg.jglb as jglb  FROM T_soa_jg T_soa_jg LIMIT 0, 10000
  --> sql:SELECT DISTINCT 1,    T_soa_jg.CKJGID AS ckjgid, T_soa_jg.JGLB AS jglb, T_soa_jg.JGMC AS jgmc, T_soa_jg.TREEID AS treeid FROM t_soa_jg T_soa_jg LIMIT 0,10000
--> binds:[]
2017-02-07 14:29:03 [SQL Time]sql 执行时间：12ms, exec KSQL:
  --> sql:SELECT count(*) FROM (SELECT  DISTINCT  T_soa_jg.CKJGID AS ckjgid, T_soa_jg.JGLB AS jglb, T_soa_jg.JGMC AS jgmc, T_soa_jg.TREEID AS treeid FROM t_soa_jg T_soa_jg) query_sentence
--> binds:[]

jishuang

设置后重启服务了吗？

你的data上设置的limit是15,打印出来的是20？

用的什么数据库？

tlkj

重启服务了，用的是msql数据库

tlkj

重启服务了，
bizData设置的值是15，pagerLimitSelect的defaultValue属性设置的是20，
用的是mysql数据库

jishuang

msql数据库是值mssql还是mysql?

tlkj

就是mysql