insertjdbc.java~1~

100多M的J2EE培训内容

package com.cwj.DatabaseAccessDemo;

import java.sql.*;

public class InsertJDBC {
  public InsertJDBC(){
     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="insert customers values('ZKRJ','中科软件有限公司','刘小姐','销售代表','大崇明路 50 号','北京','华北','343567','中国','[phone]','[phone])')";
         stat1.executeUpdate(sqlString);
         //下面语句检查刚才插入的语句
         result=stat2.executeQuery("Select * from customers");
         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);
     }
  }
}