spring-boot搭建学生管理系统附总结

先放效果图

1. 目录结构：
2. pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.2</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.huazeqi</groupId>
    <artifactId>studentdemo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>studentdemo</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!-- druid数据库连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>


    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

3. application.properties

#数据源配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/stu?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&serverTimezone=Asia/Shanghai
#3306后面，3306/数据库名，不是表名
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.initialSize=20
spring.datasource.minIdle=50
spring.datasource.maxActive=500


#上下文配置
server.port=8888
server.servlet.context-path=/stu


#配置jpa
#帮我们自动生成表结构
spring.jpa.properties.hibernate.hbm2ddl.auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.show-sql= true
spring.jpa.properties.hibernate.enable_lazy_load_no_trans=true
spring.jpa.open-in-view=false

4. Student

package com.huazeqi.studentdemo.entity;


import javax.persistence.*;
/**
 * @author:huazeqi
 * @Date:2021/2/14 12:18
 * @Description:学生类
 **/
@Entity
@Table(name = "student")
public class Student {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    private String name;
    private String age;
    private String sex;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age='" + age + '\'' +
                ", sex='" + sex + '\'' +
                '}';
    }
}

5. StudentController

package com.huazeqi.studentdemo.controller;

import com.huazeqi.studentdemo.entity.Student;
import com.huazeqi.studentdemo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletResponse;
import java.util.HashMap;
import java.util.List;

@RestController
@RequestMapping("/s")
public class StudentController {

    @Autowired
    private StudentService studentService;

    /**
     * 添加学生
     * @param student  参数
     * @return
     */
    @PostMapping("/add")
    public Student save(Student student){
        return studentService.save(student);
    }

    /**
     * 更新学生信息
     * @param student 参数
     * @return
     */
    @PostMapping("/update")
    public  Student update(Student student){
        return studentService.update(student);
    }

    /**
     * 删除学生信息
     * @param id
     */
    @GetMapping("/del/{id}")
    public  String  delete(@PathVariable int id){
        studentService.delete(id);
        return "delete yes";
    }

    /**
     * 通过名字查询学生信息
     * @param name
     * @return
     */
    @GetMapping("/findByName/{name}")
    public List<Student> findStuByName(@PathVariable  String name){
        return studentService.findStuByName(name);
    }


    /**
     * 分页查询所有学生信息
     * @param
     * @return
     */
    @GetMapping("/query")
    public Page<Student> findByPage(Integer page , HttpServletResponse response){

        response.setHeader("Access-Control-Allow-Origin","*");//异步请求响应头

        if(page==null || page<=0){
            page = 0;
        }else{
            page -= 1;
        }

        return studentService.findAll(page,5);
    }


    @GetMapping("/findById")
    public Student findStuById(int id){
        return studentService.findStuById(id);
    }

    @RequestMapping("/Hi")
    public ModelAndView sayHello() {
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.setViewName("hello");
        modelAndView.addObject("key", 12345);
        //System.out.println("test");
        return modelAndView;
    }

    @GetMapping("/index")
    public String index(HashMap map){
        map.put("hello","springboot页面");
        //return  "index";
        return "redirect:hello.html";
    }
}

6. StudentService

package com.huazeqi.studentdemo.service;

import com.huazeqi.studentdemo.entity.Student;
import org.springframework.data.domain.Page;

import java.util.List;

public interface StudentService {

    Student save(Student student);//添加
    Student update(Student student);//更新
    void delete(Integer id);//删除
    Student findStuById(Integer id);//查询by id
    List<Student> findStuByName(String name);//查询by name

    /**
     *分页查询所有页
     * @param page 当前页，
     * @param pageSize  每页几条数据
     * @return
     */
    Page<Student> findAll(int page, int pageSize);
}

7. StudentServiceImpl

package com.huazeqi.studentdemo.service;

import com.huazeqi.studentdemo.dao.StudentDao;
import com.huazeqi.studentdemo.entity.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class StudentServiceImpl implements StudentService{

    @Autowired
    private StudentDao studentDao;


    @Override
    public Student save(Student student) {
        return studentDao.save(student);
    }

    @Override
    public Student update(Student student) {
        return studentDao.save(student);
    }

    @Override
    public void delete(Integer id) {
        studentDao.deleteById(id);
    }

    @Override
    public Student findStuById(Integer id) {
        return studentDao.findStudentById(id);
    }

    @Override
    public List<Student> findStuByName(String name) {
        return studentDao.findStuByName(name);
    }

    /**
     *
     * @param page 当前页，
     * @param pageSize  每页几条数据
     * @return
     */
    @Override
    public Page<Student> findAll(int page,int pageSize) {
        Pageable pageble= PageRequest.of(page,pageSize);
        return studentDao.findAll(pageble);
    }
}

8. StudentDao

