JDBC Conectivity

[e01osama]

hi,
I have installed Oracle 9i, then create a database, fine,
I wrote a java programe to connect databade. it also working...
here is the programe
==============================­==============================­====


import java.sql.*;


class Display
{
public static void main(String args[])
{
Connection con;
try
{
try
{
DriverManager.registerDriver(n­ew
oracle.jdbc.driver.OracleDrive­r());
con =
DriverManager.getConnection("j­dbcracleciIFS","sys
as sysdba","abc123");


System.out.println("Connection is
succes....");


CallableStatement proce =
con.prepareCall("{call insert_()}");
System.out.println("Call insert ....");
proce.executeUpdate();
}
catch (SQLException sqlex)
{
System.out.println("SQL
exception"+sqlex);
}
}
catch (Exception e)
{
System.out.println("Unknown Exception"+e);
}
}



}


==============================­==============================­===========


this will insert vales to test table. now i want to run select query
from the test table.
I dont know how to do that.....


help me....

 

[Ross Bamford]

this will insert vales to test table. now i want to run select query
from the test table.
I dont know how to do that.....


help me....

e.g:


// ---

String someSql = "SELECT field FROM table"
Statement s;
ResultSet res;
try {
s = con.createStatement();
if (s.execute(someSql)) {
res = s.getResultSet();

while (res.next()) {
System.out.println("Field value is: "+res.getString("field"));
}
} catch (SQLException e) {
System.out.println("Oops!");
} finally {
try {
res.close();
s.close();
} catch (Exception e) { /* ignore */ }
}

// ---

Hope that helps,
Ross

 

[e01osama]

thanks..