lidanhua-优快云博客

原创 gnuplot绘制sysben测试图

gnuplot绘制sysben测试图cat t.log |grep "]" |awk -F" " '{print $2,$5,$8,$11}'|sed -e 's/s//g'|sed -e 's/\///g' >test.logcat t.log |grep “]” |awk -F" " ‘{print $2,$5,$8,$11}’|sed -e ‘s/s//g’|sed -e ‘s////g’ >test.log[root@Jupiter test]# cat log.conf#cat

2020-06-09 19:29:38 239

原创 Oracle SQL前三行，后三行

select * from (select e.employee_id,e.first_name,e.salary,row_number() over(order by e.salary) rank,count(*) over() total from emp e) where rank <=3 or rank >=total-2;

2019-01-08 17:56:51 2561

原创众数，中位数

众数：select * from (select salary, repeat_num, dense_rank() over(order by repeat_num desc) rank_repeat_num from (select salary, count(*) repeat_num ...

2019-01-08 17:39:29 2866

原创 Oracle分析函数

select e.employee_id, e.first_name || ' ' || e.last_name name, e.department_id dept, e.hire_date, e.salary, rank() over(partition by e.department_id order by e.salar...

2019-01-08 16:10:49 157

原创 python循环注册识别验证码

#!/usr/bin/python# !coding=utf-8import osimport timefrom io import BytesIOimport tesserocrfrom PIL import Imagefrom selenium import webdriverfrom selenium.webdriver.common.by import Byfrom s...

2018-12-27 16:13:21 615

转载 python识别验证码

#!/usr/bin/python# !coding=utf-8import tesserocrfrom PIL import Imageimage = Image.open("CheckCode.jpg")image = image.convert("L")threshold = 120table = []for i in range(256): if i < ...

2018-12-24 16:08:56 173

转载自动拖拽

#!/usr/bin/python# !coding=utf-8import timefrom selenium import webdriverfrom selenium.webdriver import ActionChainsbrowser = webdriver.Chrome()url = "http://www.runoob.com/try/try.php?filename...

2018-12-24 15:39:13 191

转载浏览器自动启动搜索

#!/usr/bin/python# !coding=utf-8from selenium import webdriverfrom selenium.webdriver.common.by import Byfrom selenium.webdriver.common.keys import Keysfrom selenium.webdriver.support import exp...

2018-12-24 11:33:58 408

转载 python ajax批量下载

#!/usr/bin/python# !coding=utf-8import osimport requestsimport refrom urllib.parse import urlencodefrom hashlib import md5from multiprocessing.pool import Pooldef get_page(offset): base...

2018-12-21 17:31:27 421

转载爬虫数据插入mysql

#!/usr/bin/python# !coding=utf-8from urllib.parse import urlencodeimport requestsfrom pyquery import PyQuery as pqimport pymysqldef get_page(page): params = { "type": "uid", ...

2018-12-14 11:13:57 586

转载批量打印查询结果

批量打印查询结果：#!/usr/bin/python# !coding=utf-8import pymysqldb = pymysql.connect(host='192.168.1.230', user='root', password='root',db='spiders', port=3306)cursor = db.cursor()sql = 'select * from s...

2018-12-10 15:16:07 450

转载 python插入mysql

#!/usr/bin/python# !coding=utf-8import pymysqldb = pymysql.connect(host='192.168.1.230', user='root', password='root', port=3306)cursor = db.cursor()cursor.execute(&amp;quot;use spiders&amp;quot;)data = {&amp;quot;id&amp

2018-12-10 14:20:59 1466 1

翻译 Python爬虫

#!/usr/bin/python#!coding=utf-8import jsonimport requestsimport reimport timedef get_one_page(url): headers = {'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (K...

2018-11-27 17:59:58 125

mha-rpms-master.zip MHA所需的安装包全包括

MHA所需的安装包都有：mha4mysql-manager-0.56-0.el5.noarch.rpm mha4mysql-manager-0.56-0.el6.noarch.rpm mha4mysql-node-0.56-0.el5.noarch.rpm mha4mysql-node-0.56-0.el6.noarch.rpm mha4mysql-manager-0.57.tar mha4mysql-node-0.57.tar.gz

2020-06-12