Django学习笔记01

1. django模板语法

• python后端代码

def user_list(request):
   # print("请求方式：" + request.method)

    name = "娅娅"

    users = ["张三", "李四", "王五", "赵六"]

    userinfo = {"name": "小明", "age": "18", "telephone": "1881888888", "sex": "男"}

    data_list = [
        {"name": "小明", "age": "18", "telephone": "1881888888", "sex": "男"},
        {"name": "小红", "age": "19", "telephone": "1999999999", "sex": "女"},
        {"name": "小黄", "age": "20", "telephone": "1777777777", "sex": "男"},
    ]

    return render(request, "index.html", {"name": name, "users": users, "userinfo": userinfo, "data_list": data_list})

• 前端代码

<div>{{ name }}</div>
<div>
    {% for user in users %}
        <span>{{ user }}</span>
    {% endfor %}
</div>
<hr>
{#遍历键#}
<div>
    {% for info in userinfo.keys %}
        <span>{{ info }}</span>
    {% endfor %}
    <hr>
    {#遍历值#}
    {% for info in userinfo.values %}
        <span>{{ info }}</span>
    {% endfor %}

</div>
<hr>
{#遍历键和值#}
<div>
    {% for k,v in userinfo.items %}
        <span>{{ k }}:{{ v }}</span><br>
    {% endfor %}
</div>
<hr>
<div>
    {% for user in data_list %}
        <span>{{ user.name }}</span><br>
        <span>{{ user.age }}</span><br>
        <span>{{ user.telephone }}</span><br>
        <span>{{ user.sex }}</span><br>
    {% endfor %}
</div>

<div>
    {% if name == "冯杰" %}
        <h1>Yes</h1>
    {% elif name == "娅娅" %}
        <h1>this is YaYa</h1>
    {% else %}
        <h1>No</h1>
    {% endif %}
</div>

2. 数据库连接配置

# 数据库连接配置,如果报错加上下面两行代码
#import pymysql
#pymysql.install_as_MySQLdb()

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'database',
        'USER': 'username',
        'PASSWORD': 'password',
        'HOST': '127.0.0.1',
        'PORT': '3306',
    }
}

3. models.py 代码

class User(models.Model):
    name = models.CharField(max_length=50)
    password = models.CharField(max_length=20)
    telephone = models.CharField(max_length=11)
    sex = models.IntegerField()
    age = models.IntegerField()
    deleted = models.IntegerField(default=0)

4. 创建数据库表：

	python manage.py makemigrations
	python manage.py migrate

5. 查询

#查询所有
user_list = User.objects.all()
#按条件查询
user = User.objects.filter(id=1).first()

6. 添加

User.objects.create(name=name, password="123456", telephone="13195124883", sex=2, age=18)

7. 修改

#修改所有
User.objects.all().update(password=111111)
#按条件修改
User.objects.filter(id=1).update(password=123456)

8. 删除

User.objects.filter(id=11).delete()