connectdb.java

一个小公司要求给写的很简单的任务管理系统。

package com.wykj.database;

import java.sql.*;
import javax.servlet.*;
import javax.sql.*;

public class ConnectDB {

  private static DataSource dataSource = null;
  private static Connection conn = null;
  public ConnectDB() {

  }

  synchronized private static void init() {

  }

  public Connection getConnection() throws SQLException {
    try {
      String sourceURL =
          "jdbc:odbc:rwgl";
      //DataBase是Access MDB文件的主文件名
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection(sourceURL, "", "");

    }
    catch (Exception e) {
    }
    return conn;

  }

  public void release() throws ServletException {
    if (conn != null) {
      try {
        if (!conn.isClosed()) {
          conn.close();
        }
      }
      catch (SQLException se) {
      }
    }
  }

  public static void main(String[] args){
    ConnectDB cd = new ConnectDB();
    Connection conn1 = null;
    try {
      conn1 = cd.getConnection();
    }
    catch (SQLException ex) {
    }
    System.out.print(conn1);

  }
}