connect.java

简单的学生管理系统。。用JBUILER和SQL2000。

package studentgl;
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 connect {
 public connect() {
   try{
     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   }catch(ClassNotFoundException e){}
 }
 public static  Connection getconn() throws SQLException{
   String url="jdbc:microsoft:sqlserver://Issac:1433;DatabaseName=studentgl";
   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    connect dbconn=new connect();


}