JDBC的PrepareStatement - bulote - ITeye博客

`

bulote

浏览: 1385743 次

最近访客更多访客>>

u012363178

songhait

chk141

sharpbai

博主相关

博客

微博

相册

收藏

留言

关于我

文章分类

全部博客 (1272)

社区版块

存档分类

2012-02 ( 25)
2012-01 ( 145)
2011-12 ( 22)
更多存档...

最新评论

JDBC的PrepareStatement

阅读更多

<wbr></wbr>

public class Information {
<wbr><wbr><wbr><wbr><wbr><wbr> String id="";<br><wbr><wbr><wbr><wbr><wbr><wbr> String name="";<br><wbr><wbr><wbr><wbr><wbr><wbr> String advice="";<br><wbr>public String getAdvice() {<br><wbr><wbr>return advice;<br><wbr>}<br><wbr>public void setAdvice(String advice) {<br><wbr><wbr>this.advice = advice;<br><wbr>}<br><wbr>public String getId() {<br><wbr><wbr>return id;<br><wbr>}<br><wbr>public void setId(String id) {<br><wbr><wbr>this.id = id;<br><wbr>}<br><wbr>public String getName() {<br><wbr><wbr>return name;<br><wbr>}<br><wbr>public void setName(String name) {<br><wbr><wbr>this.name = name;<br><wbr>}<br><wbr><wbr><wbr><wbr><wbr><wbr><br> }<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr></wbr>

public class JdbcTest {<wbr></wbr>

<wbr><br><wbr>public static void main(String[] args) throws ClassNotFoundException, SQLException {<br><wbr><wbr>// TODO Auto-generated method stub<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Class.forName("oracle.jdbc.driver.OracleDriver");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.9.29:1521:ac","bre","123");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //用PreparedStatement实现，每次执行一个条件<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //插入<br><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt0 =conn.prepareStatement("INSERT INTO Information VALUES</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> (?, ?, ?)");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(1, "111");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(2, "周鑫");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(3, "开心");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn0=pstmt0.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr> //更改<br><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt1 =conn.prepareStatement("UPDATE INFORMATION SET ADVICE=?WHERE</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> NAME=?");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt1.setString(1, "xxxx");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt1.setString(2, "aaaaa");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn1=pstmt1.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //删除<br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt2 =conn.prepareStatement("DELETE INFORMATION WHERE NAME=?");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt2.setString(1, "aaaaa");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn2=pstmt2.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //查询<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt3 =conn.prepareStatement("SELECT * FROM INFORMATION");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn3=pstmt3.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ResultSet rset1 =pstmt3.getResultSet();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> while(rset1.next())<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> {<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s1=rset1.getString(1);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s2=rset1.getString(2);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s3=rset1.getString(3);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> System.out.println(s1+"\t"+s2+"\t"+s3);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> }<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> rset1.close();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt3.close();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt3.close();<br><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

分享到：

asp.net后台前台代码相互绑定大总结 | SqlParameter类——带参数的SQL语句

2012-01-30 08:24
浏览 917
评论(0)
查看更多

评论

发表评论

您还没有登录,请您登录后再发表评论

相关推荐

JDBC PrepareStatement 使用（附各种场景 demo）: PrepareStatement是JDBC提供的一种预编译的SQL语句，它可以提高数据库操作的效率和安全性。本资源主要涵盖了使用JDBC PrepareStatement进行MySQL数据库操作的各种场景，包括基本的查询、更新以及批量处理。首先，...

JDBC(用PrepareStatement实现): **JDBC(用PrepareStatement实现)** Java Database Connectivity (JDBC) 是Java平台中的一个标准API，用于在Java应用程序和各种数据库之间建立桥梁。它允许Java开发者执行SQL语句，进行数据查询、更新和删除等操作。...

prepareStatement和Statement的区别: prepareStatement和Statement的区别 prepareStatement和Statement是 Java 中两个常用的数据库操作接口，它们都可以用来执行 SQL 语句，但是它们之间有着明显的区别。首先，从创建时的区别开始，Statement 需要...

利用JDBC的PrepareStatement打印真实SQL的方法详解: PreparedStatement ps = connection.prepareStatement(sql); ps.setInt(1, 10); ``` 在这个例子中，我们想知道实际执行的SQL语句是"SELECT * FROM table WHERE id = 10"。为了实现这个需求，我们可以自定义一个辅助...

