官术网_书友最值得收藏!

PreparedStatement Interface

A PreparedStatement object represents a precompiled SQL statement. The PreparedStatement interface extends the Statement interface. The precompiled SQL statement has IN parameters for which values are being set with the setter methods of the PreparedStatement interface. A 'setter' method is included for each of the Java data types that map to a SQL data type. The JDBC driver converts the Java data type to an SQL data type. The IN parameter values are set with parameter index. For example, update a Catalog table with the following definition using PreparedStatement :

CatalogId NUMBER Journal VARCHAR(255) Publisher VARCHAR(255) Title VARCHAR(255) Author VARCHAR(255) 

Set Publisher column value to Oracle Publishing, and Journal column values to Oracle Magazine, where CatalogId is 1, referred to the code below:

PreparedStatement pstmt = connection.prepareStatement("UPDATE CATALOG SET Journal=? AND Publisher=? WHERE CatalogId=?");
pstmt.setString(1, "Oracle Magazine");
pstmt.setString(2, "Oracle Publishing");
pstmt.setInt(3, 1);
pstmt.executeUpdate();

If the database supports statement pooling, PreparedStatement objects are pooled by default. In JDBC 4.0, the methods discussed in the following table have been added to the PreparedStatement interface:

主站蜘蛛池模板: 夏津县| 讷河市| 杭锦旗| 隆林| 平凉市| 孟州市| 舟山市| 时尚| 洛阳市| 庆元县| 玉树县| 凤山县| 祁门县| 佳木斯市| 湖北省| 科技| 尖扎县| 南投市| 闽侯县| 嵩明县| 兴安盟| 鹤峰县| 黄平县| 资源县| 汕头市| 威宁| 望谟县| 高尔夫| 桦甸市| 澄迈县| 宁蒗| 石门县| 盖州市| 木兰县| 乌苏市| 滕州市| 陇西县| 怀化市| 攀枝花市| 大庆市| 新绛县|