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

野性酷女 2021-09-21 16:58 347阅读 0赞

先放效果图  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70]

1.  目录结构：![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 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/> 
        </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>
    
            
            <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>

1.  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

1.  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 + '\'' +
                    '}';
        }
    }

1.  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";
        }
    }

1.  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);
    }

1.  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);
        }
    }

1.  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);
    }

1.  jquery.js随便找一个jquery就可以了
2.  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> <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>  <a href="javascript:downPage();">下一页</a>
    <a href="query.html">查询</a>
    
    </body>
    </html>

1.  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>

1.  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>

1.  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 根据方法名字查询详细介绍][Spring JPA_JPA]
2.  devtools，springboot的另一大优点，可以实现热部署  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 2]  
    配置为true是开启热部署，false是关闭热部署。  
    [SpringBoot 在idea中实现热部署][SpringBoot _idea]
3.  thymeleaf，模板，动态页面放置在这里，静态页面放置在static目录下  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 3]
4.  yml的配置mysql已经从spring.datasource.driverClassName=com.mysql.jdbc.Driver调整为spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
5.  @PathVariable注解，可以用来映射URL中的占位符到目标方法的参数中  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 4]
6.  分页是spring-data-common包下的，是继承了JpaRepository类实现的![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 5]
7.  可以点击这里直接进入页展示页面![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 6]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70]: /images/20210920/26e21511fc954e24916b3f5f2666761e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 1]: /images/20210920/dcedc78c4e9242918e90671ffbcf7b36.png
[JPA]: https://www.jianshu.com/p/6d38a6c561f8
[Spring JPA_JPA]: https://www.sojson.com/blog/295.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 2]: /images/20210920/1df1577fc1a04c97a9bf4644ec662c8d.png
[SpringBoot _idea]: https://blog.csdn.net/little_skeleton/article/details/80935794?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.control&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.control
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 3]: /images/20210920/648a229c3a0d4ef5b0a8ce2116d5acbd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 4]: /images/20210920/c0599e83b7ec4f469496b406279efd61.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 5]: /images/20210920/e4ade2c2f8714a39a6f117ab2cb127cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ5NTM5MA_size_16_color_FFFFFF_t_70 6]: /images/20210920/5130b3ee40104c77952a427d7fc6250d.png