From 83154e82ff44c7af4c99f206cec18a9b693e1304 Mon Sep 17 00:00:00 2001 From: CJJ <Administrator@192.168.10.18> Date: 星期三, 12 十二月 2018 17:18:10 +0800 Subject: [PATCH] 122 --- 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