panda.dao.sql.SqlLogger Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of panda-core Show documentation
Panda Core is the core module of Panda Framework, it contains commonly used utility classes similar to apache-commons.
There is a newer version: 1.8.0
package panda.dao.sql;

import java.sql.ParameterMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;

import panda.dao.DaoTypes;
import panda.log.Log;
import panda.log.Logs;


/**
 * SqlLogger
 * 
 */
public abstract class SqlLogger {
	/**
	 * log for java.sql.Statement
	 */
	private static Log sslog = Logs.getLog(Statement.class);

	/**
	 * log for java.sql.PreparedStatement
	 */
	private static Log pslog = Logs.getLog(PreparedStatement.class);

	/**
	 * log for java.sql.ResultSet
	 */
	private static Log rslog = Logs.getLog(ResultSet.class);

	/**
	 * logResultHeader
	 * @param resultSet result set 
	 */
	public static void logResultHeader(ResultSet resultSet) {
		if (rslog.isDebugEnabled()) {
			try {
				ResultSetMetaData meta = resultSet.getMetaData();
				
				StringBuilder sb = new StringBuilder();
				sb.append("Result Header: [");
				int cnt = meta.getColumnCount();
				for (int i = 1; i <= cnt; i++) {
					sb.append(meta.getColumnLabel(i));
					sb.append('(').append(DaoTypes.getType(meta.getColumnType(i))).append(')');
					if (i < cnt) {
						sb.append(", ");
					}
				}
				sb.append("]");
				rslog.debug(sb.toString());
			}
			catch (SQLException e) {
				pslog.debug("ResultSet Header LOG ERROR: " + e);
			}
		}
	}
	
	/**
	 * logResultValues
	 * @param resultSet result set 
	 */
	public static void logResultValues(ResultSet resultSet) {
		if (rslog.isDebugEnabled()) {
			try {
				ResultSetMetaData meta = resultSet.getMetaData();
	
				StringBuilder sb = new StringBuilder();
				sb.append("Result Values: [");
				int cnt = meta.getColumnCount();
				for (int i = 1; i <= cnt; i++) {
					int type = meta.getColumnType(i);
					if (type == Types.BLOB || type == Types.CLOB) {
						sb.append('<');
						sb.append(DaoTypes.getType(type));
						sb.append('>');
					}
					else {
						sb.append(String.valueOf(resultSet.getObject(i)));
					}
					if (i < cnt) {
						sb.append(", ");
					}
				}
				sb.append("]");
				rslog.debug(sb.toString());
			}
			catch (SQLException e) {
				pslog.debug("ResultSet Values LOG ERROR: " + e);
			}
		}		
	}

	/**
	 * logSatement
	 * @param sql sql statement 
	 */
	public static void logSql(String sql) {
		if (sslog.isDebugEnabled()) {
			sslog.debug("SQL: " + sql);
		}
	}
	
	/**
	 * logSatement
	 * @param ps prepared statement to log 
	 */
	public static void logStatement(PreparedStatement ps) {
		if (sslog.isDebugEnabled()) {
			sslog.debug("Statement: " + ps.toString());
		}
	}
	
	/**
	 * logParameters
	 * @param ps PreparedStatement
	 */
	public static void logParameters(PreparedStatement ps) {
		if (pslog.isDebugEnabled()) {
			try {
				ParameterMetaData pmd = ps.getParameterMetaData();

				if (pmd.getParameterCount() > 0) {
					StringBuilder sb = new StringBuilder();
					sb.append("Parameters: [");
		
					for (int i = 1; i <= pmd.getParameterCount(); i++) {
						if (i > 1) {
							sb.append(", ");
						}
						try {
							sb.append(pmd.getParameterClassName(i));
						}
						catch (SQLException e) {
							sb.append('?');
						}
					}
		
					sb.append("]");
					pslog.debug(sb.toString());
				}
			}
			catch (SQLException e) {
				pslog.debug("PreparedStatement LOG ERROR: " + e);
			}
		}
	}
}