@SpringBootApplication
@MapperScan("com.mapper")
public class SpringThymeleafApplication {
public static void main(String[] args) {
SpringApplication.run(SpringThymeleafApplication.class, args);
}
}
如果需要缓存数据,则实体类需要实现序列化
public class User implements Serializable {
private int id;
private String name;
private int sex;
public User(int id, String name, int sex) {
this.id = id;
this.name = name;
this.sex = sex;
}
public User() {
}
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 getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
User user = (User) o;
return id == user.id &&
sex == user.sex &&
Objects.equals(name, user.name);
}
@Override
public int hashCode() {
return Objects.hash(id, name, sex);
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", sex=" + sex +
'}';
}
}
mybatis二级缓存是基于mapper文件,只需要在接口上加注解就OK
@Mapper
/*开启二级缓存*/
@CacheNamespace
public interface UserMapper {
@Select("select * from user")
List<User> getList();
@Insert("insert into user(name,sex)values(#{name},#{sex})")
int save(User user);
}
/*
Navicat Premium Data Transfer
Source Server : demo
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : super
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 01/08/2019 14:02:58
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sex` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '小明', 0);
INSERT INTO `user` VALUES (2, '小红', 1);
INSERT INTO `user` VALUES (3, '小白', 0);
INSERT INTO `user` VALUES (4, '小黄', 1);
INSERT INTO `user` VALUES (5, '小绿', 0);
INSERT INTO `user` VALUES (6, '小小', 0);
INSERT INTO `user` VALUES (7, '大大', 0);
SET FOREIGN_KEY_CHECKS = 1;