def Insert(title,content,time,name,id):#插入到数据库中 count=GetCount(title,name,time); if count <1: number="insert into News(Title,Content,Time,NewsClassName,NewsClassID) values('%s','%s','%s','%s','%d')"% (title,content,time,name,id) insert=SQLHelper.InsertAboutNumber(number) if insert==1: print "OK" else: print "插入新闻出现错误!!"
def InsertDB(url): #插入到数据库中 #try: information = [] information = geturl(url) length = len(information) #print length #print information if (length <= 0): print time.ctime() + "\t" + "教务处新闻------暂无更新" return 0 else: information2 = sorted(information, key=lambda news: news[3]) for i in range(length): # print len(MySQLdb.escape_string(information2[i][2])) # cur=db.cursor() #field=["Title","Content","Time","ClassID","ClassName"] #value=[str(information[i][0]),MySQLdb.escape_string(information[i][2]),information[i][3],3,"教务处"] #insert=SQLHelper.Insert("Information", field, value) number = "insert into News(Title,Content,Time,NewsClassName,NewsClassID) values('%s','%s','%s','%s','%d')" % ( str(information2[i][0]), MySQLdb.escape_string( information2[i][2]), information2[i][3], "教务处", 16) insert = SQLHelper.InsertAboutNumber(number) if insert == 1: continue else: print "插入新闻出现错误!!" #cur.execute("insert into Information(Title,Content,Time,ClassID,ClassName) values('%s','%s','%s','%d','%s')"% (str(information[i][0]),MySQLdb.escape_string(information[i][2]),information[i][3],3,"教务处")) print time.ctime() + "\t教务处新闻更新数目:" + str(length) #有更新 return 1 #print "OK" # cur.close() # db.commit() # db.close()