prepjdbc.java~1~

来自「100多M的J2EE培训内容」· JAVA~1~ 代码 · 共 49 行

package com.cwj.DatabaseAccessDemo;

//以下例子演示PreparedStatement的使用
import java.sql.*;

public class PrepJDBC {
  public PrepJDBC() {
    ResultSet result;
    String sqlString="create table book("+
                    "id int not null CONSTRAINT pk_id PRIMARY KEY CLUSTERED,"+
                    "author varchar(20), titile varchar(50))";
    String insertSQL = "Insert INTO digest VALUES(?, ?, ?)" ;
    int[] ids = {1, 2, 3, 4, 5} ;
    String[] authors = {"java", "rjb", "java", "bill", "scott"} ;
    String[] titles = { "Prepared Hello",
    "Prepared Hello Java",
    "Prepared Hello Robert",
    "Prepared Hello from Bill",
    "Prepared Hello from Scott"} ;

    try{
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=Northwind;User=sa;Password=sa");
        Statement stat1=conn.createStatement();
        stat1.executeUpdate(sqlString);

        PreparedStatement pstmt = conn.prepareStatement(insertSQL) ;
        for(int i = 0 ; i < ids.length ; i++){
                pstmt.setInt(1, ids[i]) ;

                pstmt.setString(2, titles[i]) ;
                pstmt.setString(3, authors[i]) ;
                pstmt.executeUpdate() ;
        }

        Statement stat2=conn.createStatement();

        //下面语句检查刚才插入的记录
        result=stat2.executeQuery("Select * from customers where CustomerID='ZKRJ'");
        System.out.println("客户ID"+"  "+"公司名称"+"         "+"联系人姓名");
        while(result.next()){
          System.out.println(result.getString(1)+"  "+result.getString(2)+"  "+result.getString(3));
        }

    }catch(Exception e){
     System.out.println("Error"+e);
    }
  }
}