Spring增删改查——DaoImpl

最新推荐文章于 2025-08-10 11:58:21 发布

原创最新推荐文章于 2025-08-10 11:58:21 发布 · 431 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

本文主要探讨了Spring中DAO层的实现，特别是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) {
    boolean flag = false;
    String sql = "delete from tb_student where id = ?";
    int row = jdbcTemplate.update(sql,stuId);
    if (row > 0){
        flag = true;
    }
    return flag;
}

@Override
public boolean updStu(Student student) {
    boolean flag = false;
    String sql = "update tb_student set name = ?,sex = ?,age = ? where id = ?";
    int row = jdbcTemplate.update(sql,new Object[]{student.getName(),student.getSex(),student.getAge(),student.getId()});
    if (row > 0){
        flag = true;
    }
    return flag;
}

@Override
public Student findById(int stuId) {
    String sql ="select * from tb_student where id = ?";
    BeanPropertyRowMapper<Student> rowMapper = new BeanPropertyRowMapper<>(Student.class);
    Student student = jdbcTemplate.queryForObject(sql,new Object[]{stuId}, rowMapper);
    return student;
}

@Override
public List<Student> findAll() {
    String sql ="select * from tb_student";
    BeanPropertyRowMapper<Student> rowMapper = new BeanPropertyRowMapper(Student.class);
    List<Student> students = jdbcTemplate.query(sql,rowMapper);
    return students;
}
}