a very basic question about java and oracle database

[Sakura Mika]

first of all , I would like to say that's a very basic question, but yet I couldn't find it's answer, I'm a Java newpie have almost just finshed Head First Java second edition book, beside that I have a good knowlege in oracle database ( I'm working to get my cirtification soon ) .

I've started to learn java become a database developer, I hate " Oracle Forms " and I believe it's and old tech and full of restrictions, and Java is the feture . so actually database tech in Java are my goal for the time being , then I'll move to Oracle ADF after I do that ( long road and needs lots of effort I know ..)

I started to learn JDBC from java JDBC tutorial and learning more about JTable also form java tutorial and things are going well so far ..

sorry for this long introduction , now let's head to the question

so, so far I got a basic result , I managed to create a connection to the database and query the data and display the data at the console, but I couldn't yet figure out how to fetch the data from ResultSet into JTable , I mean I want to make a table and make it display rows from database, not from array for example .

that's the simple result I talked about ..

   

import java.sql.*;
import javax.sql.*;
public class test {
    public static void main (String[] args){
        try{
            Class.forName("oracle.jdbc.OracleDriver");
            } catch (ClassNotFoundException a) {
			System.out.println("Class not found");
            }

	try{
            Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");
            Statement stmt=conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
            ResultSet result=stmt.executeQuery("select last_name,salary from employees where salary >10000");
            while (result.next()){
		System.out.println(result.getString("last_name"));
            }
	} catch(SQLException a){
            System.out.println("SQL exception");
	}
    }
}
 

another thing , when I started studying Java form headfirst java, everything was so smooth , and everything was in one place, while I'm trying to learn about database in Java now, I have to search the net for tutorials for every single info I need ( like I said before JDBC and JTable ) , it would be great if someone would recommend a book ( or a site) where I can I find everything related to database in java in one place ..

any help , I would really appreciate it .. and thanks for everyone ..

[Paul Sturrock]

Please check your private messages.

[Sakura Mika]

Paul Sturrock wrote:Please check your private messages.

done sir , thanks for informing me

[Paul Sturrock]

OK, you need to populate some sort of data structure while you iterate through the ResultSet. Have a look at this.

[Sakura Mika]

Paul Sturrock wrote:OK, you need to populate some sort of data structure while you iterate through the ResultSet. Have a look at this.

thanks for your answer , actullay since I'm still at the first step of the ladder I would like a more detailed answer , I know maybe I'm asking to much ( and for being respectful for the forum rules and the members ), so I'll do my best studying JDBC and JTable now , and I'll back when I have some new questions .

but I still would like to find an answer for me second question ( database resoures for Java )

once again thanks for you time and effort