hgh

package com.atos.java.jdbc;

import java.sql.*;


public class JDBCdemo {
	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";
		final String sql1="update COUNTRIES set COUNTRY_NAME='Pakistan' where COUNTRY_ID = 'PK'";
		Connection conn= null;
		try
		{
			Class.forName("oracle.jdbc.OracleDriver");

			conn= DriverManager.getConnection(DB_URL, USER_ID, PASSWORD);

			Statement statement=conn.createStatement();
			statement.executeUpdate(sql1);
			Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);
			final String sql = "Select COUNTRY_ID, COUNTRY_NAME from COUNTRIES";
			ResultSet result=statement.executeQuery(sql);
			result.next();
			ResultSetMetaData resultmd = result.getMetaData();
			int n = resultmd.getColumnCount();
			for(int i=1;i<=n;i++)
			{
				System.out.println(resultmd.getColumnName(i)+" "
			+resultmd.getColumnTypeName(i));

			}
			System.out.println(resultmd.getTableName(3));

			String id= result.getString("COUNTRY_ID");
			String name= result.getString("COUNTRY_NAME");
			System.out.println(id+" "+name);
			//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();
			}

		}
	}

}