# fly

**Repository Path**: xiaofei1/fly

## Basic Information

- **Project Name**: fly
- **Description**: wan
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-05-31
- **Last Updated**: 2026-04-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# fly


数据库脚本：
-- 创建日志表
CREATE TABLE `sys_operation_log` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`title` varchar(100) DEFAULT '' COMMENT '日志标题',
`operation` varchar(100) DEFAULT '' COMMENT '操作描述',
`method` varchar(200) DEFAULT '' COMMENT '方法名',
`params` text COMMENT '请求参数',
`result` text COMMENT '返回结果',
`error_msg` text COMMENT '异常信息',
`status` int DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
`operation_time` datetime DEFAULT NULL COMMENT '操作时间',
`ip` varchar(50) DEFAULT '' COMMENT '操作IP',
`operator_id` bigint DEFAULT NULL COMMENT '操作人ID',
`operator_name` varchar(50) DEFAULT '' COMMENT '操作人姓名',
`execution_time` bigint DEFAULT NULL COMMENT '执行时间(毫秒)',
PRIMARY KEY (`id`),
KEY `idx_operation_time` (`operation_time`),
KEY `idx_method` (`method`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统操作日志表';

-- 插入测试数据
INSERT INTO `sys_operation_log`
(`id`, `title`, `operation`, `method`, `params`, `result`, `error_msg`, `status`, `operation_time`, `ip`, `operator_id`, `operator_name`, `execution_time`)
VALUES
(1, '用户登录', 'login', '
com.example.demo.controller.UserController.login', '[{\"username\":\"admin\",\"password\":\"******\"}]', NULL, NULL,
0, '2023-01-01 10:00:00', '127.0.0.1', 1, 'admin', 120),
(2, '获取用户信息', 'getUserInfo', 'com.example.demo.controller.UserController.getUserInfo', '[1]', '{\"id\":
1,\"username\":\"admin\",\"nickname\":\"管理员\"}', NULL, 0, '2023-01-01 10:01:00', '127.0.0.1', 1, 'admin', 50),
(3, '导出用户数据', 'exportUsers', '
com.example.demo.controller.UserController.exportUsers', '[]', '[{\"id\":1,\"username\":\"admin\"},{\"id\":2,\"username\":\"user1\"}]...',
NULL, 0, '2023-01-01 10:02:00', '127.0.0.1', 1, 'admin', 350),
(4, '删除用户', 'deleteUser', 'com.example.demo.controller.UserController.deleteUser', '[2]', NULL, '用户不存在', 1, '
2023-01-01 10:03:00', '127.0.0.1', 1, 'admin', 80);