| | |
|---|
| | | // TODO Auto-generated method stub
|
|---|
| | | return false;
|
|---|
| | | }
|
|---|
| | | //给gprs发送指令
|
|---|
| | | public boolean update(Object obj) {
|
|---|
| | | return false;
|
|---|
| | | Bts_gprs_state gprs=(Bts_gprs_state) obj;
|
|---|
| | | String sql=" update db_ram_db.tb_bts_gprs_state set AT_cmd=? where dev_id=? ";
|
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getAT_cmd(),gprs.getDev_id()});
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public boolean del(Object obj) {
|
|---|
| | |
|---|
| | | //根据设备id读取的设备连接的gprs模块的信号值
|
|---|
| | | public List serchByCondition(Object obj) {
|
|---|
| | | Bts_gprs_state gprs=(Bts_gprs_state) obj;
|
|---|
| | | String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,record_datetime,scq_val" +
|
|---|
| | | String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf" +
|
|---|
| | | " ,stationName,FBSDeviceName " +
|
|---|
| | | " from db_ram_db.tb_bts_gprs_state,db_battinf.tb_battinf " +
|
|---|
| | | " where db_ram_db.tb_bts_gprs_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
|
|---|
| | |
|---|
| | | g.setNum(rs.getInt("num"));
|
|---|
| | | g.setDev_id(rs.getInt("dev_id"));
|
|---|
| | | g.setOp_cmd(rs.getInt("op_cmd"));
|
|---|
| | | g.setRecord_datetime(rs.getTimestamp("record_datetime"));
|
|---|
| | | g.setScq_val(rs.getString("scq_val"));
|
|---|
| | | g.setAT_cmd(rs.getString("aT_cmd"));
|
|---|
| | | g.setAck_inf(rs.getString("ack_inf"));
|
|---|
| | | g.setStationName(rs.getString("stationName"));
|
|---|
| | | g.setFBSDeviceName(rs.getString("fBSDeviceName"));
|
|---|
| | | list.add(g);
|
|---|
