获取数据
import pymysq
conn = pymysql.connect(host='localhost', user='root', passwd='', db='study')
cur = conn.cursor()
cur.execute("SELECT * FROM class")
rows = cur.fetchall()
cur.close()
conn.close()
return render(request,'index.html',{'msg':rows})
添加数据
import pymysql
conn = pymysql.connect(host='localhost', user='root', passwd='', db='study')
cur = conn.cursor()
cur.execute("INSERT INTO class(id,class_name) VALUES(%s,%s);",[classId,class_name,] )
conn.commit()
cur.close()
conn.close()
删除数据
import pymysql
conn = pymysql.connect(host='localhost', user='root', passwd='', db='study')
cur = conn.cursor()
cur.execute("DELETE FROM class WHERE id=%s",[nid,] )
conn.commit()
cur.close()
conn.close()