sajjan

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;


public class jdbc2 {

	/**
	 * @param args
	 */
	static void getconnection(){
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
			Statement st = conn.createStatement();
			conn.setAutoCommit(true);
			String sql = "CREATE TABLE REGISTRATION9(id INTEGER, first VARCHAR(10), last VARCHAR(10), age INTEGER)";
			st.executeUpdate(sql);
			PreparedStatement ps = conn.prepareStatement("INSERT INTO REGISTRATION9 VALUES(?,?,?,?)");

			for(int i=0;i<3;i++){
				System.out.println("Enter table data id, first name, last name, age : ");
				Scanner s1 = new Scanner(System.in);
				int id = s1.nextInt();
				String first = s1.next();
				String last = s1.next();
				int age = s1.nextInt();
				ps.setInt(1, id);
				ps.setString(2, first);
				ps.setString(3, last);
				ps.setInt(4, age);

				ps.executeUpdate();
			}
		ResultSet rs = st.executeQuery("SELECT * FROM REGISTRATION9");
		while(rs.next())
			System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3) + " " + rs.getInt(4));
		}catch(Exception e){
			System.out.println(e);
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		getconnection();
	}

}