1、创建数据库表结构
CREATE TABLE `t_user` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USERNAME` varchar(128) NOT NULL COMMENT '用户名',
`PASSWD` varchar(128) NOT NULL COMMENT '密码',
`CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
`STATUS` char(1) NOT NULL COMMENT '是否有效 1:有效 0:锁定STATUS',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO T_USER VALUES ('2', 'test', '7a38c13ec5e9310aed731de58bbc4214', '2022-06-01 10:20:21', '0');
INSERT INTO T_USER VALUES ('1', 'admin', '1fedc5a36d03c185065dd2b323886aa5', '2022-06-01 10:20:21', '1');
2、引入shiro相关依赖
<!-- shiro依赖 -->
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-spring</artifactId>
<version>1.4.1</version>
</dependency>
3、创建并生成pojo、dao、mapper映射、service、service实现类
3.1、User实体类
package com.***.***.pojo;
import java.util.Date;
public class User {
private Integer id;
private String username;
private String passwd;
private Date createTime;
private String status;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPasswd() {
return passwd;
}
public void setPasswd(String passwd) {
this.passwd = passwd;
}
public Date getCreateTime() {
return createTime;
}
public void setCreateTime(Date createTime) {
this.createTime = createTime;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", passwd='" + passwd + '\'' +
", createTime=" + createTime +
", status='" + status + '\'' +
'}';
}
}
3.2、UserMapper Dao方法
package com.***.***.dao;
import com.***.***.pojo.User;
public interface UserMapper {
User findByUserName(String userName);
}
3.3、UserMapper.xml Mapper映射
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.***.***.dao.U