db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Storing an RSS feed news headlines in Derby
Date Thu, 30 Oct 2014 02:03:04 GMT
> 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


Mime
View raw message