Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes JDBC Coding assessment. A question about tables (beginner!) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Coding assessment. A question about tables (beginner!)" Watch "JDBC Coding assessment. A question about tables (beginner!)" New topic
Author

JDBC Coding assessment. A question about tables (beginner!)

Billy Sclater
Ranch Hand

Joined: Nov 18, 2012
Posts: 141

Hi, I just mentioned in a previous thread that I am just starting a coding assessment for a job.
Part of the assessment involves some JDBC code.

The coding exercise starts off by providing a data file of names and addresses, with the name and address split into columns in the file.

The exercise asks to populate 'the table' with the information from this data file.

I am 'totally' new to JDBC. When they use the language 'the table', are they referring to a basic collection like a hashtable?
Or to a JTable?

Thanks,

Billy(:


Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3611
    
  60

In the context of JDBC, I'm pretty sure that 'the table' means a database table.

I'd suggest starting off with a JDBC tutorial. If you already have experience accessing a database using some other language, then you shouldn't have problems learning JDBC. Learning it without previous database experiences will probably take quite some time, though.
Billy Sclater
Ranch Hand

Joined: Nov 18, 2012
Posts: 141

Interesting Exact Same Assessment? ....anyway!

Yikes! I have no prior database experience and only a few days to complete the assignment!
But then again as far as databases are concerned, the assessment only requires me to read the data(text) file and populate a table.
And then finally, fetch some specific data from that table.....

Off the top of my head, my first step:
#1 Use a BufferedReader to grab the data file, then parse it and load the data into an Arraylist.

I think I'm ok with this, but I will post the solution on this thread to quality assure it!

After that, it's scanning the tutorials to learn how to 'populate a table', and how to 'fetch specific data from that table'.
I'll cross those bridges when I come to them, but for now on with step one!


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Coding assessment. A question about tables (beginner!)