| | |
| | | + " from db_sensor.tb_sensor_mapinfo,db_sensor.tb_sensor_state,db_sensor.tb_sensor_inf "
|
| | | + " where db_sensor.tb_sensor_mapinfo.sensor_dev_id=db_sensor.tb_sensor_state.sensor_dev_id "
|
| | | + " and db_sensor.tb_sensor_mapinfo.sensor_dev_id=db_sensor.tb_sensor_inf.sensor_dev_id ";
|
| | | List list=(List) DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
| | | |
| | | List list= DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
|
| | |
|
| | | @Override
|
| | | public List getResults(ResultSet rs) {
|
| | |
| | |
|
| | | public static void main(String[] args) {
|
| | | Sensor_mapinfoImpl simpl=new Sensor_mapinfoImpl();
|
| | | List<Sensor_mapinfo> list=(List) simpl.searchAll();
|
| | | /*for (Sensor_mapinfo s : list) {
|
| | | List<Sensor_mapinfo> list=simpl.searchAll();
|
| | | for (Sensor_mapinfo s : list) {
|
| | | System.out.println(s);
|
| | | }*/
|
| | | }
|
| | | }
|
| | | }
|