java c3p0方式连接oracle mysql 的basedao

来源：互联网发布：淘宝产品推广方法编辑：程序博客网时间：2024/06/05 17:31

带有main方式测试：

package cn.com.systop.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseDAO {
/*
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

private static final String URL = "jdbc:oracle:thin:@localhost:1521:db_oracle";

private static final String UNAME = "accp";

private static final String UPWD = "accp";
*/

private static final String DRIVER = "com.mysql.jdbc.Driver";

private static final String URL = "jdbc:mysql://localhost:3306/db_mysql";

private static final String UNAME = "root";

private static final String UPWD = "123456";

protected Connection con;

protected PreparedStatement pstm;

protected ResultSet rs;

public void getConnection() throws Exception {
  Class.forName(DRIVER);
  con = DriverManager.getConnection(URL,UNAME,UPWD);

  System.out.println("数据库连接成功！");
}

public void closeAll() {
  if (rs != null) {
   try {
    rs.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  if (pstm != null) {
   try {
    pstm.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  try {
   if (con != null && con.isClosed() == false) {
    con.close();
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

public static void main(String[] args){
  BaseDAO baseDAO = new BaseDAO();
  try {
   baseDAO.getConnection();
  } catch (Exception e) {
   e.printStackTrace();
  }
}

}