SpringBoot整合jdbcTemplate

一、目录展示

　　

二、导入依赖

　　　　

三、配置文件

　　

四、Student实体类

package com.zn.entity;

public class Student {

    private Integer stu_id;

    private String stu_name;

    @Override

    public String toString() {

        return "Student{" +

                "stu_id=" + stu_id +

                ", stu_name='" + stu_name + '\'' +

                '}';

    }

    public Student() {

    }

    public Student(String stu_name) {

        this.stu_name = stu_name;

    }

    public Student(Integer stu_id, String stu_name) {

        this.stu_id = stu_id;

        this.stu_name = stu_name;

    }

    public Integer getStu_id() {

        return stu_id;

    }

    public void setStu_id(Integer stu_id) {

        this.stu_id = stu_id;

    }

    public String getStu_name() {

        return stu_name;

    }

    public void setStu_name(String stu_name) {

        this.stu_name = stu_name;

    }

}

五、StudentDao层

package com.zn.dao;

import com.zn.entity.Student;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import org.springframework.stereotype.Repository;

import javax.annotation.Resource;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

@Repository

public class StudentDao {

    //导入JDBCTemplate模板

    @Resource

    JdbcTemplate jdbcTemplate;

    public Student selectByName(String stu_name){

        String sql="select * from studentinfo where stu_name=?";

        RowMapper<Student> rowMapper=new BeanPropertyRowMapper<Student>(Student.class);

        Student student=jdbcTemplate.queryForObject(sql,rowMapper,stu_name);

        return student;

    }

    //增加数据

    public int insertStudent(Student student) {

        return jdbcTemplate.update("insert into studentinfo(stu_name) values(?)",student.getStu_name());

    }

    //修改数据

    public int updateStudent(Student student) {

        return jdbcTemplate.update("update studentinfo set stu_name=? where stu_id=?",student.getStu_name(),student.getStu_id());

    }

    //删除数据

    public int deleteStudent(Integer id) {

        return jdbcTemplate.update("delete from studentinfo where stu_id=?",id);

    }

    //查询数据

    public List<Student> findAll() {

        //封装行数据映射

        RowMapper<Student> rowMapper=new RowMapper<Student>() {

            @Override

            public Student mapRow(ResultSet resultSet, int i) throws SQLException {

                Student students=new Student(resultSet.getInt("stu_id"),resultSet.getString("stu_name"));

                return students;

            }

        };

        return jdbcTemplate.query("select * from studentinfo", rowMapper);

    }

}

六、StudentService层

package com.zn.service;

import com.zn.dao.StudentDao;

import com.zn.entity.Student;

import org.springframework.stereotype.Service;

import javax.annotation.Resource;

import java.util.List;

@Service

public class StudentService {

    @Resource

    StudentDao studentDao;

    public Student selectByName(String stu_name){

        return studentDao.selectByName(stu_name);

    }

    //增加数据

    public int insertStudent(Student student) {

        return studentDao.insertStudent(student);

    }

    //修改数据

    public int updateStudent(Student student) {

        return studentDao.updateStudent(student);

    }

    //删除数据

    public int deleteStudent(Integer id) {

        return studentDao.deleteStudent(id);

    }

    //查询数据

    public List<Student> findAll(){

        return studentDao.findAll();

    }

}

七、StudentController层

package com.zn.controller;

import com.zn.entity.Student;

import com.zn.service.StudentService;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

import java.util.List;

@RestController

public class StudentController {

    @Resource

    StudentService studentService;

    //根据名字查询单条数据

    @RequestMapping("/selectByName")

    public Student selectByName(String stu_name){

        return studentService.selectByName(stu_name);

    }

    //添加数据

    @RequestMapping("/insertStudent")

    public int insertStudent(){

        return studentService.insertStudent(new Student("刘三姐"));

    }

    //修改数据

    @RequestMapping("/updateStudent")

    public int updateStudent(){

        return studentService.updateStudent(new Student(5,"小飒"));

    }

    //删除数据

    @RequestMapping("/deleteStudent")

    public int deleteStudent(){

        return studentService.deleteStudent(3);

    }

    //查询数据

    @RequestMapping("/findAll")

    public List<Student> findAll(){

        return studentService.findAll();

    }

}

八、测试类

　　

九、效果展示

　　（1）根据名字查询单条

　　　　　　

　　（此处忽略增删改效果）

　　（2）查询数据