chava

package com.atos.java.database;

import java.util.*;

import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetProvider;

import java.sql.*;

public class JDBCDemo4 {
	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
		Scanner sc = new Scanner(System.in);
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.OracleDriver");// register driver
			conn = DriverManager.getConnection(DB_URL, USER_ID, PASSWORD);//establish connection
			JdbcRowSet rs= RowSetProvider.newFactory().createJdbcRowSet();
			rs.setUrl("jdbc:oracle:thin:@localhost:1521:xe");
			rs.setUsername("hr");
			rs.setPassword("hr");
			rs.setCommand("Select * from countries");
			rs.execute();
			while(rs.next()){
				String id=rs.getString("COUNTRY_ID");
				String name = rs.getString("COUNTRY_NAME");
				System.out.println(id+" "+name);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException c) {
			c.printStackTrace();
		} finally {
			// close connection
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

}