SpringBoot+JPA+thymeleaf框架实现增删改查分页显示

SpringBoot+JPA+thymeleaf 框架

实现增删改查分页显示

一、Mysql 创建数据库（schema.sql 创库脚

本）

可在 Mysql 数据库直接创建数据库 mysqldb

数据库表创建及插入脚本：

CREATE TABLE user (

id bigint(10) NOT NULL,

user_name varchar(100) DEFAULT NULL,

-- Records of user

-- ----------------------------

INSERT INTO user VALUES ('1', 'andy', '1', 22);

INSERT INTO user VALUES ('2', 'jone', '1', 28);

二、maven 依赖【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">

</parent>

<groupId>com.user</groupId>

<artifactId>JPAUserDemo</artifactId>

<version>1.0</version>

<!-- 默认打包成 jar 文件，window 环境部署需要打包成 war-->

<!--<packaging>war</packaging> -->

<name>JPAUserDemo</name>

<description>JPAUserDemo project for Spring Boot</description>

<properties>

<java.version>1.8</java.version>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

</dependency>

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-devtools</artifactId>

<scope>runtime</scope>

<optional>true</optional>

<groupId>org.apache.poi</groupId>

<artifactId>poi</artifactId>

<version>3.15</version>

</dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml</artifactId>

<version>3.15</version>

</dependency>

</dependencies>

</plugins>

</build>

</project>

import java.io.Serializable;

import java.util.Date;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

import javax.persistence.UniqueConstraint;

import org.springframework.format.annotation.DateTimeFormat;

*@Description:

*@Version:V1.0

*

@Entity

@Table(name = "user",uniqueConstraints = @UniqueConstraint(columnNames = "id"))

@Data

public class User implements Serializable{

private static final long serialVersionUID = 1L;

// @GenericGenerator(name = "id", strategy = "com.user.utils.MyIdGenerator" ) id 随机生

成为 String 类型

//@GeneratedValue(generator = "id")

private Long id;

private String userName;

private String password;

private int age;

private String sex;

private String phone;

return id;

}

public void setId(Long id){

this.id = id;

}

public String getUserName(){

return userName;

}