jdbcpreparedstatement.java

Java写的含有一个jdbc驱动的小型数据库数据库引擎

     */
//#ifdef JAVA2

    public void registerOutParameter(int paramIndex, int sqlType,
				     String typeName) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Adds a set of parameters to the batch.
     *
     * @exception SQLException if a database access error occurs
     * @see Statement#addBatch
     */

//#ifdef JAVA2
    public void addBatch() throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets the designated parameter to a java.sql.Date value,
     * using the given <code>Calendar</code> object.  The driver uses
     * the <code>Calendar</code> object to construct an SQL DATE,
     * which the driver then sends to the database.  With a
     * a <code>Calendar</code> object, the driver can calculate the date
     * taking into account a custom timezone and locale.  If no
     * <code>Calendar</code> object is specified, the driver uses the default
     * timezone and locale.
     *
     * @param parameterIndex the first parameter is 1, the second is 2, ...
     * @param x the parameter value
     * @param cal the <code>Calendar</code> object the driver will use
     * to construct the date
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setDate(int parameterIndex, java.sql.Date x,
			Calendar cal) throws SQLException {
	setDate(parameterIndex, x);
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets the designated parameter to a java.sql.Time value,
     * using the given <code>Calendar</code> object.  The driver uses
     * the <code>Calendar</code> object to construct an SQL TIME,
     * which the driver then sends to the database.  With a
     * a <code>Calendar</code> object, the driver can calculate the time
     * taking into account a custom timezone and locale.  If no
     * <code>Calendar</code> object is specified, the driver uses the default
     * timezone and locale.
     *
     * @param parameterIndex the first parameter is 1, the second is 2, ...
     * @param x the parameter value
     * @param cal the <code>Calendar</code> object the driver will use
     * to construct the time
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setTime(int parameterIndex, Time x,
			Calendar cal) throws SQLException {
	setTime(parameterIndex, x);
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets the designated parameter to a java.sql.Timestamp value,
     * using the given <code>Calendar</code> object.  The driver uses
     * the <code>Calendar</code> object to construct an SQL TIMESTAMP,
     * which the driver then sends to the database.  With a
     * a <code>Calendar</code> object, the driver can calculate the timestamp
     * taking into account a custom timezone and locale.  If no
     * <code>Calendar</code> object is specified, the driver uses the default
     * timezone and locale.
     *
     * @param parameterIndex the first parameter is 1, the second is 2, ...
     * @param x the parameter value
     * @param cal the <code>Calendar</code> object the driver will use
     * to construct the timestamp
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setTimestamp(int parameterIndex, Timestamp x,
			     Calendar cal) throws SQLException {
	setTimestamp(parameterIndex, x);
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets the designated parameter to SQL NULL.  This version of setNull should
     * be used for user-named types and REF type parameters.  Examples
     * of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and
     * named array types.
     *
     * <P><B>Note:</B> To be portable, applications must give the
     * SQL type code and the fully-qualified SQL type name when specifying
     * a NULL user-defined or REF parameter.  In the case of a user-named type
     * the name is the type name of the parameter itself.  For a REF
     * parameter the name is the type name of the referenced type.  If
     * a JDBC driver does not need the type code or type name information,
     * it may ignore it.
     *
     * Although it is intended for user-named and Ref parameters,
     * this method may be used to set a null parameter of any JDBC type.
     * If the parameter does not have a user-named or REF type, the given
     * typeName is ignored.
     *
     *
     * @param parameterIndex the first parameter is 1, the second is 2, ...
     * @param sqlType a value from java.sql.Types
     * @param typeName the fully-qualified name of an SQL user-named type,
     * ignored if the parameter is not a user-named type or REF
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setNull(int parameterIndex, int sqlType,
			String typeName) throws SQLException {
	setNull(parameterIndex, sqlType);
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets the designated parameter to the given <code>Reader</code>
     * object, which is the given number of characters long.
     * When a very large UNICODE value is input to a LONGVARCHAR
     * parameter, it may be more practical to send it via a
     * java.io.Reader. JDBC will read the data from the stream
     * as needed, until it reaches end-of-file.  The JDBC driver will
     * do any necessary conversion from UNICODE to the database char format.
     *
     * <P><B>Note:</B> This stream object can either be a standard
     * Java stream object or your own subclass that implements the
     * standard interface.
     *
     * @param parameterIndex the first parameter is 1, the second is 2, ...
     * @param reader the java reader which contains the UNICODE data
     * @param length the number of characters in the stream
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setCharacterStream(int parameterIndex, Reader reader,
				   int length) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets a REF(&lt;structured-type&gt;) parameter.
     *
     * @param i the first parameter is 1, the second is 2, ...
     * @param x an object representing data of an SQL REF Type
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setRef(int i, Ref x) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets a BLOB parameter.
     *
     * @param i the first parameter is 1, the second is 2, ...
     * @param x an object representing a BLOB
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setBlob(int i, Blob x) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets a CLOB parameter.
     *
     * @param i the first parameter is 1, the second is 2, ...
     * @param x an object representing a CLOB
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setClob(int i, Clob x) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Sets an Array parameter.
     *
     * @param i the first parameter is 1, the second is 2, ...
     * @param x an object representing an SQL array
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public void setArray(int i, Array x) throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * JDBC 2.0
     *
     * Gets the number, types and properties of a ResultSet's columns.
     *
     * @return the description of a ResultSet's columns
     * @exception SQLException if a database access error occurs
     */

//#ifdef JAVA2
    public ResultSetMetaData getMetaData() throws SQLException {
	throw getNotSupported();
    }

//#endif JAVA2

    /**
     * Constructor declaration
     *
     *
     * @param c
     * @param s
     */
    jdbcPreparedStatement(jdbcConnection c, String s) {
	super(c);

	sSql = s;
	vParameter = new Vector();
    }

    /**
     * Method declaration
     *
     *
     * @param parameterIndex
     * @param x
     * @param type
     *
     * @throws SQLException
     */
    private void setObjectInType(int parameterIndex, Object x,
				 int type) throws SQLException {
	if (Trace.TRACE) {
	    Trace.trace();
	}

	if (x == null) {
	    setNull(parameterIndex);

	    return;
	}

	switch (type) {

	case Types.BIT:
	    setBoolean(parameterIndex, ((Boolean) x).booleanValue());

	    break;

	case Types.TINYINT:
	    setByte(parameterIndex, ((Byte) x).byteValue());

	    break;

	case Types.SMALLINT:
	    setShort(parameterIndex, ((Short) x).shortValue());

	    break;

	case Types.INTEGER:
	    setInt(parameterIndex, ((Integer) x).intValue());

	    break;

	case Types.BIGINT:
	    setLong(parameterIndex, ((Long) x).longValue());

	    break;

	case Types.REAL:
	    setFloat(parameterIndex, ((Float) x).floatValue());

	    break;

	case Types.FLOAT:

	case Types.DOUBLE:
	    setDouble(parameterIndex, ((Double) x).doubleValue());

	    break;

	case Types.NUMERIC:
	    setBigDecimal(parameterIndex, (BigDecimal) x);

	    break;

	case Types.CHAR:

	case Types.VARCHAR:

	case Types.LONGVARCHAR:
	    setString(parameterIndex, (String) x);

	    break;

	case Types.DATE:
	    setDate(parameterIndex, (java.sql.Date) x);

	    break;

	case Types.TIME:
	    setTime(parameterIndex, (Time) x);

	    break;

	case Types.TIMESTAMP:
	    setTimestamp(parameterIndex, (Timestamp) x);

	    break;

	case Types.BINARY:

	case Types.VARBINARY:

// [e-mail] 20010707
// bug 425495 by [e-mail]
// to allow class cast when SQL type is used with setObject() for prepareStatement()
	case Types.LONGVARBINARY:
            if (x instanceof ByteArray)
                x= ((ByteArray)x).byteValue();
	    setBytes(parameterIndex, (byte[]) x);

	    break;

	case Types.OTHER:
	    setParameter(parameterIndex,
			 "'" + ByteArray.serializeToString(x) + "'");

	    break;

	default:
	    setParameter(parameterIndex, x.toString());

	    break;
	}
    }

    /**
     * Method declaration
     *
     *
     * @return
     */
    private SQLException getNotSupported() {
	return Trace.error(Trace.FUNCTION_NOT_SUPPORTED);
    }

}