java.sql.PreparedStatement
java.sql.PreparedStatement是预处理语句接口,具体信息如表1所示。
|
方法名 |
返回值类型 |
支持JDBC4 |
|---|---|---|
|
addBatch() |
VOID |
Yes |
|
executeBatch() |
INT[] |
Yes |
|
clearParameters() |
VOID |
Yes |
|
execute() |
BOOLEAN |
Yes |
|
executeQuery() |
RESULTSET |
Yes |
|
excuteUpdate() |
INT |
Yes |
|
executeLargeUpdate() |
LONG |
Yes |
|
getMetaData() |
RESULTSETMETADATA |
No |
|
getParameterMetaData() |
PARAMETERMETADATA |
Yes |
|
setArray(int parameterIndex, Array x) |
VOID |
Yes |
|
setAsciiStream(int parameterIndex, InputStream x, int length) |
VOID |
Yes |
|
setBinaryStream(int parameterIndex, InputStream x) |
VOID |
Yes |
|
setBinaryStream(int parameterIndex, InputStream x, int length) |
VOID |
Yes |
|
setBinaryStream(int parameterIndex, InputStream x, long length) |
VOID |
Yes |
|
setBlob(int parameterIndex, InputStream inputStream) |
VOID |
Yes |
|
setBlob(int parameterIndex, InputStream inputStream, long length) |
VOID |
Yes |
|
setBlob(int parameterIndex, Blob x) |
VOID |
Yes |
|
setCharacterStream(int parameterIndex, Reader reader) |
VOID |
Yes |
|
setCharacterStream(int parameterIndex, Reader reader, int length) |
VOID |
Yes |
|
setClob(int parameterIndex, Reader reader) |
VOID |
Yes |
|
setClob(int parameterIndex, Reader reader, long length) |
VOID |
Yes |
|
setClob(int parameterIndex, Clob x) |
VOID |
Yes |
|
setDate(int parameterIndex, Date x, Calendar cal) |
VOID |
Yes |
|
setNull(int parameterIndex, int sqlType) |
VOID |
Yes |
|
setNull(int parameterIndex, int sqlType, String typeName) |
VOID |
Yes |
|
setObject(int parameterIndex, Object x) |
VOID |
Yes |
|
setObject(int parameterIndex, Object x, int targetSqlType) |
VOID |
Yes |
|
setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) |
VOID |
Yes |
|
setSQLXML(int parameterIndex, SQLXML xmlObject) |
VOID |
Yes |
|
setTime(int parameterIndex, Time x) |
VOID |
Yes |
|
setTime(int parameterIndex, Time x, Calendar cal) |
VOID |
Yes |
|
setTimestamp(int parameterIndex, Timestamp x) |
VOID |
Yes |
|
setTimestamp(int parameterIndex, Timestamp x, Calendar cal) |
VOID |
Yes |
|
setUnicodeStream(int parameterIndex, InputStream x, int length) |
VOID |
Yes |
|
setURL(int parameterIndex, URL x) |
VOID |
Yes |
|
setBoolean(int parameterIndex, boolean x) |
VOID |
Yes |
|
setBigDecimal(int parameterIndex, BigDecimal x) |
VOID |
Yes |
|
setByte(int parameterIndex, byte x) |
VOID |
Yes |
|
setBytes(int parameterIndex, byte[] x) |
VOID |
Yes |
|
setDate(int parameterIndex, Date x) |
VOID |
Yes |
|
setDouble(int parameterIndex, double x) |
VOID |
Yes |
|
setFloat(int parameterIndex, float x) |
VOID |
Yes |
|
setInt(int parameterIndex, int x) |
VOID |
Yes |
|
setLong(int parameterIndex, long x) |
VOID |
Yes |
|
setShort(int parameterIndex, short x) |
VOID |
Yes |
|
setString(int parameterIndex, String x) |
VOID |
Yes |
|
setNString(int parameterIndex, String x) |
VOID |
Yes |
|
addBatch() |
VOID |
Yes |
|
executeBatch() |
INT[] |
Yes |