java数据库连接PrepareStatement: 要创建一个 `PreparedStatement` 对象，首先需要通过 `Connection` 对象调用 `prepareStatement` 方法，并传入一个 SQL 语句字符串。例如： ```java // 假设 con 是已建立的 Connection 对象 String sql = "UPDATE ...

JDBC从入门到放弃02-JDBC的Statement数据库增加和删除: PreparedStatement pstmt = conn.prepareStatement(sql); // 使用PreparedStatement防止SQL注入 pstmt.setString(1, "John Doe"); pstmt.setString(2, "john.doe@example.com"); int rowsInserted = pstmt....

JDBC中Statement和Preparement的使用讲解: JDBC 中 Statement 和 PrepareStatement 的使用讲解 Statement 对象是用来执行 SQL 语句的接口，提供了基本的 SQL 语句执行功能。PrepareStatement 是 Statement 的子接口，提供了预编译的功能，可以提高性能和安全...

解决oracle 驱动bug： preparestatement ArrayIndexOutOfBounds: In Oracle Metalink (Oracle's support site - Note ID 736273.1) I found that this is a bug in JDBC adapter (version 10.2.0.0.0 to 11.1.0.7.0) that when you call preparedStatement with more than 7 ...

jdbc知识带注释: PreparedStatement pstmt = conn.prepareStatement("INSERT INTO mytable VALUES (?, ?)"); pstmt.setString(1, "value1"); pstmt.setInt(2, 10); pstmt.addBatch(); pstmt.setString(1, "value2"); pstmt....

jdbc jdbc jdbc: `Connection`对象提供了多种方法，如`createStatement()`、`prepareStatement()`和`CallableStatement`，用于创建执行SQL语句的对象。 3. **SQL语句（Statement）**：`Statement`对象用于执行SQL查询和命令。有三种...

JAVA JDBC小例子: PreparedStatement pstmt = conn.prepareStatement(insertSql); pstmt.setString(1, "John Doe"); pstmt.setString(2, "john.doe@example.com"); pstmt.executeUpdate(); ``` 2. **读取（Read）**：查询数据。...

jdbc线程池演示demo: PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, value1); pstmt.setString(2, value2); pstmt.executeUpdate(); // 批量插入 List[]> data = ...; // 包含多条数据 for (String[] row ...

java使用JDBC动态创建数据表及SQL预处理的方法: ps = conn.prepareStatement(sql); ps.executeUpdate(sql); ps.close(); conn.close(); } catch (SQLException e) { System.out.println("建表失败" + e.getMessage()); } } ``` 三、动态添加数据使用 ...

JDBC学习文档: 5. **创建带有类型、并发性和保持性的PreparedStatement**：`PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)` - **用途**：创建一个带...

精通jdbc，jdbc自学文档，jdbc帮助文档: PreparedStatement pstmt = conn.prepareStatement("INSERT INTO mytable VALUES (?, ?)"); pstmt.setString(1, "value1"); pstmt.setInt(2, 123); pstmt.executeUpdate(); ``` **4. ResultSet** `ResultSet`是查询...

sql server2000 jdbc: PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM myTable"); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { // 处理结果集 } ``` 5. **事务管理**： SQL Server 2000支持事务...

JDBCJDBC高级应用: 使用 `Connection.prepareStatement(String sql)` 创建预编译语句对象，然后使用 `setXXX()` 方法设置参数。 - 预编译语句特别适合于多次执行的SQL，因为它们只需要编译一次。 6. **存储过程的使用**： - 存储...

jdbc教程_jdbc教程: PreparedStatement pstmt = conn.prepareStatement("INSERT INTO users(name, email) VALUES (?, ?)"); pstmt.setString(1, "John Doe"); pstmt.setString(2, "john@example.com"); pstmt.executeUpdate(); ...

jdbc使用参考手册: - **PreparedStatement对象**：预编译的SQL语句，可防止SQL注入，如`PreparedStatement pstmt = conn.prepareStatement("INSERT INTO users VALUES (?, ?)");`。 - **CallableStatement对象**：用于调用存储过程。 ...

Global site tag (gtag.js) - Google Analytics