trafficconnect.java

一个实用的公交系统

package traffic;

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

public class trafficConnect {
  public trafficConnect() {
                    try{
                     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                    }
                    catch(ClassNotFoundException ee){

                    }
          }

          public static Connection getconn() throws SQLException{
                   String url = "jdbc:microsoft:sqlserver://keweixing:1433;DatabaseName=dbtraffic";
                    String username= "sa";
                    String password= "";
                    return DriverManager.getConnection(url,username,password);
          }

          public static void close(ResultSet rs){
                    try{
                      rs.close();
                    }
                    catch(Exception ex){
                    }
          }

          public static void close(Statement stmt){
                    try{
                      stmt.close();
                    }
                    catch(Exception ex){
                    }
          }

          public static void close(Connection conn){
                    try{
                      conn.close();
                    }
                   catch(Exception ex){
                    }
          }
        private static trafficConnect dbconn = new trafficConnect();
}