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

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:

主站蜘蛛池模板: 临安市| 防城港市| 天柱县| 饶河县| 上虞市| 崇信县| 宿州市| 深泽县| 亚东县| 图们市| 芦山县| 会昌县| 临西县| 威信县| 张北县| 宁明县| 栾城县| 淅川县| 德令哈市| 镇安县| 承德县| 洛宁县| 德安县| 鹤山市| 普陀区| 河源市| 楚雄市| 留坝县| 达孜县| 六枝特区| 渝中区| 罗平县| 望城县| 铜川市| 德钦县| 洪洞县| 通化市| 肇源县| 万载县| 那曲县| 安宁市|