databaseconnection.java

来自「是关于struts+hibernate+spring开发宝典的源代码,希望对大家」· Java 代码 · 共 72 行

package cn.hxex.tutorial;

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

/**
 * 数据库辅助工具类
 * 
 * @author galaxy
 */
public class DatabaseConnection {

	public static String url = "jdbc:oracle:thin:@192.168.10.121:1521:HiFinance";
	public static String user = "scott";
	public static String password = "tiger";
	public static String driver = "oracle.jdbc.driver.OracleDriver";
	
	/**
	 * 获得数据库的连接
	 * @return 数据库的连接
	 */
	public static Connection getConnection()
	{
		try {
			Class.forName( driver );
			return DriverManager.getConnection( url, user, password );
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
			return null;
		}
	}
	
	/**
	 * 关闭与数据的连接，并释放相应的资源
	 */
	public static void releaseConnection( Connection conn, Statement st, ResultSet rs )
	{
		if( rs!=null )
		{
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		if( st!=null )
		{
			try {
				st.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		if( conn!=null )
		{
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}