基于JdbcTemplate的增删改查
之前简单介绍了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<People> findAllPeople() {
List<People> peopleList = jdbcTemplate.query("select * from t_people", new RowMapper<People>() {
//解决了属性名与列名不一致的情况
@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});
}
}