数据库连接工具类

package com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.log4j.Logger;

public class DB {

	  private final static String url = "jdbc:oracle:thin:@127.0.0.1:1521:db";
	  public static final String username = "username";
	  public static final String password = "password";
	  private static Logger log = Logger.getLogger(DB.class);
	  private static Connection conn = null;
	  
	public static Connection getConnection() {
		if(conn == null){
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
				conn = DriverManager.getConnection(url, username,password);
			} catch (Exception e) {
				log.error(e);
			}
		}else{
			try {
				boolean isClose = conn.isClosed();
				if(isClose){
					conn = null;
					Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
					conn = DriverManager.getConnection(url, username,password);
				}
			} catch (Exception e) {
				log.error("判断数据库连接状态失败!"+e);
			}
		}
		return conn;
	}
	
	public static void closeDB(Connection conn, PreparedStatement ps) {
		closeDB(conn, ps, null);
	}
	
	public static void closeDB(PreparedStatement ps, ResultSet rs) {
		closeDB(null, ps, rs);
	}
	
	
	public static void closeDB(Connection conn, PreparedStatement ps, ResultSet rs) {
		try {
			if(rs != null){
				rs.close();
			}
			if (ps != null) {
				ps.close();
			}
			if(conn != null){
				conn.close();
			}
		} catch (SQLException e) {
			log.error("关闭资源失败,"+e);
		}
	}
}