| | |
| | | public boolean addPro(Object obj) {
|
| | | BattInf binf=(BattInf) obj;
|
| | | String sql=" REPLACE into db_ram_db.tb_fbs9100s_dfu_state(dev_id,dfu_file,dfu_wr_stat,dfu_data_blocknum,dfu_data_blocksum) " +
|
| | | " SELECT DISTINCT fBSDeviceId,'avr_dfu.uc3',1,1,"+binf.getNum()+" FROM db_battinf.tb_battinf " +
|
| | | " SELECT DISTINCT fBSDeviceId,'avr_dfu.uc3',1,1,"+binf.getSize()+" FROM db_battinf.tb_battinf " +
|
| | | " where fBSDeviceId not in(select DISTINCT dev_id from db_ram_db.tb_fbs9100s_dfu_state where dfu_en=true) ";
|
| | | //条件
|
| | | String sql0=" and stationid=? "; //具体机房
|
| | |
| | | return listAll;
|
| | | }
|
| | |
|
| | | //升级界面点击添加的时候查询出设备对应的版本号
|
| | | public List serchByInfo(Object obj) {
|
| | | // TODO Auto-generated method stub
|
| | | return null;
|
| | | }
|
| | | public static void main(String[] args) {
|