packageorg.ljx.test;importorg.junit.Test;importorg.junit.runner.RunWith;importorg.ljx.domain.User;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.jdbc.core.BeanPropertyRowMapper;importorg.springframework.jdbc.core.JdbcTemplate;importorg.springframework.test.context.ContextConfiguration;importorg.springframework.test.context.junit4.SpringJUnit4ClassRunner;importjava.util.List;@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration("classpath:applicationContext.xml")publicclassJdbcTemplateCRUDTest{@AutowiredprivateJdbcTemplate jdbcTemplate;@TestpublicvoidtestUpdate(){
jdbcTemplate.update("update user set password=? where name=?",1,"li");}@TestpublicvoidtestDelete(){
jdbcTemplate.update("delete from user where name=?","li");}@TestpublicvoidtestQueryAll(){List<User> userList = jdbcTemplate.query("select * from user",newBeanPropertyRowMapper<User>(User.class));System.out.println(userList);}@TestpublicvoidtestQueryOne(){User userList = jdbcTemplate.queryForObject("select * from user where name =?",newBeanPropertyRowMapper<User>(User.class),"王");System.out.println(userList);}@TestpublicvoidtestQueryCount(){Long count = jdbcTemplate.queryForObject("select count(*) from user ",long.class);System.out.println(count);}}
JdbcTemplateTest
packageorg.ljx.test;importcom.alibaba.druid.pool.DruidDataSource;importcom.mchange.v2.c3p0.ComboPooledDataSource;importorg.junit.Test;importorg.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;importorg.springframework.jdbc.core.JdbcTemplate;importjava.beans.PropertyVetoException;publicclassJdbcTemplateTest{@Test// 测试JdbcTemplate开发步骤publicvoidtest01()throwsPropertyVetoException{// 创建数据源对象ComboPooledDataSource dataSource =newComboPooledDataSource();
dataSource.setDriverClass("com.mysql.jdbc.Driver");
dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/test");
dataSource.setUser("root");
dataSource.setPassword("asd.123");JdbcTemplate jdbcTemplate =newJdbcTemplate();// 设置数据源对象 知道数据源在哪
jdbcTemplate.setDataSource(dataSource);// 执行操作
jdbcTemplate.update("insert into user values(?,?)","li",12);}@Test// 测试Spring产生jdbcTemplate对象publicvoidtest02()throwsPropertyVetoException{ApplicationContext app =newClassPathXmlApplicationContext("applicationContext.xml");JdbcTemplate jdbcTemplate = app.getBean(JdbcTemplate.class);int i = jdbcTemplate.update("insert into user values (?,?)","jagssdtfy",123456);System.out.println(i);}}