cardconnect.java

J2SE实现信用卡管理系统,适合新手学习使用

package card;

import java.sql.*;
/**
 * 建立与关闭数据库连接的辅助类
 */
public class CardConnect
{
  //调用本类的构造方法
  private static CardConnect dbconn=new CardConnect();
  private CardConnect()
  {
   try
   {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   }catch(ClassNotFoundException ee){
      ee.printStackTrace();
   }

  }

  public static Connection getconn() throws SQLException
  {
    String url="jdbc:odbc:dbcard";
    String username="sa";
    String password="";
    return DriverManager.getConnection(url,username,password);
  }

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

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

  public static void close(Connection conn)
  {
    try
    {
      if(conn!=null)
        conn.close();
    }catch(Exception ex){}
  }
}