JdbcTemplate details part2

May 9, 2008 at 7:46 am | Posted in Uncategorized | Leave a comment
Tags: ,

Package Hierarchy

Batch update

JdbcTemplate#batchUpdate()
implement BatchPreparedStatementSetter or InterruptibleBatchPreparedStatement interfaces

For SimpleJdbcTemplate
you can also use value maps, bean property based objects, or SqlParameterSources
see SqlParameterSourceUtils

BatchSqlUpdate
represente batch update sql as a java class.

SimpleJdbc classes

simplified jdbc operation classes using database metadata(retrieved from JDBC driver).

SimpleJdbcTemplate
enhanced jdbcTemplate with java5 functions.

SimpleJdbcInsert
by giving table name(withTableName()), column names, and values, you can execute insert operation.

SimpleJdbcCall
simple execution for stored procedure. in/out parameters can be given as Map, or SqlParmaeterSource.

JDBC Operations

considering each DB operation as object

SqlQuery
abstract class that encapsulate all sql operations. This class defines a lot of execution methods. When you implement this class, need to provide rowMapper.

SqlUpdate
represent update operation as an object.
StoredProcedure: abstract class that you can extend for your stored procedure.

SqlFunction
expect single result

Advertisements

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: