jdbc

package com.java.atos.jdbc;

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

public class JDBCDemo {

	private static final String DB_URL = "jdbc:oracle:hin:@local)host:1521:xe";
	private static final String USER_ID ="hr";
	private static final String PASSWORD ="hr";


	public static void main(String[] args) {

		final String sq1 = "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(sq1);

			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();
			}


		}

	}

}