I wish to store title and pubDate for each headline news item on a RSS feed
in a Derby database
Would appreciate some pointers as to how to achieve this
The critical bit of code that you need to write probably
looks something like this:
PreparedStatement insRSS = con.prepareStatement(
"insert into rssfeed (title, pubdate) values( ?,? )" );
insRSS.setString( 1, title );
insRSS.setDate( 2, pubdate );
insRSS.executeUpdate();
con.commit();
There's more to it than this, but this is a start that should get
you closer to building a prototype, at which point you can see
how well it works and where you want to improve it.
You'll find lots of details to consider here:
http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html
thanks,
bryan