毕业设计——医院招标采购系统

最新推荐文章于 2024-09-05 14:50:40 发布
最新推荐文章于 2024-09-05 14:50:40 发布
阅读量224 收藏 1
点赞数
文章标签： spring boot maven java mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43675178/article/details/131747521
版权

简介

采用Spring Boot框架构建招标采购系统，采用前后端分离方式开发，招标采购系统主要功能有招标管理、采购管理、供应商管理等。招标管理功能涵盖招标、中标、发布招标等流程；采购管理功能负责进行采购流程，包括采购申请、采购计划、采购询价、供应商评审等；供应商管理功能负责管理供应商信息，包括供应商申请、供应商评审、供应商合同等。为分担系统压力将系统中静态图片资源、用户头像、供应商资质文件、项目招投标文件使用第三方文件存储、并且文件安全也得到保障。可以对文件数据进行容错容灾、备份、日志、安全管理、权限管理等功能进行设置进一步提高文件安全性。系统数据库中只存储文件路径大大降低了数据库压力。

相关技术 

Spring Boot、MyBatis PULS、Redis数据库、VUE框架、Element UI、Spring Security、MySQL

用户角色

招标采购管理系统主要面向四类角色：医院内部负责招标采购的员工（项目负责人、系统管理员等），供应商、专家。

项目负责人：负责采购项目的申请、供应商资质的审核、专家信息的审核验证、采购项目的管理、通知公告的发布。

系统管理员：负责用户管理、权限管理、采购项目审核。

供应商：参与招标的用户、个人信息的管理、公司信息的管理。

专家：参与评标的用户、个人信息的管理、对供应商的投标评分。

主要业务流程

代码部分：

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.7.2</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>BiddingSystem</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>
    <name>BiddingSystem</name>
    <description>BiddingSystem</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.6</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.6</version>
        </dependency>

        <dependency>
            <groupId>com.google.guava</groupId>
            <artifactId>guava</artifactId>
            <version>21.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.22</version>
        </dependency>

        <dependency>
            <groupId>com.github.xiaoymin</groupId>
            <artifactId>knife4j-spring-boot-starter</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>javax.mail</groupId>
            <artifactId>javax.mail-api</artifactId>
            <version>1.5.6</version>
        </dependency>

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <!--        redis-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>
        <dependency>
            <groupId>io.jsonwebtoken</groupId>
            <artifactId>jjwt</artifactId>
            <version>0.9.1</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.73</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-security</artifactId>
        </dependency>
        <!-- 2.腾讯云sdk的 -->
        <dependency>
            <groupId>com.qcloud</groupId>
            <artifactId>cos_api</artifactId>
            <version>5.6.89</version>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.5.9</version>
        </dependency>

    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

application.yml

spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/bidingsystem?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
    type: com.alibaba.druid.pool.DruidDataSource
  mvc:
    pathmatch:
      matching-strategy: ant_path_matcher
  redis:
    host: 127.0.0.1  #????????
    port: 6379      #????????
    password: 123456
    client-type: lettuce
    timeout: 10000 
    jedis:
      pool:
        max-active: 16
  servlet:
    multipart:
      max-file-size: 500MB  #单个数据大小
      max-request-size: 1024MB #总数据大小
server:
  port: 8888
mybatis-plus:
  mapper-locations: classpath*:mapper/**/*.xml
  global-config:
    db-config:
      table-prefix: tab_
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
cos: #腾讯云对象存储配置
  baseUrl: https://zhangbo-1306119450.cos.ap-chengdu.myqcloud.com/
  accessKey: AKID9Jya44zpfVJiz8JLI9sSpW6Wmy7********
  secretKey: oRmvhMxQmz6SddS2Wq2OwLZ*****
  regionName: ap-chengdu
  bucketName: zhangbo-******

目录结构

 

数据库结构



SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tab_admin
-- ----------------------------
DROP TABLE IF EXISTS `tab_admin`;
CREATE TABLE `tab_admin`  (
  `admin_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '管理员id',
  `admin_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号用户名',
  `employees_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工联系电话',
  `employees_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工号',
  `employees_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工姓名',
  `employees_email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工邮箱',
  `admin_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '管理员类型',
  `admin_pass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管理员密码',
  PRIMARY KEY (`admin_id`, `employees_id`) USING BTREE,
  INDEX `admin_id`(`admin_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_application
-- ----------------------------
DROP TABLE IF EXISTS `tab_application`;
CREATE TABLE `tab_application`  (
  `application_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报名编号',
  `purchase_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目编号',
  `expert_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评分专家编号',
  `application_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报名时间',
  `purchase_contact` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '负责人姓名',
  `purchase_bids_time` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '开标时间',
  `vendor_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商',
  `purchase_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '负责人联系方式',
  `vendor_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商联系人账号',
  `purchase_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称',
  `purchase_explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目说明',
  `purchase_file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投标文件',
  `vendor_score` int NULL DEFAULT NULL COMMENT '评分',
  `purchase_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目负责人',
  PRIMARY KEY (`application_id`) USING BTREE,
  INDEX `purchase_id`(`purchase_id` ASC) USING BTREE,
  CONSTRAINT `tab_application_ibfk_1` FOREIGN KEY (`purchase_id`) REFERENCES `tab_purchase` (`purchase_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目报名表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_article
-- ----------------------------
DROP TABLE IF EXISTS `tab_article`;
CREATE TABLE `tab_article`  (
  `article_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告id',
  `article_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告标题',
  `article_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告内容',
  `article_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发布时间',
  `article_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告类型',
  `article_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发布人',
  PRIMARY KEY (`article_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '公告表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_expert
-- ----------------------------
DROP TABLE IF EXISTS `tab_expert`;
CREATE TABLE `tab_expert`  (
  `expert_id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `expert_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',
  `expert_PS` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '政治面貌',
  `expert_graduation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '毕业学校',
  `expert_ocupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位地址',
  `expert_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所在单位',
  `expert_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位电话',
  `expert_email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位邮箱',
  `expert_introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '个人介绍',
  `expert_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '个人账号',
  `expert_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '状态',
  `expert_account_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号状态',
  `expert_industry` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所在行业',
  PRIMARY KEY (`expert_id`, `expert_account`) USING BTREE,
  INDEX `专家`(`expert_account` ASC) USING BTREE,
  CONSTRAINT `专家` FOREIGN KEY (`expert_account`) REFERENCES `tab_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专家表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_menu
-- ----------------------------
DROP TABLE IF EXISTS `tab_menu`;
CREATE TABLE `tab_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '菜单名',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '#' COMMENT '菜单图标',
  `create_by` bigint NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL,
  `update_by` bigint NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `del_flag` int NULL DEFAULT 0 COMMENT '是否删除（0未删除 1已删除）',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_opt
-- ----------------------------
DROP TABLE IF EXISTS `tab_opt`;
CREATE TABLE `tab_opt`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '供应类别、采购方式' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_outcome
-- ----------------------------
DROP TABLE IF EXISTS `tab_outcome`;
CREATE TABLE `tab_outcome`  (
  `purchase_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目编号',
  `purchase_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目名称',
  `purchase_contract` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '合同',
  `purchase_tenderer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招标人',
  `purchase_tender_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招标方式',
  `purchase_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '中标人',
  `purchase_vendor_contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人',
  `purchase_vendor_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投标人电话',
  `purchase_vendor_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  PRIMARY KEY (`purchase_id`) USING BTREE,
  CONSTRAINT `tab_outcome_ibfk_1` FOREIGN KEY (`purchase_id`) REFERENCES `tab_purchase` (`purchase_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '合同表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_purchase
-- ----------------------------
DROP TABLE IF EXISTS `tab_purchase`;
CREATE TABLE `tab_purchase`  (
  `purchase_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目编号',
  `purchase_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称',
  `purchase_explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目说明',
  `purchase_budget` int NOT NULL COMMENT '项目预算',
  `purchase_charge` int NOT NULL COMMENT '招标文件收费',
  `purchase_deposit` int NOT NULL COMMENT '保证金',
  `purchase_submission` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投标文件递交方式',
  `purchase_bidding` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '开标地点',
  `purchase_bid_opening_method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评标方式',
  `purchase_tender_method` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '招标方式',
  `purchase_registration_deadline` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报名截止时间',
  `purchase_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '采购类别',
  `purchase_contact` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系人',
  `purchase_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '固定电话',
  `purchase_email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '电子邮箱',
  `purchase_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招标文件',
  `purchase_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目状态',
  `purchase_end` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '距离结束',
  `purchase_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目负责人',
  PRIMARY KEY (`purchase_id`) USING BTREE,
  INDEX `purchase_account`(`purchase_account` ASC) USING BTREE,
  CONSTRAINT `tab_purchase_ibfk_1` FOREIGN KEY (`purchase_account`) REFERENCES `tab_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_record
-- ----------------------------
DROP TABLE IF EXISTS `tab_record`;
CREATE TABLE `tab_record`  (
  `resource_id` int NOT NULL AUTO_INCREMENT COMMENT '操作编号',
  `record_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '对应记录',
  `record_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型（项目表：删除、更新）',
  `record_update_time` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作时间',
  `record_operator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人（用户名）',
  PRIMARY KEY (`resource_id`, `record_id`) USING BTREE,
  INDEX `record_operator`(`record_operator` ASC) USING BTREE,
  CONSTRAINT `tab_record_ibfk_1` FOREIGN KEY (`record_operator`) REFERENCES `tab_user` (`user_contact_name`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_role
-- ----------------------------
DROP TABLE IF EXISTS `tab_role`;
CREATE TABLE `tab_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色权限字符串',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '角色状态（0正常 1停用）',
  `del_flag` int NULL DEFAULT 0 COMMENT 'del_flag',
  `create_by` bigint NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL,
  `update_by` bigint NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `tab_role_menu`;
CREATE TABLE `tab_role_menu`  (
  `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `menu_id` bigint NOT NULL DEFAULT 0 COMMENT '菜单id',
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE,
  INDEX `menu_id`(`menu_id` ASC) USING BTREE,
  CONSTRAINT `tab_role_menu_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `tab_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `tab_role_menu_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `tab_menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色与菜单关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_score
-- ----------------------------
DROP TABLE IF EXISTS `tab_score`;
CREATE TABLE `tab_score`  (
  `score_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `expert_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `vendor_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `purchase_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `vendor_score` int NOT NULL,
  PRIMARY KEY (`score_id`) USING BTREE,
  INDEX `purchase_id`(`purchase_id` ASC) USING BTREE,
  CONSTRAINT `tab_score_ibfk_1` FOREIGN KEY (`purchase_id`) REFERENCES `tab_application` (`purchase_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目评分表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_structure
-- ----------------------------
DROP TABLE IF EXISTS `tab_structure`;
CREATE TABLE `tab_structure`  (
  `str_id` int NOT NULL AUTO_INCREMENT,
  `tab_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `field_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `field_name_ch` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`str_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据库表结构字典表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_suggestion
-- ----------------------------
DROP TABLE IF EXISTS `tab_suggestion`;
CREATE TABLE `tab_suggestion`  (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `content` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `user_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `record` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '处理人',
  `record_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '处理时间',
  `suggestion_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发生时间',
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  CONSTRAINT `tab_suggestion_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tab_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '反馈与建议表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_user
-- ----------------------------
DROP TABLE IF EXISTS `tab_user`;
CREATE TABLE `tab_user`  (
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户标识',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `user_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系电话',
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户类型',
  `user_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '电子邮箱',
  `user_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位名称',
  `user_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账号状态',
  `user_contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',
  `user_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'https://zhangbo-1306119450.cos.ap-chengdu.myqcloud.com//avatar/581677739280521.png' COMMENT '头像',
  `user_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户密码',
  `user_register_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '注册时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  INDEX `user_contact_name`(`user_contact_name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tab_user_role`;
CREATE TABLE `tab_user_role`  (
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户id',
  `role_id` bigint NOT NULL DEFAULT 0 COMMENT '角色id',
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  INDEX `role_id`(`role_id` ASC) USING BTREE,
  CONSTRAINT `tab_user_role_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tab_user` (`user_id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT `tab_user_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `tab_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户与角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tab_vendor
-- ----------------------------
DROP TABLE IF EXISTS `tab_vendor`;
CREATE TABLE `tab_vendor`  (
  `vendor_id` int NOT NULL AUTO_INCREMENT COMMENT '供应商编号',
  `vendor_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商名称',
  `vendor_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商类型',
  `vendor_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商联系电话',
  `vendor_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商联系邮箱',
  `vendor_level` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商级别',
  `vendor_aptitude` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商资质文件',
  `vendor_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '供应商账号',
  `vendor_contact_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人姓名',
  `vendor_contact_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人电话',
  `vendor_contact_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人邮箱',
  `vendor_status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商状态',
  `vendor_account_status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '供应商账号状态',
  `vendor_add` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公司地址',
  PRIMARY KEY (`vendor_id`, `vendor_account`) USING BTREE,
  INDEX `联系人`(`vendor_account` ASC) USING BTREE,
  CONSTRAINT `联系人` FOREIGN KEY (`vendor_account`) REFERENCES `tab_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 177 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '供应商表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Triggers structure for table tab_admin
-- ----------------------------
DROP TRIGGER IF EXISTS `add_user`;
delimiter ;;
CREATE TRIGGER `add_user` AFTER INSERT ON `tab_admin` FOR EACH ROW begin
INSERT INTO tab_user(user_id,user_name,user_password,user_type,user_contact_name,user_email,user_phone,user_status,user_register_time)VALUES(new.admin_id,new.admin_name,new.admin_pass,new.admin_type,new.employees_name,new.employees_email,new.employees_phone,0,now());
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table tab_user
-- ----------------------------
DROP TRIGGER IF EXISTS `add_userinfo`;
delimiter ;;
CREATE TRIGGER `add_userinfo` BEFORE INSERT ON `tab_user` FOR EACH ROW BEGIN
IF new.user_type='专家' then 
INSERT INTO tab_expert(expert_name,expert_account,expert_phone,expert_email,expert_status,expert_account_status)VALUES(new.user_contact_name,new.user_id,new.user_phone,new.user_email,'未完善信息',new.user_status);
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,4);
ELSEIF new.user_type='供应商' then
INSERT INTO tab_vendor(vendor_name,vendor_level,vendor_contact_name,vendor_contact_phone,vendor_account,vendor_account_status,vendor_contact_email,vendor_status,vendor_aptitude)VALUES(new.user_company_name,0,new.user_contact_name,new.user_phone,new.user_id,new.user_status,new.user_email,'未完善信息','未上传');
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,3);
ELSEIF new.user_type='管理员' then
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,5);
ELSEIF new.user_type='项目负责人' then
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,2);
end if ;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table tab_user
-- ----------------------------
DROP TRIGGER IF EXISTS `update_userinfo`;
delimiter ;;
CREATE TRIGGER `update_userinfo` BEFORE UPDATE ON `tab_user` FOR EACH ROW BEGIN
if  new.user_type='供应商' then 
UPDATE tab_vendor SET vendor_name=new.user_company_name,vendor_contact_name=new.user_contact_name,vendor_contact_phone=new.user_phone,vendor_contact_email=new.user_email,vendor_status='待审核' WHERE (vendor_account= new.user_id) ;
ELSEIF new.user_type='专家' then
UPDATE tab_expert SET expert_name=new.user_contact_name,expert_phone=new.user_phone,expert_email=new.user_phone,expert_status='待审核'
WHERE (expert_account=new.user_id);
end if ;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table tab_user
-- ----------------------------
DROP TRIGGER IF EXISTS `delete_userinfo`;
delimiter ;;
CREATE TRIGGER `delete_userinfo` AFTER DELETE ON `tab_user` FOR EACH ROW BEGIN
IF old.user_type='供应商' then
DELETE from tab_vendor WHERE vendor_account=old.user_id;
ELSEIF old.user_type='专家' THEN
DELETE from tab_expert WHERE expert_account=old.user_id;
END if;
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;

触发器

1、user表
//更新触发器：User表发生更新时同步触发更新专家与供应商表
BEGIN
if  new.user_type='供应商' then 
UPDATE tab_vendor SET vendor_name=new.user_company_name,vendor_contact_name=new.user_contact_name,vendor_contact_phone=new.user_phone,vendor_contact_email=new.user_email,vendor_status='待审核' WHERE (vendor_account= new.user_id) ;
ELSEIF new.user_type='专家' then
UPDATE tab_expert SET expert_name=new.user_contact_name,expert_phone=new.user_phone,expert_email=new.user_phone,expert_status='待审核'
WHERE (expert_account=new.user_id);
end if ;
END


//删除触发器：User表发生删除时同步触发删除专家与供应商表
BEGIN
IF old.user_type='供应商' then
DELETE from tab_vendor WHERE vendor_account=old.user_id;
ELSEIF old.user_type='专家' THEN
DELETE from tab_expert WHERE expert_account=old.user_id;
END if;
END


//添加触发器：User表新增时同步触发新增至专家、供应商表，在权限表新增账号角色权限信息
BEGIN
IF new.user_type='专家' then 
INSERT INTO tab_expert(expert_name,expert_account,expert_phone,expert_email,expert_status,expert_account_status)VALUES(new.user_contact_name,new.user_id,new.user_phone,new.user_email,'未完善信息',new.user_status);
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,4);
ELSEIF new.user_type='供应商' then
INSERT INTO tab_vendor(vendor_name,vendor_level,vendor_contact_name,vendor_contact_phone,vendor_account,vendor_account_status,vendor_contact_email,vendor_status,vendor_aptitude)VALUES(new.user_company_name,0,new.user_contact_name,new.user_phone,new.user_id,new.user_status,new.user_email,'未完善信息','未上传');
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,3);
ELSEIF new.user_type='管理员' then
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,5);
ELSEIF new.user_type='项目负责人' then
INSERT INTO tab_user_role(user_id,role_id)VALUES(new.user_id,2);
end if ;
END


2、管理员表
//添加触发器：管理员表新增时同步触发新增至user表
INSERT INTO tab_user(user_id,user_name,user_password,user_type,user_contact_name,user_email,user_phone,user_status)VALUES(new.admin_id,new.admin_name,new.admin_pass,new.admin_type,new.employees_name,new.employees_email,new.employees_phone,0);
END

后续另发 

TEBOSIEST
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
大学生毕业设计论文题目大全
2402_82389843的博客
05-02 802
目的论视角下游戏名称本地化翻译策略分析 ——以动视暴雪公司旗下游戏为例。基于SpringBoot的社区C2C物品置换系统的设计与实现。基于SpringBoot+Vue的学习辅导系统的设计与实现。基于SpringBoot的人才公寓租赁管理系统的设计与实现。基于SpringBoot的社区养老服务管理系统的设计与实现。基于SpringBoot+VUE的宿舍管理系统的设计与实现。基于SpringBoot的毕业生就业服务平台的设计与实现。基于SpringBoot的社区志愿者管理系统的设计与实现。
新一代医院信息系统（NGHIS）设计（1）——体系结构篇
孺子牛的博客
05-02 3万+
一、前言我国的医院信息化建设，始于上世纪80年代中末期，经过90年代的自由繁荣（ye man）发展和本世纪初的政策扶持、引导规范与市场培育，历经30多年的发展，目前已经遇到瓶颈。其中最根本的原因是系统架构问题，由于缺乏系统互操作标准，大多数HIS厂商之间的系统互连互通成为困扰行业用户的头疼问题；同时，几乎所有HIS厂商都走大而全的系统架构路线，大有HIS包罗万象之势，随着系统的“生长”和研发人员的...
计算机专业毕业设计题目大全——各种类型系统设计大全
热门推荐
haosen
02-24 13万+
计算机专业毕业设计题目大全 一、ASP类计算机专业毕业设计题目 1.网络留言薄2.客户管理系统3.多媒体积件管理库的开发与应用4.基于WEB的多媒体素材管理库的开发与应用5.网络教学软件中的教学设计与应用6.小型教育网站的开发与建设7.基于图像的风景旅游模拟漫游系统8.网上报名系统9.电脑配件网络购物10.房产网站11.计算机组成原理网站12.软件下载系统网站13.图书管理系统14.网络办公系...
java毕业设计基于spingboot+vue药品招标采购系统的设计与实现
q_1262330535的博客
11-09 436
随着我国经济社会的发展，人民生活水平显著提高，在物质生活显著提高的情况下，人们对自己的健康更加关注。医疗卫生行业与人民的生活息息相关，因此有必要顺应时代发展的要求，引入计算机技术。信息技术在医学领域的广泛应用，带来了很多的好处。信息化的医院也更符合社会的需要，HIS系统在各级医院的普及则是其体现，而医院药品的管理更是其中十分重要的一个环节。药品与患者联系密切，而且药品在医院内部流动，涉及到药品库房、调剂部门、病房等多个环节。要实现管理目标需要在流动的各个环节设置相应的功能模块，实现对药品流动全过程的管理。
Java毕业设计174例，包含部署视频
biyesheji1000的专栏
04-27 4万+
基于Java的毕业设计，包含部署视频，一步一步教你加载数据库，运行，功能演示
计算机专业毕业设计题目汇总-最新题目 选题 推荐 毕业设计 - 毕设指导 开题报告 论文
JavaPub
04-08 1万+
计算机专业毕业设计题目汇总-最新题目-选题-推荐-毕业设计 - 毕设指导-开题报告-论文
Springboot医疗药品管理系统 毕业设计源码53580
weixin_ZYKJ985的博客
06-29 696
本文以选择Eclipse开发工具的java开发语言中springboot+mysql数据库来存储数据，以B/S为运行模式，开发了一个医疗药品管理系统，划分为了医生、仓管人员、药品管理人、系统管理员四种角色，实现了对医疗药品信息的查询、药品分类、出入库管理、库存管理、开药记录管理等功能模块。经过了多次的测试和结果评估，该医疗药品管理系统已经能够满足医疗药品管理的实际应用的需要并可以成功上线运行使用了....
药品招标采购系统的设计与实现-计算机毕业设计源码+LW文档
qq_375279829的博客
09-28 107
美国药品联合采购特点。美国药品集中采购组织：在美国，医疗机构采购的药品和设备中，超过70%的是委托药品集中采购组织（group purchasing organization,GPo）进行采购，GPo是药品、医疗器械和供应商之间的中间媒介，旨在通过持续购买大量的产品，为医疗机构、诊所等提高在市场中的议价能力，以获得较低的产品价格或更好的服务水平。(1）经济适用，该系统能够大大的节省人力和物力，降低药品招标的成本，并且具有一定的扩展性，但目前为止，它的不足之处也较为突出，比如比较缺少灵活性和通用性。
大学生毕业设计论文题目大全_kaic
涉及毕业论文、远程调试、小程序、管理系统、JAVA、C#、IDEA、VS开发工具等
08-31 2308
目的论视角下游戏名称本地化翻译策略分析 ——以动视暴雪公司旗下游戏为例。基于SpringBoot的社区C2C物品置换系统的设计与实现。基于SpringBoot+Vue的学习辅导系统的设计与实现。基于SpringBoot的人才公寓租赁管理系统的设计与实现。基于SpringBoot的社区养老服务管理系统的设计与实现。基于SpringBoot+VUE的宿舍管理系统的设计与实现。基于SpringBoot的毕业生就业服务平台的设计与实现。基于SpringBoot的社区志愿者管理系统的设计与实现。
管理类联考——逻辑——真题篇——按知识分类——综合推理
stqer的博客
12-16 420
29、某部门抽检了肉制品、白酒、乳制品、干果、蔬菜、水产品、饮料等﹖类商品共521种样品，发现其中合格样品515种，不合格样品6种。已知： （1）蔬菜、白酒中有2种不合格样品。 （2）肉制品、白酒、蔬菜、水产品中有5种不合格样品。 （3）蔬菜、乳制品、干果中有3种不合格样品。 根据上述信息，可以得出以下哪项? A. 乳制品中没有不合格样品。 B. 肉制品中没有不合格样品。 C. 蔬菜中没有不合格样品。 D. 白酒中没有不合格样品。 E. 水产品中没有不合格样品。 31~32题基于以下题干： 某中学举行田径运
最近这里了这几年做过的计算机专业毕业设计题目如下：
qq_820629211的博客
04-14 1万+
这些题目在我的资源里部分都能找到，还有一部分没有上传完！！！上传，很辛苦有没有？？、emmmmmm需要这些项目交流学习的可以评论我，也可以私信我秋——秋，秋秋hao可以看我ID.-----------------分割线---------------1.网络留言薄2.客户管理系统3.多媒体积件管理库的开发与应用4.基于WEB的多媒体素材管理库的开发与应用5.网络教学软件中的教学设计与应用6.小型教育...
优化 spring boot 的启动速度
lxl12138的博客
08-30 562
使用@ComponentScan注解的懒加载属性（lazy-init=“true”），让某些组件在真正使用时才初始化，加快初始加载速度。：在生产环境中，移除或降低logback或logging框架的日志级别，关闭Eclipse或IntelliJ IDE中的自动断点。：对于频繁使用的数据，考虑预先加载到内存缓存，比如Redis或Hazelcast。：对于耗时任务，可以使用Spring的Async或Quartz等工具改为后台运行。：检查项目是否有不必要的依赖，特别是那些启动时不使用的库。
【Spring Boot 3】【Web】返回图片
又言又语
09-01 941
本文介绍开发 Spring Boot Web 应用时如何返回图片给前端显示。
拍卖新纪元：Spring Boot赋能在线拍卖解决方案
最新发布
liuxin33445566的博客
09-05 1007
在对在线拍卖系统进行测试的时候在找到问题的情况下必须在第一时间找到解决问题的办法，不要存在侥幸的心理，这样才能让在线拍卖系统开发的质量可以过关，并且开发的周期会大大缩短，还有就是在测试时，不要出现重复性的错误，遇到一个错误问题，要将整个在线拍卖系统 开发所牵扯的该问题都必须一一解决，提高在线拍卖系统平台的安全性、稳定性。开发整个系统使用的是云计算，流量的可扩展性和基于流量的智能调整云计算的优点就是流量的可扩展性和基于流量的智能调整，保障了数据信息能够得到及时的备份，整个系统可以安全有效的运行。
Spring Boot如何解决跨域问题？
HBLOG
08-28 1220
跨域请求，就是说浏览器在执行脚本文件的ajax请求时，脚本文件所在的服务地址和请求的服务地址不一样。说白了就是ip、网络协议、端口都一样的时候，就是同一个域，否则就是跨域。这是由于Netscape提出一个著名的安全策略——同源策略造成的，这是浏览器对JavaScript施加的安全限制。是防止外网的脚本恶意攻击服务器的一种措施。
【Spring Boot 3】【Web】国际化
又言又语
09-01 823
本文介绍开发 Spring Boot Web 应用时如何配置国际化。国际化，简称i18n，源自国际化英文单词中首字母i与尾字母n之间有18个字母。Spring 默认使用提供国际化支持。通过解析 HTTP Headers 中字段判断当前语言环境。基名_语言_地区.properties，其中语言使用小写双字母，地区使用大写双字母。常用语言zh：中文en：英语ar：阿拉伯语da：丹麦语de：德语el：希腊语es：西班牙语fi：芬兰语fr：法语he：希伯来语hu：匈牙利语it：意大利语。
Spring Boot 项目中，配合 Nacos 、Gateway使用 MinIO
m0_57083961的博客
08-30 1387
在现代微服务架构中，将不同服务整合并高效地管理配置和流量是至关重要的。Spring Cloud Gateway、Nacos 和 MinIO 是三个关键组件
基于VB6.0的医院门诊收费管理系统设计与应用
这篇毕业设计展示了作者对医院管理信息系统设计的专业理解和实践能力，对于理解医院信息化建设的现状和未来趋势具有参考价值。同时，它也为其他从事类似领域研究的学生提供了有价值的案例和学习资源。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值