通過python對MySQL進行添加修改刪除以及字符串的操作方法

# coding=UTF-8

import MySQLdb
def dbDperate(sql,param):
 "定義數據庫的添加，修改和刪除操作"
 
 #獲取數據庫的連接對象
 conn=MySQLdb.connect(host="localhost",user="root",passwd="root",db="tester",charset="utf8")
 
 #獲取執行的游標對象
 cursor=conn.cursor()
 
 #執行SQL語句
 cursor.execute(sql,param)
 #提交MySql事物
 conn.commit()
 
 cursor.close()
 conn.close()

#添加一條數據
# addSql="insert into news_user(username,password) values(%s,%s)"
# addParam=("汪政","wangzheng")
# dbDperate(addSql, addParam)

#修改一條數據
# updateSql="update news_user set username=%s where id=%s"
# updateParam=("汪政new",str(1))
# dbDperate(updateSql, updateParam)

#刪除一條數據
# deleteSql="delete from news_user where id=%s"
# deleteParam=(str(1))
# dbDperate(deleteSql, deleteParam)

# coding=UTF-8

import json

#json 字符串
json1="{"name":"汪政","age":21}"

#將json字符串轉換成Python字典對象
pydict=json.loads(json1)

print "pydict的類型為：",type(pydict)

print "json中name的值",pydict["name"]
print "json中age的值",pydict["age"]

# coding=UTF-8

import json

dict1={"name":"汪政","age":21}
#將字典對象轉換為json字符串
jsonStr=json.dumps(dict1,ensure_ascii=False)

print jsonStr