记录使用springboot+vue框架搭建一个前后端分离的demo（后端项目）

我用的工具版本：idea2019.1.3 vue2.9.6 jdk1.8
数据库用的是mysql
数据库名字叫mydatabase，表名字叫t_b_member

一、最终项目结构
member是项目名字，member-os是后端项目，member-fe是前端项目
member是一个maven项目，member-os和member-fe都是member的module

创建一个springboot项目，作为member的module

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.2.0.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.laijiamei</groupId>
    <artifactId>member-os</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>member-os</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-actuator</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-amqp</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.springframework.amqp</groupId>
            <artifactId>spring-rabbit-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--引入swagger相关配置-->
        <dependency>
            <groupId>io.swagger</groupId>
            <artifactId>swagger-annotations</artifactId>
            <version>1.5.20</version>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.9.2</version>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
            <version>2.9.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.60</version>
        </dependency>

        <!--        &lt;!&ndash; redis &ndash;&gt;-->
<!--        <dependency>-->
<!--            <groupId>org.springframework.boot</groupId>-->
<!--            <artifactId>spring-boot-starter-data-redis</artifactId>-->
<!--        </dependency>-->
    </dependencies>

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

</project>

1、在com.laijiamei.member包中创建新包common,封装一个返回结果类Result.java
Result.java

package com.laijiamei.member.common;

import org.springframework.util.StringUtils;

import java.io.Serializable;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 返回结果类
 * @date 17:45 2019/10/17
 */
public class Result implements Serializable {

    public static final String DEFAULT_ERROR_MESSAGE = "系统操作过程中出现错误,请重试";

    private static final String EXCEPTION_FLAG = "Exception";

    private boolean success;

    private String message;

    private Object data;

    public static Result success() {
        return success(null);
    }

    public static Result success(Object data) {
        return new Result(true, null, data);
    }

    public static Result success(String message, Object data) {
        return new Result(true, message, data);
    }

    public static Result fail() {
        return fail("操作失败请重试!");
    }

    public static Result fail(String message) {
        if (StringUtils.isEmpty(message) || message.indexOf(EXCEPTION_FLAG) > 0) {
            message = DEFAULT_ERROR_MESSAGE;
        }
        return new Result(false, message, null);
    }

    public Result(boolean success, String message, Object data) {
        this.success = success;
        this.message = message;
        this.data = data;
    }

    public boolean isSuccess() {
        return success;
    }

    public String getMessage() {
        return message;
    }

    public Object getData() {
        return data;
    }

}

2、在com.laijiamei.member包中创建新包entity，创建一个实体类Member
Member.java

package com.laijiamei.member.entity;

import java.io.Serializable;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 用户实体类
 * @date 11:21 2019/10/17
 */
public class Member implements Serializable {

    private Long id;

    private String name;

    private String account;

    private String password;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "Member{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", account='" + account + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

3、在com.laijiamei.member包中创建新包dao，创建一个接口类MemberDao
MemberDao.java

package com.laijiamei.member.dao;

import com.laijiamei.member.entity.Member;
import org.springframework.stereotype.Repository;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 用户Dao
 * @date 11:18 2019/10/17
 */
@Repository(value = "MemberDao")
public interface MemberDao {

    /**
     * 根据id获得用户
     * @param id
     * @return
     */
    Member getMemberById(Long id);

    /**
     * 根据账号密码登陆
     * @param member
     * @return
     */
    Member login(Member member);

}

4、在com.laijiamei.member包中创建新包service，创建一个接口类MemberService和实现类MemberServiceImpl
MemberService.java

package com.laijiamei.member.service;

import com.laijiamei.member.common.Result;
import com.laijiamei.member.entity.Member;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 用户Service
 * @date 11:19 2019/10/17
 */
public interface MemberService {

    /**
     * 根据id查询用户
     * @param id
     * @return
     */
    Member getMemberById(Long id);

