Python基礎---->python的使用(二)

標籤：對象   person   建立   print   username   學習   exec   orm   charset   

　　學習一下python，這裡對python的基礎知識做一個整理。似等了一百年忽而明白，即使再見面，成熟地表演，不如不見。

 

python的一些應用一、類似於java中的MessageFormat用法

word = "{0} love {1}"wordList = (‘huhx‘, ‘linux‘)print(word.format(*wordList))print(word.format(‘huhx‘, ‘linux‘))str_word = "{name} love {lover}"wordMap = dict(name=‘huhx‘, lover=‘linux‘)print(str_word.format(name=‘huhx‘, lover=‘linux‘))print(str_word.format(**wordMap))print(str_word.format_map(wordMap))

 列印結果都是：huhx love linux

 

二、關於正則中貪心匹配的理解

import redata = ‘Thu Feb 15 17:46:04 2007::[email protected]::1171590364-6-8‘print(re.search(‘\d+-\d+-\d+‘, data).group()) # 1171590364-6-8print(re.match(‘.+\d+-\d+-\d+‘, data).group()) # Thu Feb 15 17:46:04 2007::[email protected]::1171590364-6-8print(re.match(‘.+(\d+-\d+-\d+)‘, data).group(1)) # 4-6-8print(re.match(‘.+?(\d+-\d+-\d+)‘, data).group(1)) # 1171590364-6-8

 

 三、python中簡單的json請求

import http.clientimport jsonconn = http.client.HTTPConnection("hostname")data = {    ‘TellerId‘: ‘***‘,    ‘Password‘: ‘***‘}payload = json.dumps(data)headers = {    ‘content-type‘: "application/json"}conn.request("POST", "/mweb/login.do", payload, headers)res = conn.getresponse()data = res.read()print(data.decode("utf-8"))

 

四、python中簡單的mysql串連

首先可以通過：pip install pymysql安裝pymysql。

import pymysqldb = pymysql.connect("localhost","root","pass","database", charset=‘utf8‘)cur = db.cursor()cur.execute(‘select * from puser‘)for i in cur.fetchall():    print(str(i))db.close()

 

五、python中使用sftp串連的簡單使用

首先可以通過：pip install paramiko安裝sftp的支援

import paramikohost = ‘hostname‘port = 22user = ‘root‘passwd = ‘password‘# 建立SSH對象ssh = paramiko.SSHClient()# 允許串連不在know_hosts檔案中的主機ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())# 串連伺服器ssh.connect(hostname=host, port=port, username=user, password=passwd)# 執行命令stdin, stdout, stderr = ssh.exec_command(‘ls -al‘)# 擷取命令結果result = stdout.read()print(result)# 關閉串連ssh.close()

 

六、python簡單串連操作redis

首先啟動redis服務，然後下載python的redis包：pip install redis。

import redisr = redis.Redis(host=‘127.0.0.1‘,port=6379)r.set(‘name‘, ‘linux‘)print(r.get(‘name‘)) # linux

 

七、python簡單的dom對xml的解析

from xml.dom.minidom import parseimport xml.dom.minidomDOMTree = xml.dom.minidom.parse("huhx.xml")collection = DOMTree.documentElementpersons = collection.getElementsByTagName(‘person‘)for person in persons:    if person.hasAttribute(‘name‘):        print(‘my name is %s: ‘ % person.getAttribute(‘name‘))    age = person.getElementsByTagName(‘age‘)[0].childNodes[0].data    address = person.getElementsByTagName(‘address‘)[0].childNodes[0].data    print(‘age = %d, address = %s.‘ % (int(age), address))

測試的huhx.xml檔案如下：

<persons>    <person name="huhx">        <age>12</age>        <address>wuhan</address>    </person>    <person name="linux">        <age>1</age>        <address>hubai</address>    </person></persons>

啟動並執行結果如下：

my name is huhx: age = 12, address = wuhan.my name is linux: age = 1, address = hubai.

 

八、python中csv檔案的讀寫

　　csv檔案可以在excel表中建立資料，最後儲存的時候存為csv格式的檔案。

• 先看一個讀取csv檔案的內容，測試的huhx.csv檔案內容如下：

import csvcsvFile = open(‘huhx.csv‘, ‘r‘)reader = csv.reader(csvFile)for item in reader:    for subItem in item:        print(subItem, end=" ")    print()

啟動並執行結果如下：

姓名 年齡 地址 huhx 23 china linux 24 hubai liuling 21 wuhan 

• python寫入內容到csv檔案

import csvfileHeader = [‘username‘, ‘age‘, ‘address‘]data1 = [‘huhx‘, 342, ‘hubai‘]data2 = [‘linux‘, 56, ‘wuhan‘]data3 = [‘tomhu‘, 44, ‘china‘]csvFile = open(‘huhx.csv‘, ‘a‘)writer = csv.writer(csvFile)# writer.writerow(fileHeader)# writer.writerow(data1)# writer.writerow(data2)# writer.writerow(data3)writer.writerows([fileHeader, data1, data2, data3])csvFile.close()

 

友情連結

 

Python基礎---->python的使用(二)