封装一个JDBC工具类

封装JDBC工具类代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class JDBCUtils {
// ResourceBundle读取配置文件
private static final ResourceBundle RB = ResourceBundle.getBundle("jdbc");
private static final String URL = RB.getString("url");
private static final String USERNAME = RB.getString("username");
private static final String PASSWORD = RB.getString("password");
static {
	try {
		Class.forName(RB.getString("driverClass"));
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	}
}

// 获取连接
public static Connection getConnection() throws SQLException {
	return DriverManager.getConnection(URL, USERNAME, PASSWORD);
}

//关闭资源方法
public static void release(ResultSet rs, Statement stmt, Connection conn) {
	if ( rs != null ) {
		try {
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	if ( stmt != null ) {
		try {
			stmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	if ( conn != null ) {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

public static void main(String[] args) throws SQLException {
	System.out.println(getConnection());
}
}