简单的学生系统
SpringBoot因其其实就是简单、快速、方便!所以本文通过SpringBoot搭建一个简单的学生管理系统(持续更新)!
准备工作:
工具:Mysql,Idea,navicat(其他也可以),Postman,HbuilderX
准备工作:创建student表,表信息为:int id,varchar name,varchar age,varchar sex。
创建一个新的项目,
步骤:
点击Next,下一步。
设置好后,点击Next。
后端代码如下:
entity.java(实体层)
package com.kude.stu.kudestu.stu.entity;
import javax.persistence.*;
@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 Student() {
}
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 + '\'' +
'}';
}
}
StudentDao.java(Dao层)
package com.kude.stu.kudestu.stu.dao;
import com.kude.stu.kudestu.stu.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> {
/**
* 通过Id查询成员信息
* @param id
* @return
*/
Student findStudentById(Integer id);
/**
* 通过Name查询成员信息
* @param name
* @return
*/
@Query(name = "findStuByName",nativeQuery = true,value =
"select * from student where name=:name")
List<Student> findStuByName(@Param("name") String name);
void deleteById(Integer id);
}
StudentService .java(Service层)
package com.kude.stu.kudestu.stu.service;
import com.kude.stu.kudestu.stu.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);
List<Student> findStuByName(String name);
/**
*分页查询所有页
* @param page 当前页,
* @param pageSize 每页几条数据
* @return
*/
Page<Student> findAll(int page,int pageSize);
}
StudentServiceImpl.java(实现Service层的接口)
package com.kude.stu.kudestu.stu.service;
import com.kude.stu.kudestu.stu.dao.StudentDao;
import com.kude.stu.kudestu.stu.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);
}
}
StudentController.java
package com.kude.stu.kudestu.stu.controller;
import com.kude.stu.kudestu.stu.entity.Student;
import com.kude.stu.kudestu.stu.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletResponse;
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(@PathVariable("id") 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);
}
}
application.properties (配置文件)
#数据源配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.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=
spring.datasource.password=
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
pom.xml (pom文件)
<?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 http://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.1.4.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.kude.stu</groupId>
<artifactId>kudestu</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>kudestu</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>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</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.hibernate</groupId>-->
<!--<artifactId>hibernate-entitymanager</artifactId>-->
<!--<version>5.0.3.Final</version>-->
<!--</dependency>-->
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
前端代码如下:
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='xiugai.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="chaxun.html">查询</a>
</body>
</html>
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>
xiugai.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Xiugai</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>
chaxun.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>
</from>
</body>
</html>
jquery.js
运行结果:
码云上后端代码:https://gitee.com/LOL_toulan/SpringBootProject