一、路由url(r'^login', views2.login),
url(r'^index', views2.index),
url(r'^test', views.test),
二、视图函数
导入pymysql模块def index(request): return render(request, 'index2.html')def login(request): if request.method == 'GET': return render(request, 'login.html') else:
name = request.POST.get('name')
password = request.POST.get('password') # 创建一个数据库链接
conn = pymysql.connect(host='127.0.0.1', user='root', password='123', database='userinfo', port=3306, ) # 拿到一个游标
cursor = conn.cursor() # 执行sql
cursor.execute('select * from user where name=%s and password=%s ', (name, password)) # 获取结果
ret = cursor.fetchone() print(ret) if ret: return redirect('/index') else: return HttpResponse('用户名或密码错误')
三、模板文件login.htmlTitle