bankconnect.java~2~

来自「银行管理系统,根据实习的要求以及参考现实中的银行数据库系统」· JAVA~2~ 代码 · 共 70 行

package bank;
import java.sql.*;
/**
 * <p>Title: bank system</p>
 *
 * <p>Description: for save for get money</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: evalet</p>
 *
 * @author chenxiuzhu
 * @version 1.0
 */
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=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 bankconnect dbconn = new bankconnect();
  private void jbInit() throws Exception {
  }

}