1.Dao的实现类

/** * 客户Dao实现类 */public class CustomerDaoImpl implements CustomerDao{    /* jdbc模板,封装样板代码 */    private JdbcTemplate jt;    // 待【注入】        /* 注入模板 */    public void setJt(JdbcTemplate jt) {        this.jt = jt;    }    //插入    public void saveCustomer(Customer c) {        String sql = "insert into customers(name,age) values(?,?)";        jt.update(sql,new Object[]{c.getName(),c.getAge()});            }    //更新    public void updateCustomer(Customer c) {        String sql = "update customers set name=?,age=? where id=?";        jt.update(sql,new Object[]{c.getName(),c.getAge(),c.getId()});    }    //查找    public List
     
       findCustomersByName(String name) {        String sql = "select * from customers where name=?";        return jt.query(sql, new Object[]{name}, new RowMapper(){                @Override                public Object mapRow(ResultSet rs, int rowNum)                        throws SQLException {                    Customer c = new Customer();                    c.setId(rs.getInt("id"));                    c.setName(rs.getString("name"));                    c.setAge(rs.getInt("age"));                    return c;                }});    }}
     

 

2.Spring配置文件