mvc:
throw-exception-if-no-handler-found: true
web:
resources:
add-mappings: false
SpringbootServerApplication:
package com.keafmd;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan(“com.keafmd.mapper”)
public class SpringbootServerApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootServerApplication.class, args);
}
}
1、在 UserMapper代码页大括号内,按下Alt+Insert,选择Test
2、Ok
3、自动生成了测试类
4、编写测试代码
UserMapperTest :
package com.keafmd.mapper;
import com.keafmd.SpringbootServerApplication;
import com.keafmd.entity.User;
import com.keafmd.service.UserService;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import javax.annotation.Resource;
import java.util.List;
import static org.junit.jupiter.api.Assertions.*;
@SpringBootTest(classes = SpringbootServerApplication.class)
class UserMapperTest {
@Resource
UserService userService;
@Test
public void test1(){
List userList = userService.list();
for (User user : userList) {
System.out.println(user);
}
}
}
5、测试结果
至此,后端和数据库连接没问题。
8、编写后端的工具类代码(封装结果集、日期处理、解决跨域请求)
1、CommonResult
package com.keafmd.common;
import lombok.Getter;
/**
-
Keafmd
-
@ClassName: CommonResult
-
@Description: 封装结果集
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@Getter
public class CommonResult {
private Integer code;
private String message;
private Object obj;
private CommonResult(Integer code, String message, Object obj) {
this.code = code;
this.message = message;
this.obj = obj;
}
public static CommonResult nohandler() {
return new CommonResult(ResultCode.NOHANDLER.getCode(), ResultCode.NOHANDLER.getMessage(),null);
}
public static CommonResult success(Object data) {
return new CommonResult(ResultCode.SUCCESS.getCode(), ResultCode.SUCCESS.getMessage(),data);
}
public static CommonResult failed() {
return new CommonResult(ResultCode.FAILED.getCode(), ResultCode.FAILED.getMessage(),null);
}
public static CommonResult failed(String message) {
return new CommonResult(ResultCode.FAILED.getCode(),message,null);
}
public static CommonResult notoken() {
return new CommonResult(ResultCode.NOTOKEN.getCode(), ResultCode.NOTOKEN.getMessage(),null);
}
public static CommonResult nopremiss() {
return new CommonResult(ResultCode.NOPERMISS.getCode(), ResultCode.NOPERMISS.getMessage(),null);
}
}
2、DateConverter
package com.keafmd.common;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.convert.converter.Converter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.regex.Pattern;
/**
-
Keafmd
-
@ClassName: DateConverter
-
@Description: 日期处理
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@Configuration
public class DateConverter implements Converter<String, Date> {
public DateConverter() {
// System.out.println(“初始化…”);
}
static List sdfs = new ArrayList();
static {
sdfs.add(new SimpleDateFormat(“yyyy/MM/dd HH:mm:ss”));
sdfs.add(new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”));
sdfs.add(new SimpleDateFormat(“yyyy-MM-dd”));
sdfs.add(new SimpleDateFormat(“yyyy/MM/dd”));
}
@Override
public Date convert(String s) {
SimpleDateFormat sdf = null;
if (Pattern.matches(“^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$”, s)) {
sdf = sdfs.get(1);
}
else if (Pattern.matches(“^\d{4}/\d{2}/\d{2} \d{2}:\d{2}:\d{2}$”, s)){
sdf = sdfs.get(0);
}
else if (Pattern.matches(“^\d{4}/\d{2}/\d{2}$”, s)){
sdf = sdfs.get(3);
}
else if (Pattern.matches(“^\d{4}-\d{2}/-\d{2}}$”, s)){
sdf = sdfs.get(2);
}
Date date = null;
try {
date = sdf.parse(s);
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}
}
3、LocalDateTimeConverter
package com.keafmd.common;
import org.springframework.core.convert.converter.Converter;
import org.springframework.stereotype.Component;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
/**
-
Keafmd
-
@ClassName: LocalDateTimeConverter
-
@Description: 日期处理
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@Component
public class LocalDateTimeConverter implements Converter<String, LocalDateTime> {
//2021-04-29%2001:02:03
@Override
public LocalDateTime convert(String s) {
return LocalDateTime.parse(s, DateTimeFormatter.ofPattern(“yyyy-MM-dd HH:mm:ss”));
}
}
4、ResultCode
package com.keafmd.common;
import lombok.Getter;
/**
-
Keafmd
-
@ClassName: ResultCode
-
@Description: 结果代码
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@Getter
public enum ResultCode {
NOHANDLER(404,“请求地址错误”),
SUCCESS(200,“操作成功”),
FAILED(500,“操作失败”),
NOTOKEN(401,“未登录或登录已超时”),
NOPERMISS(403,“无操作权限”),
;
private Integer code;
private String message;
ResultCode(Integer code, String message) {
this.code = code;
this.message = message;
}
}
5、AppConfig
package com.keafmd.config;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.dialects.MySqlDialect;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import com.fasterxml.jackson.annotation.JsonInclude;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;
import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule;
import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateSerializer;
import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateTimeSerializer;
import com.keafmd.common.DateConverter;
import com.keafmd.common.LocalDateTimeConverter;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.format.FormatterRegistry;
import org.springframework.http.converter.HttpMessageConverter;
import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter;
import org.springframework.web.cors.CorsConfiguration;
import org.springframework.web.cors.UrlBasedCorsConfigurationSource;
import org.springframework.web.filter.CorsFilter;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.List;
/**
-
Keafmd
-
@ClassName: AppConfig
-
@Description: 解决跨域请求
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@Configuration
public class AppConfig extends WebMvcConfigurationSupport {
/**
-
分页插件
-
@return
*/
@Bean
public PaginationInterceptor paginationInterceptor() {
PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
paginationInterceptor.setDialect(new MySqlDialect());
paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
return paginationInterceptor;
}
@Bean
FilterRegistrationBean cors(){
FilterRegistrationBean registrationBean = new FilterRegistrationBean();
CorsConfiguration config = new CorsConfiguration();
config.setAllowCredentials(true);
config.addAllowedOrigin(“http://127.0.0.1:81”);
config.addAllowedHeader(“*”);
config.addAllowedMethod(“*”);
UrlBasedCorsConfigurationSource source = new UrlBasedCorsConfigurationSource();
source.registerCorsConfiguration(“/**”, config);
CorsFilter filter = new CorsFilter(source);
registrationBean.setFilter(filter);
registrationBean.addUrlPatterns(“/*”);
return registrationBean;
}
/**
-
curl http://127.0.0.1/user/getById?id=31
-
@param converters
*/
@Override
protected void configureMessageConverters(List<HttpMessageConverter<?>> converters) {
ObjectMapper objectMapper = new ObjectMapper();
objectMapper.disable(SerializationFeature.WRITE_DATES_AS_TIMESTAMPS);
objectMapper.disable(DeserializationFeature.ADJUST_DATES_TO_CONTEXT_TIME_ZONE);
// objectMapper.enable(SerializationFeature.WRITE_ENUMS_USING_TO_STRING);
objectMapper.setSerializationInclusion(JsonInclude.Include.NON_NULL); //忽略 null 字段
JavaTimeModule javaTimeModule = new JavaTimeModule();
javaTimeModule.addSerializer(LocalDateTime.class, new LocalDateTimeSerializer(DateTimeFormatter.ofPattern(“yyyy-MM-dd HH:mm:ss”)));
javaTimeModule.addSerializer(LocalDate.class, new LocalDateSerializer(DateTimeFormatter.ofPattern(“yyyy-MM-dd”)));
// javaTimeModule.addDeserializer(LocalDateTime.class, new LocalDateTimeDeserializer(DateTimeFormatter.ofPattern(“yyyy-MM-dd HH:mm:ss”)));
// javaTimeModule.addDeserializer(LocalDate.class, new LocalDateDeserializer(DateTimeFormatter.ofPattern(“yyyy-MM-dd”)));
objectMapper.registerModule(javaTimeModule);
converters.add(new MappingJackson2HttpMessageConverter(objectMapper));
}
@Override
protected void addFormatters(FormatterRegistry registry) {
super.addFormatters(registry);
registry.addConverter(new DateConverter());
registry.addConverter(new LocalDateTimeConverter());
}
}
6、DefaultExceptionHandler
package com.keafmd.config;
import com.keafmd.common.CommonResult;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;
import org.springframework.web.servlet.NoHandlerFoundException;
import javax.servlet.http.HttpServletRequest;
/**
-
Keafmd
-
@ClassName: DefaultExceptionHandler
-
@Description:
-
@author: 牛哄哄的柯南
-
@Date: 2021-04-29 18:11
-
@Blog: https://keafmd.blog.csdn.net/
*/
@RestControllerAdvice
public class DefaultExceptionHandler {
@ExceptionHandler
public CommonResult exceptionHandler(HttpServletRequest request, Exception ex) {
ex.printStackTrace();
if(ex instanceof NoHandlerFoundException) {
return CommonResult.nohandler();
}
return CommonResult.failed(ex.getMessage());
}
}
1、在UserService接口中编写分页查询代码
package com.keafmd.service;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.keafmd.entity.User;
import com.baomidou.mybatisplus.extension.service.IService;
/**
-
-
服务类
-
@author 关注公众号:牛哄哄的柯南
-
@since 2021-04-29
*/
public interface UserService extends IService {
Page pageList(Page page, User user);
}
2、在UserServiceImpl实现类中实现分页查询和模糊查找
package com.keafmd.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.keafmd.entity.User;
import com.keafmd.mapper.UserMapper;
import com.keafmd.service.UserService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
/**
-
-
服务实现类
-
@author 关注公众号:牛哄哄的柯南
-
@since 2021-04-29
*/
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
@Override
public Page pageList(Page page, User user) {
if(page == null){
page = new Page();
}
QueryWrapper wrapper = new QueryWrapper();
if(user!=null && StringUtils.isNotEmpty(user.getUserName())){
//根据user_name字段模糊查找
wrapper.like(“user_name”,user.getUserName());
}
return super.page(page,wrapper);
}
}
3、在UserController中编写增删改查代码
package com.keafmd.controller;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.keafmd.common.CommonResult;
import com.keafmd.entity.User;
import com.keafmd.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.Arrays;
/**
-
-
前端控制器
-
@author 关注公众号:牛哄哄的柯南
-
@since 2021-04-29
*/
@RestController
@RequestMapping(“/user”)
public class UserController {
@Autowired
UserService userService;
/**
-
查找
-
@return
*/
@RequestMapping(“/list”)
CommonResult list(ModelMap modelMap, Page page, @ModelAttribute(“user”) User user) {
page = userService.pageList(page, user);
modelMap.addAttribute(“page”, page);
return CommonResult.success(page);
}
@RequestMapping(“/save”)
CommonResult save(User user){
return CommonResult.success(userService.saveOrUpdate(user));
}
/**
-
根据id查
-
@param id
-
@return
*/
@RequestMapping(“/getById”)
CommonResult getById(Integer id) {
return CommonResult.success(userService.getById(id));
}
/**
-
删除,逻辑删除
-
@param id
-
@return
*/
@RequestMapping(“/del”)
CommonResult del(Integer id ) {
User user = userService.getById(id);
user.setUserState(“0”);
return CommonResult.success(userService.updateById(user));
}
/**
-
批量删除
-
@param id
-
@return
*/
@RequestMapping(“/delByIds”)
CommonResult delByIds(Integer[] id) {
/*for (Integer integer : id) {
System.out.println(integer);
}*/
return CommonResult.success(userService.removeByIds(Arrays.asList(id)));
}
}
==============================================================
SpringBoot+MyBatisPlus+Vue 前后端分离项目快速搭建【前端篇】【快速生成后端代码、封装结果集、增删改查、模糊查找】【毕设基础框架】