档案制度建设专业宣传怎么做?3招搞定没人看、传不开的难题
你是不是上周刚熬3夜写的档案制度宣传稿,发单位群里只有行政部同事点赞,其他人连打开都不打开?还有上次组织档案制度培训,到的人还没请假的多,问起来都说“太枯燥听不懂,反正跟我没关系”?甚至到了归档截止日...
2026年08月30日 11:30:07
所有工具均提供免配置或一键安装版本,跳过复杂编译环节
档案软件不需要过度拆分,以下3个服务覆盖核心业务:
打开MySQL Workbench或Navicat,连接root用户,执行以下完整SQL脚本:
```sql CREATE DATABASE IF NOT EXISTS archive_user DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE DATABASE IF NOT EXISTS archive_meta DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; USE archive_user; CREATE TABLE IF NOT EXISTS sys_user ( id BIGINT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(100) NOT NULL, role VARCHAR(20) NOT NULL DEFAULT 'USER' ); INSERT INTO sys_user (username, password, role) VALUES ('admin', '$2a$10$N.zmdr9k7uOCQb376NoUnuTJ8iAt6Z5EHsM8lE9lBOsl7iAt6Z5EH', 'ADMIN'); USE archive_meta; CREATE TABLE IF NOT EXISTS archive_category ( id BIGINT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL UNIQUE, parent_id BIGINT DEFAULT 0 ); CREATE TABLE IF NOT EXISTS archive_file ( id BIGINT PRIMARY KEY AUTO_INCREMENT, category_id BIGINT NOT NULL, file_name VARCHAR(100) NOT NULL, file_path VARCHAR(200) NOT NULL, upload_time DATETIME DEFAULT CURRENT_TIMESTAMP ); ```访问Nacos控制台,进入「配置管理」→「配置列表」,点击「+」创建3个配置:
第一个配置:Data ID=archive-user-dev.yml,Group=DEFAULT_GROUP,配置格式=YAML,内容如下:
```yaml server: port: 8001 spring: application: name: archive-user datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/archive_user?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai username: root password: Archive@2024 jpa: hibernate: ddl-auto: update show-sql: true cloud: nacos: discovery: server-addr: localhost:8848 ```第二个配置:Data ID=archive-meta-dev.yml,Group=DEFAULT_GROUP,配置格式=YAML,内容如下:
```yaml server: port: 8002 spring: application: name: archive-meta datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/archive_meta?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai username: root password: Archive@2024 jpa: hibernate: ddl-auto: update show-sql: true redis: host: localhost port: 6379 password: cloud: nacos: discovery: server-addr: localhost:8848 ```
第三个配置:Data ID=archive-gateway-dev.yml,Group=DEFAULT_GROUP,配置格式=YAML,内容如下:
```yaml server: port: 8000 spring: application: name: archive-gateway cloud: nacos: discovery: server-addr: localhost:8848 gateway: discovery: locator: enabled: true lower-case-service-id: true routes: - id: archive-user uri: lb://archive-user predicates: - Path=/user/ - id: archive-meta uri: lb://archive-meta predicates: - Path=/meta/ ```使用Spring Initializr快速创建3个Spring Boot 3.2.5项目,依赖选择统一配置:
所有项目的pom.xml统一添加Spring Cloud Alibaba依赖管理(在
archive-user的启动类添加@EnableDiscoveryClient注解,创建SysUser实体类(Lombok自动生成getter/setter)、SysUserRepository接口、简化的LoginController(跳过复杂权限验证):
```java // SysUser.java package com.example.archiveuser.entity; import jakarta.persistence.; import lombok.Data; @Data @Entity @Table(name = "sys_user") public class SysUser { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String username; private String password; private String role; } // SysUserRepository.java package com.example.archiveuser.repository; import com.example.archiveuser.entity.SysUser; import org.springframework.data.jpa.repository.JpaRepository; public interface SysUserRepository extends JpaRepositoryarchive-meta和archive-gateway仅需在启动类添加@EnableDiscoveryClient注解即可运行最小可用版本,后续可自行扩展业务。
严格按照以下顺序启动,避免服务找不到注册中心:
打开Postman或Apifox,执行以下测试: