How to display a oracle table from a java program?

Question

How to display a oracle table from a java program.

Hello friends, I have written a Java program, using oracle 10g as backend.

I want to display a oracle table as output. Im not getting how to display oracle table as a output table.. Pls help me
Thank you

Answer 1

Hai Shaam,
I assume that you are successful in obtaining aconnection to the
Oracle Table, If not please code as necessary like
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
Connection con=DriverManager.getConnection("jdbc:odbc:", "","");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery();
// you will get each value by using
//rs.getString() then store it in an array
//display it to output,
//if you need to display it in an output table in java
//you can use JTable in the swing library.
}
catch(Exception e){}

for further details you can contact me

email:[e-mail]
cell:[phone]

Answer 2

basic n 1st most steps:
1) create a odbc datasource name for oracle using odbc datasources

2) then hope ur java code has the connectivity codes from
"
try{
class.forName(...)
.
.
.
statement st= con.createStatement();
ResultSet rs = st.executeQuery("select * from ");
while(rs.next())
{
System.out.println(rs.getString(1) + " :: " + rs.getString(2) + "::" ....upto rs.getString(n));
}
}
catch(Exception e)
{
System.out.println("Exception occured : "+e);
}

Answer 3

Hi, You can use executeUpdate("insert query") to insert data into database. You have to first form the query before writing the execute update or you can give the query directly in executeUpdate statement. Ex: Statement st = conn.createStatement(); st.executeUpdate("insert into emp values (100,'Smith')");

Answer 4

http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=5&rl=1

Answer 5

http://www.exzilla.net/docs/jdbc/jdbctCodetemplates.html?PHPSESSID=33e09f73d351b71f9e0fc4a3cdc42652#ExDML