## 保存 ~~~ jt.update("insert into account (name,money) values (?,?)","Milan",200); ~~~ ## 更新 ~~~ jt.update("update account set name = ? where id = ?","jack",1); ~~~ ## 刪除 ~~~ jt.update("delete from account where id = ?",1); ~~~ ## 查詢所有 寫一個累實現RowMapper接口,并實現方法. ~~~ class AccountRowMapper implements RowMapper<Account> { public Account mapRow(ResultSet resultSet, int i) throws SQLException { Account account = new Account(); account.setId(resultSet.getInt("id")); account.setName(resultSet.getString("name")); account.setMoney(resultSet.getFloat("money")); return account; } } ~~~ 查詢: ~~~ //獲取容器 ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); //獲取數據源 JdbcTemplate jt = (JdbcTemplate) context.getBean("jdbcTemplate"); //執行SQL List<Account> list = jt.query("select * from account where money > ?", new AccountRowMapper(), 1000f); System.out.println(list); ~~~ 每次自己寫實現接口太麻煩了,spring給我也提供了和queryRunner一樣的結果集處理的封裝. ~~~ //獲取容器 ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); //獲取數據源 JdbcTemplate jt = (JdbcTemplate) context.getBean("jdbcTemplate"); //執行SQL List<Account> list = jt.query("select * from account where money > ?", new BeanPropertyRowMapper<Account>(Account.class), 1000f); System.out.println(list); ~~~ ## 查詢一個 ~~~ List<Account> list = jt.query("select * from account where id = ?", new BeanPropertyRowMapper<Account>(Account.class), 3); ~~~ ## 查詢返回一行一列 ~~~ Integer count = jt.queryForObject("select count(*) from account", Integer.class); ~~~