python开发接口

最新推荐文章于 2021-05-17 18:51:35 发布

caiyong_

最新推荐文章于 2021-05-17 18:51:35 发布

阅读量457

点赞数

CC 4.0 BY-SA版权

分类专栏： python-接口开发文章标签： python

本文链接：https://blog.youkuaiyun.com/caiyong_/article/details/83276824

python-接口开发专栏收录该内容

1 篇文章

订阅专栏

该博客介绍了如何使用Python的Flask框架和cx_Oracle模块建立一个接口，该接口与Oracle数据库交互进行用户登录验证。通过接收账号和密码，进行MD5加密并与数据库中的信息比对，返回相应的登录状态消息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import json,flask
from flask import request,jsonify
import cx_Oracle as oracle
import hashlib

def jiaoyan(user):
db = oracle.connect(‘pj_core’, ‘pj_core’, ‘192.168.55.5:1521/ljcprd’)
cur = db.cursor()
cur.execute(‘select SQDLZH,DLMM from SYR_SQGX where SQDLZH=%r’ % user)
row = cur.fetchone()
db.close()
return row
def jiami(pwd):
hl = hashlib.md5(pwd.encode(encoding=‘UTF-8’)).hexdigest().upper()
return hl
server = flask.Flask(name)
@server.route(’/login’, methods=[‘get’, ‘post’])
def denglu():
number = request.values.get(‘SJH’)
password = request.values.get(‘PWD’)
print(number,password)
if number== ‘’:
message = {‘msg’: “账号为空”, ‘msg_code’: “202”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)
elif number.isdigit() == False:
message = {‘msg’: “账号格式有误，为纯数字”, ‘msg_code’: “201”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)
else:
result = jiaoyan(number)
mima = jiami(password)
print(password,mima,result[1])
if result == None:
message = {‘id’: “账号不存在”, ‘msg_code’: “203”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)
elif result[0]==number:
if mima == result[1]:
message = {‘id’: “成功登录”, ‘msg_code’: “200”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)
elif mima != result[1]:
message = {‘id’: “密码有误”, ‘msg_code’: “204”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)
else:
message = {‘id’: “请再次输入”, ‘msg_code’: “205”}
return json.dumps(message, sort_keys=True, indent=2, ensure_ascii=False)