| | |
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | //查询存在电池告警的机房个数
|
|---|
| | | public int searchAlarmInStation(Object obj){
|
|---|
| | | User_inf uinf=(User_inf) obj;
|
|---|
| | | String sql=" select count(distinct db_battinf.tb_battinf.stationid) as nums from db_battinf.tb_battinf where station_install=1 " +
|
|---|
| | | " and db_battinf.tb_battinf.battgroupid in (select distinct db_alarm.tb_battalarm_data.battgroupid from db_alarm.tb_battalarm_data) " +
|
|---|
| | | " and db_battinf.tb_battinf.stationid in ( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.stationid " +
|
|---|
| | | " from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +
|
|---|
| | | " where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
|---|
| | | " and db_user.tb_user_battgroup_baojigroup_usr.uId=? ) " ;
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | | |
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while(rs.next()){
|
|---|
| | | list.add(rs.getInt("nums"));
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | int nums=0;//最后的结果
|
|---|
| | | if(list!=null&&list.size()>0){
|
|---|
| | | nums=(Integer) list.get(list.size()-1);
|
|---|
| | | }
|
|---|
| | | return nums;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public static void main(String[] args) throws ParseException {
|
|---|
| | | Battalarm_dataDAOImpl bimp = new Battalarm_dataDAOImpl();
|
|---|
| | |
|---|
| | | for (int num : list) {
|
|---|
| | | System.out.println(num);
|
|---|
| | | }*/
|
|---|
| | | List list=bimp.serchIn30(uinf);
|
|---|
| | | System.out.println(list.size());
|
|---|
| | | //List list=bimp.serchIn30(uinf);
|
|---|
| | | //System.out.println(list.size());
|
|---|
| | | int nums=bimp.searchAlarmInStation(uinf);
|
|---|
| | | System.out.println(nums);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
