打开读取反馈

whyclj

2020-07-21 63433c46e1330bf65703e2ce7a7fd225a25b1ffb

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
package com.data; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
 
import com.dev.base.data.Dynamicload_button; 
import com.dev.base.data.Dynamicload_control; 
import com.sql.MysqlConnPool; 
import com.sql.Sql_Mysql; 
 
public class PowerArk_SocketClient_Thread_SQL { 
 
    /** 
     *     ¶ÁÈ¡µ±Ç°É豸¿ØÖƲÙ×÷ 
     * @param conn_pool 
     * @param dev_id 
     * @return 
     */ 
    public static void queryPowerArkControl(MysqlConnPool conn_pool,Dynamicload_control control) { 
        String sql_str = " SELECT * FROM " + Sql_Mysql.Tb_Dynamicload_Control + " WHERE dev_id = " + control.dev_id; 
        Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn()); 
        ResultSet res = null; 
        try { 
            res = sql.sqlMysqlQuery(sql_str); 
            if(res.next()) { 
                control.FZ_b1 = res.getInt("FZ_b1");                            //FZ°´Å¥1 
                control.FZ_b2 = res.getInt("FZ_b2");                            //FZ°´Å¥2 
                control.FZ_b3 = res.getInt("FZ_b3");                            //FZ°´Å¥3 
                control.FZ_b4 = res.getInt("FZ_b4");                            //FZ°´Å¥4 
                control.FZ_b5 = res.getInt("FZ_b5");                            //FZ°´Å¥5 
                control.FZ_b6 = res.getInt("FZ_b6");                            //FZ°´Å¥6 
                control.FZ_b7 = res.getInt("FZ_b7");                            //FZ°´Å¥7 
                control.FZ_b8 = res.getInt("FZ_b8");                            //FZ°´Å¥8 
                control.FZ_b9 = res.getInt("FZ_b9");                            //FZ°´Å¥9 
                control.FZ_b10 = res.getInt("FZ_b10");                             //FZ°´Å¥10 
                control.FZ_b11 = res.getInt("FZ_b11");                            //FZ°´Å¥11 
                control.start_auto = res.getInt("start_auto");                    //Æô¶¯×Ô¶¯¼ÓÔØ 
                control.stop_auto = res.getInt("stop_auto");                    //Í£Ö¹×Ô¶¯¼ÓÔØ 
                control.sudden_crease = res.getInt("sudden_crease");            //Í»¼Óͻж 
                control.all_open = res.getInt("all_open");                        //È«²¿·ÖÕ¢ 
                control.FZ_autostate1 = res.getInt("FZ_autostate1");            //FZ×Ô¶¯×´Ì¬1 
                control.FZ_autostate2 = res.getInt("FZ_autostate2");            //FZ×Ô¶¯×´Ì¬2 
                control.FZ_autostate3 = res.getInt("FZ_autostate3");            //FZ×Ô¶¯×´Ì¬3 
                control.FZ_autostate4 = res.getInt("FZ_autostate4");            //FZ×Ô¶¯×´Ì¬4 
                control.FZ_autostate5 = res.getInt("FZ_autostate5");            //FZ×Ô¶¯×´Ì¬5 
                control.local_control = res.getInt("local_control");            //¾ÍµØ¿ØÖÆ 
                control.back_control = res.getInt("back_control");                //ºǫ́¿ØÖÆ 
                control.central_control = res.getInt("central_control");        //Öмä¿ØÖÆ 
                control.inter_volume_M200 = res.getInt("inter_volume_M200");    //ÖмäÁ¿M200 
                control.fan_button = res.getInt("fan_button");                    //·ç»ú°´Å¥ 
                //control.fan_output = res.getInt("fan_output");                    //·ç»úÊä³ö 
                control.set_power = res.getFloat("set_power");                    //É趨¹¦ÂÊ 
            } 
        } catch (Exception e) { 
            e.printStackTrace(); 
        } finally { 
            if(res != null) { 
                try { 
                    res.close(); 
                } catch (SQLException e) { 
                    e.printStackTrace(); 
                } 
            } 
            sql.close_con(); 
        } 
    } 
}