<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[v_ccaili的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/v_ccaili</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; v_ccaili]]></copyright><item><title><![CDATA[利用openpyxl获取excel中的数据]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/132525771</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/132525771</guid><author>v_ccaili</author><pubDate>Sun, 27 Aug 2023 17:58:57 +0800</pubDate><description><![CDATA[【代码】利用openpyxl获取excel中的数据。]]></description><category></category></item><item><title><![CDATA[获取Yaml文件中的数据]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/129477315</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/129477315</guid><author>v_ccaili</author><pubDate>Sun, 12 Mar 2023 16:28:24 +0800</pubDate><description><![CDATA[【java】获取Yaml文件中的数据。]]></description><category></category></item><item><title><![CDATA[使用多线程实现异步任务]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/125749606</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/125749606</guid><author>v_ccaili</author><pubDate>Tue, 12 Jul 2022 19:20:38 +0800</pubDate><description><![CDATA[多线程实现异步任务]]></description><category></category></item><item><title><![CDATA[sql中的时间处理]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/122245456</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/122245456</guid><author>v_ccaili</author><pubDate>Thu, 30 Dec 2021 22:18:58 +0800</pubDate><description><![CDATA[SQL语句
1、str_to_date(str,format)
str_to_date函数将str转化为日期型的数据，format表示转化后的格式
常用：
%Y  年
%m  月
%d  日
%H  小时
%i  分
%s  秒
select visit_time from time_count where id = 1

select str_to_date(visit_time ,’%Y%m%d %H:%i:%s’) from time_count where id=1

2、DATE_FORMAT(d]]></description><category></category></item><item><title><![CDATA[Moco的简单使用]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/121089012</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/121089012</guid><author>v_ccaili</author><pubDate>Mon, 01 Nov 2021 22:16:14 +0800</pubDate><description><![CDATA[1、从下方的地址中，下载moco的jar包
https://github.com/dreamhead/moco

2、新建一个项目（随便建一个项目就可以）
3、在项目中新建一个json文件，在文件中写请求的路径与响应的数据，格式如下：
[
  {
    "description": "mock例1",
    "request": {
      "uri": "/demo"
    },
    "response": {
      "headers":{
        "Content-Type"]]></description><category></category></item><item><title><![CDATA[java使用POI读取和写入excel内容]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/119154125</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/119154125</guid><author>v_ccaili</author><pubDate>Tue, 27 Jul 2021 21:48:04 +0800</pubDate><description><![CDATA[1.读取excel中的内容
    public void excelRead() throws IOException {

        String filePath = "E:\\case.xlsx";
        //获取excel文件的文件输入流
        FileInputStream inFiele = new FileInputStream(filePath);
        //获取excel的WorkBook
        Workbook workbook = Wor]]></description><category></category></item><item><title><![CDATA[python中xlwt、xlrd、xlutils对excel的读写操作]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/119119231</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/119119231</guid><author>v_ccaili</author><pubDate>Mon, 26 Jul 2021 22:41:48 +0800</pubDate><description><![CDATA[1.使用xlwt新建一个excel文件并向里面写入一些内容
import xlwt

def write_excel():
    #新建一个工作簿
    writeBook = xlwt.Workbook(encoding="utf-8")
    #在新建的工作簿中添加一个sheet
    writeSheet = writeBook.add_sheet("内容")
    #在新建的sheet中的第1行第1列的单元格中输入1
    writeSheet.write(0, 0, 1)
    #在]]></description><category></category></item><item><title><![CDATA[Python读取yaml文件中的数据]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/119117625</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/119117625</guid><author>v_ccaili</author><pubDate>Mon, 26 Jul 2021 21:03:21 +0800</pubDate><description><![CDATA[1.下载PyYAML插件
2.创建一个yaml文件并乡里面写一些数据

-
  a: 2
  b: 3


3.读取yaml文件中的数据
import yaml

class yamlRead:

    def __init__(self,yaml_file):
        self.yaml_file = yaml_file

    def readYaml(self):
        with open(self.yaml_file,encoding="utf-8") as f:
      ]]></description><category></category></item><item><title><![CDATA[Jmeter集群搭建]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/115918832</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/115918832</guid><author>v_ccaili</author><pubDate>Tue, 20 Apr 2021 21:39:43 +0800</pubDate><description><![CDATA[1.Master（主机）设置

（1）在Jmeter的安装目录的bin文件夹中找到jmeter.properties文件



（2）打开jmeter.properties文件，先添加slave（从机）的ip地址，添加多个时每个ip用英文逗号隔开



添加后启动jmeter，在运行—&gt;远程启动中就能看见添加的从机了



（3）将server_port前的"#"去掉



（4）将server.rmi.ssl.disable前的"#"去掉，并将disable改为true



（5）将mode=St]]></description><category></category></item><item><title><![CDATA[EasyExcel实现上传和下载Excel数据]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/107475837</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/107475837</guid><author>v_ccaili</author><pubDate>Thu, 30 Jul 2020 00:19:00 +0800</pubDate><description><![CDATA[1.在POM中添加EasyExcel的依赖
		&lt;dependency&gt;
			&lt;groupId&gt;com.alibaba&lt;/groupId&gt;
			&lt;artifactId&gt;easyexcel&lt;/artifactId&gt;
			&lt;version&gt;2.2.6&lt;/version&gt;
		&lt;/dependency&gt;


2.根据Excel中的数据，写一个对应的VO类
import java.util.Date;

impor]]></description><category></category></item><item><title><![CDATA[文件上传功能简单实现]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/107307153</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/107307153</guid><author>v_ccaili</author><pubDate>Sun, 12 Jul 2020 22:57:13 +0800</pubDate><description><![CDATA[1.前端页面
&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;meta charset="UTF-8"&gt;
&lt;title&gt;文件上传测试&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;form action="/li/fileUpload" method="POST" enctype="multipart/form-data"&gt;
&lt;input type="file" name="fi]]></description><category></category></item><item><title><![CDATA[图片验证码的生成与验证]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/107192292</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/107192292</guid><author>v_ccaili</author><pubDate>Tue, 07 Jul 2020 23:49:48 +0800</pubDate><description><![CDATA[#1.先创建一个生成图片验证码的工具类
package com.cv.mall.entity;

import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;

import javax.imageio.ImageIO;
import javax.se]]></description><category></category></item><item><title><![CDATA[项目本地运行正常，但发布到服务器后，部分页面取无法访问]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/107137208</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/107137208</guid><author>v_ccaili</author><pubDate>Sun, 05 Jul 2020 12:14:27 +0800</pubDate><description><![CDATA[原因1：在Controller中返回页面地址前面多了一个"/"

解决办法：将返回页面最前面的"/"去掉
//商城登录页面
	@GetMapping("/user/login")
	public String userLogin() {
		return "mall/login";
	}
	
	//商城注册页面
	@RequestMapping("/user/register")
	public String userRegister() {
		return "mall/register";
	}

原因]]></description><category></category></item><item><title><![CDATA[利用Ajax在页面加载数据]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/106774424</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/106774424</guid><author>v_ccaili</author><pubDate>Tue, 16 Jun 2020 00:16:36 +0800</pubDate><description><![CDATA[1.启动服务器后，在浏览器打开页面地址，显示如下

打开页面后在加载数据时先显示"数据加载中"
前端页面代码：
&lt;tbody id="activityInfo"&gt;
		&lt;tr&gt;&lt;td&gt;数据加载中&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;

controller代码：
@RequestMapping("showActivity")
public String showActivity() {
	return "activity";
}

2.]]></description><category></category></item><item><title><![CDATA[将表格中的数据传到模态框中]]></title><link>https://blog.youkuaiyun.com/v_ccaili/article/details/106653321</link><guid>https://blog.youkuaiyun.com/v_ccaili/article/details/106653321</guid><author>v_ccaili</author><pubDate>Tue, 09 Jun 2020 23:56:36 +0800</pubDate><description><![CDATA[1.表格中的数据如下图所示:

2.在更新按钮上绑定一个点击事件,将按钮当做参数(this)传到方法中

        		&lt;td&gt;
        			&lt;button type="button" class="btn btn-primary" data-toggle="modal" 
        				data-target=".bs-example-modal-lg" onclick="showDialog(this)"
        				&gt;更新&lt;/butt]]></description><category></category></item></channel></rss>