时来时去时不返

前言现在需要向数据库中某张表中的某个字段中，插入的值为SQL语句，但是要保证插入SQL语句的正确性，而且还需要进行格式化，就像navicat中的美化SQL语句一样。格式化druid包中提供了SQLUtils用来格式化SQL语句，直接使用即可依赖<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version&

1.service实现类代码courseTypes = baseMapper.selectForTreeData();2.mapper层//第1条：根据pid=0或pid=xxx查询出第1级课程分类列表 List<CourseType> selectForTreeData();3.mapper.xml代码<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.or

1.redis工具类编写package cn.x.x.config;import com.alibaba.fastjson.JSONObject;import org.apache.commons.lang3.StringUtils;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.data.redis.core.StringRedisTemplate;import

自定义异常系统中的异常可以分为我们能预知的异常和未知的系统异常，对于我们能预知的异常如空值判断，用户名错误，密码错误等异常我们需要返回客户端，对于系统内部异常如SQL语法错误，参数格式转换错误等需要统一包装成友好的提示后再返回客户端，否则用户也看不懂系统内部的异常。2.方案是可以自定义异常来封装我们能够预知的异常，和系统未知的异常做一个区分，3.自定义异常类package cn.xx.th.config;import lombok.Data;@Datapublic class Glob.

HELP.mdtarget/!.mvn/wrapper/maven-wrapper.jar!/src/main/!/src/test/STS.apt_generated.classpath.factorypath.project.settings.springBeans.sts4-cacheIntelliJ IDEA.idea*.iws*.iml*.iprNetBeans/nbproject/private//nbbuild//dist//nbdist//.nb

package cn.x.org;import cn.x.org.domain.Department;import cn.x.org.mapper.DepartmentMapper;import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;import lombok.extern.slf4j.Slf4j;import org.junit.Test;import org.junit.runner.RunWith;imp

package cn.xx.org;import cn.itsource.org.domain.Department;import cn.itsource.org.mapper.DepartmentMapper;import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;import com.baomidou.mybatisplus.extension.plugins.pagination.Page;import lomb

1.查询总条数和数据集合package cn.xx.basic.utils;import lombok.Data;import java.util.List;@Datapublic class PageResult<T> { private Long total; private List<T> data; public PageResult(Long total, List<T> data) { this.tota

package cn.xx;import org.junit.runner.RunWith;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;@SpringBootTest@RunWith(SpringRunner.class)public class BaseTest {}

package cn.xx;import org.mybatis.spring.annotation.MapperScan;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication@MapperScan("你的mapper路径")//格式如：cn.xx.*.mapperp

中国网建短信验证码接口方法package cn.xxx.basic.utils;import org.apache.commons.httpclient.Header;import org.apache.commons.httpclient.HttpClient;import org.apache.commons.httpclient.NameValuePair;import org.apache.commons.httpclient.methods.PostMethod;public cla

redis工具类package cn.xxx.basic.utils;import redis.clients.jedis.Jedis;import redis.clients.jedis.JedisPool;import redis.clients.jedis.JedisPoolConfig;import java.io.IOException;import java.util.Properties;/** * 获取连接池对象 */public enum RedisUtils {

分页参数接收设置package cn.xxx.basic.utils;import lombok.Data;import java.util.List;@Datapublic class PageResult<T> { private Long total; private List<T> data; public PageResult(Long total, List<T> data) { this.total =

MD5加密工具package cn.xx.basic.utils;import java.security.MessageDigest;import java.security.NoSuchAlgorithmException;import java.util.UUID;public class MD5Utils { /** * 加密 * @param context */ public static String encrypByMd5(St

java后台发送get请求工具类package cn.xxx.basic.utils;import org.apache.commons.httpclient.HttpClient;import org.apache.commons.httpclient.methods.GetMethod;import org.apache.commons.httpclient.params.HttpMethodParams;import java.io.IOException;/** * 使用http

1.文件上传controllerpackage cn.xx.basic.controller;import cn.xx.basic.utils.AjaxResult;import cn.xxx.basic.utils.FastDfsApiOpr;import org.springframework.web.bind.annotation.PostMapping;import org.springframework.web.bind.annotation.RequestMapping;impor

package cn.xxx.basic.config;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import springfox.documentation.builders.ApiInfoBuilder;import springfox.documentation.builders.PathSelectors;im

后端解决跨域问题工具类import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.web.cors.CorsConfiguration;import org.springframework.web.cors.UrlBasedCorsConfigurationSource;import

package cn.itsource.basic.utils;import lombok.Data;@Datapublic class AjaxResult { private Boolean success = true; private String message = "操作成功"; private Object resultObj; public boolean isSuccess() { return success; }