gaokao/数据库操作.ipynb

In [ ]:

import pymysql
db = pymysql.connect("localhost","songyi","yylzs","mydata" )
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
print ("Database version : %s " % data)
db.close()

In [ ]:

import pymysql
db = pymysql.connect("localhost","songyi","yylzs","mydata" )
cursor = db.cursor()
sql = "select id,name from sports_person where name= %s"
cursor.execute(sql, ('张联红',))
result = cursor.fetchone()
print(result)
db.close()

In [ ]:

import pymysql
db = pymysql.connect("localhost","songyi","yylzs","mydata" )
cursor = db.cursor()
sql = "select id,name from sports_person"
cursor.execute(sql)
result = cursor.fetchone()
print("人员信息：")
print(result)
sql = "select id,name from sports_item"
cursor.execute(sql)
result = cursor.fetchone()
print("\n运动项目信息：")
print(result)
db.close()

In [ ]:

import pymysql
db = pymysql.connect("localhost","songyi","yylzs","mydata" )
cursor = db.cursor()
sql = "select a.target_id,b.name from sports_item_target as a,sports_target as b where a.target_id=b.id"
cursor.execute(sql)
re_ta = {}
print("\n运动项目信息：")
results = cursor.fetchall()
for result in results:
#    print ("%d--%s" %(result[0],result[1]))
    re_ta[result[0]] = result[1]
    print("re_ta[%d]=        #%s" %(result[0],result[1]))
print(re_ta)
db.close()

In [ ]:

import pymysql
db = pymysql.connect("localhost","songyi","yylzs","mydata" )
cursor = db.cursor()
person_id = 
record_date = ''
item_id =
re_ta = {}
re_ta[1]=        #运动距离
re_ta[2]=        #运动时间
re_ta[3]=        #平均配速
re_ta[4]=        #平均速度
re_ta[5]=        #平均步频
re_ta[6]=        #平均步幅
re_ta[7]=        #步数
re_ta[8]=        #平均心率
re_ta[9]=        #最大心率
re_ta[10]=        #无氧耐力
re_ta[11]=        #有氧耐力
re_ta[12]=        #最大步频
re_ta[13]=        #最快配速
sql = "select * from sports_person"
db.close()