testjdbc.java

用于测试JDBC访问数据库的测试程序。希望对大家有所帮助。

import java.sql.*;

public class TestJdbc {
 
 Connection con;
 Statement  sta;
 ResultSet  rs;
 
 String driver;
 String url;
 public TestJdbc()
 {
  driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
     init();
 }
 public void init()
 {
  try{
   System.out.println("dddddddddddddddd");
   Class.forName(driver);
   System.out.println("driver is ok");
   con = DriverManager.getConnection(url,"sa","");
   System.out.println("conection is ok");
      sta = con.createStatement();
      rs = sta.executeQuery("select * from Customers");
      while(rs.next())
       System.out.println(rs.getString(1)); 
  }catch(Exception e)
   {
    e.printStackTrace();
   }
 }
 
 public static void main(String args[])
 {
  System.out.println("KKKKKKKKKKK");
  new TestJdbc();
 }
}