~whyclj/iec61850_forFoShanAES_Model.git

			@@ -122,14 +122,14 @@
			*/
			public static void UpdateBattInfTable(MysqlConnPool m_ConnPool,FBS9100_StatAndParam param) {
			String sql_str = " UPDATE " + Sql_Mysql.BattInf_Table + ""
			+ " SET PublicKeyX = '"+ param.publicKeyX +"',KeyID = '" + param.keyID + "',SerialNumber = '"+param.serialNumber+"'"
			+ " SET PublicKeyX = '" + param.publicKeyX /* +"',KeyID = '" + param.keyID */ + "',SerialNumber = '"+param.serialNumber+"'"
			+ " WHERE FBSDeviceId = " + param.dev_id;

			Sql_Mysql sql = new Sql_Mysql(m_ConnPool);
			try {
			sql.sqlMysqlExecute(sql_str);
			} catch (SQLException e) {
			e.printStackTrace();
			sql.logger.error("BTS61850_Task_Thread_SQL.UpdateBattInfTable():" + e.toString(), e);
			} finally {
			sql.close_con();
			}
			@@ -151,11 +151,42 @@
			try {
			sql.sqlMysqlExecute(sql_str);
			} catch (SQLException e) {
			sql.logger.error("BTS61850_Task_Thread_SQL.updateBattRtState_Table():" + e.toString(), e);
			sql.logger.error("BTS61850_Task_Thread_SQL.updateBattRtState_Table():" + e.toString(), e);
			} finally {
			sql.close_con();
			}

			}
			}

			/**
			* 查询设备的uKeyID
			* @param m_ConnPool
			* @param dev_id
			* @return
			*/
			public static String queryDeviceUkeyID(MysqlConnPool m_ConnPool, int dev_id) {
			String ukeyID = "";
			String sql_str = "SELECT KeyID FROM " + Sql_Mysql.BattInf_Table+ " WHERE FBSDeviceId = " + dev_id + " LIMIT 1";
			Sql_Mysql sql = new Sql_Mysql(m_ConnPool);
			ResultSet res = null;
			try {
			res = sql.sqlMysqlQuery(sql_str);
			if(res.next()) {
			ukeyID = res.getString("KeyID").trim();
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			if(null != res) {
			try {
			res.close();
			} catch (SQLException e) {
			sql.logger.error("BTS61850_Task_Thread_SQL.queryDeviceUkeyID():" + e.toString(), e);
			}
			}
			sql.close_con();
			}
			return ukeyID;
			}
			}