SSM入门实战(登录功能的实现)
(1)数据库文件--->user.sql
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 50719
Source Host : localhost:3306
Source Schema : ssm_maven
Target Server Type : MySQL
Target Server Version : 50719
File Encoding : 65001
Date: 16/05/2020 18:33:03
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
`userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
`avatar` varchar(255) CHARACTER SET swe7 COLLATE swe7_swedish_ci NULL DEFAULT NULL COMMENT '头像',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`userType` int(5) NOT NULL COMMENT '用户类型',
`regTime` datetime(0) NOT NULL COMMENT '注册时间',
`regIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '注册IP',
PRIMARY KEY (`userID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('201601', '沐晴つ', '女', '', '123456', '13578519307', 1, '2020-05-12 12:10:06', '127.0.0.0.1');
INSERT INTO `user` VALUES ('201602', '墨夕つ', '男', '', '123456', '13578519307', 1, '2020-05-12 12:10:06', '127.0.0.0.1');
SET FOREIGN_KEY_CHECKS = 1;
(2)逆向工程generator生成Mapper和Entity
(2-a)Generator.java
package com.edu.util;
impor