數(shù)據(jù)庫查詢代碼

引入指定model文件
1 from .models import UserMessage
2 定義存儲數(shù)據(jù)的變量
3 給變量賦值

object.all方法 無條件

def getform(request):
    all_messages = UserMessage.objects.all()
    for message in all_messages:
        print(message.name)
    return render(request, 'message_form.html')

object.filter方法 有條件查詢

def getform(request):
    all_messages = UserMessage.objects.filter(name='bobby', address='上海')
    for message in all_messages:
        print(message.name)
    return render(request, 'message_form.html')

數(shù)據(jù)庫插入操作

使用model的方法
給各個字段賦值
使用save()方法

def getform(request):
    user_message = UserMessage()
    user_message.name = "lz"
    user_message.message = "月薪10w帥小伙"
    user_message.address = "北京"
    user_message.email = "lz@qq.com"
    user_message.object_id = "2"
    user_message.save()
    return render(request, 'message_form.html')

將頁面上的POST給后臺的數(shù)據(jù)獲取寫入數(shù)據(jù)庫

使用request.method 判斷 是否是POST請求
使用 request.POST.get方法獲取前端傳來的數(shù)據(jù)
最后用 model的方法賦值并保存

    if request.method == "POST":
        name = request.POST.get('name', '')
        message = request.POST.get('message', '')
        address = request.POST.get('address', '')
        email = request.POST.get('email', '')
        user_message = UserMessage()
        user_message.name = name
        user_message.message = message
        user_message.address = address
        user_message.email = email
        user_message.object_id = "3"
        user_message.save()