发个jdbc工具类

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JdbcUtil 
{
	private static String db_driver;
	private static String db_url;
	private static String db_userName;
	private static String db_passWord;

	static
	{
		Properties pro=new Properties();
		try {
		     pro.load(new FileInputStream((JdbcUtil.class.getResource("/").getPath()+"/jdbc.properties"))); 
			db_driver=pro.getProperty("db_driver");
			db_url=pro.getProperty("db_url");
			db_userName=pro.getProperty("db_userName");
			db_passWord=pro.getProperty("db_passWord");
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public static Connection getConnection()
	{
		Connection conn=null;

		try {
			Class.forName(db_driver);

			conn=DriverManager.getConnection(db_url, db_userName, db_passWord);


		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return conn;
	}

	public static void close(Connection conn,PreparedStatement ps,ResultSet rs)
	{
		if(rs!=null)
		{
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(ps!=null)
		{
			try {
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public static void close(Connection conn)
	{
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}



}

db_driver=oracle.jdbc.driver.OracleDriver
db_url=jdbc:oracle:thin:@10.66.6.10:1521:dot
db_userName=fms2
db_passWord=1qaz2wsx