DisplayRecordIndex
//Retrive the data from DB and display it Using with INDEXS
import java.sql.*;
import java.sql.*;
class DisplayRecordIndex
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select eno,name from emp3");
System.out.println(rs);
while(rs.next())
{
int deno=rs.getInt(1);
System.out.println("Eno: "+deno);
String s=rs.getString(2);
System.out.println("Nane: "+s);
}
con.close();
System.out.println("connection is closed");
}
}
Using Prepared Statement
retrieve-records
