56天.图书管理系统

浅浅的花香味﹌ 2023-08-17 17:48 90阅读 0赞

## 图书管理系统 ##

前期工作

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

更改数据库配置
    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.mysql',
            'NAME': 'day56',
            'USER':'root',
            'PASSWORD':'123',
            'HOST':'127.0.0.1',
            'PORT':3306,
            'CHARSET':'utf8'
        }
    }
    
    环境配置
    
    STATICFILES_DIRS = [
        os.path.join(BASE_DIR,'static')
    ]

settings.py

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

import pymysql
    pymysql.install_as_MySQLdb()

\_\_init\_\_.py

表模型

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

from django.db import models
    
    # Create your models here.
    
    class MyChar(models.Field):
        def __init__(self,max_length,*args,**kwargs):
            self.max_length = max_length
            super().__init__(*args,**kwargs)
    
        def  db_type(self, connection):
            return 'char(%s)' % self.max_length
    
    
    class Book(models.Model):
        title = models.CharField(max_length=64)
        price = models.DecimalField(max_digits=8,decimal_places=2)
        create_time = models.DateField(auto_now_add=True)
    
    # 外键
        publish = models.ForeignKey(to='Publish')
        authors = models.ManyToManyField(to='Author')
    
        def __str__(self):
            return self.title
    
    
    class Publish(models.Model):
        name = models.CharField(max_length=32)
        addr = models.CharField(max_length=64)
    
        def __str__(self):
            return self.name
    
    class Author(models.Model):
        name = models.CharField(max_length=64)
        age = models.IntegerField()
    
        author_detail = models.OneToOneField(to='AuthorDetail')
    
        def __str__(self):
            return self.name
    
    class AuthorDetail(models.Model):
        phone = models.BigIntegerField()
        addr = models.CharField(max_length=32)
    
    
        def __str__(self):
            return self.addr
    
    
    
    """
        models.py中的模型类__str__方法 必须返回一个字符串形式数据!!!
    
    """

models.py

启动连接数据库:

![1659204-20190920214937897-1572647993.png][]

输入命令:

![1659204-20190920215158162-514531604.png][]

![1659204-20190920215210006-1645349055.png][]

数据库框架创立成功,填写数据。

转载于:https://www.cnblogs.com/komorebi/p/11559982.html

[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20230808/65ce83d77cd3498789d31b2d661768c4.png
[1659204-20190920214937897-1572647993.png]: /images/20230808/69a5cbf49c3b49ec802e3c7ad9291233.png
[1659204-20190920215158162-514531604.png]: /images/20230808/5e0220aa2d394b4fb68c80a01f0538c1.png
[1659204-20190920215210006-1645349055.png]: /images/20230808/76a46db8d58c416099512e425764585a.png