dbtest.java

bbs论坛系统

package struts.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DBTest 
{ 
  
 Connection con; 
 Statement  sta; 
 ResultSet  rs; 
  
 String driver; 
 String url; 
 String user; 
 String pwd; 
 public DBTest() 
 { 
     driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
     url    = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test"; 
     //test为数据库名 
     user   = "sa"; 
     pwd    = "6599996"; 
     //请更改为你相应的用户和密码 
     init(); 
 } 
 public void init() 
 { 
  try{ 
   Class.forName(driver); 
   System.out.println("driver is ok"); 
   con = DriverManager. 
getConnection(url,user,pwd); 
   System.out.println("conection is ok"); 
      sta = con.createStatement(); 
      rs  = sta.executeQuery("select * from room"); 
     if(rs.next()) 
       System.out.println("success!");  
  }catch(Exception e) 
   { 
    e.printStackTrace(); 
   } 
 } 
  
 public static void main(String[] args)  
 { 
  new DBTest(); 
 } 
}