Home  >  Article  >  Backend Development  >  How to add, modify, delete and operate strings in MySQL through python

How to add, modify, delete and operate strings in MySQL through python

高洛峰
高洛峰Original
2017-03-15 14:59:551489browse

This article introduces how to add and modify MySQL through pythondelete and string

# 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

We have two ways to design software: one is to make it simple enough that BUGs cannot hide; the other is to make it complex enough so that no one can find BUGs. The former is more difficult.

The above is the detailed content of How to add, modify, delete and operate strings in MySQL through python. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn