package?demo;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
/*
?*?數據庫連接
?*/
public?class?baseDao?{
	private?static?String?driver?=?“oracle.jdbc.driver.OracleDriver“;
	private?static?String?url?=?“jdbc:oracle:thin:@localhost:1521:HFACCP“;
	private?static?String?username?=“system“;
	private?static?String?password?=“system“;
	
	/**
	?*?定義數據庫連接工具
	?*?*/
	public?static?Connection?con?=?null;
	public?PreparedStatement?ps?=?null;
	public?ResultSet?rs?=?null;
	public???Connection?getConnection（）{
		try?{
			//加載數據庫驅動程序
			Class.forName（driver）;
			//獲得連接
			con=DriverManager.getConnection（urlusernamepassword）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?con;

	}
	public?void?shutdown（Connection?conPreparedStatement?psResultSet?rs）{
		try?{
			if（rs?!=?null?）
				rs.close（）;
			if（ps?!=?null）
				ps.close（）;
			if（con?!=?null）
				con.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}