connectionhelper.java

用jsp,servlet实现人力资源管理系统

package com.test;

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

public class ConnectionHelper {
	public static Connection getConnection() {
		Connection con = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:WOLF","system","system");
			if(con==null){
				System.out.println("连接失败!");
			}else{
				System.out.print("ok");
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		return con;
	}
	
	 public static void closeConnection(Connection con, Statement st, ResultSet rs) {
		 if(con != null) {
			 if(rs != null) {
				 try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			 }
			 if(st != null) {
				 try {
					 st.close();
				 } catch (SQLException e) {
					 e.printStackTrace();
				 }
			 }
			 try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		 }
	 }
	 public  static void main(String[] args){
		 ConnectionHelper.getConnection();
	 } 
}