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()
