From 7f953d9aa0e7d4fcbe3c366c7f9f0b3f847f12bd Mon Sep 17 00:00:00 2001 From: hdw <hdw@192.168.137.1> Date: 星期六, 19 一月 2019 09:16:08 +0800 Subject: [PATCH] Merge branch 'dev_lxw' of https://gitlab.com/whyclxw1/gx_tieta.git into dev_lxw --- gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java | 37 ++++++++++++++++++++++++++++++++++--- 1 files changed, 34 insertions(+), 3 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java index 56f9959..55d807f 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java @@ -749,7 +749,36 @@ } return list; } - public static void main(String[] args) { + + //鏌ヨ鍑哄綋鍓嶅瓨鍦ㄥ唴瀛樹腑鏈�澶х殑鐢垫睜缁刬d(寰堥噸瑕�**********) + public int searchMaxBattgroupId(){ + String sql=" select max(battgroupId) as id from db_ram_db.tb_batt_rtstate limit 1"; + List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + int battgroupid=1010000; + if(rs.getString("id")!=null){ + battgroupid=rs.getInt("id"); + } + list.add(battgroupid); + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + int battgroupid=0; + if(list!=null&&list.size()>0){ + battgroupid=(Integer) list.get(list.size()-1); + } + return battgroupid; + } + public static void main(String[] args) { User_inf uinf=new User_inf(); uinf.setUId(1001); Batt_rtstateDAOImpl bimpl=new Batt_rtstateDAOImpl(); @@ -759,9 +788,11 @@ }*/ Batt_rtstate br=new Batt_rtstate(); br.setBattGroupId(1002101); - List<Batt_rtstate> list=bimpl.serchByCondition_ky(br); + /*List<Batt_rtstate> list=bimpl.serchByCondition_ky(br); for (Batt_rtstate b : list) { System.out.println(b); - } + }*/ + int battgroupid=bimpl.searchMaxBattgroupId(); + System.out.println(battgroupid); } } -- Gitblit v1.9.1