7天毕设速成4： springboot后端搭建

一。创建springboot项目

通过idea来搭建

好了，现在我们来说一下，如何在Idea上直接搭建SpringBoot项目：

1. 在左侧列表选择Spring Initializer，代表这是一个Spring Boot项目

2. 项目来源地址，因为spring是国外的服务器，所以我们通常使用阿里云的网站来搭建会快一点。

3. 点击设置，更改URL为：https://start.aliyun.com/

4.创建项目，等maven依赖加载完成

5.更改application.properties配置

#下面这些内容是为了让MyBatis映射
#指定Mybatis的Mapper文件
mybatis.mapper-locations=classpath:mappers/*xml
#指定Mybatis的实体目录
mybatis.type-aliases-package=com.my.demo.myspringbootdemo.mybatis.entity

# 应用服务 WEB 访问端口
server.port=9999
spring.servlet.multipart.enabled= true
spring.servlet.multipart.max-file-size= 20MB
spring.servlet.multipart.max-request-size= 20MB
spring.datasource.url= jdbc:mysql://127.0.0.1:3306/ehealthdist?useUnicode=true&useSSL=false&characterEncoding=gbk&serverTimezone=Asia/Shanghai
#    spring.datasource.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.driver-class-name= com.mysql.cj.jdbc.Driver
spring.datasource.username= root
spring.datasource.password= root

6.创建数据库ehealthdist

创建表sys_user

CREATE TABLE `sys_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登陆密码',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;


INSERT INTO `sys_user` VALUES (1, 'admin', 'admin123', '超级管理员', '555555', '女');
INSERT INTO `sys_user` VALUES (5, 'test2221', '222222', 'test1222', '11111111112', '男');

SET FOREIGN_KEY_CHECKS = 1;

7.启动项目，如下就代表项目启动成功了

二。写一个登录接口

2.1.创建mvc包

依次创建包controller->service->serviceImpl->mapper

2.2.创建mvc类

依次创建   SysUserController->SysUserService->SysUserServiceImpl->SysUserMapper->SysUserMapper.xml ->SysUser

2.3.写登录接口

附代码

package com.my.demo.myspringbootdemo.controller;


import com.my.demo.myspringbootdemo.entity.SysUser;
import com.my.demo.myspringbootdemo.service.SysUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.HashMap;
import java.util.Map;

@RestController
@RequestMapping("/api/bishe/sysuser")
public class SysUserController {
    @Autowired
    private SysUserService sysUserService;

    @PostMapping("/login")
    public Map login(@RequestBody SysUser user){
        String username=user.getUsername();
        String password=user.getPassword();

        SysUser sysUser=sysUserService.login(username,password);

        Map map=new HashMap<>();
        if(sysUser==null){
            map.put("code",100);
            map.put("msg","查询失败，用户不存在或密码错误");
        }else{
            sysUser.setPassword(null);
            map.put("code",200);
            map.put("msg","查询成功");
            map.put("data",sysUser);
        }
        return map;
    }
}

package com.my.demo.myspringbootdemo.service;


import com.my.demo.myspringbootdemo.entity.SysUser;


public interface SysUserService {
    SysUser login( String username,String password);
}

package com.my.demo.myspringbootdemo.serviceImpl;

import com.my.demo.myspringbootdemo.entity.SysUser;
import com.my.demo.myspringbootdemo.mapper.SysUserMapper;
import com.my.demo.myspringbootdemo.service.SysUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service("sysUserService")
public class SysUserServiceImpl implements SysUserService {

    @Autowired
    private SysUserMapper sysUserMapper;
    @Override
    public SysUser login(String username, String password) {
        return sysUserMapper.login(username,password);
    }
}

package com.my.demo.myspringbootdemo.mapper;

import com.my.demo.myspringbootdemo.entity.SysUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SysUserMapper {
    SysUser login(@Param("username") String username, @Param("password")String password);
    
}

<?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.my.demo.myspringbootdemo.mapper.SysUserMapper">

    <select id="login" parameterType="java.lang.String" resultType="com.my.demo.myspringbootdemo.entity.SysUser">
        select
            id,
            username,
            password,
            name,
            phone,
            sex
        from  sys_user where  username=#{username} and password=#{password} limit 0,1
    </select>
</mapper>

package com.my.demo.myspringbootdemo.entity;


public class SysUser {
    private Integer id;
    /**
     * 昵称
     */
    private String username;
    /**
     * 登陆密码
     */
    private String password;
    /**
     * 用户姓名/医护人员姓名
     */
    private String name;
    /**
     * 电话
     */
    private String phone;
    /**
     *
     */
    private String sex;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

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

    public String getName() {
        return name;
    }

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

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }
}

重新启动项目

2.4.apipost测试接口

至此，springboot+mybatis+mysql+mvc项目搭建完成。