Java tutorial
/* Copyright (C) 2006 NTT DATA Corporation This program is free software; you can redistribute it and/or Modify it under the terms of the GNU General Public License as published by the Free Software Foundation, version 2. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. */ package com.clustercontrol.sql.factory; import java.sql.ResultSet; import java.sql.SQLException; import java.text.NumberFormat; import java.util.Map; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.clustercontrol.fault.MonitorNotFound; import com.clustercontrol.monitor.run.factory.RunMonitor; import com.clustercontrol.monitor.run.factory.RunMonitorStringValueType; import com.clustercontrol.repository.util.RepositoryUtil; import com.clustercontrol.sql.model.SqlCheckInfo; import com.clustercontrol.sql.util.AccessDB; import com.clustercontrol.sql.util.QueryUtil; import com.clustercontrol.util.MessageConstant; import com.clustercontrol.util.StringBinder; /** * SQL ?<BR> * * @version 4.0.0 * @since 2.1.0 */ public class RunMonitorSqlString extends RunMonitorStringValueType { private static Log m_log = LogFactory.getLog(RunMonitorSqlString.class); /** SQL */ private SqlCheckInfo m_sql = null; /** */ private String m_url = null; /** */ private String m_user = null; /** */ private String m_password = null; /** */ private String m_query = null; /** JDBC? */ private String m_jdbcDriver = null; /** ? */ private String m_unKnownMessage = ""; /** */ private String m_messageOrg = null; /** * * */ public RunMonitorSqlString() { super(); } /** * ???CallableTask??????? * * @see com.clustercontrol.monitor.run.factory.RunMonitor#runMonitorInfo() * @see com.clustercontrol.monitor.run.util.MonitorExecuteTask */ @Override protected RunMonitor createMonitorInstance() { return new RunMonitorSqlString(); } /** * SQL? * * @param facilityId ID * @return ???????true */ @Override public boolean collect(String facilityId) { // set Generation Date if (m_now != null) { m_nodeDate = m_now.getTime(); } boolean result = false; AccessDB access = null; ResultSet rSet = null; String url = m_url; try { // ???URL?? if (nodeInfo != null && nodeInfo.containsKey(facilityId)) { Map<String, String> nodeParameter = RepositoryUtil.createNodeParameter(nodeInfo.get(facilityId)); StringBinder strbinder = new StringBinder(nodeParameter); url = strbinder.bindParam(m_url); if (m_log.isTraceEnabled()) m_log.trace("jdbc request. (nodeInfo = " + nodeInfo + ", facilityId = " + facilityId + ", url = " + url + ")"); } // DB?? access = new AccessDB(m_jdbcDriver, url, m_user, m_password); // SQL????? if (m_query.length() >= 6) { String work = m_query.substring(0, 6); if (work.equalsIgnoreCase("SELECT")) { rSet = access.read(m_query); //1?1?? rSet.first(); m_value = rSet.getString(1); //? rSet.last(); int number = rSet.getRow(); NumberFormat numberFormat = NumberFormat.getNumberInstance(); m_messageOrg = MessageConstant.RECORD_VALUE.getMessage() + " : " + m_value + ", " + MessageConstant.RECORDS_NUMBER.getMessage() + " : " + numberFormat.format(number); m_messageOrg += "\n" + MessageConstant.CONNECTION_URL.getMessage() + " : " + url; result = true; } else { //SELECT? m_log.info("collect(): " + MessageConstant.MESSAGE_PLEASE_SET_SELECT_STATEMENT_IN_SQL.getMessage()); m_unKnownMessage = MessageConstant.MESSAGE_PLEASE_SET_SELECT_STATEMENT_IN_SQL.getMessage(); m_messageOrg = MessageConstant.SQL_STRING.getMessage() + " : " + m_query; m_messageOrg += "\n" + MessageConstant.CONNECTION_URL.getMessage() + " : " + url; } } else { //SELECT? m_log.info("collect(): " + MessageConstant.MESSAGE_PLEASE_SET_SELECT_STATEMENT_IN_SQL.getMessage()); m_unKnownMessage = MessageConstant.MESSAGE_PLEASE_SET_SELECT_STATEMENT_IN_SQL.getMessage(); m_messageOrg = MessageConstant.SQL_STRING.getMessage() + " : " + m_query; m_messageOrg += "\n" + MessageConstant.CONNECTION_URL.getMessage() + " : " + url; } } catch (ClassNotFoundException e) { m_log.debug("collect() : " + e.getClass().getSimpleName() + ", " + e.getMessage()); m_unKnownMessage = MessageConstant.MESSAGE_CANNOT_FIND_JDBC_DRIVER.getMessage(); m_messageOrg = MessageConstant.SQL_STRING.getMessage() + " : " + m_query + " (" + e.getMessage() + ")"; m_messageOrg += "\n" + MessageConstant.CONNECTION_URL.getMessage() + " : " + url; } catch (SQLException e) { // SQL m_log.info("collect() : " + e.getClass().getSimpleName() + ", " + e.getMessage()); m_unKnownMessage = MessageConstant.MESSAGE_FAILED_TO_EXECUTE_SQL.getMessage(); m_messageOrg = MessageConstant.SQL_STRING.getMessage() + " : " + m_query + " (" + e.getMessage() + ")"; m_messageOrg += "\n" + MessageConstant.CONNECTION_URL.getMessage() + " : " + url; } finally { try { if (rSet != null) { rSet.close(); } if (access != null) { // DB? access.terminate(); } } catch (SQLException e) { m_log.warn("collect() : " + e.getClass().getSimpleName() + ", " + e.getMessage(), e); } } return result; } /* (non-Javadoc) * SQL * @see com.clustercontrol.monitor.run.factory.OperationNumericValueInfo#setMonitorAdditionInfo() */ @Override protected void setCheckInfo() throws MonitorNotFound { // SQL? if (!m_isMonitorJob) { m_sql = QueryUtil.getMonitorSqlInfoPK(m_monitorId); } else { m_sql = QueryUtil.getMonitorSqlInfoPK(m_monitor.getMonitorId()); } // SQL m_url = m_sql.getConnectionUrl().trim(); m_user = m_sql.getUser().trim(); m_password = m_sql.getPassword().trim(); m_query = m_sql.getQuery().trim(); m_jdbcDriver = m_sql.getJdbcDriver().trim(); } /* (? Javadoc) * ? * @see com.clustercontrol.monitor.run.factory.RunMonitor#getMessage(int) */ @Override public String getMessage(int id) { String message = super.getMessage(id); if (message == null || "".equals(message)) { return m_unKnownMessage; } return message; } /* (? Javadoc) * ? * @see com.clustercontrol.monitor.run.factory.RunMonitor#getMessageOrg(int) */ @Override public String getMessageOrg(int id) { return m_messageOrg; } @Override protected String makeJobOrgMessage(String orgMsg, String msg) { if (m_monitor == null || m_monitor.getSqlCheckInfo() == null) { return ""; } String[] args = { String.valueOf(m_monitor.getSqlCheckInfo().getJdbcDriver()), String.valueOf(m_monitor.getSqlCheckInfo().getUser()), String.valueOf(m_monitor.getSqlCheckInfo().getQuery()) }; return MessageConstant.MESSAGE_JOB_MONITOR_ORGMSG_SQL.getMessage(args) + "\n" + orgMsg; } }