| | |
|---|
| | | }
|
|---|
| | | //添加电池组时查询出最大的机房id和电池组id
|
|---|
| | | public int searchMaxId(){
|
|---|
| | | //,max(battgroupid) as maxb
|
|---|
| | | String sql="select max(stationid) as stationid_maxs from db_battinf.tb_battinf limit 1";
|
|---|
| | | String sql="SELECT GREATEST((select max(StationId) from db_battinf.tb_battinf) ,(select max(StationId) from db_battinf.tb_battinf_apply)) as id";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | try {
|
|---|
| | |
|
|---|
| | | while(rs.next()){
|
|---|
| | | int maxs=42000000;
|
|---|
| | | int maxs=42010000;
|
|---|
| | | //int maxb=1000001;
|
|---|
| | | if(rs.getString("stationid_maxs") != null){
|
|---|
| | | maxs=Integer.parseInt(rs.getString("stationid_maxs"));
|
|---|
| | | if(rs.getString("id") != null){
|
|---|
| | | maxs=Integer.parseInt(rs.getString("id"));
|
|---|
| | | }
|
|---|
| | | /*if(rs.getInt("maxb")!=0){
|
|---|
| | | maxb=rs.getInt("maxb");
|
|---|
| | |
|---|
| | | }
|
|---|
| | | return stationid;
|
|---|
| | | }
|
|---|
| | | //查询出当前存在内存中最大的设备的id(很重要**********)
|
|---|
| | | public int searchMaxdevId_binf(){
|
|---|
| | | String sql="select max(FbsDeviceId) as id from db_battinf.tb_battinf 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 dev_id=0;
|
|---|
| | | if(rs.getString("id")!=null){}
|
|---|
| | | dev_id=rs.getInt("id");
|
|---|
| | | list.add(dev_id);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | int dev_id=0;
|
|---|
| | | if(list!=null&&list.size()>0){
|
|---|
| | | dev_id=(Integer) list.get(list.size()-1);
|
|---|
| | | }
|
|---|
| | | return dev_id;
|
|---|
| | | }
|
|---|
| | | //判断新增的电池组是否存在
|
|---|
| | | public List judgeBatt(Object obj){
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
