databaseconn.java

JSP+Servlet+JavaBean+标签文件写的分页标签！

package page;

import java.sql.Connection;
import java.sql.DriverManager;

public class DataBaseConn {
  private Connection con = null;
  private static DataBaseConn me = new DataBaseConn();
  private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
  private String url = "jdbc:odbc:Driver={SQL Server};Server=.;database=test";

  private DataBaseConn() {
  }

  public static DataBaseConn newInstance() {
    return me;
  }

  public Connection getConnDB() {
    try {
      Class.forName(driver);
      con = DriverManager.getConnection(url);
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return con;
  }
}