代码
import pymysql
def getConn():
conn=pymysql.connect(host='127.0.0.1',port=3306,user='root',password='12345678',database='lk')
return conn
def getData():
conn=getConn()
sql='select *from menu'
curser=conn.cursor()
curser.execute(sql)
list=curser.fetchall()
for li in list:
print(li)
conn.close()
def getDataByParam():
conn=getConn()
cursor=conn.cursor()
sql='select *from menu where parentid<%s'
cursor.execute(sql,('5'))
list=cursor.fetchall()
print(list)
def doInsert():
conn=getConn()
cursor=conn.cursor()
sql='insert into score(name,classinfo,value) values (%s,%s,%s)'
cursor.execute(sql,('qqqqqq','vvvvvvvv',66))
conn.commit()
conn.close()
doInsert()