package demo;

import java.sql.*;

public class database {
	String url;
	String name;
	String pwd;
	String driverName;

	public database() {
		url = "jdbc:mysql://127.0.0.1:3306/mybookshop";
		name = "root";
		pwd = "123456";
		driverName = "com.mysql.jdbc.Driver";
		try {
			Class.forName(driverName);// 속潼혜땡
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 돤돕젯쌈
	public Connection getConnection() {
		try {
			return DriverManager.getConnection(url, name, pwd);// 쉔접鑒앴욋젯쌈

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		// TODO Auto-generated method stub
		return null;
	}

	public void CloseConnection(Connection con) {
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}