public<\/span> class<\/span> JdbcProductDaoTests<\/span> extends<\/span> AbstractTransactionalDataSourceSpringContextTests<\/span> {<\/span><\/div> <\/div>
private<\/span> ProductDao<\/span> productDao<\/span>;<\/span><\/div> <\/div>
<\/div>
public<\/span> void<\/span> setProductDao<\/span>(<\/span>ProductDao<\/span> productDao<\/span>)<\/span> {<\/span><\/div> this<\/span>.<\/span>productDao<\/span> =<\/span> productDao<\/span>;<\/span><\/div> }<\/span><\/div> <\/div>
@Override<\/span><\/div> protected<\/span> String<\/span>[]<\/span> getConfigLocations<\/span>()<\/span> {<\/span><\/div> return<\/span> new<\/span> String<\/span>[]<\/span> {<\/span>"classpath:test-context.xml"<\/span>};<\/span><\/div> }<\/span><\/div> <\/div>
@Override<\/span><\/div> protected<\/span> void<\/span> onSetUpInTransaction<\/span>()<\/span> throws<\/span> Exception<\/span> {<\/span><\/div> super<\/span>.<\/span>deleteFromTables<\/span>(<\/span>new<\/span> String<\/span>[]<\/span> {<\/span>"products"<\/span>});<\/span><\/div> super<\/span>.<\/span>executeSqlScript<\/span>(<\/span>"file:db/load_data.sql"<\/span>,<\/span> true<\/span>);<\/span><\/div> }<\/span><\/div> <\/div>
public<\/span> void<\/span> testGetProductList<\/span>()<\/span> {<\/span><\/div> <\/div>
List<\/span><<\/span>Product<\/span>><\/span> products<\/span> =<\/span> productDao<\/span>.<\/span>getProductList<\/span>();<\/span><\/div> <\/div>
assertEquals<\/span>(<\/span>"wrong number of products?"<\/span>,<\/span> 3<\/span>,<\/span> products<\/span>.<\/span>size<\/span>());<\/span><\/div> <\/div>
}<\/span><\/div> <\/div>
public<\/span> void<\/span> testSaveProduct<\/span>()<\/span> {<\/span><\/div> <\/div>
List<\/span><<\/span>Product<\/span>><\/span> products<\/span> =<\/span> productDao<\/span>.<\/span>getProductList<\/span>();<\/span><\/div> <\/div>
for<\/span> (<\/span>Product<\/span> p<\/span> :<\/span> products<\/span>)<\/span> {<\/span><\/div> p<\/span>.<\/span>setPrice<\/span>(<\/span>200.12<\/span>);<\/span><\/div> productDao<\/span>.<\/span>saveProduct<\/span>(<\/span>p<\/span>);<\/span><\/div> }<\/span><\/div> <\/div>
List<\/span><<\/span>Product<\/span>><\/span> updatedProducts<\/span> =<\/span> productDao<\/span>.<\/span>getProductList<\/span>();<\/span><\/div> for<\/span> (<\/span>Product<\/span> p<\/span> :<\/span> updatedProducts<\/span>)<\/span> {<\/span><\/div> assertEquals<\/span>(<\/span>"wrong price of product?"<\/span>,<\/span> 200.12<\/span>,<\/span> p<\/span>.<\/span>getPrice<\/span>());<\/span><\/div> }<\/span><\/div> <\/div>
}<\/span><\/div> <\/div>
}<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n