updatejdbc.java

100多M的J2EE培训内容

package com.cwj.DatabaseAccessDemo;

import java.sql.*;

public class UpdateJDBC {
  public UpdateJDBC(){
    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="update customers set ContactName='王女士' where  CustomerID='ZKRJ'";
        stat1.executeUpdate(sqlString);
        //下面语句检查刚才修改的记录
        result=stat2.executeQuery("Select * from customers where CustomerID='ZKRJ'");
        System.out.println("修改后的记录信息");
        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);
    }
  }
}