package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectionFactory {
	public static Connection conn = null;
	private static String driver = "com.mysql.jdbc.Driver";
	private static String url;
	private static String userName = "root";
	private static String password = "";

	public static Connection getConnection() {
		try {
			Class.forName(driver);
			url = "jdbc:mysql://127.0.0.1:3306/student";
			conn = DriverManager.getConnection(url, userName, password);// 建立連接
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return conn;
	}

	public static void close(Statement st, Connection con) {
		close(st);
		close(con);
	}

	public static void close(ResultSet rs, Statement st) {
		close(rs);
		close(st);
	}

	public static void close(ResultSet rs) {
		try {
			rs.close();
		} catch (Exception e) {
		}
	}

	public static void close(Statement st) {
		try {
			st.close();
		} catch (Exception e) {
		}
	}

	public static void close(Connection con) {
		try {
			con.close();
		} catch (Exception e) {
		}
	}
}