连接数据库的类~

package testweb;

import java.sql.*;

/**
 * <p>Title: 连接数据库</p>
 * <p>Description: 连接数据库的类</p>
 * <p>Copyright: Copyright (c) FrogGroup 2004</p>
 * <p>Company: FrogGroup</p>
 * @author ZoRRo.X
 * @version 0.1
 */

public class DbConn {
  private Connection con;
  private Statement stmt; //Statement 对象用于把 SQL 语句发送到 DBMS
  private boolean inited = false;
  private String localhost = "jdbc:mysql://localhost:3306/";
  private String dbDriver = "org.gjt.mm.mysql.Driver";

  public DbConn(){
    this("testweb", "xxx", "");
  }

  public DbConn(String ODBC, String UID, String PWD) {
    //inited = true; //是否已经初始化了
    try {
      Class.forName(dbDriver); //装载mysql驱动
      con = DriverManager.getConnection(localhost + ODBC, UID, PWD); //连接mysql数据库
      stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
                                 ResultSet.CONCUR_READ_ONLY); //连接
    }
    catch (Exception ex) {
      errReport(ex, "DbConn: 数据库连接创建失败");
      inited = false; //初始化失败
    }
  }

  //错误报告
  private void errReport(Exception ex, String position) {
    System.out.print("----====" + position + "====----");
    System.out.println("----====" + (new java.util.Date().toString()) +
                       "====----");
    System.out.println(ex.getMessage());
  }

  public java.sql.Connection getConnection() {
    return con;
  }

  public java.sql.Statement getStatement() { //返回sql语句
    return stmt;
  }

}