摘要:
# -*- coding:utf8 -*-from bs4 import BeautifulSoupimport os, sys, urllib2, urllibfrom multiprocessing.dummy import Pool as ThreadPoolurls = []def download(url): urllib.urlretrieve(url, 'd:/'+url[-7... 阅读全文
摘要:
有关DBLINK操作的语句执行机制及优化方式 - Oracle开发-ITPUB论坛-it168旗下专业技术社区 用户名 自动登录 找回密码密码 登录 注册 只需一步,快速开始快捷导航首页论坛博客频道认证专区招聘大话IT名人堂OCM联盟文库会议自测版主团手机版 本版搜索热搜: oracleSAPsap二维码dbaOraclec++C++CRM银联信息中心比特币小额... 阅读全文
摘要:
in 多个数据使用动态SQL传入字符串 1.动态SQL传入字符串CREATE OR REPLACE PROCEDURE p_test (v_str VARCHAR2) AS TYPE cur_type IS REF CURSOR ; c_fzt cur_type; v_sql VARCHAR2( 2000); v_jrh VARCHAR2( 20);BEGIN v... 阅读全文
摘要:
CentOS升级Python2.7及安装pip CentOS升级Python2.7及安装pip1) 升级Python2.7?1234567891011121314151617181920212223242526272829303132python -V # 查看版本:Python 2.6.6mkdir -p ~/Env/python; cd ~/Env/python # 创建个目录w... 阅读全文
摘要:
Dim table_Name$Sub JugeData()Dim i%, Cnum%, dt$, arry1 () As String, arry2 () As String, arry3 () As String, cnn As Object, rst As Objectcdt = Format(Date, "MMDD")table_Name = InputBox("请输入数据库表名", "数据... 阅读全文
摘要:
vba基础知识汇总 1.工作簿事件写到THISWORKBOOK中,工作表事件写到sheet中,其他通用代码和函数子程序之类的写到模块中,窗体代码写到对应的窗体中,类相关的代码写到类模块中。2.If 句法,if 有两种写法,单行和块结构。 1、If 条件 Then 符合条件后的语句 2、If 条件 Then 符合条件后的语句 End If其实就是... 阅读全文
摘要:
from apscheduler.scheduler import Scheduler import datetime # Start the scheduler sched = Scheduler() def job_function(): print "Hello World" , 'start job1 at: ', datetime.datetime.now()def jo... 阅读全文
摘要:
pip install InstallationPython & OS Supportpip works with CPython versions 2.6, 2.7, 3.1, 3.2, 3.3, 3.4 and also pypy.pip works on Unix/Linux, OS X, and Windows.NotePython 2.5 was supported throug... 阅读全文
摘要:
#coding:utf-8import urllib, urllib2, cookielibimport os, timeimport redef login (): user = 'user' cookiename = 'chd%s.coockie' % ( user ) logined = False cj = cookielib .LWPCookieJar () ... 阅读全文
摘要:
hcsv导入oracle#coding:gbkimport csv import cx_Oraclefields = []data = []table_name = 'ygl_test3'file_name = '清单.csv'with open(file_name, 'rb') as f: reader = csv.reader(f) contents = [i for i in r... 阅读全文