环境:Ubuntu14.04,内置python3.4,Eclipse pydev.
1.数据库操作
# official connector of mysql
import mysql.connector
# init connection begin
config = {'host':'127.0.0.1',
'user':'root',
'password':'123',
'port':3306 ,
'database':'test'
}
conn = mysql.connector.connect(**config)
# init connection end
# get cursor begin
cur = conn.cursor()
# get cursor end
# insert begin
try:
cur.execute("insert into tb01(id) values(2)")
conn.commit()
except:
conn.rollback()
sql_insert_user = ("insert into user(uid,pwd)"
"values(%s,%s)")
user_data = ("leo", "123")
try:
cur.execute(sql_insert_user, user_data)
conn.commit()
except:
conn.rollback()
# insert end
# select begin
cur.execute("select id from tb01")
# select end
# result set begin
rs = cur.fetchall()
for el in rs:
print(el[0])
# result set end
# close resource begin
cur.close()
conn.close()
# close resource end
2.Http连接
import httplib
conn = httplib.HTTPConnection("localhost") #
conn.request("GET", "/index.html") # send request
resp = conn.getresponse() # get resp
print(resp.status, resp.reason, resp.read()) # read data
3.JSON
import json
user = {
'name':'leo',
'age':23
}
print(json.dumps(user))#obj to json
print(json.loads(json.dumps(user)))#json to obj
4.Date format
print datetime.now().strftime("%Y-%m-%d %H:%M:%S") #yyyy-MM-dd HH:mm:ss
5.使用别的py文件的所有方法
from 其它py的名字 import *