2019.1.1新年快乐，今天从新复习了数据库的增删改查

本文介绍了一个酒店管理系统的模型设计，包括客户、房间及订单管理。详细展示了如何使用Django框架进行数据库设计，涵盖了客户信息、房间类型及状态、订单处理等功能模块。

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

这是一个酒店的模型

from django.db import models


# Create your models here.
class Client(models.Model):
    GENDER_CHOICES=(
        ('male',u"男"),
        ('female',u"女"),
        ('secret',u"保密")

    )
    name =models.CharField(max_length=100)
    gender =models.CharField(max_length=10,choices=GENDER_CHOICES,default="secret")
    telephone = models.CharField(max_length=11,unique=True)
    ID_num=models.CharField(max_length=20,unique=True)
    def __str__(self):
        return "<Client:({name},{gender},{telephone},{ID_num})>".format(name=self.name,gender=self.gender,telephone=self.telephone,ID_num=self.ID_num)


class Room(models.Model):
    TYPE_CHOICES =(
        (1,"big"),
        (2,"middle"),
        (3,"small")
    )
    STATE_CHOICES = (
        (1,u"empty"),
        (2,u"full")
    )
    num = models.IntegerField()
    type =models.CharField(max_length=2,choices =TYPE_CHOICES)
    address =models.TextField()
    price =models.FloatField()
    state =models.CharField(max_length=2,choices=STATE_CHOICES,default=1)
    remark=models.TextField(null=True)


class RoomOrder(models.Model):
    client = models.ForeignKey("Client",on_delete=models.CASCADE )
    room =models.ForeignKey("Room",on_delete=models.CASCADE)
    startDate = models.DateTimeField(auto_now_add=True)
    endDate = models.DateTimeField(auto_now=True)
    remark = models.TextField()

    class Meta:
        ordering =['-startDate']

配置数据库

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'restaurant',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'USER': 'root',
        'PASSWORD':'7923161',

    }
}

码农们的必备技能增删改查。复习完毕。明天贴上实战项目。

from django.shortcuts import render
from django.shortcuts import HttpResponse
from datetime import datetime
from .models import RoomOrder,Client,Room
# Create your views here.


def index(request):
    return HttpResponse("酒店页面")


    def roomorder(request):
        #增加数据
        # client =Client(name='罗伟中',gender='male',telephone=13698546412,ID_num=4419041975012123)
        # client.save()
        # return HttpResponse("酒店下单系统")
        # 查询并且改动数据
        # client =Client.objects.get(pk=2)
        # client.gender="female"
        # client.save()
        #删除数据
        client = Client.objects.get(pk=2)
        client.delete()
        print(client)
        return HttpResponse("我在查询")