DBUtil

package util;

import java.sql.*;

import java.io.*;

import java.util.*;

public class DBUtil {

private static String driver, url, user, pass;

//보통 이런 정보들은 한번 읽으면 자주변경되지는 않는다.

//이럴경우 한번 읽어서 계속 재효ㅑㄹ용 라할 수 있겠다.

// 한번 읽어서 쭈~ 이런작업이 있다면

// static 키워드를 떠올리자.

static {

loadInfo();

driverLoading();

}

private static void loadInfo() {

// TODO Auto-generated method stub

try {

Properties props;

File file = new File(System.getProperty("user.dir"), "db.properties");

FileInputStream fis;

fis = new FileInputStream("db.properties");

props = new Properties();

props.load(fis);

url = props.getProperty("url");

user = props.getProperty("user");

pass = props.getProperty("pass");

driver = props.getProperty("driver");

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

private static void driverLoading()  {

// TODO Auto-generated method stub

//jdbc 1 driver loading

try {

Class.forName(driver);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static Connection getConnection() throws SQLException {

return DriverManager.getConnection(url, user, pass);

}

}

##############################################################

# db.properties 파일

##############################################################

#=======================================================

# # is comment

# db setting

#=======================================================

url = jdbc:mysql://localhost:3306/test

user = javamaster

pass = 1111

driver = com.mysql.jdbc.Driver