barconnect.java

用JBUILDER和SQL2

 package bar;
 import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class barConnect {
  public barConnect() {
    try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }catch(ClassNotFoundException e){}
  }
  public static  Connection getconn() throws SQLException{
    String url="jdbc:microsoft:sqlserver://102-38:1433;DatabaseName=webbra";
    String username="sa";
    String password="123456";
    return DriverManager.getConnection(url,username,password);
  }
  public static void  close(ResultSet rs){
    try{
      rs.close();
    }catch(Exception e){}
  }
  public static void  close(Statement stmt){
    try{
      stmt.close();
    }catch(Exception e){}
  }
  public static void  close(Connection conn){
    try{
      conn.close();
    }catch(Exception e){}
  }
  private static    barConnect dbconn=new barConnect();


}