Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Billy Sclater
Ranch Hand
Posts: 145
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 3751
62
Chrome Netbeans IDE Oracle
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 145
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!


 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic