用IDEA创建Spring项目实现对数据库的增删改查操作(后续)

修改操作

StudentDao接口

int upd(Student student);

StudentDaoImpl类

@Override
    public int upd(Student student) {
        String sql= "update students set name=:name where id=:id";
        Map<String,Object> param = new HashMap<>();
        param.put("id",student.getId());
        param.put("name",student.getName());
        return (int) jdbcTemplate.update(sql,param);
    }

controller层

public String hello(){
        Student s = new Student();
        s.setId(103);
        s.setName("小鬼");
        studentDao.upd(s);
        return "hello";
    }

删除操作 

StudentDao接口

int del(int id);

StudentDaoImpl类

@Override
    public int del(int id) {
        String sql= "delete from students where id=:id