This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "JDBC Coding assessment. A question about tables (beginner!)" Watch "JDBC Coding assessment. A question about tables (beginner!)" New topic

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

Billy Sclater
Ranch Hand

Joined: Nov 18, 2012
Posts: 145

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?



Martin Vajsar

Joined: Aug 22, 2010
Posts: 3718

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: 145

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:
subject: JDBC Coding assessment. A question about tables (beginner!)
It's not a secret anymore!