From 8410662678ad065a8b270a9c9cbdfde8461f424d Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期二, 11 十二月 2018 13:22:05 +0800
Subject: [PATCH] 自动获取最大设备id
---
gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java | 13 +++++++++----
1 files changed, 9 insertions(+), 4 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 f9c15b2..a63fb42 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java
@@ -752,14 +752,17 @@
//鏌ヨ鍑哄綋鍓嶅瓨鍦ㄥ唴瀛樹腑鏈�澶х殑鐢垫睜缁刬d(寰堥噸瑕�**********)
public int searchMaxBattgroupId(){
- String sql=" select max(battgroupid) as max_id from db_ram_db.tb_batt_rtstate limit 1";
+ String sql=" SELECT GREATEST((select max(battgroupId) from db_battinf.tb_battinf) ,(select max(battgroupId) from db_battinf.tb_battinf_apply)) as id 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=rs.getInt("battgroupid");
+ int battgroupid=1010000;
+ if(rs.getString("id")!=null){
+ battgroupid=rs.getInt("id");
+ }
list.add(battgroupid);
}
} catch (SQLException e) {
@@ -785,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