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;
|
}
|
|
}
|
