Spring增删改查——DaoImpl

五、DaoImpl(dao层实现)

package net.zrgj.dao.impl;

import net.zrgj.bean.Student;
import net.zrgj.dao.IStudentDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public class StudentDaoImpl implements IStudentDao {
@Autowired
private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
    this.jdbcTemplate=jdbcTemplate;
}
@Override
public boolean addStu(Student student) {
    boolean flag = false;
    String sql = "insert into tb_student values(null,?,?,?)";
    int row = jdbcTemplate.update(sql, student.getName(), student.getSex(), student.getAge());
    if (row > 0){
        flag = true;
    }
    return flag;
}

@Override
public boolean delStu(int stuId) {