insertjdbc.java

100多M的J2EE培训内容

package com.cwj.DatabaseAccessDemo;

import java.sql.*;

public class InsertJDBC {
  public InsertJDBC(){
    Connection conn=null;
    Statement stat1=null;
    Statement stat2=null;
    ResultSet result=null;
     try{
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
         conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=Northwind;User=sa;Password=sa");
         stat1=conn.createStatement();
         stat2=conn.createStatement();
         String sqlString="insert customers values('ZKRJ','中科软件有限公司','刘小姐','销售代表','大崇明路 50 号','北京','华北','343567','中国','[phone]','[phone])')";
         stat1.executeUpdate(sqlString);
         //下面语句检查刚才插入的记录
         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));
         }
         if(result!=null){
            result.close();
         }
         if(stat1!=null){
            stat1.close();
         }
         if(stat2!=null){
            stat2.close();
         }
         if(conn!=null){
           conn.close();
         }
     }catch(Exception e){
      System.out.println("Error"+e);
     }
  }
}