目录
先上效果图
1. 工程搭建
技术选型:springboot
+通用mapper
+thymeleaf
+amazeUI
(还需要lombok
插件)
平台工具:idea2019.3
+maven
+MySQL5.5
+Navicat
1.1数据库设计
包括三个属性:id,username,password
,其中id
设置为主键并自增
1.2依赖坐标
在pom.xml中添加
<dependencies>
<!-- 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.10</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
<!--mybatis 通用mapper-->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.1.5</version>
</dependency>
<!--jdbc 包含hikariCP-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--thymeleaf-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!--web-->
<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>
<optional>true</optional>
</dependency>
<!--属性注入bean-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--test-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
利用maven
项目管理工具自动导入相关依赖
1.3yml相关配置
# 使用springboot自带的数据源hikariCP
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
# 其中/eshop对应数据库
url: mysql://localhost:3306/eshop?characterEncoding=utf8
username: root
# yml的bug,对于纯数字类型的密码需要加引号,如果是包含字母的就不需要
password: '052398'
thymeleaf: #关闭缓存
cache: false
# mybatis配置 showSql
mybatis:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# pagehelper配置
pagehelper:
helperDialect: mysql
reasonable: true # 合理化查询,例如在第一页点击上一页时不会报错
supportMethodsArguments: true
params: count=countSql # 需要查出总记录数
2. 测试先行
2.1实体类UserTK
package com.hp.day5pagesearchdemo.domain;
import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;
import javax.persistence.Id;
import javax.persistence.Table;
@Data//提供getter\setter\tostring方法的注解
@Table(name = "users")// 声明此对象映射到数据库的数据表'users'
public class UserTK {
@Id//自增
@KeySql(useGeneratedKeys = true)
private Integer id;//int改为Integer
private String username;
private String password;
//有参、无参构造可利用注解实现