数据库连接工具类

最新推荐文章于 2024-10-01 08:16:13 发布

原创最新推荐文章于 2024-10-01 08:16:13 发布 · 619 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

Java 专栏收录该内容

24 篇文章

订阅专栏

本文介绍了一个使用Java进行Oracle数据库连接及基本操作的示例类。该类提供了获取数据库连接的方法，并实现了对连接状态的检查及资源关闭的功能。

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);
		}
	}
}