瑞吉外卖项目：环境搭建以及项目初始化

Dear 丶 2023-09-29 11:19 4阅读 0赞

**目录**

一. 数据库搭建

二. 后端项目搭建

2.1 pom工程配置

2.2 设置静态资源访问

--------------------

> **道冲，而用之或不盈。------《道德经》**

**上一篇：**

[瑞吉外卖项目整体介绍![icon-default.png?t=M3K6][icon-default.png_t_M3K6]https://blog.csdn.net/qq\_41857955/article/details/124310414][icon-default.png_t_M3K6_icon-default.png_t_M3K6_https_blog.csdn.net_qq_41857955_article_details_124310414]

## 一. 数据库搭建 ##

本项目使用11张表，具体如下：

<table style="width:420px;"> 
 <tbody> 
  <tr> 
   <td style="width:100px;">序号</td> 
   <td style="width:130px;">表名</td> 
   <td style="width:184px;">说明</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">1</td> 
   <td style="width:130px;">employee</td> 
   <td style="width:184px;">员工表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">2</td> 
   <td style="width:130px;">category</td> 
   <td style="width:184px;">餐品与套餐分类表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">3</td> 
   <td style="width:130px;">dish</td> 
   <td style="width:184px;">菜品表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">4</td> 
   <td style="width:130px;">setmeal</td> 
   <td style="width:184px;">套餐表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">5</td> 
   <td style="width:130px;">setmeal_dish</td> 
   <td style="width:184px;">套餐菜品关系表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">6</td> 
   <td style="width:130px;">dish_flavor</td> 
   <td style="width:184px;">菜品口味关系表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">7</td> 
   <td style="width:130px;">user</td> 
   <td style="width:184px;">用户表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">8</td> 
   <td style="width:130px;">address_book</td> 
   <td style="width:184px;">地址簿表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">9</td> 
   <td style="width:130px;">shoping_cart</td> 
   <td style="width:184px;">购物车表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">10</td> 
   <td style="width:130px;">orders</td> 
   <td style="width:184px;">订单表</td> 
  </tr> 
  <tr> 
   <td style="width:100px;">11</td> 
   <td style="width:130px;">order_detail</td> 
   <td style="width:184px;">订单明细表</td> 
  </tr> 
 </tbody> 
</table>

可以通过命令行去执行SQL，具体操作如下：

![61165c127459440b81169466b2b1bc79.png][]

先创建一个数据库，然后在执行SQL文件:

create database reggie character set utf8mb4;
    source xxx.sql;

## 二. 后端项目搭建 ##

### 2.1 pom工程配置 ###

建一个springboot的项目，导入依赖，写入基本配置：

<?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 http://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.4.5</version>
            <relativePath/> 
        </parent>
        <groupId>org.example</groupId>
        <artifactId>reggie_take_out</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <maven.compiler.source>8</maven.compiler.source>
            <maven.compiler.target>8</maven.compiler.target>
        </properties>
    
        <dependencies>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
                <scope>compile</scope>
            </dependency>
    
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.4.2</version>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.20</version>
            </dependency>
    
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.76</version>
            </dependency>
    
            <dependency>
                <groupId>commons-lang</groupId>
                <artifactId>commons-lang</artifactId>
                <version>2.6</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
    
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.23</version>
            </dependency>
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <version>2.4.5</version>
                </plugin>
            </plugins>
        </build>
    </project>

**yml文件配置：**

server:
      port: 8080
    spring:
      application:
        name: reggie_take_out
      datasource:
        druid:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
          username: root
          password: root
    mybatis-plus:
      configuration:
        #在映射实体或者属性时，将数据库中表名和字段名中的下划线去掉，按照驼峰命名法映射
        map-underscore-to-camel-case: true
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      global-config:
        db-config:
          # 主键生成策略
          id-type: ASSIGN_ID

### 2.2 设置静态资源访问 ###

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA54iq5ZOH5paX572X_size_13_color_FFFFFF_t_70_g_se_x_16][]

如果将静态资源直接放在资源目录下，肯定访问不了的，这时可以写一个静态资源配置类去访问：

package com.itheima.reggie.config;
    
    import lombok.extern.slf4j.Slf4j;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
    import org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport;
    
    /**
     * @author tongbing
     * @date 2022/4/21
     */
    @Slf4j
    @Configuration
    public class WebMvcConfig extends WebMvcConfigurationSupport {
    
    
        /**
         * TODO：或者在资源路径下创建static然后进行yml配置也可
         * 静态资源映射
         * @param registry
         */
        @Override
        protected void addResourceHandlers(ResourceHandlerRegistry registry) {
            log.info("开始进行资源映射");
            log.info("开始进行静态资源映射...");
            registry.addResourceHandler("/backend/**").addResourceLocations("classpath:/backend/");
            registry.addResourceHandler("/front/**").addResourceLocations("classpath:/front/");
        }
    }

访问：[http://localhost:8080/backend/index.html][http_localhost_8080_backend_index.html]即可加载静态资源如下：

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA54iq5ZOH5paX572X_size_20_color_FFFFFF_t_70_g_se_x_16][]

如果发现在任何配置都正确的情况下还没有出现已上效果，可能出现的问题：

**问题：**

1.  项目启动主类没有放在最外部（需要包含各个子包）
2.  重新rebuild一下，编辑器会加载静态资源（重启亦可）

到这里，整个项目环境搭建完毕！！！

**下一篇：**

**[瑞吉外卖项目：后端登录功能实现![icon-default.png?t=M3K6][icon-default.png_t_M3K6]https://blog.csdn.net/qq\_41857955/article/details/124334559][icon-default.png_t_M3K6_icon-default.png_t_M3K6_https_blog.csdn.net_qq_41857955_article_details_124334559]**

[icon-default.png_t_M3K6]: https://csdnimg.cn/release/blog_editor_html/release2.1.0/ckeditor/plugins/CsdnLink/icons/icon-default.png?t=M3K6
[icon-default.png_t_M3K6_icon-default.png_t_M3K6_https_blog.csdn.net_qq_41857955_article_details_124310414]: https://blog.csdn.net/qq_41857955/article/details/124310414
[61165c127459440b81169466b2b1bc79.png]: https://img-blog.csdnimg.cn/61165c127459440b81169466b2b1bc79.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA54iq5ZOH5paX572X_size_13_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/835fb61e51294063aab4cbade3b01b12.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA54iq5ZOH5paX572X,size_13,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8080_backend_index.html]: http://localhost:8080/backend/index.html
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA54iq5ZOH5paX572X_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/f073d49723584346bbd7dea668e97f7b.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA54iq5ZOH5paX572X,size_20,color_FFFFFF,t_70,g_se,x_16
[icon-default.png_t_M3K6_icon-default.png_t_M3K6_https_blog.csdn.net_qq_41857955_article_details_124334559]: https://blog.csdn.net/qq_41857955/article/details/124334559