python3增删改查

增

import pymysql#打开数据库连接（地址,用户名,密码,数据库名称）db = pymysql.connect("localhost","root","123456","test")#创建游标cursor = db.cursor()try:    #传入的数据    id=0    name='admin'    password='admin'    status=0        cursor.execute('insert into user(id,name,password,status) values("%d","%s", "%s","%d")' % \             (id, name,password,status))    #执行    db.commit()except:    db.rollback()db.close(); 

删

import pymysqldb = pymysql.connect("localhost","root","123456","test")cursor = db.cursor()id=4sql = "DELETE FROM user WHERE id = %d" % \(id)try:    cursor.execute(sql)    db.commit()except:    db.rollback();db.close()

改

import pymysqldb = pymysql.connect("localhost","root","123456","test")cursor = db.cursor()id = 6name='6'password='6'status=6sql = "update user set name=%s,password=%s,status=%d where id=%d" % \(name,password,status,id)try:    cursor.execute(sql)    db.commit()except:    db.rollback()db.close()

查

import pymysqldb = pymysql.connect('localhost','root','123456','test')cursor = db.cursor()sql="select * from user"try:    cursor.execute(sql)    result = cursor.fetchall()    for row in result:        id = row[0]        name=row[1]        password=row[2]        status=row[3]        print("id=%d,name=%s,password=%s,status=%d" % \              (id,name,password,status))except:    print("unable to fetch data")    db.close();