package com;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class DBUtil {

	private static String url;
	private static String driver;
	private static String user;
	private static String password;

	static {
		try {
			ClassLoader classLoader = DBUtil.class.getClassLoader();

			InputStream is = classLoader
					.getResourceAsStream("config/props/db.properties");

			Properties props = new Properties();

			props.load(is);

			url = props.getProperty("url");
			driver = props.getProperty("driver");
			user = props.getProperty("user");
			password = props.getProperty("password");

			// regist drawing

			Class.forName(driver);
		} catch (ClassNotFoundException e) {

			e.printStackTrace();
			throw new RuntimeException("");
		} catch (IOException e) {
			e.printStackTrace();
			throw new RuntimeException("");
		}
	}

	// get connect
	public static Connection getConnection() throws Exception {
		return DriverManager.getConnection(url, user, password);
	}

	// close connect
	public static void close(ResultSet rs, Statement smt, Connection conn)
			throws Exception {
		if (rs != null) {
			rs.close();
		}
		if (smt != null) {
			smt.close();
		}
		if (conn != null) {
			conn.close();
		}
	}

	public static void close(Statement smt, Connection conn) throws Exception {
		close(null, smt, conn);
	}

	public static void main(String[] args) throws Exception {
		System.out.println(getConnection());
	}
	// close connection with resultset
}