def add(self):
        import pymysql
        conn=pymysql.connect(host="localhost", user="root", password="root", database="yong", charset="utf8")
        cur=conn.cursor()
        id=self.tableWidget_2.item(0,0).text()
        name=self.tableWidget_2.item(0,1).text()
        fl=self.tableWidget_2.item(0,2).text()
        pr=self.tableWidget_2.item(0,3).text()
        rj=self.tableWidget_2.item(0,4).text()
        # sql="INSERT INTO books (id,name,category,price,publish_time) VALUES(%s,%s,%s,%s,%s),(id,name,fl,pr,rj)"
        cur.execute("INSERT INTO books (id,name,category,price,publish_time) VALUES(%s,%s,%s,%s%s)",(id,name,fl,pr,rj))
        conn.commit()