package com.data;

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

import com.dev.base.data.Dynamicload_button;
import com.dev.base.data.Dynamicload_control;
import com.dev.base.data.Dynamicload_inf;
import com.dev.base.data.Dynamicload_state;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;

public class PowerArk_Task_SQL {
	
	/**
	 * 	²éѯËùÓеÄÉ豸ÐÅÏ¢
	 * @param conn_pool
	 * @return
	 */
	public static List<Dynamicload_inf> queryAllPowerArk(MysqlConnPool conn_pool){
		List<Dynamicload_inf> dys = new ArrayList<Dynamicload_inf>();
 		String sql_str = " SELECT * FROM db_dynamicsystem.tb_dynamicload_inf ";
		ResultSet res = null;
		Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
		try {
			res = sql.sqlMysqlQuery(sql_str);
			Dynamicload_inf dyna = null;
			while(res.next()) {
				dyna = new Dynamicload_inf();
				dyna.setDev_id(res.getInt("dev_id"));
				dyna.setDev_ip(res.getString("dev_ip"));
				dyna.setDev_name(res.getString("dev_name"));
				dyna.setDev_type(res.getInt("dev_type"));
				dyna.setFZ_button_num(res.getInt("fZ_button_num"));
				dyna.setNote(res.getString("note"));
				
				dyna.button = new Dynamicload_button(dyna.dev_id);
				dyna.control = new Dynamicload_control(dyna.dev_id);
				dyna.state = new Dynamicload_state(dyna.dev_id);
				dys.add(dyna);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if(res != null) {
				try {
					res.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				sql.close_con();
			}
		}
		return dys;
	}
	
}