sql_a = str(info_data[0]) sql_b = str(info_data[1]) print sql_a sql1 = "UPDATE signup SET info_data ='"+ sql_a +"' where userid = '" + username + "' AND passwd= '"+ passwd + "'" sql2 = "UPDATE signup SET fullgrade ='"+ sql_b +"' where userid = '" + username + "' AND passwd= '"+ passwd + "'" #print sql_0 cur.execute(sql1) cur.execute(sql2) cur.close() conn.close() return 1 # 主函数 程序从这里开始执行 if __name__ == '__main__': try: username = sys.argv[1] passwd = sys.argv[2] id = sys.argv[3] except IndexError,e: sys.exit() k = scoreScanner(username,passwd,id) if k == 0 : #proFile = username + '_1' GPA = calGPA(username,passwd,id,0) a = saveScore(username ,passwd,GPA) print k #if (a == 1): # sendSMS(phone_num,phone_passwd,final_s)
sys.exit() cur = conn.cursor() sql_a = str(info_data) print sql_a sql_0 = "SELECT info_data FROM `signup` WHERE userid= '" + username + "' " sql = "UPDATE signup SET info_data ='"+ sql_a +"' where userid = '" + username + "'" #print sql_0 cur.execute(sql) cur.close() conn.close() return 1 # 主函数 程序从这里开始执行 if __name__ == '__main__': try: username = sys.argv[1] passwd = sys.argv[2] except IndexError,e: sys.exit() scoreScanner(username,passwd) proFile = username + '_1' GPA = calGPA(proFile) a = saveScore(username ,GPA) print GPA #if (a == 1): # sendSMS(phone_num,phone_passwd,final_s)
