@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")publicclassJdbcTemplateCRUDTest{
@Autowired
private JdbcTemplate jdbcTemplate;
@Test
publicvoidtestUpdate(){
jdbcTemplate.update("update user set uname=? where uid=? ","yuyu",1);}
@Test
publicvoidtestDelete(){
jdbcTemplate.update("delete from user where uid=? ",6);}
@Test
publicvoidtestQueryAll(){
List<Account> accountList = jdbcTemplate.query("select * from user",new BeanPropertyRowMapper<Account>(Account.class));
System.out.println(accountList);}
@Test
publicvoidtestQueryOne(){
Account account = jdbcTemplate.queryForObject("select * from user where uid=?",new BeanPropertyRowMapper<Account>(Account.class),1);
System.out.println(account);}
@Test
publicvoidtestQueryCount(){
Long aLong = jdbcTemplate.queryForObject("select count(*) from user", Long.class);
System.out.println(aLong);}}