package com.atos.jdbc;

import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDemo1 {

	private static final String DB_URL=
			"jdbc:oracle:thin:@localhost:1521:xe";
	private static final String USER_ID ="hr";
	private static final String PASSWORD ="hr";

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		final String sql=
				"Select COUNTRY_ID,COUNTRY_NAME FROM COUNTRIES";
		Connection conn = null;
		try{
			Class.forName("oracle.jdbc.OracleDriver");
			conn = DriverManager.getConnection(DB_URL,USER_ID,PASSWORD);
			Statement statement = conn.createStatement();
			ResultSet result = statement.executeQuery(sql);

			while(result.next())
			{
				String id = result.getString("COUNTRY_ID");
				String name = result.getString("COUNTRY_NAME");
				System.out.println(id+" "+name);

			}
		}catch(SQLException e){
			e.printStackTrace();
		}catch (ClassNotFoundException e){
			e.printStackTrace();
		}finally{

			try{
				conn.close();
			}catch (SQLException e){
				e.printStackTrace();
			}
		}

	}

}