以下主要是web服务器处理app请求的后台代码:
#用户注册(app) @app.route('/android_register') def android_register(): name = request.values.get("name") phone = request.values.get("phone") password = request.values.get("password") sql.android_register(name,phone,password) print("用户注册(app)成功") data=1 return jsonify({"data": data}) #用户(app)查询 @app.route('/android_query_user') def android_query_user(): phone = request.values.get("phone") str_s=sql.android_query(phone); return jsonify({"data": str_s}) #用户(app)收藏添加 @app.route('/android_like') def android_like(): userphone = request.values.get("userphone") usermovie=request.values.get("usermovie") usertype=request.values.get("usertype") scorenum=request.values.get("scorenum") url=request.values.get("url") score=request.values.get("score") data=sql.android_like(userphone,usermovie,usertype,scorenum,url,score); print("收藏(app)") print(data) return jsonify({"data": data}) @app.route('/web_like') def web_like(): usermovie=request.values.get("usermovie") usertype=request.values.get("usertype") scorenum=request.values.get("scorenum") url=request.values.get("url") score=request.values.get("score") # userphone=session['userphone'] userphone="15722222222" data=sql.android_like(userphone, usermovie, usertype, scorenum, url, score); print("收藏(web)") print(data) return jsonify({"data": data}) #用户(app)收藏查询 @app.route('/android_like_query') def android_like_query(): userphone=request.values.get("userphone") usertype=request.values.get("usertype") data=sql.android_like_query(userphone,usertype) return jsonify({"data": data}) @app.route('/web_like_query') def web_like_query(): # userphone=session['userphone'] usertype=request.values.get("usertype") userphone="15722222222" data = sql.android_like_query(userphone, usertype) return jsonify({"data": data}) #用户(app)收藏删除 @app.route('/android_delete') def android_delete(): userphone = request.values.get("userphone") usertype = request.values.get("usertype") usermovie = request.values.get("usermovie") scorenum = request.values.get("scorenum") flag=sql.android_delete(userphone,usertype,usermovie,scorenum) return jsonify({"data": flag}) #用户(app)收藏转移 @app.route('/android_user_like_trans') def android_user_like_trans(): userphone = request.values.get("userphone") usertype = request.values.get("usertype") usermovie = request.values.get("usermovie") scorenum = request.values.get("scorenum") usertype_new = request.values.get("usertype_new") flag=sql.android_user_like_trans(userphone,usertype,usermovie,scorenum,usertype_new) return jsonify({"data": flag}) #用户部分
#用户部分 #用户(app)注册 def android_register(name,phone,passwrod): cursor = None conn = None conn, cursor = get_conn() sql="insert into userdata (userphone,userpass,useremail,username) values(%s,%s,%s,%s)" cursor.execute(sql,[phone,passwrod,"",name]) conn.commit() close_conn(conn,cursor) print("注册成功(APP)") #用户(app)查询 def android_query(phone): sql="select userphone,userpass,useremail,username from userdata where userphone="+phone res = query(sql) print("用户(app)查询") print(sql) res_2=("","","","") try: print(res[0]) except: print(res_2) return res_2 return res[0] #用户(app)收藏 def android_like(userphone,usermovie,usertyppe,scorenum,url,score): cursor = None conn = None conn, cursor = get_conn() try: sql="insert into userlike(userphone,usermovie,usertype,scorenum,url,score) values(%s,%s,%s,%s,%s,%s)" cursor.execute(sql,[userphone,usermovie,usertyppe,scorenum,url,score]) conn.commit() close_conn(conn,cursor) except: traceback.print_exc() return 0 print("收藏(app)成功") return 1; #用户(app)收藏查询 def android_like_query(userphone,usertype): sql="select userphone,usermovie,usertype,scorenum,url,score from userlike where userphone='"+userphone+"' and usertype='"+usertype+"'" res = query(sql) print("用户(app)收藏查询") print(sql) print(res) return res #用户(app)收藏删除 def android_delete(userphone,usertype,usermovie,scorenum): cursor = None conn = None conn, cursor = get_conn() sql="delete from userlike where (userphone='"+userphone+"') and (usermovie='"+usermovie+ "') and (usertype='"+usertype+"') and (scorenum="+scorenum+") " try: print("用户(app)收藏删除") print(sql) cursor.execute(sql) conn.commit() close_conn(conn,cursor) return 1 except: traceback.print_exc() return 0 #用户(app)收藏查询单个 def android_like_query_one(userphone,usertype,usermovie,scorenum): sql="select * from userlike where (userphone='"+userphone+"') and (usermovie='"+usermovie+ "') and (usertype='"+usertype+"') and (scorenum="+scorenum+") " res = query(sql) print("用户(app)收藏查询单个") print(sql) try: print(res[0]) except: return 0 return 1 #用户(app)收藏转移 def android_user_like_trans(userphone,usertype,usermovie,scorenum,usertype_new): cursor = None conn = None conn, cursor = get_conn() if(android_like_query_one(userphone,usertype_new,usermovie,scorenum)): return -1 else: sql="update userlike set usertype='"+usertype_new+"' where (userphone='"+userphone+"') and (usermovie='"+usermovie+ "') and (usertype='"+usertype+"') and (scorenum="+scorenum+") " try: cursor.execute(sql) conn.commit() close_conn(conn, cursor) print("用户(app)收藏转移") print(sql) return 1 except: return 0 #用户部分