笔记
用Python连接数据库,并作简单的数据查询,插入操作
import pymssql as ss
import datetime
myConn=ss.connect(host='127.0.0.1',user='sa',password='wxxlwy1318',database='Review')
myCursor=myConn.cursor() #游标
sql='select * from Rank'
myCursor.execute(sql)
myList=myCursor.fetchall()
print(myList)
sql1="insert into Rank(Name,Season,Score,Rank) values (%s,%s,%s,%s);commit"
#myDatatime1=str(datetime.datetime.now())
Name='jae'
Season = 3
Score=47
Rank=20
text=[(Name,Season,Score,Rank)]
myCursor.executemany(sql1,text)
sql2='select * from Rank'
myCursor.execute(sql2)
myList=myCursor.fetchall()
print(myList[0])