python中管理mysql数据库

 

一、配置服务

下载数据库mysql，php，

具体查看之前博客

2

# _*_ coding:utf-8 _*_
"""
file: 02.py
date: 2018-07-25 10:17 AM
author: westos-dd
desc:
    

"""
import MySQLdb
# 打开门
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')

# 伸出手
cur = conn.cursor()

# 拿东西
recont = cur.execute('select * from userInfo')
data = cur.fetchall()

# 把手伸回来
cur.close()

# 把门关上
conn.close()
print recont
print data

 

# _*_ coding:utf-8 _*_
"""
file: 02.py
date: 2018-07-25 10:17 AM
author: westos-dd
desc:
    

"""
import MySQLdb
# 打开门
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')

# 伸出手
#cur = conn.cursor() #创建了一个“手”
cur = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
# 拿东西
# 这个操作影响了多少行数(有多少行被操作了)
recont = cur.execute('select * from userInfo')
data = cur.fetchall()

# 把手伸回来
cur.close()

# 把门关上
conn.close()
print recont
print data

对数据库进行增加

# _*_ coding:utf-8 _*_
"""
file: 增.py
date: 2018-07-25 10:48 AM
author: westos-dd
desc:


"""
import MySQLdb

# 打开门
conn = MySQLdb.connect(host='127.0.0.1', user='root', passwd='westos', db='python')

# 伸出手
cur = conn.cursor()

# 操作数据
sql = 'insert into usermg(id,name,address) values(%s,%s,%s)'
params = ('1', 'dd', 'usa')
recount = cur.execute(sql, params)

# 提交请求
conn.commit()

# 把手伸回来
cur.close()

# 把门关上
conn.close()
print recount

对数据库进行删除

# _*_ coding:utf-8 _*_
"""
file: 删.py
date: 2018-07-25 10:48 AM
author: westos-dd
desc:
    

"""
import MySQLdb

# 打开门
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')

# 伸出手
cur = conn.cursor()

# 操作数据
sql = 'delete from usermg where id = %s'
params = (1,)
recount = cur.execute(sql,params)

# 提交请求
conn.commit()

# 把手伸回来
cur.close()

#把门关上
conn.close()
print recount

插入多条数据

# _*_ coding:utf-8 _*_
"""
file: 插入多条数据.py
date: 2018-07-25 11:29 AM
author: westos-dd
desc:
    

"""
import MySQLdb
# 打开门
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')

# 伸出手
cur = conn.cursor()

# 操作数据
# sql = 'update usermg set name = %s where id = %s'
# params = ('uu','1',)
li = [
    ('2','hahaha','wwww'),
    ('3','lalala','qqqq'),
]
recount = cur.executemany('insert into usermg(id,name,address) values(%s,%s,%s)',li)

# 提交请求
conn.commit()

# 把手伸回来
cur.close()

#把门关上
conn.close()
print recount

改变数据库中的内容

# _*_ coding:utf-8 _*_
"""
file: 改.py
date: 2018-07-25 10:48 AM
author: westos-dd
desc:
    

"""
import MySQLdb

# 打开门
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')

# 伸出手
cur = conn.cursor()

# 操作数据
sql = 'update usermg set name = %s where id = %s'
params = ('uu','1',)
recount = cur.execute(sql,params)

# 提交请求
conn.commit()

# 把手伸回来
cur.close()

#把门关上
conn.close()
print recount

数据表的回滚

# _*_ coding:utf-8 _*_
"""
file: commit.py
date: 2018-07-25 11:34 AM
author: westos-dd
desc:
提交和回滚 在数据库里交事务操作

"""
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='dd',db='python')
cur = conn.cursor()

sql = 'update money set money = %s where id = 1'
params = ('0',)
recount = cur.execute(sql,params)

sql = 'update money set money = %s where id = 2'
param = ('100',)
recount = cur.execute(sql,param)
conn.commit()