bankconnect.java

银行管理系统,根据实习的要求以及参考现实中的银行数据库系统

package bank;
import java.sql.*;
//数据库连接类
public class bankconnect
{

  public bankconnect()
  {
    try
    {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }
    catch(ClassNotFoundException e){}
    try
    {
       jbInit();
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }

}
  public static Connection getconn() throws SQLException{
                   String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bank";
                    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 bankconnect dbconn = new bankconnect();
  private void jbInit() throws Exception {
  }

}