各种数据库工具类

今天为各种数据库做了些总结并为各种数据库的连接分别写了工具类.这些工具类都是经过本人测试了的，下载下去就能直接用。这里给个现成的Oracle工具类：
package com.dfbz.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DBTools {

private static String driver;
private static String url;
private static String name;
private static String pwd;


static{
try {
InputStream in = DBTools.class.getResourceAsStream("/com/dfbz/util/database.properties");
java.util.Properties props = new Properties();
props.load(in);
in.close();
url = props.getProperty("url");
driver = props.getProperty("driver");
name = props.getProperty("name");
pwd = props.getProperty("pwd");
} catch (IOException e1) {
e1.printStackTrace();
}


try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConn() {

Connection conn = null;
try {
conn = DriverManager.getConnection(url,name,pwd);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}

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

}

}
=============================
在项目的src下建立一个database.properties文件
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@192.168.0.25:1521:XE
name=hr
pwd=hr