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

public class JDBCTest {
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Class.forName("oracle.jdbc.driver.OracleDriver");

		Connection con = DriverManager
				.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "username", "password");

		Statement stmt = con.createStatement();

		stmt.execute("Create table emp_jan18(eno number(10), ename varchar(50), esal number(10))");
		stmt.execute("insert into emp_jan18 values(1001, 'Vishal', 12345)");
		stmt.execute("insert into emp_jan18 values(1002, 'Scott', 72356)");
		stmt.execute("insert into emp_jan18 values(1003, 'Jon', 58345)");

		ResultSet rs = stmt.executeQuery("Select * from emp_jan18");

		while(rs.next()) {
			System.out.println("Eno: "+rs.getInt(1));
			System.out.println("Ename: "+rs.getString(2));
			System.out.println("Esal: "+rs.getInt(3));
		}

		stmt.close();
		con.close();
	}
}