快速开发实战

CREATE TABLE user
(
	id BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
	name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
	age INT(11) NULL DEFAULT NULL COMMENT '年龄',
	email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
	PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


INSERT INTO user (name, age, email) VALUES
('Jone', 18, 'test1@baomidou.com'),
('Jack', 20, 'test2@baomidou.com'),
('Tom', 28, 'test3@baomidou.com'),
('Sandy', 21, 'test4@baomidou.com'),
('Billie', 24, 'test5@baomidou.com'),
('ZhangSan', 18, 'test1@baomidou.com'),
('LiSi', 20, 'test2@baomidou.com'),
('WangWu', 28, 'test3@baomidou.com'),
('LiuDeHua', 21, 'test4@baomidou.com'),
('KouKou', 24, 'test5@baomidou.com'),
('ZhangSan', 18, 'test1@baomidou.com'),
('LiSi', 20, 'test2@baomidou.com'),
('WangWu', 28, 'test3@baomidou.com'),
('LiuDeHua', 21, 'test4@baomidou.com'),
('KouKou', 24, 'test5@baomidou.com'),
('ZhangSan', 18, 'test1@baomidou.com'),
('LiSi', 20, 'test2@baomidou.com'),
('WangWu', 28, 'test3@baomidou.com'),
('LiuDeHua', 21, 'test4@baomidou.com'),
('KouKou', 24, 'test5@baomidou.com');

$ git clone https://gitee.com/zangzh/zzh-generator.git

# DataSource Configspring:  
datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&useSSL=false    
    username: root    
    password: xxxxx

<li>
	<a href="javascript:;">
		<i class="iconfont left-nav-li" lay-tips="订单管理">&#xe723;</i>
		<cite>用户管理</cite>
		<i class="iconfont nav_right">&#xe697;</i></a>
	<ul class="sub-menu">
		<li>
			<a onclick="xadmin.add_tab('用户列表','order-list.html')">
				<i class="iconfont">&#xe6a7;</i>
				<cite>用户列表</cite></a>
		</li>
	</ul>
</li>