PreparedStatement prepareStatement()

最新推荐文章于 2023-07-12 18:24:38 发布
最新推荐文章于 2023-07-12 18:24:38 发布
阅读量232 收藏
点赞数
文章标签： SQL JDBC Access
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/iteye_10188/article/details/81892021
版权
传送给数据库的 SQL 语句通过一个包含两个步骤的过程来返回结果。首先准备它们，然后处理它们。借助 Statement 对象，这两个阶段对应用程序而言变成一个阶段。

PreparedStatement 允许将这两个步骤分开。准备步骤在创建对象时发生，而处理步骤在对 PreparedStatement 对象调用 executeQuery、executeUpdate 或 execute 方法时发生。

prepareStatement
PreparedStatement prepareStatement(String sql,
int autoGeneratedKeys)
throws SQLException
Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys. The given constant tells the driver whether it should make auto-generated keys available for retrieval. This parameter is ignored if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.

Result sets created using the returned PreparedStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY. The holdability of the created result sets can be determined by calling getHoldability().


Parameters:
sql - an SQL statement that may contain one or more '?' IN parameter placeholders
autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS
Returns:
a new PreparedStatement object, containing the pre-compiled SQL statement, that will have the capability of returning auto-generated keys
Throws:
SQLException - if a database access error occurs, this method is called on a closed connection or the given parameter is not a Statement constant indicating whether auto-generated keys should be returned
SQLFeatureNotSupportedException - if the JDBC driver does not support this method with a constant of Statement.RETURN_GENERATED_KEYS
Since:
1.4

----------------------------------------------------------------------

prepareStatement
PreparedStatement prepareStatement(String sql,
int[] columnIndexes)
throws SQLException
Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
An SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.

Result sets created using the returned PreparedStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY. The holdability of the created result sets can be determined by calling getHoldability().


Parameters:
sql - an SQL statement that may contain one or more '?' IN parameter placeholders
columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row or rows
Returns:
a new PreparedStatement object, containing the pre-compiled statement, that is capable of returning the auto-generated keys designated by the given array of column indexes
Throws:
SQLException - if a database access error occurs or this method is called on a closed connection
SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since:
1.4

----------------------------------------------------------------------

prepareStatement
PreparedStatement prepareStatement(String sql,
String[] columnNames)
throws SQLException
Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array. This array contains the names of the columns in the target table that contain the auto-generated keys that should be returned. The driver will ignore the array if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
An SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.

Result sets created using the returned PreparedStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY. The holdability of the created result sets can be determined by calling getHoldability().


