更新时间:2026-11-13 GMT+08:00
分享

java.sql.PreparedStatement

java.sql.PreparedStatement是预处理语句接口。

表1 对java.sql.PreparedStatement的支持情况

方法名

返回值类型

支持JDBC 4

executeQuery()

ResultSet

Yes

executeUpdate()

int

Yes

executeLargeUpdate()

long

Yes

execute()

boolean

Yes

addBatch()

void

Yes

clearParameters()

void

Yes

setNull(int, int)

void

Yes

setNull(int, int, String)

void

Yes

setBoolean(int, boolean)

void

Yes

setByte(int, byte)

void

Yes

setShort(int, short)

void

Yes

setInt(int, int)

void

Yes

setLong(int, long)

void

Yes

setFloat(int, float)

void

Yes

setDouble(int, double)

void

Yes

setBigDecimal(int, BigDecimal)

void

Yes

setString(int, String)

void

Yes

setDate(int, Date)

void

Yes

setTime(int, Time)

void

Yes

setTimestamp(int, Timestamp)

void

Yes

setAsciiStream(int, InputStream, int)

void

Yes

setUnicodeStream(int, InputStream, int)

void

Yes

setBytes(int, byte[])

void

No

setBinaryStream(int, InputStream, int)

void

No

setObject(int, Object)

void

Yes

setObject(int, Object, int)

void

No

setObject(int, Object, int, int)

void

No

setCharacterStream(int, Reader, int)

void

Yes

setRef(int, Ref)

void

No

setBlob(int, Blob)

void

No

setClob(int, Clob)

void

Yes

setClob(int, Reader, long)

void

Yes

setClob(int, Reader)

void

Yes

setArray(int, Array)

void

Yes

getMetaData()

ResultSetMetaData

Yes

setDate(int, Date, Calendar)

void

Yes

setTime(int, Time, Calendar)

void

Yes

setTimestamp(int, Timestamp, Calendar)

void

Yes

setURL(int, URL)

void

No

getParameterMetaData()

ParameterMetaData

No

setRowId(int, RowId)

void

No

setNString(int, String)

void

No

setNCharacterStream(int, Reader, long)

void

No

setNCharacterStream(int, Reader)

void

No

setNClob(int, NClob)

void

No

setNClob(int, Reader, long)

void

No

setNClob(int, Reader)

void

No

setSQLXML(int, SQLXML)

void

Yes

setAsciiStream(int, InputStream, long)

void

No

setAsciiStream(int, InputStream)

void

No

setBinaryStream(int, InputStream, long)

void

No

setBinaryStream(int, InputStream)

void

No

setCharacterStream(int, Reader, long)

void

No

setCharacterStream(int, Reader)

void

No

setBlob(int, InputStream, long)

void

No

setBlob(int, InputStream)

void

No

  • addBatch()、execute()必须在clearBatch()之后才能执行。
  • 调用executeBatch()方法并不会清除batch。用户必须显式使用clearBatch()清除 。
  • 在添加了一个batch的绑定变量后,用户如果想重用这些值(再次添加一个batch),无需再次使用set*()方法 。
  • 以下方法是从java.sql.Statement继承而来:close,execute,executeQuery,executeUpdate,getConnection,getResultSet,getUpdateCount,isClosed,setMaxRows, setFetchSize。

相关文档