<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Varose的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Varose</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Varose]]></copyright><item><title><![CDATA[控制台输入获取屏幕坐标]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/129752011</link><guid>https://blog.youkuaiyun.com/Varose/article/details/129752011</guid><author>Varose</author><pubDate>Fri, 24 Mar 2023 15:36:42 +0800</pubDate><description><![CDATA[ui自动化获取屏幕坐标，将代码在控制台执行]]></description><category></category></item><item><title><![CDATA[python解析图片验证码并登录]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/128548063</link><guid>https://blog.youkuaiyun.com/Varose/article/details/128548063</guid><author>Varose</author><pubDate>Wed, 04 Jan 2023 14:56:49 +0800</pubDate><description><![CDATA[python解析登录图片验证码 ，适合字母和数字验证码]]></description><category></category></item><item><title><![CDATA[httprunner执行报错：ImportError: cannot import name ‘soft_unicode‘ from ‘markupsafe‘]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/123135657</link><guid>https://blog.youkuaiyun.com/Varose/article/details/123135657</guid><author>Varose</author><pubDate>Fri, 25 Feb 2022 16:27:23 +0800</pubDate><description><![CDATA[可能是Jinja2版本的问题

1、在命令行输入pip list，查看Jinja2版本

2、卸载这个包：pip uninstall Jinja2

3、到https://www.lfd.uci.edu/~gohlke/pythonlibs/#jinja2

找到Jinja2，选择其他版本安装，使用3.0.3正常了，



4、下载.whl文件之后，执行命令


pip install xxx.whl


...]]></description><category></category></item><item><title><![CDATA[通过URL触发Jenkins构建]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/117568709</link><guid>https://blog.youkuaiyun.com/Varose/article/details/117568709</guid><author>Varose</author><pubDate>Fri, 04 Jun 2021 17:43:56 +0800</pubDate><description><![CDATA[http://test:116b5c298e4702d1895cab43c636e33a0e@jenkins-master.com/job/jobName/build?token=modeling-ui-auto

https://humanwhocodes.com/blog/2015/10/triggering-jenkins-builds-by-url/
]]></description><category></category></item><item><title><![CDATA[读取excel数据批量插入数据库]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/109455768</link><guid>https://blog.youkuaiyun.com/Varose/article/details/109455768</guid><author>Varose</author><pubDate>Mon, 02 Nov 2020 19:43:27 +0800</pubDate><description><![CDATA[package com;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import org.apache.poi.POIXMLDocument;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.]]></description><category></category></item><item><title><![CDATA[sql转换为json对象和数组]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/109352712</link><guid>https://blog.youkuaiyun.com/Varose/article/details/109352712</guid><author>Varose</author><pubDate>Thu, 29 Oct 2020 10:15:39 +0800</pubDate><description><![CDATA[select v.patient_name,json_object("name",d.item_name,"code",d.item_code) from op_advice_master v join op_advice_detail d on d.advice_id=v.id


SELECT org_id,org_name,dept_name,doctor_id,doctor_name,json_array(group_concat(json_object("visitNo",visit_no,"c.]]></description><category></category></item><item><title><![CDATA[testng-pom配置，可以直接maven打成可执行jar包]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/109215310</link><guid>https://blog.youkuaiyun.com/Varose/article/details/109215310</guid><author>Varose</author><pubDate>Thu, 22 Oct 2020 09:35:18 +0800</pubDate><description><![CDATA[&lt;project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"&gt;

  &lt;modelVersion&gt;4.0.0&lt;/modelVersi.]]></description><category></category></item><item><title><![CDATA[接口解析图片验证码]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/109214835</link><guid>https://blog.youkuaiyun.com/Varose/article/details/109214835</guid><author>Varose</author><pubDate>Thu, 22 Oct 2020 09:33:32 +0800</pubDate><description><![CDATA[1、登录有图片验证码时，使用tesseract-ocr解析图片





2、安装

windows：本地调用，先安装tesseract-ocr包


linux
执行yum install icu 52.1 libicu-devel pango 1.22.0 libgnomeui-devel libtiff-devel libjpeg-devel libpng-devel -y
	安装leptonica-1.78.0.tar.gz：1、cd leptonica-1.78.0  2、 ./au...]]></description><category></category></item><item><title><![CDATA[本地生成git公钥]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/105800576</link><guid>https://blog.youkuaiyun.com/Varose/article/details/105800576</guid><author>Varose</author><pubDate>Mon, 27 Apr 2020 21:53:21 +0800</pubDate><description><![CDATA[1、打开git bash，输入ssh-keygen -t rsa -C "youremail@sample.com"，一直enter



2、将公钥（id_rsa.pub）的内容复制到gitlab的ssh里面



3、打开git bash然后输入如下命令：

git config--global user.name“xxxx”

git config--global user.em...]]></description><category></category></item><item><title><![CDATA[JMeter 修改字体大小]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/105668218</link><guid>https://blog.youkuaiyun.com/Varose/article/details/105668218</guid><author>Varose</author><pubDate>Tue, 21 Apr 2020 21:31:11 +0800</pubDate><description><![CDATA[环境：jmeter3.3，win10

1、修改 jmeter.properties
修改 bin 目录下的 jmeter.properties ，设置 jsyntaxtextarea.font.size=25。

此方法是针对界面右侧的 Body Data 的字体。

2、修改 jmeter.hidpi
修改 bin 目录下的 jmeter.properties，针对其中的 jmeter.hid...]]></description><category></category></item><item><title><![CDATA[jmeter获取请求参数数据]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/103925774</link><guid>https://blog.youkuaiyun.com/Varose/article/details/103925774</guid><author>Varose</author><pubDate>Fri, 10 Jan 2020 15:45:50 +0800</pubDate><description><![CDATA[1、jmeter获取请求参数，参数字段和参数值


import org.apache.jmeter.config.Arguments;
import java.util.Map.Entry;

Arguments args = sampler.getArguments();
Map map = args.getArgumentsAsMap();
log.info("==============:...]]></description><category></category></item><item><title><![CDATA[java blob类型和字符串转换]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/103726097</link><guid>https://blog.youkuaiyun.com/Varose/article/details/103726097</guid><author>Varose</author><pubDate>Fri, 27 Dec 2019 09:00:58 +0800</pubDate><description><![CDATA[package test;

import java.sql.Blob;
import java.sql.Clob;

import javax.sql.rowset.serial.SerialBlob;
import javax.sql.rowset.serial.SerialClob;

public class Hello {
    public static void main(Str...]]></description><category></category></item><item><title><![CDATA[linux-centos7-安装redis集群]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/99004866</link><guid>https://blog.youkuaiyun.com/Varose/article/details/99004866</guid><author>Varose</author><pubDate>Sat, 10 Aug 2019 01:02:34 +0800</pubDate><description><![CDATA[1、安装redis


//安装
$ wget http://download.redis.io/releases/redis-5.0.5.tar.gz
$ tar xzf redis-5.0.5.tar.gz
$ cd redis-5.0.5
$ make

//启动服务
$ src/redis-server

//使用
$ src/redis-cli
redis&gt; set foo bar...]]></description><category></category></item><item><title><![CDATA[linux-centos7-局域网内访问虚拟机]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/98791852</link><guid>https://blog.youkuaiyun.com/Varose/article/details/98791852</guid><author>Varose</author><pubDate>Wed, 07 Aug 2019 22:36:40 +0800</pubDate><description><![CDATA[1、查看虚拟机的ip



2、vmware选择编辑-虚拟网络编辑器



3、更改NAT模式的网络设置



4、NAT设置，添加一个映射关系，把虚拟机的ip写上，要访问虚拟机内项目的端口写上，对外开放的主机端口可以任意写，不重复就行



5、局域网访问就使用本地的ip:主机端口


...]]></description><category></category></item><item><title><![CDATA[linux-centos7环境搭建-mysql安装]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/98266237</link><guid>https://blog.youkuaiyun.com/Varose/article/details/98266237</guid><author>Varose</author><pubDate>Sat, 03 Aug 2019 01:50:56 +0800</pubDate><description><![CDATA[1、下载mysql源安装包，安装mysql源，并检查是否成功


wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm
yum repolist enabled | grep "my...]]></description><category></category></item><item><title><![CDATA[linux-centos7环境搭建-git安装]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/98259777</link><guid>https://blog.youkuaiyun.com/Varose/article/details/98259777</guid><author>Varose</author><pubDate>Sat, 03 Aug 2019 00:16:58 +0800</pubDate><description><![CDATA[1、如果有旧版本，删除git


rpm -qa|grep git
rpm -e --nodeps git  或者  rpm -e git

2、下载依赖包


yum install gcc
yum install gcc-c++
yum -y install zlib-devel openssl-devel cpio expat-devel gettext-devel curl-devel p...]]></description><category></category></item><item><title><![CDATA[linux-centos7环境搭建-jenkins安装]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/98250858</link><guid>https://blog.youkuaiyun.com/Varose/article/details/98250858</guid><author>Varose</author><pubDate>Fri, 02 Aug 2019 22:49:35 +0800</pubDate><description><![CDATA[1、官网下载jenkins.war包

2、将jenkins.war放到tomcat下的webapps目录下，启动tomcat，访问地址：http://192.168.6.128:8088/jenkins/

3、第一次打开要输入密码，密码保存在/root/.jenkins/secrets/initialAdminPassword路径下

4、进入jenkins中，全局安全配置勾选允许用户注册

...]]></description><category></category></item><item><title><![CDATA[linux-centos7环境搭建-tomcat8]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/98199350</link><guid>https://blog.youkuaiyun.com/Varose/article/details/98199350</guid><author>Varose</author><pubDate>Fri, 02 Aug 2019 14:34:00 +0800</pubDate><description><![CDATA[1、直接使用xshell下载，wegethttp://mirror.bit.edu.cn/apache/tomcat/tomcat-8/v8.5.43/bin/apache-tomcat-8.5.43.tar.gz，或者先下载到本地，通过xftp传到linux

xshell&amp;xftp：下载地址
	如果weget没有安装：yum -y install wget


2、进入tomcat中...]]></description><category></category></item><item><title><![CDATA[jmeter导出]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/95986516</link><guid>https://blog.youkuaiyun.com/Varose/article/details/95986516</guid><author>Varose</author><pubDate>Mon, 15 Jul 2019 16:57:31 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[jmeter线程组间传递cookie]]></title><link>https://blog.youkuaiyun.com/Varose/article/details/95984417</link><guid>https://blog.youkuaiyun.com/Varose/article/details/95984417</guid><author>Varose</author><pubDate>Mon, 15 Jul 2019 16:49:49 +0800</pubDate><description><![CDATA[1、登录接口下面新建cookie取值正则和BeanShell PostProcessor设置全局变量：

登录请求返回数据和获取cookie的正则：



BeanShell PostProcessor:



2、在测试计划下新建cookie管理器




...]]></description><category></category></item></channel></rss>