Parameters:
sql - an SQL statement that may contain one or more '?' IN parameter placeholders
columnNames - an array of column names indicating the columns that should be returned from the inserted row or rows
Returns:
a new PreparedStatement object, containing the pre-compiled statement, that is capable of returning the auto-generated keys designated by the given array of column names
Throws:
SQLException - if a database access error occurs or this method is called on a closed connection
SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since:
1.4
iteye_10188
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java JDBC用法详解
杨青葱的博客
06-18 972
第一章 JDBC 1.1 基本概念 概念：( Java DataBase Connectivity standard Java数据库连接，Java语言操作数据库） 他定义了操作所有关系型数据库的规则（接口）。 具体操作什么数据库用接口实现类实现，这个实现类叫做数据库驱动 JDBC本质： 其实是官方（sun公司）定义的一套操作所有关系型数据库的规则，即接口。各个数据库厂商去实现这套接口，提供数据库驱动jar包。我们可以使用这套接口（JDBC）编程，真正执行的代码时驱动jar包中的实现类 （其实就是使用了多态来
用prepareStatement(String sql, String[] columnNames)获取自动生成的id
lyq18235187358的博客
01-22 3810
/**   * 先增加一个部门,再给此部门增加一个员工.   * 要点:增加部门后如何获得生成的部门ID.   */  @Test  public void test2(){   //假设页面传入的部门数据是   String dname="软件部";   String loc="北京";   //假设传入的员工数据是   String ename="八戒";   Strin
关于prepareStatement(String sql,int autoGeneratedKeys)的记录
weixin_30258027的博客
04-17 438
PreparedStatementprepareStatement(Stringsql,intautoGeneratedKeys) throws SQLExceptionautoGeneratedKeys可以取值为Statement.RETURN_GENERATED_KEYS或Statement.NO_GENERATED_KEYS取Statement.RETURN_GENERATED_KEY...
Connection 对象简介 方法解读 JDBC简介（四）
noteless的博客
01-22 3426
Connection 对象简介 方法解读 JDBC简介（四） 通过驱动管理器DriverManager的getConnection方法，可以创建到指定URL的连接 Connection conn = DriverManager.getConnection(url, user, password); 看得出来，在JDBC中连接被...
结合spring jdbc 实现分表分库的数据库访问构思
07-22 236
数据库的分库分表访问，原理上很简单。对于一条sql来说，就是确定表名称，对于操作来说，就是要确定数据源。因此，我要对数据源与表名进行分析。 在spring中对于单数据源的配置，非常简单，相信大家也都会配置。那么对于多数据源来说有两种方式： 1，静态数据源选择方式，只需要在dao中注入对应数据源。这种也没什么好说的，但是如果存在事物的话，需要注意，一旦在 service的方法中操作不...
PreparedStatement
攸的博客
01-13 134
PreparedStatement 与StateMent主要区别于 ps 是预编译，多次查询同样语法，但是参数不同的情况，只需要给？参数赋值即可，示例忽略try。 def transforDeviceId(): Unit = { val url = "jdbc:mysql://localhost:3306/origin_platform" val outPath =...
java中PreparedStatement和Statement详细讲解
08-25
pstmt = conn.prepareStatement("SELECT * FROM admin WHERE username = ? AND password = ?"); pstmt.setString(1, "韦小宝"); pstmt.setString(2, "222' OR '8'='8"); ResultSet rs = pstmt.executeQuery(); ...
利用JDBC的PrepareStatement打印真实SQL的方法详解
08-29
PreparedStatement ps = connection.prepareStatement(sql); ps.setInt(1, 10); ``` 在这个例子中，我们想知道实际执行的SQL语句是"SELECT * FROM table WHERE id = 10"。为了实现这个需求，我们可以自定义一个辅助...
PreparedStatement和Statement
03-22
PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "John Doe"); pstmt.setInt(2, 30); pstmt.executeUpdate(); ``` 3. **比较与选择** - **性能**：由于预编译，`...
prepareStatement和Statement的区别
09-23
首先，从创建时的区别开始，Statement 需要通过 Connection 对象的 createStatement() 方法创建，而 PreparedStatement 需要通过 Connection 对象的 prepareStatement() 方法创建，并且需要带有 SQL 语句。...
JDBC PrepareStatement 使用（附各种场景 demo）
01-14
PrepareStatement是JDBC提供的一种预编译的SQL语句，它可以提高数据库操作的效率和安全性。本资源主要涵盖了使用JDBC PrepareStatement进行MySQL数据库操作的各种场景，包括基本的查询、更新以及批量处理。 首先，...
掌握数据库操作的关键技巧：深入解析prepareStatement方法
2301_77478553的博客
07-12 4317
prepareStatement是表示预编译的 SQL 语句的对象。prepareStatement方法是Java中用于准备执行SQL语句的方法。它可以避免SQL注入攻击，提高执行效率，且支持占位符，可以方便地设置参数。2.为什么要使用prepareStatementStatement与preparedStatement的区别：1. preparedStatement可以写动态参数化的查询。
PreparedStatement接口，prepareStatement方法
he_hchx的专栏
04-26 8473
1、public interface PreparedStatementextends Statement表示预编译的 SQL 语句的对象。 SQL 语句被预编译并且存储在 PreparedStatement 对象中。然后可以使用此对象高效地多次执行该语句。 注：用来设置 IN 参数值的 setter 方法（setShort、setString 等等）必须指定与输入参数的已定义 SQL 类型兼
java.sql.Connection类中有个方法
evilcry2012的专栏
11-17 1296
java.sql.Connection类中有个方法 10 java.sql.Connection类中有个方法  PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException 这个方法中参数的第二个作用是什么，代表什么意思？  下面是org.springfram
Java--Statement和PrepareStatement的区别
MinggeQingchun的博客
10-26 948
一、语法 两者的语法区别 Statement语法 Statement stmt = connect.createStatement(); String sql= "SELECT * FROM cg_user WHERE userId=10086 AND name LIKE 'xiaoming'"; ResultSet rs = stmt.executeUpdate(sql); PrepareStatement PreparedStatement preparedStatement = conne
12_02.【Java】JDBC中常用的类和接口
changchuanlai
11-27 747
JDBC中常用的类和接口 java.sql包中提供了丰富的接口、类，还有一些Enum枚举对象和Exception常见异常用于数据库编程。利用这些类和接口可以放拜年的访问并处理存储在数据库中的数据。本节将介绍一些常用的JDBC接口和类，这些接口和类都在java.sql包中。 一、DriverManager类 DriverManager类是JDBC的管理层，用来管理数据库中的驱动程序。在使用Java操作数据库之前，必须使用Class类的静态方法forName（String className）加载能够连接数据库
获取自动生成的主键
KUANG1314520的博客
10-07 464
步骤： 1）设置需要返回生成的主键,【通过preparedStatement的第二个参数】 PreparedStatement prepareStatement(String sql, int autoGeneratedKeys);//创建一个默认 PreparedStatement 对象，该对象能获取自动生成的键 参数： ...
2022年全国地级市人口分布数据(全新整理)
最新发布
08-15
1、资源内容地址：https://blog.csdn.net/2301_79696294/article/details/140877988 2、代码特点：今年全新，手工精心整理，放心引用，数据来自权威，相对于其他人的控制变量数据准确很多,适合写论文做实证用 ，不会出现数据造假问题 3、适用对象：大学生，本科生，研究生小白可用，容易上手！！！ 3、课程引用，经济学，地理学，城市规划与城市研究，公共政策与管理，社会学，商业与管理 ## 数据指标说明 资源名称：2022年全国地级市人口分布数据 区域范围：全国地级市 数据格式：.shp格式 数据规模:大于2G 数据来源：https://landscan.ornl.gov/
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
03-24
这是一个 Java 中的方法，用于创建一个 PreparedStatement 对象，该对象可以执行 SQL 语句并返回结果集。其中，sql 参数是要执行的 SQL 语句，resultSetType 和 resultSetConcurrency 参数分别表示结果集的类型和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值