JDBC数据库连接类（MySQL与Oracle举例）

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DataBaseConnectionMySQL { //Oracle连接方式 //private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ; //private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ruan" ; //private static final String DBUSER = "scott" ; //private static final String DBPASSWORD= "tiger" ; //MySQL连接方式 //private static final String DBDRIVER1 = "com.mysql.jdbc.Driver" ; private static final String DBDRIVER2 = "org.gjt.mm.mysql.Driver" ; private static final String DBURL = "jdbc:mysql://localhost:3306/ruan" ; private static final String DBUSER = "root" ; private static final String DBPASSWORD= "mysql" ; private Connection conn ; public DataBaseConnectionMySQL() { // 在这里建立连接 // 饿汉式 } /** * 打开连接 * @return */ public Connection getConnection() { try { if (conn == null || conn.isClosed()) { // 懒汉式 // 连接可以反复使用。 Class.forName(DBDRIVER); conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn ; } /** * 关闭连接 */ public void close() { if (conn != null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }