使用SpringBoot+Mysql+JPA实现对数据库的增删改查和分页

最新推荐文章于 2024-03-06 09:05:55 发布

枯玄

最新推荐文章于 2024-03-06 09:05:55 发布

阅读量5.5k

点赞数 4

分类专栏：基础语法

本文链接：https://blog.csdn.net/weixin_43904316/article/details/89743419

版权

基础语法专栏收录该内容

25 篇文章 1 订阅

订阅专栏

使用idea新建个SpringBoot项目

1. 选择create new project
2. 在这里插入图片描述

								controler

studentController

package com.kude.stu.stu.controller;

import com.kude.stu.stu.entity.Student;
import com.kude.stu.stu.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.awt.*;
import java.awt.print.Pageable;
import java.io.IOException;
import java.util.List;

@RestController
@RequestMapping("/student")
public class studentController {

    @Autowired
    private StudentService studentService;


    /**
     * 添加
     * @param student
     * @return
     */

    @RequestMapping(value = "/add", method = RequestMethod.POST)
    public Student save(Student student, HttpServletResponse response , HttpServletRequest request) throws ServletException, IOException {

        return studentService.save(student);


    }

    /**
     * 修改
     * @param student
     * @return
     */

    @RequestMapping(value = "/update",method = RequestMethod.POST)
    public Student update(Student student){
        return studentService.update(student);
    }

    /**
     * 删除
     * @param id
     */

    @RequestMapping(value = "/delete",method = RequestMethod.GET)
    public void delete(int id, HttpServletResponse response , HttpServletRequest request) throws ServletException, IOException {
        studentService.delete(id);
       /*request.getRequestDispatcher("stu\\index.html").forward(request,response);*/
    }

    /**
     * 通过id查询
     * @param id
     * @return
     */
    @RequestMapping(value = "/findById/{id}",method = RequestMethod.GET)
    public Student findById(@PathVariable int id){
        return studentService.findById(id);
    }

    /**
     * 通过姓名查询
     * @param name
     * @return
     */
    @GetMapping(value = "/findByName/{name}")
    public List<Student> findByName(@PathVariable String name){
        return studentService.findByName(name);
    }


    /**
     * 分页
     * @param page
     * @param response
     * @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.finAll(page,5);

    }

}

userControler

package com.kude.stu.stu.controller;

import com.kude.stu.stu.entity.User;
import com.kude.stu.stu.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.sound.midi.Soundbank;
import java.util.List;

/**
 * @author HoHner
 *
 */


@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;


    /**
     *查询所有用户
     */

    @ResponseBody
    @RequestMapping(value = "/findAll",method = RequestMethod.POST)
    public List<User> findAll(){
        return userService.findAll();
    }


    /**
     * 根据id查询
     *
     */

    @ResponseBody
    @RequestMapping("/findById")
    public User findById(int id){
        return userService.findUserById(id);

    }


    /**
     * 注册用户
     */

    @ResponseBody
    @RequestMapping(value = "/req",method = RequestMethod.POST)
    public User reg(User user){
        return userService.save(user);
    }

    /**
     *
     * 删除
     * @param id
     */

    @ResponseBody
    @RequestMapping(value = "/delete",method = RequestMethod.GET)
    public void deleteById(int id){
        userService.delete(id);
        System.out.println("delete");

}


    /**
     *
     * 登录
     */
    @ResponseBody
    @RequestMapping(value = "/login",method = RequestMethod.POST)
    public User login(String name,String password){
        return userService.login(name,password);

    }

}

dao

userDao

package com.kude.stu.stu.dao;

import com.kude.stu.stu.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface UserDao extends JpaRepository<User,Integer> {

    /**
     *根据id查询
     *
     */
    User findUserById(int id);


    /**
     * 登录
     */
    @Query(name="login",nativeQuery = true,value =
            "select * from user where name=:name and password=:password")
    User login(@Param("name") String username, @Param("password") String password);


}

StudentDao

package com.kude.stu.stu.dao;

import com.kude.stu.stu.entity.Student;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface StudentDao extends JpaRepository<Student,Integer> {

    Student findById(int id);

    List<Student> findByName(String name);

    void deleteById(int id);
}

							entity

Student

package com.kude.stu.stu.entity;

