This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 114

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: 3606
    
  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: 114

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!)
 
Similar Threads
Netbeans Visual JSF Data Bindings to Table
Enabling non-programmers to change the output of my code ?
Moving parmaeters from object constructors to a database table
Need help on one-to-one - child data not getting saved
problem with schemaexport