连接Oracle数据库

package wftech.util;

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

/**
 * 提供对Oracle数据库的连接以及关闭连接等功能
 *
 * @author 

 * @version 1.0
 * @date 2010-8-27
 *
 */
public class ConnectionUtil {
 
 /**
  * 对数据库进行连接
  * @author 
  * @return Connection连接对象
  */
 public static Connection getConnection() {

  String url = "jdbc:oracle:thin:@localhost:1521:or10g";
  String userName = "scott";
  String password = "tiger";
  Connection con = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   con = DriverManager.getConnection(url, userName, password);

  } catch (Exception e) {
   e.printStackTrace();
  }

  return con;
 }

 public static void closeCon(Connection con) throws SQLException {
  con.close();
 }

 public static void closeSt(Statement st) throws SQLException {
  st.close();
 }

 public static void closeRs(ResultSet rs) throws SQLException {
  rs.close();
 }
}