connectionhelper.java

基于SSH (struts+spring+hibernate)框架设计的 CRM客户关系管理系统

package com.csu.crm.login;

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

import javax.swing.JOptionPane;

public class ConnectionHelper {
	public static Connection getConnection() {
		Connection con = null;
		String driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@localhost:1521:FENGZI";
		try {
			Class.forName(driver);
				       con = DriverManager.getConnection(url,"system","manager");
			if (con != null) {
				System.out.println("数据库连接成功");
			} else {
				System.out.println("数据库连接失败");
				//	    	  JOptionPane.showMessageDialog(null,"数据库连接失败","出错拉",JOptionPane.YES_NO_CANCEL_OPTION);
			}
		} catch (ClassNotFoundException e) {
			System.out.println(e.getMessage());
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		}
		return con;
	}

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

		try {
			if (ps != null) {
				ps.close();
			}

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

		try {
			if (con != null) {
				con.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}