org.javasimon.jdbc.SimonPreparedStatement Maven / Gradle / Ivy
The newest version!
package org.javasimon.jdbc;
import org.javasimon.Split;
import java.sql.*;
import java.math.BigDecimal;
import java.io.InputStream;
import java.io.Reader;
import java.util.Calendar;
import java.net.URL;
/**
* Simon JDBC proxy prepared statement implementation class.
*
* @author Radovan Sninsky
* @version $Revision: 304 $ $Date: 2011-04-08 10:39:02 +0200 (Fri, 08 Apr 2011) $
* @see java.sql.PreparedStatement
* @since 1.0
*/
public class SimonPreparedStatement extends SimonStatement implements java.sql.PreparedStatement {
/**
* SQL string.
*/
protected String sql;
private java.sql.PreparedStatement stmt;
/**
* Class constructor, initializes Simons (lifespan, active) related to statement.
*
* @param conn database connection (Simon impl.)
* @param stmt real prepared statement
* @param sql sql command
* @param prefix hierarchy prefix for statement Simons
*/
SimonPreparedStatement(Connection conn, java.sql.PreparedStatement stmt, String sql, String prefix) {
super(conn, stmt, prefix);
this.stmt = stmt;
this.sql = sql;
}
/**
* Called before each prepared SQL command execution. Prepares (obtains and starts)
* {@link org.javasimon.Stopwatch Stopwatch Simon} for measure SQL operation.
*
* @return simon stopwatch object or null if sql is null or empty
*/
protected final Split prepare() {
if (sql != null && !sql.equals("")) {
sqlNormalizer = new SqlNormalizer(sql);
sqlCmdLabel = prefix + ".sql." + sqlNormalizer.getType();
return startSplit();
} else {
return null;
}
}
/**
* Measure and execute prepared SQL operation.
*
* @return database rows and columns
* @throws SQLException if real calls fails
*/
public final ResultSet executeQuery() throws SQLException {
Split s = prepare();
try {
return new SimonResultSet(stmt.executeQuery(), this, prefix, s.getStopwatch().getName());
} finally {
finish(s);
}
}
/**
* Measure and execute prepared SQL operation.
*
* @return count of updated rows
* @throws SQLException if real calls fails
*/
public final int executeUpdate() throws SQLException {
Split s = prepare();
try {
return stmt.executeUpdate();
} finally {
finish(s);
}
}
/**
* Measure and execute prepared SQL operation.
*
* @return true if the first result is a ResultSet object;
* false if it is an update count or there are no results
* @throws SQLException if real calls fails
*/
public final boolean execute() throws SQLException {
Split s = prepare();
try {
return stmt.execute();
} finally {
finish(s);
}
}
/**
* Adds prepared SQL command into batch list of sql and also into real batch.
*
* @throws SQLException if real calls fails
*/
public final void addBatch() throws SQLException {
batchSql.add(sql);
stmt.addBatch();
}
/////////////////// Not interesting methods for monitoring
/**
* {@inheritDoc}
*/
public final void setNull(int i, int i1) throws SQLException {
stmt.setNull(i, i1);
}
/**
* {@inheritDoc}
*/
public final void setBoolean(int i, boolean b) throws SQLException {
stmt.setBoolean(i, b);
}
/**
* {@inheritDoc}
*/
public final void setByte(int i, byte b) throws SQLException {
stmt.setByte(i, b);
}
/**
* {@inheritDoc}
*/
public final void setShort(int i, short i1) throws SQLException {
stmt.setShort(i, i1);
}
/**
* {@inheritDoc}
*/
public final void setInt(int i, int i1) throws SQLException {
stmt.setInt(i, i1);
}
/**
* {@inheritDoc}
*/
public final void setLong(int i, long l) throws SQLException {
stmt.setLong(i, l);
}
/**
* {@inheritDoc}
*/
public final void setFloat(int i, float v) throws SQLException {
stmt.setFloat(i, v);
}
/**
* {@inheritDoc}
*/
public final void setDouble(int i, double v) throws SQLException {
stmt.setDouble(i, v);
}
/**
* {@inheritDoc}
*/
public final void setBigDecimal(int i, BigDecimal bigDecimal) throws SQLException {
stmt.setBigDecimal(i, bigDecimal);
}
/**
* {@inheritDoc}
*/
public final void setString(int i, String s) throws SQLException {
stmt.setString(i, s);
}
/**
* {@inheritDoc}
*/
public final void setBytes(int i, byte[] bytes) throws SQLException {
stmt.setBytes(i, bytes);
}
/**
* {@inheritDoc}
*/
public final void setDate(int i, Date date) throws SQLException {
stmt.setDate(i, date);
}
/**
* {@inheritDoc}
*/
public final void setTime(int i, Time time) throws SQLException {
stmt.setTime(i, time);
}
/**
* {@inheritDoc}
*/
public final void setTimestamp(int i, Timestamp timestamp) throws SQLException {
stmt.setTimestamp(i, timestamp);
}
/**
* {@inheritDoc}
*/
public final void setAsciiStream(int i, InputStream inputStream, int i1) throws SQLException {
stmt.setAsciiStream(i, inputStream, i1);
}
/**
* {@inheritDoc}
*/
public final void setUnicodeStream(int i, InputStream inputStream, int i1) throws SQLException {
stmt.setUnicodeStream(i, inputStream, i1);
}
/**
* {@inheritDoc}
*/
public final void setBinaryStream(int i, InputStream inputStream, int i1) throws SQLException {
stmt.setBinaryStream(i, inputStream, i1);
}
/**
* {@inheritDoc}
*/
public final void clearParameters() throws SQLException {
stmt.clearParameters();
}
/**
* {@inheritDoc}
*/
public final void setObject(int i, Object o, int i1) throws SQLException {
stmt.setObject(i, o, i1);
}
/**
* {@inheritDoc}
*/
public final void setObject(int i, Object o) throws SQLException {
stmt.setObject(i, o);
}
/**
* {@inheritDoc}
*/
public final void setObject(int i, Object o, int i1, int i2) throws SQLException {
stmt.setObject(i, o, i1, i2);
}
/**
* {@inheritDoc}
*/
public final void setCharacterStream(int i, Reader reader, int i1) throws SQLException {
stmt.setCharacterStream(i, reader, i1);
}
/**
* {@inheritDoc}
*/
public final void setRef(int i, Ref ref) throws SQLException {
stmt.setRef(i, ref);
}
/**
* {@inheritDoc}
*/
public final void setBlob(int i, Blob blob) throws SQLException {
stmt.setBlob(i, blob);
}
/**
* {@inheritDoc}
*/
public final void setClob(int i, Clob clob) throws SQLException {
stmt.setClob(i, clob);
}
/**
* {@inheritDoc}
*/
public final void setArray(int i, Array array) throws SQLException {
stmt.setArray(i, array);
}
/**
* {@inheritDoc}
*/
public final ResultSetMetaData getMetaData() throws SQLException {
return stmt.getMetaData();
}
/**
* {@inheritDoc}
*/
public final void setDate(int i, Date date, Calendar calendar) throws SQLException {
stmt.setDate(i, date, calendar);
}
/**
* {@inheritDoc}
*/
public final void setTime(int i, Time time, Calendar calendar) throws SQLException {
stmt.setTime(i, time, calendar);
}
/**
* {@inheritDoc}
*/
public final void setTimestamp(int i, Timestamp timestamp, Calendar calendar) throws SQLException {
stmt.setTimestamp(i, timestamp, calendar);
}
/**
* {@inheritDoc}
*/
public final void setNull(int i, int i1, String s) throws SQLException {
stmt.setNull(i, i1, s);
}
/**
* {@inheritDoc}
*/
public final void setURL(int i, URL url) throws SQLException {
stmt.setURL(i, url);
}
/**
* {@inheritDoc}
*/
public final ParameterMetaData getParameterMetaData() throws SQLException {
return stmt.getParameterMetaData();
}
//////// from JDK 6, JDBC 4
/*
public final void setRowId(int i, RowId rowId) throws SQLException {
stmt.setRowId(i, rowId);
}
public final void setNString(int i, String s) throws SQLException {
stmt.setNString(i, s);
}
public final void setNCharacterStream(int i, Reader reader, long l) throws SQLException {
stmt.setNCharacterStream(i, reader, l);
}
public final void setNClob(int i, NClob nClob) throws SQLException {
stmt.setNClob(i, nClob);
}
public final void setClob(int i, Reader reader, long l) throws SQLException {
stmt.setClob(i, reader, l);
}
public final void setBlob(int i, InputStream inputStream, long l) throws SQLException {
stmt.setBlob(i, inputStream, l);
}
public final void setNClob(int i, Reader reader, long l) throws SQLException {
stmt.setNClob(i, reader, l);
}
public final void setSQLXML(int i, SQLXML sqlxml) throws SQLException {
stmt.setSQLXML(i, sqlxml);
}
public final void setAsciiStream(int i, InputStream inputStream, long l) throws SQLException {
stmt.setAsciiStream(i, inputStream, l);
}
public final void setBinaryStream(int i, InputStream inputStream, long l) throws SQLException {
stmt.setBinaryStream(i, inputStream);
}
public final void setCharacterStream(int i, Reader reader, long l) throws SQLException {
stmt.setCharacterStream(i, reader, l);
}
public final void setAsciiStream(int i, InputStream inputStream) throws SQLException {
stmt.setAsciiStream(i, inputStream);
}
public final void setBinaryStream(int i, InputStream inputStream) throws SQLException {
stmt.setBinaryStream(i, inputStream);
}
public final void setCharacterStream(int i, Reader reader) throws SQLException {
stmt.setCharacterStream(i, reader);
}
public final void setNCharacterStream(int i, Reader reader) throws SQLException {
stmt.setNCharacterStream(i, reader);
}
public final void setClob(int i, Reader reader) throws SQLException {
stmt.setClob(i, reader);
}
public final void setBlob(int i, InputStream inputStream) throws SQLException {
stmt.setBlob(i, inputStream);
}
public final void setNClob(int i, Reader reader) throws SQLException {
stmt.setNClob(i, reader);
}
*/
}