public class JDBCUsingProps {

	public static void main(String[] args) {

        //기본 값 초기화
		InputStream input = null;
		String driver = "";
		String url = "";
		String user = "";
		String password = "";
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "";

		try {
			input = new FileInputStream("db.properties");
            //FiledInputStream( "프로퍼티 파일 이름" )
			Properties prop = new Properties();
			prop.load(input);

			driver = prop.getProperty("db.driver");
			url=prop.getProperty("db.url");
			user=prop.getProperty("db.user");
			password=prop.getProperty("db.pass");
			sql = prop.getProperty("db.sql");

            //props.getProperty() 매소드를 통해 properties파일 내부의 설정을 받아옴


		}catch(IOException io) {
			io.printStackTrace();
		}finally {
			try {
				input.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

try {

	conn = DriverManager.getConnection(url, user, password);
	System.out.println("Connection created : "  + conn.getClass().getName());

	//Factory Method
	stmt = conn.createStatement();
	System.out.println("Statement created : " + stmt.getClass().getName());

	rs = stmt.executeQuery(sql);
	System.out.println("ResultSet created : " + rs.getClass().getName());

	ResultSetMetaData md = rs.getMetaData();
	for(int i=1; i <= md.getColumnCount();i++)
		System.out.print(md.getColumnLabel(i) + " / ");


	    while(rs.next()) {
            for(int i=1; i <= md.getColumnCount(); i++)
	    System.out.print(rs.getString(i) + "\t \t ");
            System.out.println();
	    }

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
			if(rs != null) rs.close();
			if(stmt != null) stmt.close();
			if(conn != null) conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}