package com.fgkj.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.Device_inf;

public class Device_infImpl implements BaseDAO,CallBack{

	@Override
	public List getResults(ResultSet rs) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public boolean add(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	@Override
	public boolean update(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	@Override
	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}
    //查询所有的设备（按照设备类型分类）
	public List searchAll() {
		String sql=" select distinct dev_id,num,dev_name,sys_type,sys_name,analog_count,switch_count,state_count "
				+ " from db_equipstand.tb_device_inf "
				+ " order by sys_type asc ";
		//System.out.println(sql);
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {
			public List getResults(ResultSet rs) {
				List list=new ArrayList();
				try {
					while(rs.next()){
						Device_inf dinf=new Device_inf();
						dinf.setNum(rs.getInt("num"));
						dinf.setDev_id(rs.getInt("dev_id"));
						dinf.setDev_name(rs.getString("dev_name"));
						dinf.setSys_type(rs.getInt("sys_type"));
						dinf.setSys_name(rs.getString("sys_name"));
						dinf.setAnalog_count(rs.getInt("analog_count"));
						dinf.setSwitch_count(rs.getInt("switch_count"));
						dinf.setState_count(rs.getInt("state_count"));
						list.add(dinf);
					
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				return list;
			}
		});
		return list;
	}

	@Override
	public List serchByCondition(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
	public static void main(String[] args) {
		Device_infImpl dimpl=new Device_infImpl();
		List list=dimpl.searchAll();
		System.out.println(list.size());
	}
}