public<\/span> class<\/span> JdbcProductDao<\/span> extends<\/span> SimpleJdbcDaoSupport<\/span> implements<\/span> ProductDao<\/span> {<\/span><\/div> <\/div>
/** Logger for this class and subclasses */<\/span><\/div> protected<\/span> final<\/span> Log<\/span> logger<\/span> =<\/span> LogFactory<\/span>.<\/span>getLog<\/span>(<\/span>getClass<\/span>());<\/span><\/div> <\/div>
<\/div>
public<\/span> List<\/span><<\/span>Product<\/span>><\/span> getProductList<\/span>()<\/span> {<\/span><\/div> logger<\/span>.<\/span>info<\/span>(<\/span>"Getting products!"<\/span>);<\/span><\/div> List<\/span><<\/span>Product<\/span>><\/span> products<\/span> =<\/span> getSimpleJdbcTemplate<\/span>().<\/span>query<\/span>(<\/span><\/div> "select id, description, price from products"<\/span>,<\/span> <\/div> new<\/span> ProductMapper<\/span>());<\/span><\/div> return<\/span> products<\/span>;<\/span><\/div> }<\/span><\/div> <\/div>
public<\/span> void<\/span> saveProduct<\/span>(<\/span>Product<\/span> prod<\/span>)<\/span> {<\/span><\/div> logger<\/span>.<\/span>info<\/span>(<\/span>"Saving product: "<\/span> +<\/span> prod<\/span>.<\/span>getDescription<\/span>());<\/span><\/div> int<\/span> count<\/span> =<\/span> getSimpleJdbcTemplate<\/span>().<\/span>update<\/span>(<\/span><\/div> "update products set description = :description, price = :price where id = :id"<\/span>,<\/span><\/div> new<\/span> MapSqlParameterSource<\/span>().<\/span>addValue<\/span>(<\/span>"description"<\/span>,<\/span> prod<\/span>.<\/span>getDescription<\/span>())<\/span><\/div> .<\/span>addValue<\/span>(<\/span>"price"<\/span>,<\/span> prod<\/span>.<\/span>getPrice<\/span>())<\/span><\/div> .<\/span>addValue<\/span>(<\/span>"id"<\/span>,<\/span> prod<\/span>.<\/span>getId<\/span>()));<\/span><\/div> logger<\/span>.<\/span>info<\/span>(<\/span>"Rows affected: "<\/span> +<\/span> count<\/span>);<\/span><\/div> }<\/span><\/div> <\/div>
private<\/span> static<\/span> class<\/span> ProductMapper<\/span> implements<\/span> ParameterizedRowMapper<\/span><<\/span>Product<\/span>><\/span> {<\/span><\/div> <\/div>
public<\/span> Product<\/span> mapRow<\/span>(<\/span>ResultSet<\/span> rs<\/span>,<\/span> int<\/span> rowNum<\/span>)<\/span> throws<\/span> SQLException<\/span> {<\/span><\/div> Product<\/span> prod<\/span> =<\/span> new<\/span> Product<\/span>();<\/span><\/div> prod<\/span>.<\/span>setId<\/span>(<\/span>rs<\/span>.<\/span>getInt<\/span>(<\/span>"id"<\/span>));<\/span><\/div> prod<\/span>.<\/span>setDescription<\/span>(<\/span>rs<\/span>.<\/span>getString<\/span>(<\/span>"description"<\/span>));<\/span><\/div> prod<\/span>.<\/span>setPrice<\/span>(<\/span>new<\/span> Double<\/span>(<\/span>rs<\/span>.<\/span>getDouble<\/span>(<\/span>"price"<\/span>)));<\/span><\/div> return<\/span> prod<\/span>;<\/span><\/div> }<\/span><\/div> <\/div>
}<\/span><\/div> <\/div>
}<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n