JdbcTemplate 增删改

    @Override
    public void insert(Customer cust) {
        String sql = "insert into customers(name,email,birth)values(?,?,?)";
        Object[] args = {cust.getName(),cust.getEmail(),cust.getBirth()};
        jdbcTemplate.update(sql,args);
    }

    @Override
    public void deleteById(int id) {
        String sql = "delete from customers where id = ?";
        Object[] args = {id};
        jdbcTemplate.update(sql,args);
    }

    @Override
    public void update(Customer cust) {
        String sql = "update customers set name = ?,email = ?,birth = ? where id = ?";
        Object[] args = {cust.getName(),cust.getEmail(),cust.getBirth(),cust.getId()};
        jdbcTemplate.update(sql,args);
    }

 

posted on 2022-04-08 10:02  金满仓  阅读(27)  评论(0)    收藏  举报

导航