Re: [Springframework-developer] New JDBC functionality for 1.3

[Alef A. <ale...@in...>]

Isn't this just like introducing a 'lite' version of the JdbcTemplate 
(without exposing the actual template pattern) in order to keep things 
clean and simple for users? I agree there's a lot of methods on the 
JdbcTemplate, but every time I take about 5 minutes to explain the 
interface, users seem to grasp the API quite quickly... If the 
SqlCommand were around already I had to explain users two classes to 
interact instead of one.

About the SqlCommand class (it's a class), I don't exactly call this a 
nice and clean interface by the way, isn't it specific to SQLServer?? :-).

regards,
Alef

Juergen Hoeller wrote:
> Thomas,
> 
> Looks interesting! Isn't this quite similar to our current operation objects
> in the "jdbc.object" package, just more generic? A SqlCommand instance seems
> to be thread-safe, parameters passed in through execute calls...
> 
> In any case, I do see your point: I guess it's worth keeping the named
> parameter support restricted to such a command class, not in JdbcTemplate
> itself. If that command class is close enough to the existing operation
> objects in style, we could also put it into the "jdbc.object" package
> directly...
> 
> Juergen
>  
>
> -----Original Message-----
> From: spr...@li...
> [mailto:spr...@li...] On Behalf Of
> Thomas Risberg
> Sent: Saturday, November 19, 2005 5:50 PM
> To: spr...@li...
> Subject: [Springframework-developer] New JDBC functionality for 1.3
> 
> I was talking to Mark last weekend about data access for Spring.NET and we
> discussed the .NET class SqlCommand that provides a nice and clean interface
> to the ADO.NET functionality.  It got me thinking, and after adding the
> support for named parameters, I counted over 75 different methods for
> interfacing with the JdbcTemplate - that's a lot :)
> 
> So, I started looking at providing a SqlCommand interface on top of
> JdbcTemplate to just present the most used features and limit the sometimes
> bewildering number of options for how to pass in the parameters etc.  I
> decided to only support the new named parameter support.  The old position
> based array style is still available from the JdbcTemplate directly.  I
> added a new class org.springframework.jdbc.command.SqlCommand to the
> sandbox.  It's  
> simply a number of one-line wrappers on top of the JdbcTemplate.   
> Combined with the new named parameter support, it provides a simpler
> interface IMHO.
> 
> Here are a few examples:
> 
>          SqlCommand listOfBeersCommand = new SqlCommand("select id, brand,
> price from beers", dataSource);
>          List beerList = listOfBeersCommand.executeQuery(new
> BeerMapper());
> 
>          SqlCommand priceCommand = new SqlCommand("select price from beers
> where brand = :brand", dataSource);
>          Map parameters = new HashMap();
>          parameters.put("brand", "Heineken");
>          Number price = (Number)priceCommand.executeScalar(parameters);
> 
> Also, with the new option of passing in a JavaBean as the holder of the
> parameter values (SqlParameterBeanWrapper) it does provide the option of
> using the following code:
> 
>          SqlCommand readCommand = new SqlCommand("select id, brand, price
> from beers where id = :id", dataSource);
>          SqlCommand saveCommand = new SqlCommand("update beers set brand =
> :brand, price = :price where id = :id", dataSource);
> 
>          Map parameters = new HashMap();
>          parameters.put("id", new Long(2));
>          Beer beer = (Beer)readCommand.executeObject(new BeerMapper (),
> parameters);
> 
>          beer.setPrice(new BigDecimal("49.87"));
> 
>          SqlNamedParameters updateValues = new SqlParameterBeanWrapper
> (beer);
>          int updateCount = saveCommand.executeUpdate(updateValues);
> 
> All this is in CVS now (SqlCommand is in the sandbox) and if you have any
> feedback, I'm all ears.
> 
> Thomas
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam for All
> Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer