| | |
| | | */
|
| | | public static void insertOrUpdateTb_Central_Monitor_Sys_St(MysqlConnPool pool,Central_ST_Data stdata) {
|
| | | String sql_str_sel = " select dev_id from " + Sql_Mysql.Tb_Central_Monitor_Sys_St + " where dev_id = " + stdata.getDev_id();
|
| | | String sql_str_ins = " intsert into " + Sql_Mysql.Tb_Central_Monitor_Sys_St + "(dev_id) values("+stdata.getDev_id()+")";
|
| | | String sql_str_ins = " insert into " + Sql_Mysql.Tb_Central_Monitor_Sys_St + "(dev_id) values("+stdata.getDev_id()+")";
|
| | | String sql_str_upd = " update " + Sql_Mysql.Tb_Central_Monitor_Sys_St + ""
|
| | | + " SET record_time '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
|
| | | + " SET record_time = '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
|
| | | + "',switch_close_1st_2500A = " + stdata.getSwitch_close_1st_2500A()
|
| | | + ",switch_open_1st_2500A = " + stdata.getSwitch_open_1st_2500A()
|
| | | + ",switch_fault_1st_2500A = " + stdata.getSwitch_fault_1st_2500A()
|
| | |
| | | */
|
| | | public static void insertOrUpdateTb_Central_Monitor_Sys_Rt(MysqlConnPool pool,Central_RT_Data rtdata) {
|
| | | String sql_str_sel = " select dev_id from " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + " where dev_id = " + rtdata.getDev_id();
|
| | | String sql_str_ins = " intsert into " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + "(dev_id) values("+rtdata.getDev_id()+")";
|
| | | String sql_str_ins = " insert into " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + "(dev_id) values("+rtdata.getDev_id()+")";
|
| | | String sql_str_upd = " update " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + ""
|
| | | + " SET record_time '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
|
| | | + " SET record_time = '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
|
| | | + "',switch_close = " + rtdata.getSwitch_close()
|
| | | + ",switch_open = " + rtdata.getSwitch_open()
|
| | | + ",switch_fault = " + rtdata.getSwitch_fault()
|