    /**
     * 根据账号密码登陆
     * @param member
     * @return
     */
    Result login(Member member);

}

MemberServiceImpl.java

package com.laijiamei.member.service.impl;

import com.laijiamei.member.common.Result;
import com.laijiamei.member.dao.MemberDao;
import com.laijiamei.member.entity.Member;
import com.laijiamei.member.service.MemberService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Service;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 用户ServiceImpl
 * @date 11:19 2019/10/17
 */
@Service
public class MemberServiceImpl implements MemberService {

    protected static Logger logger = LoggerFactory.getLogger(MemberServiceImpl.class);

    @Autowired
    private MemberDao memberDao;

    @Override
    public Member getMemberById(Long id) {
        logger.info("调用getMemberById方法，id：{}", id);
        return memberDao.getMemberById(id);
    }

    /**
     * 用redis做缓存来查询
     * @param id
     * @return
     */
//    @Override
//    @Cacheable(value = "member", key = "#id")
//    public Member getMemberById(Long id) {
//        logger.info("调用getMemberById方法，id：{}", id);
//        return memberDao.getMemberById(id);
//    }

    @Override
    public Result login(Member member) {
        logger.info("调用login方法，account：{}，password：{}",
                member.getAccount(), member.getPassword());
        if(memberDao.login(member) == null) {
            return Result.fail("账号密码错误！");
        } else {
            return Result.success(memberDao.login(member));
        }
    }

}

5、在com.laijiamei.member包中创建新包controller，创建一个类MemberController
MemberController.java

package com.laijiamei.member.controller;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.laijiamei.member.common.Result;
import com.laijiamei.member.entity.Member;
import com.laijiamei.member.service.impl.MemberServiceImpl;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;

/**
 * @author jiamei.lai（2477637880@qq.com）
 * @version 1.0
 * @description: 用户Controller
 * @date 11:20 2019/10/17
 */
@RestController
@RequestMapping(value = "/member")
@Api("用户Controller")
public class MemberController {

    @Autowired
    private MemberServiceImpl memberService;

    @RequestMapping(value = "/getMemberById", method = RequestMethod.GET)
    @ApiOperation("根据id获得用户")
    public Result getMemberById(@RequestParam("id") Long id) {
        return Result.success(memberService.getMemberById(id));
    }

    @RequestMapping(value = "/login", method = RequestMethod.POST)
    @ApiOperation("登陆")
    public Result login(HttpServletRequest request, @RequestBody String jsonString) {
        JSONObject param = JSON.parseObject(jsonString);
        Member member = JSON.parseObject(String.valueOf(param.get("member")), Member.class);
        return memberService.login(member);
    }

}

6、修改com.laijiamei.member包下的MemberOsApplication.java文件

package com.laijiamei.member;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cache.annotation.EnableCaching;

@SpringBootApplication
@EnableCaching
@MapperScan("com.laijiamei.member.dao")
public class MemberOsApplication {

    public static void main(String[] args) {
        SpringApplication.run(MemberOsApplication.class, args);
    }

}

7、在resources目录下创建一个mapping目录，在mapping目录下创建一个MemberDao.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.laijiamei.member.dao.MemberDao">
    
    <select id="getMemberById" resultType="com.laijiamei.member.entity.Member" parameterType="java.lang.Long">
        select id, name, account, password
        from t_b_member
        where id = #{id}
    </select>

    <select id="login" resultType="com.laijiamei.member.entity.Member" parameterType="com.laijiamei.member.entity.Member">
        select account, password
        from t_b_member
        where account = #{account} and password = #{password}
    </select>
    
</mapper>

8、application.properties文件

server.port=8080

spring.application.name=member-os

#数据库配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mydatabase?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#mybatis配置
mybatis.mapper-locations=classpath:mapping/*.xml
mybatis.type-aliases-package=com.laijiamei.member.entity
mybatis.configuration.mapUnderscoreToCamelCase=true

9、运行com.laijiamei.member包下的MemberOsApplication.java，运行成功在浏览器输入路径 http://http://localhost:8080/member/getMemberById?id=1

附上源码：
https://github.com/Boom-Mei/member