| | |
|---|
| | | //给gprs发送指令
|
|---|
| | | public boolean update(Object obj) {
|
|---|
| | | Bts_gprs_state gprs=(Bts_gprs_state) obj;
|
|---|
| | | String sql=" update db_ram_db.tb_bts_gprs_state set AT_cmd='"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"' where dev_id=? ";
|
|---|
| | | String sql=" REPLACE into db_ram_db.tb_bts_gprs_state(AT_cmd,dev_id) values('"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"',?)";
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getDev_id()});
|
|---|
| | | return bl;
|
|---|
| | |
|---|
| | | //根据设备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,AT_cmd,ack_inf" +
|
|---|
| | | String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf,bts_task_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 " +
|
|---|
| | | " and dev_id=? " +
|
|---|
| | | " order by record_datetime desc";
|
|---|
| | | " and dev_id=? " ;
|
|---|
| | | //System.err.println(sql);
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{gprs.getDev_id()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | g.setOp_cmd(rs.getInt("op_cmd"));
|
|---|
| | | g.setAT_cmd(rs.getString("aT_cmd"));
|
|---|
| | | g.setAck_inf(rs.getString("ack_inf"));
|
|---|
| | | g.setBts_task_inf(rs.getString("bts_task_inf"));
|
|---|
| | | g.setStationName(rs.getString("stationName"));
|
|---|
| | | g.setFBSDeviceName(rs.getString("fBSDeviceName"));
|
|---|
| | | list.add(g);
|
|---|
| | |
|---|
| | | // TODO Auto-generated method stub
|
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public static void main(String[] args) {
|
|---|
| | | Bts_gprs_stateImpl bimpl=new Bts_gprs_stateImpl();
|
|---|
| | | Bts_gprs_state gprs=new Bts_gprs_state();
|
|---|
| | | gprs.setDev_id(910000001);
|
|---|
| | | gprs.setAT_cmd("CSQ");
|
|---|
| | | /* boolean bl=bimpl.update(gprs);
|
|---|
| | | System.out.println(bl);*/
|
|---|
| | | List list=bimpl.serchByCondition(gprs);
|
|---|
| | | System.out.println(list);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
