# 創(chuàng)建數(shù)據(jù)庫: yygh_hosp
CREATE DATABASE IF NOT EXISTS `yygh_hosp` CHARACTER SET utf8mb4;
USE `yygh_hosp`;
# 創(chuàng)建表:hospital_set
CREATE TABLE `hospital_set` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '編號',
  `hosname` VARCHAR(100) DEFAULT NULL COMMENT '醫(yī)院名稱',
  `hoscode` VARCHAR(30) DEFAULT NULL COMMENT '醫(yī)院編號',
  `api_url` VARCHAR(100) DEFAULT NULL COMMENT 'api基礎(chǔ)路徑',
  `sign_key` VARCHAR(50) DEFAULT NULL COMMENT '簽名秘鑰',
  `contacts_name` VARCHAR(20) DEFAULT NULL COMMENT '聯(lián)系人',
  `contacts_phone` VARCHAR(11) DEFAULT NULL COMMENT '聯(lián)系人手機',
  `status` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '狀態(tài)',
  `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
  `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間',
  `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '邏輯刪除(1:已刪除，0:未刪除)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_hoscode` (`hoscode`) COMMENT '唯一約束(醫(yī)院編號必須唯一)'
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='醫(yī)院設(shè)置表';

# 服務(wù)端口
server.port=8201
# 服務(wù)名
spring.application.name=service-hosp
# 環(huán)境設(shè)置：dev、test、prod
spring.profiles.active=dev
# mysql數(shù)據(jù)庫連接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://[ip地址]:3306/yygh_hosp?characterEncoding=utf-8&useSSL=false
spring.datasource.username=[數(shù)據(jù)庫名稱]
spring.datasource.password=[數(shù)據(jù)庫密碼]
#返回json的全局時間格式
spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
spring.jackson.time-zone=GMT+8

package com.gql.yygh.hosp;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
 * @Description: 啟動類
 * @author Guoqianliang
 * @date 20:17 - 2021/4/3
 */
@SpringBootApplication
public class ServiceHospApplication {
    public static void main(String[] args) {
        SpringApplication.run(ServiceHospApplication.class, args);
    }
}

package com.gql.yygh.hosp.config;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Configuration;
/**
 * @Description: 醫(yī)院配置
 * @author Guoqianliang
 * @date 9:42 - 2021/4/4
 */
@Configuration
@MapperScan("com.gql.yygh.hosp.mapper")
public class HospConfig {
}

/**
 * @Description: Controller
 * @author Guoqianliang
 * @date 0:16 - 2021/4/4
 */
@RestController
@RequestMapping("/admin/hosp/hospitalSet")
public class HospitalSetController {
    /**
     * 注入Service
     */
    @Autowired
    private HospitalSetService hospitalSetService;
}

/**
 * @Description: Controller
 * @author Guoqianliang
 * @date 0:16 - 2021/4/4
 */
@RestController
@RequestMapping("/admin/hosp/hospitalSet")
public class HospitalSetController {
    /**
     * 注入Service
     */
    @Autowired
    private HospitalSetService hospitalSetService;
}