`
bulote
  • 浏览: 1307517 次
文章分类
社区版块
存档分类
最新评论

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>

分享到：
| SqlParameter类——带参数的SQL语句
评论
发表评论

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

相关推荐

    JDBC(用PrepareStatement实现)

    用JDBC实现Java与数据库的连接，该文件使用PrepareStatement实现。

    JDBC PrepareStatement 使用（附各种场景 demo）

    该资源中包含 JDBC 连接 MySQL 完整代码、常规 select、update 语句完整代码，以及 JDBC 批量处理数据的几种不同方式完整代码，且附带 使用说明！

    利用JDBC的PrepareStatement打印真实SQL的方法详解

    PreparedStatement是预编译的,对于批量处理可以大大提高效率. 也叫JDBC存储过程，下面这篇文章主要给大家介绍了关于利用JDBC的PrepareStatement打印真实SQL的方法，需要的朋友可以参考借鉴，下面来一起看看吧。

    Spring Data JDBC与JDBC的区别

    JDBC规范  ... PrepareStatement:预编译语句，性能更好  CallableStatement：调用存储过程  ResultSet：结果集，封装了多条记录  JDBC数据库连接池/Connection Pool  DBCP:apache tomcat内置  

    踩踩踩JDBC六大步骤

    PrepareStatement: conn.prepareStatement(String sql); CallableStatement: conn.prepareCall(String sql); 4）执行sql语句 stmt.execute(sql); stmt.executeUpdate(sql); stmt.executeQuery(sql); pstmt.execute*...

    解决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详解HTML-JDBC.pp

    1、JDBC(Java Database Connection)：java连接数据库统一接口API,底层主要... PreparedStatemet ps = cn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs.absolute(9000);

    JAVA连接FileMaker完整工程

    JAVA连接FileMaker完整工程 包函FileMaker数据库Java连接驱动 修改工程中的FileMaker安装地址就 可以用JAVA操作FileMaker ... prepareStatement = con.prepareStatement(insertSQL); b = prepareStatement.execute();

    采用JDBC进行数据库分页查询

    一次只从数据库中查询最大maxCount条记录 ... PreparedStatement pstat = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //最大查询到第几条记录.........

    java使用jdbc插入信息时获取id1

    // 设置成可以获取主键 preparedStatement = connection.prepareStatement(sql, Statement.RE

    JDBC 连接MySQL数据库的一系列详细步骤

    JDBC 连接MySQL数据库的一系列详细步骤，包括JDBC API详解 1.DriverManager 2.Connection 3.Statement 4.ResultSet 5.PrepareStatement

    JDBC连接代码

    Class.forName(driver); conn = DriverManager.getConnection(url, userName, passWord); String sql = "select * from t_... ps = conn.prepareStatement(sql); ps.setString(1, "liu"); rs = ps.executeQuery();

    JDBC-Student.rar_callablestatement_dbtoobject_java 学员 管理 系统_jdbc

    一个学员管理系统的实例，演示了JDBC一些拓展的特性，例如PrepareStatement、CallableStatement、ResultSetMetaData、大对象、DataSource等。

    jdbc连接数据库getConnection 增、删、改、查

    ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)+"\t" +rs.getString("password")); } } catch (SQLException e) { ...

    JDBC.txt是链接mysql数据库的源码，复制粘贴即可，需要mysql.jar包

    PreparedStatement ptmt=conn.prepareStatement(sql); ResultSet rs= ptmt.executeQuery(); //查看结果 while(rs.next()){ System.out.println( rs.getString("name")); //资源回收 } rs.close(); ptmt....

    JDBC访问数据库的步骤

    Connection.prepareStatement(sql) （2）Statement.executeQuery() （3）Statement.executeUpdate() 4. Retrieve the result data: 循环取得结果while(rs.next()) 5. Show the result data:将遍历的结果记录显示...

    完美的myeclipse连接mysql代码和最新驱动包JDBC

    pstmt = conn.prepareStatement(sql); pstmt.setObject(1, id); pstmt.setObject(2, name); pstmt.setObject(3, classname); pstmt.setObject(4, sex); pstmt.setObject(5, age); pstmt...

    jdbc-odbc的基本操作

    pstmt = cn.prepareStatement("select PCity from shouji where ?=PhoneNo"); pstmt.setString(1, tel.substring(0, 7)); rs = pstmt.executeQuery(); if (rs.next()) { result=new String(rs.getBytes("PCity...

    java 数据库实例

    java 中几个连接数据库的小例子 Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@192.168.8.20:1521:recruit";... PreparedStatement pstat = con.prepareStatement(sql);

    有关于jdbc的基本封装

    实现了基本的增删改查的封装，利用了属性配置文件，让代码更加灵活，但也存在不足，只实现了prepareStatement，还有statement没有实现

Magicbox
Global site tag (gtag.js) - Google Analytics