### applicationContext.xml ``` 1. Spring管理內置的連接池 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> ???????<property name="driverClassName" value="com.mysql.jdbc.Driver"/> ???????<property name="url" value="jdbc:mysql:///spring_day03"/> ???????<property name="username" value="root"/> ???????<property name="password" value="root"/> </bean> 2. Spring管理模板類 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> ???????<property name="dataSource" ref="dataSource"/> </bean> ``` ### test ``` @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration("classpath:applicationContext.xml") public class SpringDemo { @Resource(name="jdbcTemplate") private JdbcTemplate jdbcTemplate; @Test // 插入操作 public void demo1(){ jdbcTemplate.update("insert into account values (null,?,?)", "test",10000d); } @Test // 修改操作 public void demo2(){ jdbcTemplate.update("update account set name=?,money =? where id = ?", "test",10000d,5); } @Test // 刪除操作 public void demo3(){ jdbcTemplate.update("delete from account where id = ?", 5); } @Test // 查詢一條記錄 public void demo4(){ Account account = jdbcTemplate.queryForObject("select * from account where id = ?", new BeanMapper(), 1); System.out.println(account); } @Test // 查詢所有記錄 public void demo5(){ List<Account> list = jdbcTemplate.query("select * from t_account", new BeanMapper()); for (Account account : list) { System.out.println(account); } } } ```