大二下学期团队项目（服务器后台用户部分）

以下主要是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
#用户部分