Nutz
  1. 主页/
  2. 问答
NutzCN Logo
问答 sql语句 After end of result set
发布于 2696天前 作者 大豪豪 2140 次浏览 复制 上一个帖子 下一个帖子
标签: 无

public List orderQuery(HttpServletRequest re){
String ordNO = re.getParameter("ordNo");
String ddname = re.getParameter("Ddname");
String startDat=re.getParameter("startDat");
String endrDat= re.getParameter("endtDat");
System.out.println(ordNO+"............"+startDat+"..........."+endrDat+"......"+ddname);
final OrderQuery oq = new OrderQuery();
Sql sql =Sqls.create("select lo.yfhj,l.ordNO,bu.username,bu.telephone,l.createDat FROM LgtOrder l LEFT JOIN LgtOrderCarriage lo on l.ordPk=lo.ordPk LEFT JOIN BaseUserInfo bu on bu.userPk=l.shipper where l.ordNO=@ordNO AND bu.username like @ddname AND lo.createDat BETWEEN @startDat and @endrDat");
sql.params().set("ordNO", ordNO);
sql.params().set("ddname", "%" + ddname + "%");
sql.params().set("startDat", startDat);
sql.params().set("endrDat", endrDat);

    sql.setCallback(new SqlCallback() {
       @Override
       public Object invoke (Connection conn, ResultSet rs, Sql sql)
          throws SQLException {
          List<OrderQuery> list = new ArrayList<OrderQuery>();
          System.out.println(rs.next()+"..............");
            while (rs.next())
             System.out.println(rs.getDouble("yfhj")+"...................");
            System.out.println(rs.getDouble(1)+"...................1111111111");
                oq.setYfhj(rs.getDouble("yfhj"));

                oq.setOrdNo(rs.getLong(2));
                oq.setDdName(rs.getString(3));
                oq.setTel(rs.getLong(4));
                oq.setStarDat(rs.getDate(5));
                list.add(oq);
            return list;
       }
    });
    dao.execute(sql);
    System.out.println(sql.getList(OrderQuery.class).get(0).getDdName());
  return sql.getList(OrderQuery.class);

程序没有进while中 但是re.next() 返回时true

9 回复

之前的帖子都没结贴.

可以了啊 是您说的呀就按您说的那么做

那你去结啊

缺大括号

while (rs.next()) {
             System.out.println(rs.getDouble("yfhj")+"...................");
            System.out.println(rs.getDouble(1)+"...................1111111111");
                oq.setYfhj(rs.getDouble("yfhj"));

                oq.setOrdNo(rs.getLong(2));
                oq.setDdName(rs.getString(3));
                oq.setTel(rs.getLong(4));
                oq.setStarDat(rs.getDate(5));
                list.add(oq);
}

还是没有进while

For example:> "select lo.yfhj,l.ordNO,bu.username,bu.telephone,l.createDat FROM LgtOrder l LEFT JOIN LgtOrderCarriage lo on l.ordPk=lo.ordPk LEFT JOIN BaseUserInfo bu on bu.userPk=l.shipper where l.ordNO='20170802102033' AND bu.username like '%p%' AND lo.createDat BETWEEN '2017-07-31' and '2017-08-11'"
*************** ������ �Զ����sql��� ����
true..............
2017-08-05 21:22:50,307 [DEBUG-http-apr-8080-exec-3:271087] org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:28) time=3ms, sql=select lo.yfhj,l.ordNO,bu.username,bu.telephone,l.createDat FROM LgtOrder l LEFT JOIN LgtOrderCarriage lo on l.ordPk=lo.ordPk LEFT JOIN BaseUserInfo bu on bu.userPk=l.shipper where l.ordNO='20170802102033' AND bu.username like '%p%' AND lo.createDat BETWEEN '2017-07-31' and '2017-08-11'
2017-08-05 21:22:50,308 [DEBUG-http-apr-8080-exec-3:271088] com.kf.dms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:31) [POST]URI=/k/ard/y/biz/order/query/orderQuery 9ms
2017-08-05 21:23:37,042 [INFO-Druid-ConnectionPool-Log-362068441:317822] com.alibaba.druid.pool.DruidDataSourceStatLoggerImpl.log(DruidDataSourceStatLoggerImpl.java:77) {"url":"jdbc:mysql://192.168.1.134:3306/dmsv2?useUnicode=true&characterEncoding=UTF-8","dbType":"mysql","name":"DataSource-362068441","activeCount":0,"activePeak":1,"activePeakTime":"2017-08-05 21:18:37","poolingCount":1,"poolingPeak":1,"poolingPeakTime":"2017-08-05 21:18:37","connectCount":173,"closeCount":173,"executeCount":66,"pstmtCacheHitCount":4,"pstmtCacheMissCount":3,"connectionHoldTimeHistogram":[220,116,8,0,2],"sqlList":[{"sql":"SHOW VARIABLES LIKE ?","executeCount":8,"executeMillisMax":454,"executeMillisTotal":1038,"executeHistogram":[0,4,2,2],"executeAndResultHoldHistogram":[8],"concurrentMax":2,"fetchRowCount":8,"fetchRowHistogram":[0,8]},{"sql":"SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n\tAND engine = ?","executeCount":2,"executeMillisMax":6,"executeMillisTotal":12,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2},{"sql":"SELECT COUNT(?)\nFROM SysAreaDict\nWHERE 1 != 1","executeCount":2,"executeMillisMax":8,"executeMillisTotal":16,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtOrderExcep\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseBillReceiveRecord\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM AuthMenu\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM AuthRole\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM SysUpdateLog\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinChargeItem\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCarLocation\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":7,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCustomerAddress\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtOrderDetails\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":7,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtOrderStatusHistory\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtSendOrderDetails\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCustomerRelation\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinChargeCourse\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtInfoDimensionality\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtOrderCarriage\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseBillAddRecord\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCar\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtTransportationDetails\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseUserInfo\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM SysSetting\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseEmployeeRelation\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM AuthRoleMenu\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM AuthAccount\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCompany\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtDriverAcceptStatus\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM AuthEmpRole\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LogOptBeanField\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LogOptBean\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseDriverLicType\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtNeedsCarDetails\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtOrder\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtEvaluateDimensionality\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseLevelConfig\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtCSRecord\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtPathWay\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LogCarriageAuditRecord\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM ComFile\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtYdStatusHistory\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinReceiptSet\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtSendOrderRecord\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCarType\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinChargeVoucherLog\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseDept\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtEvaluateInfo\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinChargeWay\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtSendLoc\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseDriverCarBinding\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtDriverAccept\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM BaseCyGoods\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM SysFileUploadInfo\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LogUserLogin\nWHERE 1 != 1","executeCount":2,"executeMillisMax":2,"executeMillisTotal":5,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM FinChargeVoucher\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LgtTransfer\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT COUNT(?)\nFROM LogSMS\nWHERE 1 != 1","executeCount":2,"executeMillisMax":3,"executeMillisTotal":6,"executeHistogram":[0,2],"executeAndResultHoldHistogram":[2],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,2]},{"sql":"SELECT *\nFROM AuthAccount\nWHERE lgnname = ?\nLIMIT ?, ?","executeCount":4,"executeMillisMax":2,"executeMillisTotal":10,"executeHistogram":[0,4],"executeAndResultHoldHistogram":[4],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[0,4]},{"sql":"select lo.yfhj,l.ordNO,bu.username,bu.telephone,l.createDat FROM LgtOrder l LEFT JOIN LgtOrderCarriage lo on l.ordPk=lo.ordPk LEFT JOIN BaseUserInfo bu on bu.userPk=l.shipper where l.ordNO=? AND bu.username like ? AND lo.createDat BETWEEN ? and ?","executeCount":8,"executeMillisMax":4,"executeMillisTotal":22,"executeHistogram":[0,8],"executeAndResultHoldHistogram":[8],"concurrentMax":2,"fetchRowCount":1,"fetchRowHistogram":[4,4]}]}

删掉这一行

System.out.println(rs.next()+"..............");

把druid的日志关掉啦，完全没用

另外，发代码/日志有按钮，不要直接贴啊

嗯嗯 知道啦 问题解决啦 谢谢啊兽总

添加回复
请先登陆
回到顶部