updatejdbc.java~4~

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

package com.cwj.DatabaseAccessDemo;

import java.sql.*;

public class UpdateJDBC {
  public UpdateJDBC(){
    ResultSet result;
    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();
        Statement 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));
        }
    }catch(Exception e){
     System.out.println("Error"+e);
    }
  }
}