package Util;

import java.io.FileReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class JDBCUtil {
	private static String driver="com.mysql.jdbc.Driver";
	private static String url="jdbc:mysql://localhost:3306/jspdemo?useUnicode=true&characterEncoding=utf8";
	private static String user="root";
	private static String password="787913269";

	static Connection conn = null;

	static {
		/*
		 * Properties properties = new Properties(); // 创建一个properties对象 Reader
		 * inReader; // 一个reader属性;
		 * 
		 * try { String path =
		 * Thread.currentThread().getContextClassLoader().getResource("jdbc.properties")
		 * .getPath(); inReader = new FileReader(path); // 用这个方法获取properties配置文件;
		 * properties.load(inReader); // 加载load内部的地址; } catch (Exception e) { // TODO
		 * Auto-generated catch block e.printStackTrace(); }
		 */

		// 通过properties.getProperty("driver");方法获取值
		/*
		 * driver = properties.getProperty("driver"); url =
		 * properties.getProperty("url"); user = properties.getProperty("user");
		 * password = properties.getProperty("password");
		 */
	}
	/**
	 * 打开数据库连接
	 * 
	 * @return
	 */
	public static Connection open() {
		try {
			Class.forName(driver);
			System.out.println("连接成功......");
			return DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			System.out.println("连接数据库失败....");
		}
		return null;
	}

	/**
	 * 关闭数据库连接
	 * 
	 * @return
	 */
	

	public static void close(Connection con,PreparedStatement ps,ResultSet rs) {
		if (conn != null) {
			try {
				conn.close();// 关闭数据库
				System.out.println("关闭...");
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		if (ps != null) {
			try {
				ps.close();// 关闭数据库
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		if (rs != null) {
			try {
				ps.close();// 关闭数据库
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

}