package dao;
/**
* @author 作者: guya
* description:
*/

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

import util.JdbcUtil;

public class DbUtil {
	public static Connection getConnection() {
		Connection conn=null;
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_exam?useSSL=false&serverTimezone=UTC",
			        "root", "123456");
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}   
		return conn;
	}
	public static void close(Connection connn,Statement st){
		try {
			st.close();
			connn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void close(Connection connn,PreparedStatement ps){
		try {
			ps.close();
			connn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void close(Connection connn,PreparedStatement ps, ResultSet rs){
		try {
			rs.close();
			ps.close();
			connn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void close(Connection connn,Statement st, ResultSet rs){
		try {
			rs.close();
			st.close();
			connn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		System.out.println(getConnection());
	}
}