| | |
|---|
| | |
|
|---|
| | | //查询出当前存在内存中最大的电池组id(很重要**********)
|
|---|
| | | 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("max_id");
|
|---|
| | | int battgroupid=1010000;
|
|---|
| | | if(rs.getString("id")!=null){
|
|---|
| | | battgroupid=rs.getInt("id");
|
|---|
| | | }
|
|---|
| | | list.add(battgroupid);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
