package?com.routon.dao;

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

public?class?Conn?{
	public?static?Connection?getConnection（）?{
		Connection?conn?=?null;
		try?{
			//?裝載驅動com.microsoft.jdbc.sqlserver.SQLServerDriver.class
			Class.forName（“com.mysql.jdbc.Driver“）;
			//?定義數據庫連接所需的URL地址
			String?url?=?“jdbc:mysql://172.16.42.57:3306/zengjiangfeng“;
			//獲得連接
			conn?=?DriverManager.getConnection（url?“root“?“12345678“）;
			}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（“裝載驅動錯誤“）;
			}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（“創建數據庫連接錯誤“）;
			}
		return?conn;
	}

	/**
	?*?釋放資源
	?*?@param?conn
	?*?@param?st
	?*?@param?rs
	?*/
	public?static?void?clear（Connection?conn?PreparedStatement?ps?ResultSet?rs）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;				
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if?（ps?!=?null）?{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}
	
}