import pymysql
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
sql="insert into class values\
(7,'Emma',17,'w',76.5,'2019-8-8');"
cur.execute(sql)
db.commit()
cur.close()
db.close()
import pymysql
"""
读操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
sql="select * from class where sex='m';"
cur.execute(sql)
one_row = cur.fetchone()
print(one_row)
cur.close()
db.close()
import pymysql
"""
读操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
sql="select * from class;"
cur.execute(sql)
one_row = cur.fetchall()
print(one_row)
cur.close()
db.close()
import pymysql
"""
读操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
sql="select * from class;"
cur.execute(sql)
one_row = cur.fetchmany(2)
print(one_row)
cur.close()
db.close()
import pymysql
"""
写操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
try:
name = input("name:")
age = input("age:")
score = input("score:")
sql = f"insert into class (name,age,score) values ('{name}',{age},{score})"
print(sql)
cur.execute(sql)
db.commit()
except Exception as e:
db.rollback()
print(e)
cur.close()
db.close()
import pymysql
"""
写操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
try:
name = input("name:")
age = input("age:")
score = input("score:")
sql = "insert into class (name,age,score) values (%s,%s,%s)"
print(sql)
cur.execute(sql,[name,age,score])
db.commit()
except Exception as e:
db.rollback()
print(e)
cur.close()
db.close()
import pymysql
"""
写操作实例
"""
db = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
database='stu',
charset='utf8')
cur = db.cursor()
try:
sql = "update interest set price=11800 \
where name='Abby' "
cur.execute(sql)
db.commit()
except Exception as e:
db.rollback()
print(e)
cur.close()
db.close()