From 1c25524f12918b63af745a79f59d0e94f1ec6d3c Mon Sep 17 00:00:00 2001 From: 81041 <81041@192.168.10.16> Date: 星期二, 11 十二月 2018 15:25:44 +0800 Subject: [PATCH] 修改 --- gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java index 5b0a86b..1fad757 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java @@ -382,7 +382,7 @@ } //娣诲姞鐢垫睜缁勬椂鏌ヨ鍑烘渶澶х殑鏈烘埧id鍜岀數姹犵粍id public int searchMaxId(){ - String sql="SELECT GREATEST((select max(StationId) from db_battinf.tb_battinf) ,(select max(StationId) from db_battinf.tb_battinf_apply)) as id"; + String sql="select max(StationId) as id from db_battinf.tb_battinf limit 1"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { public List getResults(ResultSet rs) { -- Gitblit v1.9.1