连接Oracle 11g时用到的数据库连接和释放工具类DBUtil

package com.qst.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//数据库连接和释放工具类
public class DBU {
		//数据库实例用户名，可根据自己的设置进行更改
		static String user = "shixun";
		//数据库实例密码，可根据自己的设置进行更改
		static String password = "orcl";
		//数据库实例链接地址，可根据自己的设置进行更改
		static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		static {
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
		}

		public static Connection getConnection() {
			Connection conn = null;
			try {
				conn = DriverManager.getConnection(url, user, password);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			return conn;
		}

		public static void closeJDBC(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();
				}
			}

		}

	}