| | |
|---|
| | | */
|
|---|
| | | public static void updateFbs9100SysParamParamBydev_id(MysqlConnPool con_pool,
|
|---|
| | | FBS9100_StatAndParam param) {
|
|---|
| | | if(param.op_cmd == FBS9100_ComBase.CMD_GetSYSSetParamAck) |
|---|
| | | if(param.op_cmd == FBS9100_ComBase.CMD_GetSYSSetParamAck || |
|---|
| | | param.op_cmd == FBS9100_ComBase.CMD_GetJuHengParamAck) |
|---|
| | | {
|
|---|
| | |
|
|---|
| | | FBS9100_SysParam sysparam = param.m_FBS_SysParam;
|
|---|
| | | String sql_str_base = Sql_Mysql.FBS9100SysParam_Table
|
|---|
| | | + " SET "
|
|---|
| | | + " dev_id=" + param.dev_id + ", "
|
|---|
| | | + " op_cmd=" + FBS9100_ComBase.CMD_GetSYSSetParamAck + ", "
|
|---|
| | | + " op_cmd=" + param.op_cmd + ", "
|
|---|
| | | + " GroupVolSorce =" + sysparam.GroupVolSorce + ", " //在线电压低阀值
|
|---|
| | | + " CurrentTyte =" + sysparam.CurrentTyte + ", " //浮充电流阀值
|
|---|
| | | + " PowerBreakChargeCurr =" + sysparam.PowerBreakChargeCurr + ", " //电流异常阀值
|
|---|
| | |
|---|
| | | String sql_str_base = Sql_Mysql.FBS9100SysParam_Table + " SET "
|
|---|
| | | + "dev_id=" + param.dev_id + ", "
|
|---|
| | | + "op_cmd=" + param.op_cmd + " ";
|
|---|
| | | //String sql_str_update = "UPDATE " + sql_str_base;
|
|---|
| | | String sql_str_replace = "REPLACE INTO " + sql_str_base;
|
|---|
| | | String sql_str_update = "UPDATE " + sql_str_base + " Where dev_id = " + param.dev_id;
|
|---|
| | | //String sql_str_replace = "REPLACE INTO " + sql_str_base;
|
|---|
| | | //System.out.println(sql_str_replace);
|
|---|
| | | Sql_Mysql sql = new Sql_Mysql(con_pool);
|
|---|
| | | try {
|
|---|
| | | sql.sqlMysqlExecute(sql_str_replace);
|
|---|
| | | sql.sqlMysqlExecute(sql_str_update);
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | sql.logger.error("FBS9100_Task_Thread_SQL.updateFbs9100SysParamCmdBydev_id():" + e.toString(), e);
|
|---|
