This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman 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

Win a copy of Elasticsearch in Action this week in the Big Data forum!
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: 143

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

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

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!)