2021/08/24笔记

我们于2021/08/24 的学习目标是:CRM，核心任务为:

1、学习技术:

1）、CRM系统概念

2）、CRM系统模块划分

3）、数据库表结构设计

4）、项目环境搭建与测试

5）、功能设计

2、文档总结

1）、CRM系统概念

CRM，即客户关系管理，是指企业为提高核心竞争力，利用相应的信息技术以及互联网技术协调企业与顾客间在销售、营销和服务上的交互，从而提升其管理方式，向客户提供创新式的个性化的客户交互和服务的过程。其最终目标是吸引新客户、保留老客户以及将已有客户转为忠实客户，增加市场。

CRM系统即客户关系管理系统。

2）、CRM系统模块划分

3）、数据库表结构设计

略

4）、项目环境搭建与测试

配置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 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>



  <groupId>com.sdf</groupId>

  <artifactId>005</artifactId>

  <version>1.0-SNAPSHOT</version>



  <name>005</name>

<!-- FIXME Subscribe to my BLOG!! -->

  <url>https://blog.csdn.net/qq_59903099</url>



  <properties>

    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

    <maven.compiler.source>11</maven.compiler.source>

    <maven.compiler.target>11</maven.compiler.target>

  </properties>



  <parent>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-parent</artifactId>

    <version>2.2.2.RELEASE</version>

  </parent>



  <dependencies>

    <dependency>

      <groupId>junit</groupId>

      <artifactId>junit</artifactId>

      <version>4.13</version>

      <scope>test</scope>

    </dependency>

    <!-- web 环境 -->

    <dependency>

      <groupId>org.springframework.boot</groupId>

      <artifactId>spring-boot-starter-web</artifactId>

    </dependency>

    <!-- aop -->

    <dependency>

      <groupId>org.springframework.boot</groupId>

      <artifactId>spring-boot-starter-aop</artifactId>

    </dependency>

    <!-- freemarker -->

    <dependency>

      <groupId>org.springframework.boot</groupId>

      <artifactId>spring-boot-starter-freemarker</artifactId>

    </dependency>

    <!-- 测试环境 -->

    <dependency>

      <groupId>org.springframework.boot</groupId>

      <artifactId>spring-boot-starter-test</artifactId>

      <scope>test</scope>

    </dependency>

    <!-- mybatis -->

    <dependency>

      <groupId>org.mybatis.spring.boot</groupId>

      <artifactId>mybatis-spring-boot-starter</artifactId>

      <version>2.1.1</version>

    </dependency>



    <!-- 分页插件 -->

    <dependency>

      <groupId>com.github.pagehelper</groupId>

      <artifactId>pagehelper-spring-boot-starter</artifactId>

      <version>1.2.13</version>

    </dependency>



    <!-- mysql -->

    <dependency>

      <groupId>mysql</groupId>

      <artifactId>mysql-connector-java</artifactId>

      <scope>runtime</scope>

    </dependency>



    <!-- c3p0 -->

    <dependency>

      <groupId>com.mchange</groupId>

      <artifactId>c3p0</artifactId>

      <version>0.9.5.2</version>

    </dependency>



    <!-- commons-lang3 -->

    <dependency>

      <groupId>org.apache.commons</groupId>

      <artifactId>commons-lang3</artifactId>

      <version>3.5</version>

    </dependency>



    <!-- json -->

    <dependency>

      <groupId>com.alibaba</groupId>

      <artifactId>fastjson</artifactId>

      <version>1.2.47</version>

    </dependency>



    <!-- DevTools 热部署 -->

    <dependency>

      <groupId>org.springframework.boot</groupId>

      <artifactId>spring-boot-devtools</artifactId>

      <optional>true</optional>

    </dependency>

  </dependencies>



  <build>

    <plugins>

      <plugin>

        <groupId>org.apache.maven.plugins</groupId>

        <artifactId>maven-compiler-plugin</artifactId>

        <version>2.3.2</version>

        <configuration>

          <source>11</source>

          <target>11</target>

          <encoding>UTF-8</encoding>

        </configuration>

      </plugin>

      <plugin>

        <groupId>org.mybatis.generator</groupId>

        <artifactId>mybatis-generator-maven-plugin</artifactId>

        <version>1.3.2</version>

        <configuration>

          <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>

          <verbose>true</verbose>

          <overwrite>true</overwrite>

        </configuration>

      </plugin>

      <plugin>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-maven-plugin</artifactId>

        <configuration>

          <!-- 如果没有该配置，热部署的devtools不生效 -->

          <fork>true</fork>

        </configuration>

      </plugin>

    </plugins>

  </build>

</project>

在src/main/resources目录下新建application.yml配置文件：

server:

  port: 8085

  servlet:

    context-path: /crm

spring:

  datasource:

    type: com.mchange.v2.c3p0.ComboPooledDataSource

    driver-class-name: com.mysql.cj.jdbc.Driver

    url: jdbc:mysql://127.0.0.1:3306/crm?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8

    username: root

    password: qq_59903099@CSDN



  freemarker:

    suffix: .ftl

    content-type: text/html

    charset: UTF-8

    template-loader-path: classpath:/views/



  devtools:

    restart:

      enabled: true

      additional-paths: src/main/java





mybatis:

  mapper-locations: classpath:/mappers/*.xml

  type-aliases-package: com.sdf.bean;com.sdf.query;com.sdf.dto

  configuration:

    map-underscore-to-camel-case: true



pagehelper:

  helper-dialect: mysql





logging:

  level:

    com:

      sdf:

        mapper: debug             

在com.sdf.controller包下添加IndexController类实现视图转发

package com.yjxxt.controller;



import com.yjxxt.base.BaseController;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;



@Controller

public class IndexController extends BaseController {

    @RequestMapping("index")

    public String index(){

        System.out.println("IndexController.index");

        return "index";

    }



    @RequestMapping("welcome")

    public String welcome(){

        System.out.println("IndexController.welcome");

        return "welcome";

    }

   

    @RequestMapping("main")

    public String main(){

        System.out.println("IndexController.main");

        return "main";

    }

   

}

在com.sdf包下添加启动类

package com.sdf;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication

public class Starter {

 public static void main(String[] args) {

 SpringApplication.run(Starter.class);

 }

}

在src/main/resources目录下新建public和views目录并添加相应文件

运行Stater的main方法,并使用浏览器访问http://localhost:8085/crm/main

5）、功能设计

• 用户登录
• 密码修改与修改
• 全局异常统一处理
• 非法请求拦截
• 记住我