基于layui-2.4.5实现的单表功能的增删改查功能

最新推荐文章于 2022-07-20 00:36:32 发布

我叫小菜菜

最新推荐文章于 2022-07-20 00:36:32 发布

阅读量2.3k

点赞数 1

分类专栏：原创文章标签： layui springboot 增删改查

本文链接：https://blog.csdn.net/zhi_ai_yaya/article/details/86225400

版权

本文的弹窗部分是用闭包写的比较绕，可以参考下文：
https://blog.csdn.net/zhi_ai_yaya/article/details/86326039

下面是本文正文：

后端部分
1.1 数据库表和语句

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(255) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `experience` int(11) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `join_time` varchar(255) DEFAULT NULL,
  `logins` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', null, 'xiaohong@qq.com', '67', '1.1.1.1', '2019-01-07', '10', '女', '黄河之水天上来，奔流到海不复回。小红666666611111111111111', '小红哄哄哄哄');
INSERT INTO `user` VALUES ('10001', '浙江杭州', 'xianxin@layui.com', '116', '192.168.0.8', '2016-10-14', '108', '男', '点击此处，显示更多。当内容超出时，点击单元格会自动显示更多内容。', '杜甫');
INSERT INTO `user` VALUES ('1000111', '浙江杭州', 'xianxin@layui.com', '116', '192.168.0.8', '2016-10-14', '108', '男', '点击此处，显示更多。当内容超出时，点击单元格会自动显示更多内容。', '杜甫');
INSERT INTO `user` VALUES ('10003', '浙江杭州', 'xianxin@layui.com', '65', '192.168.0.8', '2016-10-14', '106', '男', '人生恰似一场修行', '王勃');
INSERT INTO `user` VALUES ('10004', '浙江杭州', 'xianxin@layui.com', '666', '192.168.0.8', '2016-10-14', '106', '女', '人生恰似一场修行', '李清照');
INSERT INTO `user` VALUES ('10005', '浙江杭州', 'xianxin@layui.com', '86', '192.168.0.8', '2016-10-14', '106', '女', '人生恰似一场修行', '冰心');
INSERT INTO `user` VALUES ('10006', '浙江杭州', 'xianxin@layui.com', '12', '192.168.0.8', '2016-10-14', '106', '男', '人生恰似一场修行', '贤心');
INSERT INTO `user` VALUES ('123455555', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明');
INSERT INTO `user` VALUES ('123456', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明');
INSERT INTO `user` VALUES ('12345611', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明11');
INSERT INTO `user` VALUES ('12345622', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明22');
INSERT INTO `user` VALUES ('12345666', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明6');
INSERT INTO `user` VALUES ('13', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明');
INSERT INTO `user` VALUES ('14', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明');
INSERT INTO `user` VALUES ('15', null, 'xiaoming@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。', '小明');
INSERT INTO `user` VALUES ('2', null, 'xiaodong@qq.com', '6', '1.1.1.1', '2019-01-07', '10', '男', '黄河之水天上来，奔流到海不复回。小东55555555', '小东');
INSERT INTO `user` VALUES ('admin', null, 'xiaoming@qq.com', '6666', '1.1.1.1', '2019-01-23', '10', '女', '管理员不允许删除或更新。用于测试删除或更新失败的情况', '管理员不允许删除或更新');

1.2 springboot项目和jpa代码

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>

	<groupId>com.starseaing</groupId>
	<artifactId>ex0015-springboot-elasticsearch-hello</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>ex0015-springboot-elasticsearch-hello</name>
	<description>ex0015-springboot-elasticsearch-hello</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.17.RELEASE</version>
		<relativePath /> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<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>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-elasticsearch</artifactId>
		</dependency>
		<dependency>
		    <groupId>net.java.dev.jna</groupId>
		    <artifactId>jna</artifactId>
		    <version>4.5.1</version>
		</dependency>
		<dependency>
		    <groupId>com.alibaba</groupId>
		    <artifactId>fastjson</artifactId>
		    <version>1.2.52</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.commons</groupId>
		    <artifactId>commons-collections4</artifactId>
		    <version>4.0</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-freemarker</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

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


</project>

实体：

package com.starseaing.sbelsdemo.bean;

import java.io.Serializable;
import javax.persistence.*;

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

	private static final long serialVersionUID = 5656473551030415169L;

	@I
	private String id;

	private String username;

	
	private String email;

	private String sex;


	private String city;


	private String sign;


	private Integer experience;


	private String ip;

	private String logins;

	private String joinTime;

	public String getId() {
		return id;
	}

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

	public String getUsername() {
		return us

最低0.47元/天解锁文章

我叫小菜菜

关注

1
点赞
踩
16

收藏

觉得还不错? 一键收藏
0
评论
基于layui-2.4.5实现的单表功能的增删改查功能

后端部分1.1 数据库表和语句DROP TABLE IF EXISTS `user`;CREATE TABLE `user` ( `id` varchar(255) NOT NULL, `city` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `experience` int(11) DEFA...
复制链接

扫一扫