cardconnect.java~1~

来自「小型的信用卡账户管理系统」· JAVA~1~ 代码 · 共 55 行

package card;

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 cardConnect {
         public cardConnect() {
                    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=dbcard";
                    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 cardConnect dbconn = new cardConnect();
}