void setBoolean(int parameterIndex, boolean x) |
java.lang.Boolean |
BIT BOOLEAN |
|
void setByte(int parameterIndex, byte x) |
java.lang.Byte |
TINYINT |
|
void setShort(int parameterIndex, short x) |
java.lang.Short |
SMALLINT |
|
void setInt(int parameterIndex, int x) |
java.lang.Integer |
INTEGER |
|
void setLong(int parameterIndex, long x) |
java.lang.Long |
BIGINT |
|
void setFloat(int parameterIndex, float x) |
java.lang.Float |
REAL |
|
void setDouble(int parameterIndex, double x) |
java.lang.Double |
DOUBL |
|
void setBigDecimal(int parameterIndex, BigDecimal x) |
java.math.BigDecimal |
NUMERIC |
|
void setString(int parameterIndex, String x) |
java.lang.String |
VARCHAR LONGVARCHAR |
|
void setBytes(int parameterIndex, byte x[]) |
java.lang.Byte[] |
VARBINARY LONGVARBINARY |
|
void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) |
java.io.InputStream |
LONGVARCHAR |
|
void setUnicodeStream(int parameterIndex, java.io.InputStream x,int length) |
java.io.InputStream |
LONGVARCHAR |
编码必须是UTF-8 |
void setBinaryStream(int parameterIndex, java.io.InputStream x,int length) |
java.io.InputStream |
LONGVARBINARY |
|
void setDate(int parameterIndex, java.sql.Date x) |
java.sql.Date |
DATE |
jvm默认时区 |
void setTime(int parameterIndex, java.sql.Time x) |
java.sql.Time |
TIME |
jvm默认时区 |
void setTimestamp(int parameterIndex, java.sql.Timestamp x) |
java.sql.Timestamp |
TIMESTAMP |
jvm默认时区 |
void setDate(int parameterIndex, java.sql.Date x, Calendar cal) |
java.sql.Date |
DATE |
JDBC 2.0 Calendar指定时区 |
void setTime(int parameterIndex, java.sql.Time x, Calendar cal) |
java.sql.Time |
TIME |
JDBC 2.0 Calendar指定时区 |
void setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar cal) |
java.sql.Timestamp |
TIMESTAMP |
JDBC 2.0 Calendar指定时区 |
void setRef (int parameterIndex, Ref x) |
java.sql.Ref |
REF |
JDBC 2.0 |
void setBlob (int parameterIndex, Blob x) |
java.sql.Blob |
BLOB |
JDBC 2.0 |
void setClob (int parameterIndex, Clob x) |
java.sql.Clob |
CLOB |
JDBC 2.0 |
void setArray (int parameterIndex, Array x) |
java.sql.Array |
ARRAY |
JDBC 2.0 |
void setCharacterStream(int parameterIndex,java.io.Reader reader,int length) |
java.io.Reader |
LONGVARCHAR |
JDBC 2.0 大UNICODE使用 |
void setURL(int parameterIndex, java.net.URL x) |
java.net.URL |
DATALINK |
JDBC 3.0 |
void setNString(int parameterIndex, String value) |
java.lang.String |
NCHAR NVARCHAR LONGNVARCHAR |
JDBC 4.0 |
void setRowId(int parameterIndex, RowId x) |
java.sql.RowId |
ROWID |
JDBC 4.0 |
void setNClob(int parameterIndex, NClob value) |
java.sql.NClob |
NCLOB |
JDBC 4.0 |
void setSQLXML(int parameterIndex, SQLXML xmlObject) |
java.sql.SQLXML |
XML |
JDBC 4.0 |
void setBlob(int parameterIndex, InputStream inputStream, long length) |
java.io.InputStream |
BLOB LONGVARBINARY |
JDBC 4.0 |
void setClob(int parameterIndex, Reader reader, long length) |
java.io.Reader |
CLOB |
JDBC 4.0 |
void setNClob(int parameterIndex, Reader reader, long length) |
java.io.Reader |
LONGNVARCHAR NCLOB |
JDBC 4.0 |
void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) |
java.io.InputStream |
LONGVARCHAR |
JDBC 4.0 When a very large ASCII value is input to a LONGVARCHAR parameter |
void setBinaryStream(int parameterIndex, java.io.InputStream x,long length) |
java.io.InputStream |
LONGVARBINARY |
JDBC 4.0 When a very large binary value is input to a LONGVARBINARY parameter |
void setCharacterStream(int parameterIndex,java.io.Reader reader,long length) |
java.io.Reader |
LONGVARCHAR |
JDBC 4.0 When a very large UNICODE value is input to a LONGVARCHAR parameter |
void setAsciiStream(int parameterIndex, java.io.InputStream x) |
java.io.InputStream |
LONGVARCHAR |
JDBC 4.0 |
void setBinaryStream(int parameterIndex, java.io.InputStream x) |
java.io.InputStream |
LONGVARBINARY |
JDBC 4.0 |
void setCharacterStream(int parameterIndex,java.io.Reader reader) |
java.io.Reader |
LONGVARCHAR |
JDBC 4.0 When a very large UNICODE value is input to a LONGVARCHAR parameter |
void setNCharacterStream(int parameterIndex, Reader value) |
java.io.Reader |
LONGVARCHAR |
JDBC 4.0 |
void setNCharacterStream(int parameterIndex, Reader value, long length) |
java.io.Reader |
LONGVARCHAR |
JDBC 4.0 |
void setClob(int parameterIndex, Reader reader) |
java.io.Reader |
CLOB LONGVARCHAR |
JDBC 4.0 |
void setBlob(int parameterIndex, InputStream inputStream) |
java.io.InputStream |
LONGVARBINARY BLOB |
JDBC 4.0 |
void setNClob(int parameterIndex, Reader reader) |
java.io.Reader |
LONGNVARCHAR NCLOB |
JDBC 4.0 |