2021-11-11

之前简单介绍了JdbcTemplate的连接，接下来我为大家来讲解一下JDBC 使用Spring框架来进行CURD（增删改查操作）

package com.hao.dao.impl;

import com.hao.dao.PeopleDao;
import com.hao.pojo.People;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

@Repository  //将PeopleDaoImpl注册到Spring容器中
public class PeopleDaoImpl implements PeopleDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    // 查询全部用户
    @Override
    public List findAllPeople() {
        List peopleList = jdbcTemplate.query("select * from t_people", new RowMapper() {

            //解决了属性名与列名不一致的情况
            @Override
            public People mapRow(ResultSet rs, int i) throws SQLException {
                People people = new People();
                people.setId(rs.getInt("id"));
                people.setName(rs.getString("sname"));  //这里我的数据库列名为  sname
                people.setAge(rs.getInt("age"));
                people.setAdress(rs.getString("address"));
                return people;
            }
        });
        return peopleList;
    }

    //通过id更改姓名
    @Override
    public void upadatePeopleNameById(People people) {
        jdbcTemplate.update("update t_people set sname = ? where id = ?  ",new Object[]{people.getName(),people.getId()});


    }

    //增加用户
    @Override
    public void addStudent(People people) {

        jdbcTemplate.update("insert into t_people value (?,?,?,?)",new Object[]{people.getId(),people.getName(),people.getAge(),people.getAdress()});
    }

    //通过id删除用户
    @Override
    public void deletePeopleById(Integer id) {

        jdbcTemplate.update("delete from t_people where id = ?",new Object[]{id});
    }
}