import pymysql
db = pymysql.connect(host='localhost',user='root',passwd='',db='jodb1',port=3307,charset='utf8')
# #测试连接开发库成功
# db = pymysql.connect(host='172.31.20.2',user='root',passwd='sjroot',port=3306,charset='utf8')
# print('heh')
#数据中创建表
cursor = db.cursor()
cursor.execute('drop table if exists new_table2')
print('Success!') sql = '''create table employee3 (
first_name char(20) not null,
last_name char(20),
age int ,
sex char(1),
income float)
'''
# 这样修改语法有错误
# sql = '''create table employee3 if not exists employee3(
# first_name char(20) not null,
# last_name char(20),
# age int ,
# sex char(1),
# income float)
# '''
cursor.execute(sql)
db.close()
print('table create Successully!') sql = '''insert into employee
(first_name,last_name,age,sex,income)
values('Jiang','LiGai',20,'F',2000)'''
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
print('data insert successully') #数据没有插入成功，但是也没有出错
# sql2 = 'insert into employee(first_name,last_name,age,sex,income)values({0},{1},{2},{3},{4})'.format('Jiang','PeiRong',21,'F',3000)
# try:
# cursor.execute(sql2)
# db.commit()
# except:
# db.rollback()
# print('data insert successully2')