信息技术基础认知与实践 python方向 作业3

老师会查重，没办法只能等过12点再发了。

题目要求

建立一张数据表goods，包含字段gid 主键自增，gname varchar(20),gprice int,gnum int,
使用python完成对该数据表的crud操作。

注：
crud操作：增加(Create)、读取查询(Retrieve)、更新(Update)和删除(Delete)

代码

#coding = utf-8

'''
信息技术基础认知与实践 python方向 第三次作业:
建立一张数据表goods，包含字段gid 主键自增，gname varchar(20),gprice int,gnum int,
使用python完成对该数据表的crud操作。
增加(Create)、读取查询(Retrieve)、更新(Update)和删除(Delete)

@date:2021/06/17
'''

import pymysql

DBUSER = 'root'
DBHOST = 'localhost'
DBPASS = '123456'
DBNAME = 'goods'
DBPORT = '3306'

goods = pymysql.connect(host="localhost",port=3306,user="root",password="123456",db="goods")
abc = goods.cursor()
abc.execute("DROP TABLE IF EXISTS GOODS")
chart = "create table goods(gid int AUTO_INCREMENT,primary key(gid),gname varchar(20),gprice int ,gnum int)"
abc.execute(chart)

#增加(Create)
abc = goods.cursor()#创建游标对象
chart = 'insert into goods(gname,gprice,gnum) value (%s,%s,%s)'
e = ('phone','3000','50')
abc.execute(chart,e)
goods.commit()
print("Create成功")

#读取查询(Retrieve)
abc = goods.cursor()#创建游标对象
chart = "select *from goods"
abc.execute(chart)
results = abc.fetchall()
for line in results:
        gid = line[0]
        gname = line[1]
        gprice = line[2]
        gnum = line[3]
        print(gid,gname,gprice,gnum)
print("Retrieve成功")

#更新(Update)
abc = goods.cursor()#创建游标对象
chart = "update goods set gname = %s where gname = %s"
e = ('computer','phone')
abc.execute(chart,e)
chart = "update goods set gprice = %s where gprice = %s"
r = ("7000","3000")
abc.execute(chart,r)
chart = "update goods set gnum = %s where gnum = %s"
r = ("200","50")
abc.execute(chart,r)
goods.commit()
print("Update成功")

#删除(Delete)
abc = goods.cursor()#创建游标对象
chart = "delete from goods where gname = %s"
e = ("computer")
abc.execute(chart,e)
goods.commit()
print("Delete成功")

实现