Python-MySQL操作

#***********************建表**********************************
import pymysql
import sys
try:
    conn=pymysql.connect(host='localhost',user='root',passwd='123qwe',db='exercise',port=3306,charset='utf8')
except:
    print("打开数据库连接出错，请检查!")
    conn.close()
    sys.exit()
cur=conn.cursor()
sql="create table if not exists python" \
    "(date1 char(12)primary key not null," \
    "name char(10) not null, nums int not null,price decimal(10,2) not null,sExplain varchar(200));"
#sql="insert into user values('9', '胡一菲', '2016203511', '14479122166', '980408', 'W', 'Teacher', '2016软件工程1班')"

try:
    cur.execute(sql)
    conn.commit()
    print("TT表可以使用！")
except:
    print("TT表建立过程出错！")
conn.close()

#***************************增删改查******************************
#***************************增加******************************
import pymysql
import sys
try:
    conn=pymysql.connect(host='localhost',user='root',passwd='123qwe',db='exercise',port=3306,charset='utf8')
except:
    print("连接数据库出错")
    conn.close()
    sys.exit()
cur=conn.cursor()
insertSQL = "insert into python values('2018-3-28','黑鱼',10,28.3,'Tom')"
insertSQL2 = "insert into python values('2018-3-29','鲤鱼',25,9.8,'John')"
try:
    cur.execute(insertSQL)
    cur.execute(insertSQL2)
    conn.commit()
    print("两条记录插入成功")
except:
    print("两条记录插入失败")
    conn.close()
    sys.exit()
    
#***************************修改******************************
import pymysql
import sys
try:
    conn=pymysql.connect(host='localhost',user='root',passwd='123qwe',db='exercise',port=3306,charset='utf8')
except:
    print("连接数据库出错")
    conn.close()
    sys.exit()
cur=conn.cursor()
updateSQL = "update python set nums=12 where date1='2018-3-28'"
try:
    cur.execute(updateSQL)
    conn.commit()
    print("第一条记录修改成功")
except:
    print("第一条记录修改失败")
    conn.close()
    sys.exit()
    
#***************************删除******************************
import pymysql
import sys
try:
    conn=pymysql.connect(host='localhost',user='root',passwd='123qwe',db='exercise',port=3306,charset='utf8')
except:
    print("连接数据库出错")
    conn.close()
    sys.exit()
cur=conn.cursor()
deleteSQL = "delete from python where date1 = '2018-3-29'"
try:
    cur.execute(deleteSQL)
    conn.commit()
    print("第二条记录删除成功")
except:
    print("第二条记录删除失败")
    conn.close()
    sys.exit()

#***************************查询******************************
import pymysql
import sys
try:
    conn=pymysql.connect(host='localhost',user='root',passwd='123qwe',db='exercise',port=3306,charset='utf8')
except:
    print("连接数据库出错")
    conn.close()
    sys.exit()
cur=conn.cursor()
selectSQL = 'select * from test1'
cur.execute(selectSQL)
record = []
for row in cur.fetchall():
    record.append(row)
print(record)