package com.huazeqi.studentdemo.dao;

import com.huazeqi.studentdemo.entity.Student;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface StudentDao extends JpaRepository<Student, Integer> {
    
    /**
     * @Description:通过id查询学生
     * @Author:huazeqi
     * @Date:2021/2/14 12:42
     */
    Student findStudentById(Integer id);
    /**
     * @Description:通过name查询学生
     * @Author:huazeqi
     * @Date:2021/2/14 12:43
     */
    @Query(name = "findStuByName",nativeQuery = true,value =
            "select * from student where name=:name")
    List<Student> findStuByName(@Param("name") String name);
    /**
     * @Description:通过id删除学生
     * @Author:huazeqi
     * @Date:2021/2/14 12:49
     */
    void deleteById(Integer id);
}

9. jquery.js随便找一个jquery就可以了
10. index.html

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
    <script src="js/jquery.js" type="text/javascript" charset="utf-8"></script>

    <script type="text/javascript">

        var page = 1;
        var tp = 0;

        $(function(){
            showData();
        });

        function upPage(){
            if(page>1){
                page--;
                showData();
            }

        }

        function downPage(){
            if(page<tp){
                page++;
                showData();
            }

        }

        function showData(){
            $.ajax({
                url:'http://localhost:8888/stu/s/query?page='+page,
                success:function(result){

                    var rel = result.content;
                    tp = result.totalPages;

                    var htmlStr = "<table width='80%' algin='center' border='1'>"+
                        "<tr><th>ID</th><th>姓名</th><th>年龄</th><th>性别</th><th>操作</th></tr>";

                    for(var i=0;i<rel.length;i++){
                        var stu = rel[i];
                        htmlStr += "<tr><td>"+stu.id+"</td><td>"+stu.name+"</td><td>"+stu.age+"</td><td>"+stu.sex+"</td>"+
                            "<td><a href='update.html'>修改</a>&nbsp;<a href='http://localhost:8888/stu/s/del/"+stu.id+"'>删除</a></td></tr>";
                    }""

                    htmlStr += "</table>";

                    $("#show").html(htmlStr);
                }
            });
        }

    </script>

</head>
<body>

<h1 style="text-align: center;">学生管理系统</h1>
<hr>
<a href="add.html">添加学生</a>

<div id="show">

</div>

<a href="javascript:upPage();">上一页</a>&nbsp;&nbsp;<a href="javascript:downPage();">下一页</a>
<a href="query.html">查询</a>

</body>
</html>

11. add.html

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Add</title>
</head>
<body>
<h1>添加学生</h1>
<hr>
<form action="http://localhost:8888/stu/s/add" method="post">
    <p>
        姓名：<input type="text" name="name" />
    </p>
    <p>
        年龄：<input type="text" name="age" />
    </p>
    <p>
        性别：
        <input type="radio" name="sex" value="男"  checked />男
        <input type="radio" name="sex" value="女" />女
    </p>
    <p>
        <input type="submit" value="保存" />
    </p>
</form>
</body>
</html>

12. update.html

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Update</title>
</head>
<body>
<h1 style="text-align: center;">修改学生信息</h1>

<form action="http://localhost:8888/stu/s/update" method="post">
    <p>
        id：<input type="text" name="id">
    </p>
    <p>
        姓名：<input type="text" name="name" />
    </p>
    <p>
        年龄：<input type="text" name="age" />
    </p>
    <p>
        性别：
        <input type="radio" name="sex" value="男"  checked />男
        <input type="radio" name="sex" value="女" />女
    </p>
    <p>
        <input  type="submit" value="保存"  />
    </p>
</form>
</body>
</html>

13. query.html

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
</head>
<body>
<h1 style="text-align: center;">查询学生信息</h1>

    <form action="http://localhost:8888/stu/s/findById" method="get">
        <h1>通过Id查询</h1>
        <p>
            id：<input type="text" name="id">
        </p>

        <p>
            <input  type="submit" value="查询"  />
        </p>
    </form>
</body>
</html>

一些小结：

1. spring Data JPA(实际上是Hibernate的封装)：JPA的作用就是通过对象操作数据库的，不用编写sql语句。
   JPA
   Spring JPA查询，JPA 根据方法名字查询详细介绍
2. devtools，springboot的另一大优点，可以实现热部署
   
   配置为true是开启热部署，false是关闭热部署。
   SpringBoot 在idea中实现热部署
3. thymeleaf，模板，动态页面放置在这里，静态页面放置在static目录下
   
4. yml的配置mysql已经从spring.datasource.driverClassName=com.mysql.jdbc.Driver调整为spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
5. @PathVariable注解，可以用来映射URL中的占位符到目标方法的参数中
   
6. 分页是spring-data-common包下的，是继承了JpaRepository类实现的
7. 可以点击这里直接进入页展示页面