shadouhui.cn

成功源于坚持

0%

django连接数据库

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
pycharm 默认的数据库是sqlite3
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
}
}
1.第一步:把sqlite3改为mysql
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'day60',
'USER':'root',
'PASSWORD':'7344395',
'PORT':'3306',
'CHARSET':'utf8'
}
}
2.第二步:代码声明
django默认的是mysqldb模块连接mysql,但是该模块的兼容性不好,需要
手动改为pymysql。
你需要告诉django不要用默认的mysqldb还是用pysql

#在项目名的init或任意应用名下的init文件中书写下面两句话
import pymysql
pymysql.install_as_MySQLdb()

操作mysql

1.Django orm

1.Django orm
可以简单、快速的操作数据库, 不足:封装程度太高,有时候自己要写sql语句
应用下面的model.py文件

login.html

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Forbidden (403)
CSRF verification failed. Request aborted.

You are seeing this message because this site requires a CSRF cookie when submitting forms. This cookie is required for security reasons, to ensure that your browser is not being hijacked by third parties.

If you have configured your browser to disable cookies, please re-enable them, at least for this site, or for 'same-origin' requests.

Help
Reason given for failure:

CSRF cookie not set.

In general, this can occur when there is a genuine Cross Site Request Forgery, or when Django's CSRF mechanism has not been used correctly. For POST forms, you need to ensure:

Your browser is accepting cookies.
The view function passes a request to the template's render method.
In the template, there is a {% csrf_token %} template tag inside each POST form that targets an internal URL.
If you are not using CsrfViewMiddleware, then you must use csrf_protect on any views that use the csrf_token template tag, as well as those that accept the POST data.
The form has a valid CSRF token. After logging in in another browser tab or hitting the back button after a login, you may need to reload the page with the form, because the token is rotated after a login.
You're seeing the help section of this page because you have DEBUG = True in your Django settings file. Change that to False, and only the initial error message will be displayed.

You can customize this page using the CSRF_FAILURE_VIEW setting.

提交时出现这个页面,可以在settings.py中把这个CsrfViewMiddleware注释掉。

设置的方法为: # ‘django.middleware.csrf.CsrfViewMiddleware’, 先把这一行代码注释掉

1
2
3
4
5
6
7
8
9
10

MIDDLEWARE = [
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
# 'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="/static/bootstrap/css/bootstrap.css">
<link rel="stylesheet" href="/static/bootstrap/css/bootstrap.min.css">
<title>用户登录</title>
</head>
<body>
<div class="container">
<h1 class="text-center">登陆</h1>
</div>
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<form action="" method="post">
<p>用户名:<input type="text" name="username" class="form-control"></p>
<p>密 码:<input type="password" name="password" class="form-control"></p>
<p>
<input type="checkbox" name="hobby" value="111">游泳
<input type="checkbox" name="hobby" value="222">唱歌
<input type="checkbox" name="hobby" value="333">跳舞
</p>
<input type="submit" class="btn btn-success btn-block">
</form>
</div>
</div>
</div>
</body>
</html>

上面是login.html

下面是login函数

1
2
3
4
5
6
7
8
9
10
def login(request):
# print(request.method) 返回请求的方式,是一个大写的字符串
# print(request.POST) 返回的是一个字典,如下
# <QueryDict: {'username': ['111'], 'password': ['111'], 'hobby': ['222']}>
if request.method=="POST":
username = request.POST.get('username') # 只获取列表的最后一个元素
print(f'用户名是:{username}')
hobby= request.POST.getlist('hobby') # 获取一个列表
print(f'你的爱好是:{hobby}') #返回的值是:你的爱好是:['111', '222', '333']
return render(request, 'login.html')

django学习


在settings.py中绑定app01,这是一个简版

2022-05-09_160021.png

1.用命令输入的时候没有templates文件夹,所以要在项目中创建templates文件夹。

2022-05-09_161129.png

2.在Settings.py中绑定Templates文件夹

2022-05-09_161248.png


基本操作

在views.py在写函数,在urls.py中绑定函数

2022-05-09_164142.png

2022-05-09_164513.png