import javax.persistence.*;

@Entity
@Table(name = "student")
public class Student {

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

    public Student() {
    }

    public Student(String name, int age, String sex) {
        this.name = name;
        this.age = age;
        this.sex = 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 int getAge() {
        return age;
    }

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

    public String getSex() {
        return sex;
    }

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


}

User

在这里插入代码片package com.kude.stu.stu.entity;


import javax.persistence.*;

@Entity
@Table(name="user")
public class User {

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


    public User() {
    }

    public User(String name, String password) {
        this.name = name;
        this.password = password;
    }

    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 getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;

    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

								service

package com.kude.stu.stu.service;

import com.kude.stu.stu.entity.User;

import java.util.List;

public interface UserService {
    List<User> findAll();

    User findUserById(int id);

    User save(User user);

    User update(User user);

    void delete(int id);

    User login(String name,String password);



}

studentService

package com.kude.stu.stu.service;

import com.kude.stu.stu.entity.Student;
import org.springframework.data.domain.Page;

import java.util.List;

public interface StudentService {

    /**
     * 添加
     * @param student
     * @return
     */
    Student save(Student student);

    /**
     * 修改
     * @param student
     * @return
     */
    Student update(Student student);

    /**
     * 删除
     * @param id
     */
    void delete(int id);

    /**
     * 通过id查询
     * @param id
     * @return
     */
    Student findById(int id);

    /**
     * 同过姓名查询
     * @param name
     * @return
     */
    List<Student> findByName(String name);

    /**
     * 分页查询
     * @param page
     * @param pageSize
     * @return
     */

    Page<Student> finAll(int page, int pageSize);


}

						impl

UserServiceImpl

package com.kude.stu.stu.service;

import com.kude.stu.stu.entity.User;

import java.util.List;

public interface UserService {
    List<User> findAll();

    User findUserById(int id);

    User save(User user);

    User update(User user);

    void delete(int id);

    User login(String name,String password);



}

StudentServiceimpl

package com.kude.stu.stu.service;

import com.kude.stu.stu.dao.UserDao;
import com.kude.stu.stu.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;



@Service
public class UserServiceImpl implements UserService{

    @Autowired
    private UserDao userDao;

    @Override
    public List<User> findAll() {
        return userDao.findAll();
    }

    @Override
    public User findUserById(int id) {
        return userDao.findUserById(id);
    }

    @Override
    public User save(User user) {
        return userDao.save(user);
    }

    @Override
    public User update(User user) {
        return null;
    }

    @Override
    public void delete(int id) {
        userDao.deleteById(id);
    }


    @Override
    public User login(String name, String password) {
        return userDao.login(name,password);
    }



}

启动类

StuApplication

package com.kude.stu.stu;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class StuApplication {

    public static void main(String[] args) {
        SpringApplication.run(StuApplication.class, args);
        System.out.println("hello");
    }

}

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

						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 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>stu</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>stu</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>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </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>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </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>

									html

add.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">
			
			
		</script>
		
	</head>
	<body>
		
		<h1 align="center">添加学生</h1>
		
		<form action="http://localhost:8888/stu/student/add" method="post">
			<p>姓名：<input type="text" name="name"/></p>
			<p>性别：
			<input type="radio" name="sex" value="=男">男
			<input type="radio" name="sex" value="=女">女</p>
			<p>年龄：<input type="text" name="age"></p>
			
			<input type="submit" value="提交">
		</form>
	
	
	</body>
</html>

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/student/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/student/delete?id="+stu.id+"'>删除</a></td></tr>"; 
						}
						
						htmlStr += "</table>";
						
						$("#show").html(htmlStr);
					}
				});
			}
			
				localStorage.setItem("lastname",stu.id);
			
	
			
			
		</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>
	</body>
</html>````

枯玄

关注

4
点赞
踩
20

收藏

觉得还不错? 一键收藏
4
评论
使用SpringBoot+Mysql+JPA实现对数据库的增删改查和分页

使用idea新建个SpringBoot项目1. 选择create new project2. controlerstudentControllerpackage com.kude.stu.stu.controller;import com.kude.stu.stu.entity.Student;import com.kude.stu.stu.service.Stu...
复制链接

扫一扫