loginController
@RequestMapping ("/login")
@RestController
@Configuration
@EnableWebSecurity
public class LoginController {
@Resource
private UserDetailServiceImpl userDetailServiceImpl;
@Bean
AuthenticationManager authenticationManager(HttpSecurity httpSecurity) throws Exception {
return httpSecurity.getSharedObject(AuthenticationManagerBuilder.class)
.userDetailsService(userDetailServiceImpl)
.passwordEncoder(passwordEncoder())
.and()
.build();
}
/**
* 过滤器链
*
* @param authenticationManager 身份验证管理器
* @param http http
* @return {@link SecurityFilterChain}
* @throws Exception 异常
*/
@Bean
public SecurityFilterChain filterChain(AuthenticationManager authenticationManager, HttpSecurity http) throws Exception {
return http
.authorizeRequests()
.antMatchers("/add","/adduser")
.permitAll()
.anyRequest()
.authenticated()
.and()
.formLogin()
.loginPage("/admin/login")
.loginProcessingUrl("/admin/login")
.permitAll()
.successHandler((request, response, authentication) -> {
response.setContentType("application/json;charset=utf-8");
response.getWriter().write("{\"code\":200,\"msg\":\"登录成功\"}");
}).failureHandler((request, response, exception) -> {
response.setContentType("application/json;charset=utf-8");
response.getWriter().write("{\"code\":500,\"msg\":\"登录失败\"}");
})
.and()
.logout()
.logoutSuccessUrl("/logoutSuccess")
.permitAll()
.and()
.csrf().disable()
.headers().frameOptions().disable()
.and()
.build();
}
@Bean
public WebSecurityCustomizer webSecurityCustomizer() {
return (web) -> web.ignoring().antMatchers("/layui/**");
}
@Bean
public PasswordEncoder passwordEncoder() {
return new BCryptPasswordEncoder(); // 使用BCrypt加密
}
}
RouterController
@Controller
public class RouterController {
@RequestMapping("/")
public String index(){
return "index";
}
@RequestMapping("/admin/login")
public String login (){
return "login";
}
@RequestMapping("/logoutSuccess")
public String logoutSuccess(){
return "logout";
}
@RequestMapping("/add")
public String add(){
return "add";
}
}
addcontroller
@RestController
public class AddController {
@Resource
private AdminService adminService;
@RequestMapping("/adduser")
public Boolean addUser (Admin admin){
adminService.addUsers(admin);
return true;
}
}
TreeMenuController
@RequestMapping("/list")
@RestController
public class TreeMenuController {
@Resource
private TreeMenuService TreeMenuService;
@RequestMapping("/menu")
public List<TreeMenu>TreeMenu (){
Admin admin = (Admin) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
List<TreeMenu> list = TreeMenuService.selectMenuByRoleId(admin.getRoleId());
return list;
}
}
adminmapper
public interface AdminMapper {
@Select("select * from admin where account = #{account}")
Admin selectById(String account) ;
@Select("insert into admin value (#{id},#{account},#{password},#{roleId})")
Boolean addUser(Admin admin);
@Select("update admin set account = #{account},password = #{password},role_id = #{roleId} where account = #{account}")
Boolean updateUser(Admin admin);
}
TreeMenuMappeer
public interface TreeMenuMapper {
@Select("select menu.* FROM treemenu menu inner join role_treemenu rm on menu.id = rm .menu_id where rm .role_id = #{roleId}")
List<TreeMenu> selectMenuByRoleId (Integer roleId);
}
AdminServiceImpl
public class AdminServiceImpl implements AdminService {
@Resource
private AdminMapper adminMapper;
@Override
public Admin selectById(String account) {
return adminMapper.selectById(account);
}
@Override
public Boolean addUsers(Admin admin) {
// 密码加密
String newPassword = new BCryptPasswordEncoder().encode(admin.getPassword());
admin.setPassword(newPassword);
return adminMapper.addUser(admin);
}
}
TreeMenuServiceImpl
@Service
public class TreeMenuServiceImpl implements TreeMenuService {
@Resource
TreeMenuMapper treeMenuMapper;
@Override
public List<TreeMenu> selectMenuByRoleId(Integer roleId) {
return treeMenuMapper.selectMenuByRoleId(roleId);
}
}
UserDetailServiceImpl
@Service
public class UserDetailServiceImpl implements UserDetailsService {
@Resource
private AdminService adminService;
@Override
public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
Admin admin= adminService.selectById(username);
return admin;
}
}
AdminService
public interface AdminService {
Admin selectById(String account);
Boolean addUsers(Admin admin);
}
TreeMenuService
public interface TreeMenuService {
List<TreeMenu> selectMenuByRoleId (Integer roleId);
}
ADD.html
html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>注册title>
head>
<body>
input your id:<input id="id">input>
<br>
input your username:<input id="username">input>
<br>
input your password:<input type =password id="password">input>
<br>
input your roleid:<input id="role_id">
<br>
<button onclick="add()">注册button>
<script src="https://cdn.bootcss.com/jquery/3.3.1/jquery.min.js">script>
<script>
function add(){
var username = $("#username").val();
var password = $("#password").val();
var id = $("#id").val();
var role_id = $("#role_id").val();
// ajax 请求登录接口跳转首页
$.ajax({
url: '/adduser',
type: 'post',
dataType: 'json',
data: {
id:id,
account:username,
password:password,
roleId:role_id
},
success: function (data) {
if (data==true) {
window.location = "/login";
alert("注册成功，请重新登录！");
}else alert("注册失败，请重新输入信息！");
}, error: function (data) {
console.log(data);
}
});
}
script>
body>
html>
jiazai
<script>
function jiazai(){
$.ajax({
url: "/list/menu",
type: "get",
success: function (data) {
if (data){ // 如果有数据
var html = "";
for (const tr of data){
html += ""+tr.name+""+tr.url+""
}
$("#table").html(html);
}
}
})
}
script>
denglu
<script>
function denglu(){
var username = $("#username").val();
var password = $("#password").val();
// ajax 请求登录接口跳转首页
$.ajax({
url: '/admin/login',
type: 'post',
dataType: 'json',
data: {
username:username,
password:password
},
success: function (data) {
if (data.code == 200) {
window.location = "/";
} else {
alert("登录失败");
}
}, error: function (data) {
console.log(data);
}
});
}
script>
yum install java-1.8.0-openjdk-devel -y
java -jar loginDemo.jar
nohup java -jar yytest5.jar &
curl 常用的参数
curl -X POST -d "username=admin&password=123456" http://localhost:8080/login
curl -L http://localhost:8080/logout
-X/--request [GET|POST|PUT|DELETE|…] 使用指定的http method发出 http request
-H/--header 设定request里的header
-i/--include 显示response的header
-d/--data 设定 http parameters
-v/--verbose 輸出比较多的信息
-u/--user 使用者账号
-b/--cookie cookie 文件路径 使用cookie
#spring.datasource.url=jdbc:mysql://10.1.1.30:3306/manager_system
spring.datasource.url=jdbc:mysql://localhost:3306/manager_system
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=YangY657X+
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
# mybatis ????????
mybatis.configuration.map-underscore-to-camel-case=true
数据库
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80030 (8.0.30)
Source Host : localhost:3306
Source Schema : manager_system
Target Server Type : MySQL
Target Server Version : 80030 (8.0.30)
File Encoding : 65001
Date: 23/03/2023 03:16:08
*/
/**
如果需要导入的数据库不存在，需要先创建数据库
*/
CREATE DATABASE IF NOT EXISTS `manager_system` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int NOT NULL AUTO_INCREMENT,
`account` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '账号',
`password` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
`role_id` int DEFAULT '-1' COMMENT '角色ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` (`id`, `account`, `password`, `role_id`) VALUES (1, 'admin', '$2a$10$U3XImY9eYKEe9faMgVzpc..MLjYYH3Ci4..i0WNrhQYR3JkgtptL.', 1);
COMMIT;
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`) VALUES (1, 'ROLE_admin');
COMMIT;
-- ----------------------------
-- Table structure for role_treemenu
-- ----------------------------
DROP TABLE IF EXISTS `role_treemenu`;
CREATE TABLE `role_treemenu` (
`id` int NOT NULL AUTO_INCREMENT,
`role_id` int DEFAULT NULL COMMENT '角色ID',
`menu_id` int DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of role_treemenu
-- ----------------------------
BEGIN;
INSERT INTO `role_treemenu` (`id`, `role_id`, `menu_id`) VALUES (1, 1, 1);
INSERT INTO `role_treemenu` (`id`, `role_id`, `menu_id`) VALUES (2, 1, 2);
INSERT INTO `role_treemenu` (`id`, `role_id`, `menu_id`) VALUES (3, 1, 3);
COMMIT;
-- ----------------------------
-- Table structure for treemenu
-- ----------------------------
DROP TABLE IF EXISTS `treemenu`;
CREATE TABLE `treemenu` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '名称',
`url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of treemenu
-- ----------------------------
BEGIN;
INSERT INTO `treemenu` (`id`, `name`, `url`) VALUES (1, '首页', '/home');
INSERT INTO `treemenu` (`id`, `name`, `url`) VALUES (2, '控制台', '/console');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
