Java后端
文章平均质量分 67
98年撸铁的老阿姨
这个作者很懒,什么都没留下…
展开
-
excel-poi读取excel
1. 代码前准备在项目poi.xml中导入excel-poi相关的依赖 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.原创 2022-01-10 15:58:28 · 719 阅读 · 0 评论 -
Mybatis的关联映射(1-1,1-n,n-n)
Mybatis的关联映射(1-1,1-n,n-n)一对一一对多多对多一张表的一对多(自查询)一对一表:address 与 students1.嵌套结果:一条sql语句,在select后b把两张表中要查询出来的所有的列名写出来,一个列名对应一个属性值(两个对象中的属性),最后一一映射起来。association标签有两个属性、有子标签(从以下代码中可以看出,select 后的...原创 2019-12-21 20:00:21 · 309 阅读 · 0 评论 -
Mybatis面试题目
${s}与#{s}的区别1.${s}是Properties文件中的变量占位符,属于静态文本替换,比如driver会被静态替换为com.mysql.jdbc.Driver。eg:id={driver}会被静态替换为com.mysql.jdbc.Driver。eg:id=driver会被静态替换为com.mysql.jdbc.Driver。eg:id={1 Or 1=1}(sql注入问题)。即传入的...原创 2019-12-22 09:43:06 · 85 阅读 · 0 评论 -
Springboot发送定时任务(新建、删除)
使用情景:每天下午两点给用户发送一条短信代码@Service@Slf4jpublic class BrokerAuthTaskServiceImpl implements BrokerAuthTaskService { @Autowired SmsRecordMapper smsRecordMapper; @Autowired private ThreadPoolTaskScheduler threadPoolTaskScheduler = new ThreadPoolTa.原创 2020-07-28 16:39:59 · 163 阅读 · 0 评论 -
Mybatis的like、foreach遍历、时间范围
<select id="query" parameterType="cn.enn.electric.entity.UserCusVO" resultMap="BaseResultMap"> select u.id broker_id ,u.name brokerName,u.mobile brokerPhone, c.name cusName,c.province province,c.city city,c.area area,c.unit unit,c原创 2020-07-28 16:50:53 · 978 阅读 · 0 评论 -
ThreadLocal保存当前用户
@Datapublic class BrokerInfo { private static final ThreadLocal<UserBroker> userContext = new ThreadLocal<UserBroker>(); /** * 存储用户信息 * @param userBroker */ public static void addUserContext(UserBroker userBroker)原创 2020-07-28 16:55:05 · 391 阅读 · 0 评论 -
自定义Http请求(get、post)
import com.alibaba.fastjson.JSON;import org.apache.http.HttpEntity;import org.apache.http.NameValuePair;import org.apache.http.client.config.RequestConfig;import org.apache.http.client.entity.UrlEncodedFormEntity;import org.apache.http.client.methods.原创 2020-07-29 10:35:43 · 997 阅读 · 1 评论 -
springboot+swagger
1.导入依赖<dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger2</artifactId> <version>2.7.0</version> </dependency> <dependency>原创 2020-07-29 16:34:15 · 81 阅读 · 0 评论 -
springboot+分页PageHelper
1.导入依赖<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.13</version> </dependency>2.使用@Override public ApiRes queryA原创 2020-07-29 16:53:22 · 70 阅读 · 0 评论 -
springboot 解决vue跨域问题
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 org.springfr原创 2020-07-29 17:45:10 · 198 阅读 · 0 评论 -
poi实现excel的导入和导出
import com.pro.telecom.bean.back.ChuZhangBack;import com.pro.telecom.bean.back.ChuZhangBack2;import com.pro.telecom.bean.entity.*;import com.pro.telecom.dao.*;import com.pro.telecom.util.CodeUtil;import org.apache.poi.hssf.usermodel.*;import org.apac原创 2020-08-07 14:04:04 · 108 阅读 · 0 评论 -
Json对象转java对象,json数组转list
import com.alibaba.fastjson.JSON;import org.json.JSONObject;public CustomerMessage getCustomerMessage (JSONObject json) throws ParseException { CustomerMessage message = new CustomerMessage(); message.setId(json.getLong("id")); m原创 2020-08-07 14:11:15 · 778 阅读 · 0 评论 -
@Value注解
在多模块项目中,在service中添加resources目录1.在controller下的resources的application.yml文件中添加spring:profiles:active: dev,dao-dev,service-devservice-dev指的是 service层下的resources目录下的application-service-dev.yml文件2.在service下的resources目录下可以添加application-service-dev.yml或者appl原创 2020-08-17 11:11:12 · 194 阅读 · 0 评论 -
RestTemplate模拟get、post请求
String url = "www.xxx.com";MultiValueMap<String, String> postParameters = new LinkedMultiValueMap<String, String>();postParameters.add("entName", elecUser.getCompanyName());postParameters.add("mobile", elecUser.getMobile());postParameters.a原创 2020-08-17 14:10:12 · 162 阅读 · 0 评论 -
json字符串转化成java对象
import com.alibaba.fastjson.JSONObject;public void getObject () throws NoSuchMethodException { JSONObject object1 = new JSONObject(); object1.put("openid","123"); object1.put("mobile","131313020"); object1.put("status","1原创 2020-08-17 15:50:43 · 372 阅读 · 0 评论 -
Java加入手机号的校验
/** * 校验手机号 * @param telephone * @return */ public static boolean isCellPhoneNo(String telephone) { if (telephone == null || telephone.trim().equals("")) { return false; } if (telephone.length...原创 2020-08-18 09:10:56 · 262 阅读 · 2 评论 -
Springboot常用的注解
1.@RequestBody :接收json格式的参数2.@RequestHeader :接收header里的参数3.@Value :接收application.yml里的参数原创 2020-08-18 15:20:04 · 76 阅读 · 0 评论 -
图片链接url转MultipartFile
import lombok.extern.slf4j.Slf4j;import org.apache.commons.fileupload.FileItem;import org.apache.commons.fileupload.FileItemFactory;import org.apache.commons.fileupload.disk.DiskFileItemFactory;import org.springframework.web.multipart.MultipartFile;im原创 2020-09-24 11:16:13 · 5207 阅读 · 7 评论 -
feign
1.导入相关jar包<dependency> <groupId>org.springframework.cloud</groupId> <artifactId>spring-cloud-starter-openfeign</artifactId> <version>2.2.1.RELEASE</version> </depende原创 2020-10-15 16:53:41 · 124 阅读 · 0 评论