package Dao;

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

public class BaseDao {
	private String url = "jdbc:mysql://localhost:3306/book?serverTimezone=GMT%2B8";
	private String user = "root";
	private String password = "zyd525";
	private String driver = "com.mysql.cj.jdbc.Driver";
	

	protected Statement createSatement() throws ClassNotFoundException, SQLException {
		// 1,导入mysql connecter jar包
		// 2,加载驱动类Driver
		Class.forName(driver);
		// 3,创建连接类(建立通道)
		Connection conn = DriverManager.getConnection(url, user, password);
		// 4，具体操作（增删改查）
		Statement state = conn.createStatement();
		return state;
	}
	
	protected Connection createConnection() throws ClassNotFoundException, SQLException {
		// 1,导入mysql connecter jar包
		// 2,加载驱动类Driver
		Class.forName(driver);
		// 3,创建连接类(建立通道)
		Connection conn = DriverManager.getConnection(url, user, password);
		// 4，具体操作（增删改查）
		//Statement state = conn.createStatement();
		
		return conn;
	}
}