Python学习记录

来源：互联网发布：星际争霸2数据库编辑：程序博客网时间：2024/06/09 20:00

环境:Ubuntu14.04,内置python3.4,Eclipse pydev.

1.数据库操作

# official connector of mysqlimport mysql.connector# init connection beginconfig = {'host':'127.0.0.1',        'user':'root',        'password':'123',        'port':3306 ,        'database':'test'        }conn = mysql.connector.connect(**config)# init connection end# get cursor begincur = conn.cursor()# get cursor end# insert begintry:    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 begincur.execute("select id from tb01")# select end# result set beginrs = 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 httplibconn = httplib.HTTPConnection("localhost")  #conn.request("GET", "/index.html")  # send requestresp = conn.getresponse()  # get respprint(resp.status, resp.reason, resp.read())  # read data

3.JSON

import jsonuser = {   'name':'leo',   'age':23   }print(json.dumps(user))#obj to jsonprint(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 *

0 0