<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lvxiaoting的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lvxiaoting</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lvxiaoting]]></copyright><item><title><![CDATA[连接数据库：ERROR: The server time zone value引发的错误（链接格式很重要）]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/82997847</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/82997847</guid><author>lvxiaoting</author><pubDate>Wed, 10 Oct 2018 15:38:04 +0800</pubDate><description><![CDATA[jmeter在访问mysql配置JDBC的时候有时候会出现java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents........的错误，具体错误如下：



经过查找资料，将参数

jdbc:mysql://192.168.23.102:3306/sxcassdb
...]]></description><category></category></item><item><title><![CDATA[禅道Bug管理工具环境搭建]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/82867372</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/82867372</guid><author>lvxiaoting</author><pubDate>Thu, 27 Sep 2018 15:00:27 +0800</pubDate><description><![CDATA[下载地址：http://sourceforge.net/projects/zentao/files/8.2/ZenTaoPMS.8.2.stable.exe/download

1、解压ZenTaoPMS.8.1.3到根目录，比如“C:\ xampp”、“D:\ xampp 



2、进入xampp，以管理员身份点击“启动禅道”



3、禅道集成运行环境1.2.6，点击启动



4、系统会自...]]></description><category></category></item><item><title><![CDATA[sql之join练习]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80942506</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80942506</guid><author>lvxiaoting</author><pubDate>Fri, 06 Jul 2018 16:08:04 +0800</pubDate><description><![CDATA[SELECT *from t_distribution;
SELECT *from t_department;


SELECT t_distribution.ad_area_code,t_distribution.area_num,t_department.ad_area_name
FROM t_distribution
LEFT JOIN t_department
ON t_distribut...]]></description><category></category></item><item><title><![CDATA[SQL 测验记录]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80936137</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80936137</guid><author>lvxiaoting</author><pubDate>Fri, 06 Jul 2018 09:37:09 +0800</pubDate><description><![CDATA[SQL 测验结果：17/20您的回答：1.SQL 指的是？您的回答：Structured Query Language2.哪个 SQL 语句用于从数据库中提取数据？您的回答：SELECT3.哪条 SQL 语句用于更新数据库中的数据？您的回答：UPDATE4.哪条 SQL 语句用于删除数据库中的数据？您的回答：DELETE5.哪条 SQL 语句用于在数据库中插入新的数据？您的回答：INSERT IN...]]></description><category></category></item><item><title><![CDATA[19.Selenium2 自动化测试实战-基于Python语言-记录cookie]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/68944975</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/68944975</guid><author>lvxiaoting</author><pubDate>Wed, 04 Jul 2018 17:20:28 +0800</pubDate><description><![CDATA[通过向浏览器中添加cookie可以绕过登录的验证码，这是比较有意思的一种解决方法。
from selenium import webdriver
import time
driver=webdriver.Chrome()
driver.get(&quot;http://www.youdao.com&quot;)
'''
#获得cookie信息
cookie=driver.get_cookies()
#将获得cook]]></description><category></category></item><item><title><![CDATA[sql 面积求和笔记]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80915481</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80915481</guid><author>lvxiaoting</author><pubDate>Wed, 04 Jul 2018 17:02:12 +0800</pubDate><description><![CDATA[根据数据表统计某地某年农作物种植面积SELECT *from t_distribution ;
SELECT sum(area_num) as &quot;2016总面积&quot;  from t_distribution where ad_area_code LIKE '6103%' and current_year ='2016';
SELECT sum(area_num) as &quot;2016小麦面积&quot; from...]]></description><category></category></item><item><title><![CDATA[Virtualenv  ——虚拟的Python环境安装]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80777134</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80777134</guid><author>lvxiaoting</author><pubDate>Fri, 22 Jun 2018 18:07:04 +0800</pubDate><description><![CDATA[虚拟的 Python 环境（简称 venv） 是一个能帮助你在本地目录安装不同版本的 Python 模块的 Python 环境，你可以不再需要在你系统中安装所有东西就能开发并测试你的代码。
 

一、安装virtualenv

1.先安装pip3
sudo apt-get update
sudo apt-get install python3-pip
2.安装virtualenv
sudo pip...]]></description><category></category></item><item><title><![CDATA[IIS 7无法写入配置文件C:\Windows\System32\inetsrv\config\applicationHost.config]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80679427</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80679427</guid><author>lvxiaoting</author><pubDate>Wed, 13 Jun 2018 15:11:17 +0800</pubDate><description><![CDATA[---------------------------Internet 信息服务(IIS)管理器---------------------------文件名: \\?\C:\Windows\system32\inetsrv\config\applicationHost.config错误: 无法写入配置文件---------------------------确定   ---------------...]]></description><category></category></item><item><title><![CDATA[[转]pycharm的一些快捷键]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80519474</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80519474</guid><author>lvxiaoting</author><pubDate>Thu, 31 May 2018 09:43:34 +0800</pubDate><description><![CDATA[最近在用pycharm时候，比如调试、注释有时觉得麻烦，看有没有类似vs一样的快捷键，找了一些资料，（地址：http://www.2cto.com/os/201410/341542.html）仅供参考。编辑类：Ctrl + Space 基本的代码完成（类、方法、属性）Ctrl + Alt + Space 类名完成Ctrl + Shift + Enter 语句完成Ctrl + P 参数信息（在方法中...]]></description><category></category></item><item><title><![CDATA[解决Pycharm无法导入包问题 Unresolved reference]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80509034</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80509034</guid><author>lvxiaoting</author><pubDate>Wed, 30 May 2018 14:01:08 +0800</pubDate><description><![CDATA[从SVN更新下来的代码，突然导入包路径都有问题，必须加上根路径才正确，之前运行是OK的。检查了运行的环境路径，也是没有问题，最后查资料，是package的source路径设置问题。在pycharm中设置source路径file–&amp;gt;setting–&amp;gt;project:server–&amp;gt;project structure将放package的文件夹设置为source，这样import的模块...]]></description><category></category></item><item><title><![CDATA[Python+Selenium获取HTML-Table表格数据]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80497980</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80497980</guid><author>lvxiaoting</author><pubDate>Tue, 29 May 2018 16:24:11 +0800</pubDate><description><![CDATA[在自动化中，有时我们会遇到html表格，需要对表格添加的内容判断其正确性，那么怎么才能取得表格数据呢？1.通过selenium定位方式（id,name,xpath等方式）定位table标签定义基类base# -*- coding: utf-8 -*-
from selenium.webdriver.support.wait import WebDriverWait


class PageMeth...]]></description><category></category></item><item><title><![CDATA[python获取当前文件路径以及父文件路径]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80309190</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80309190</guid><author>lvxiaoting</author><pubDate>Mon, 14 May 2018 14:24:50 +0800</pubDate><description><![CDATA[123456#当前文件的路径pwd = os.getcwd()#当前文件的父路径father_path=os.path.abspath(os.path.dirname(pwd)+os.path.sep+&quot;.&quot;)#当前文件的前两级目录grader_father=os.path.abspath(os.path.dirname(pwd)+os.path.sep+&quot;..&quot;)...]]></description><category></category></item><item><title><![CDATA[python+selenium随机添加用户自动化测试脚本]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/80018036</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/80018036</guid><author>lvxiaoting</author><pubDate>Fri, 20 Apr 2018 14:12:20 +0800</pubDate><description><![CDATA[from selenium import webdriver
import time
import random
global userName,userPassword #为了便于使用，定义为全局变量
userName = ''
userPassword = ''

driver = webdriver.Chrome()
driver.maximize_window()
driver .get(...]]></description><category></category></item><item><title><![CDATA[selenium报错：is not clickable at point (1214, 124). Other element would receive the clickd]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79992835</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79992835</guid><author>lvxiaoting</author><pubDate>Wed, 18 Apr 2018 16:42:22 +0800</pubDate><description><![CDATA[    定位元素没有问题，但是执行脚本时候，循环第二遍时候，就报错is not clickable at point (1214, 124). Other element would receive the click。  具体错误：selenium.common.exceptions.WebDriverException: Message: unknown error: Element &amp;lt;...]]></description><category></category></item><item><title><![CDATA[多个用户登录导致python出现’no module named 'selenium'异常解决]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79973821</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79973821</guid><author>lvxiaoting</author><pubDate>Tue, 17 Apr 2018 14:15:46 +0800</pubDate><description><![CDATA[之前系统一直使用administrator账户登录，python环境搭建好之后使用正常，最近新建了个账户后，若程序中有“from selenium import webdriver”,那么久报错‘no module named 'selenium’。1.查看系统安装的selenium：pip show selenium，可以发现，selenium安装在administrator用户权限的目录下，那...]]></description><category></category></item><item><title><![CDATA[python运行的unknown error: call function result missing 'value']]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79972431</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79972431</guid><author>lvxiaoting</author><pubDate>Tue, 17 Apr 2018 11:39:40 +0800</pubDate><description><![CDATA[之前调试好的程序，这两天打开一直报错unknown error: call function result missing 'value'，经过不断确认代码没问题之后，找到问题原因，由于自己使用的chrome版本升级，原先使用的chromedriver不匹配。这是在网上查询的浏览器与驱动匹配信息，但是已经不是最新的了我这里稍作补充V2.29  V56-58V2.30  V57-59V2.31  V...]]></description><category></category></item><item><title><![CDATA[python的字符串切片操作]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79957235</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79957235</guid><author>lvxiaoting</author><pubDate>Mon, 16 Apr 2018 10:29:54 +0800</pubDate><description><![CDATA[回文是一种无论从左还是从右读都一样的字符序列。比如 “madam”。在这个例子中，我们检查用户输入的字符串是否是回文，并输出结果。一：取字符串中第几个字符print &quot;Hello&quot;[0] 表示输出字符串中第一个字符print &quot;Hello&quot;[-1] 表示输出字符串中最后一个字符二：字符串分割print &quot;Hello&quot;[1:3]#第一个参数表示原来字符串中的下表#第二个阐述表示分割后剩下的字符串的第...]]></description><category></category></item><item><title><![CDATA[python 代码风格建议]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79799827</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79799827</guid><author>lvxiaoting</author><pubDate>Tue, 03 Apr 2018 10:39:28 +0800</pubDate><description><![CDATA[在 Python 中，空格很重要，我们使用空格将标识符区分开，行开始处的空格我们称之为缩进，如果你的缩进是错误的，Python 解释器会抛出错误。例如下面情形：&amp;gt;&amp;gt;&amp;gt; a = 12
&amp;gt;&amp;gt;&amp;gt;   a = 12
  File &quot;&amp;lt;stdin&amp;gt;&quot;, line 1
    a = 12
    ^
IndentationError: unexpected i...]]></description><category></category></item><item><title><![CDATA[win7管理模板“进行解析时遇到错误”的解决方法]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79568762</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79568762</guid><author>lvxiaoting</author><pubDate>Thu, 15 Mar 2018 15:32:57 +0800</pubDate><description><![CDATA[win7系统用gpedit.msc打开本地组策略编辑器时很多人都遇到一个问题，那就是有错误提示：管理模板“进行解析时遇到错误”。以至于不能设置某些项目，例如管理模板。这个问题的产生，是因为系统安装了最新补丁而导致管理模板不兼容所致。那么我们要怎么解决这个问题呢？win7管理模板“进行解析时遇到错误”解决方法是下载新的模板文件替换旧模板文件。1、先下载新的模板文件，点击下载（此文件压缩包由卡卡网本站...]]></description><category></category></item><item><title><![CDATA[常用Linux命令]]></title><link>https://blog.youkuaiyun.com/lvxiaoting/article/details/79529106</link><guid>https://blog.youkuaiyun.com/lvxiaoting/article/details/79529106</guid><author>lvxiaoting</author><pubDate>Mon, 12 Mar 2018 16:38:26 +0800</pubDate><description><![CDATA[Linux系统有着众多的优点，比如开源、非商业版本免费、多任务多用户操作，因此Linux系统在非桌面领域占有压倒性的市场份额。对于互联网技术工作者来说，掌握常用的Linux命令也是一门必修课。下面列举一些笔者在工作中常用的Linux命令。　　cd切换目录　　cd..返回上一层目录　　cd.进入当前目录　　cd-返回前一次的目录，即上一次的目录不是上一层目录　　ls查看文件与目录　　用法：ls[参数...]]></description><category></category></item></channel></rss>