show databases;//查看已经有的数据库
create database guanwang;
1.使用pycharm新建django项目guan,新建App取名company
2.新建static目录,在static目录下新建css目录、js目录、img目录
3.新建media目录,在media目录下新建images目录
4.在settings的末尾增加代码
STATICFILES_DIRS=(os.path.join(BASE_DIR, 'static'),)
MEDIA_URL="/media/"
MEDIA_ROOT=os.path.join(BASE_DIR,"media")
5.在urls.py中
from django.contrib import admin
from django.urls import path
from django.views.static import serve
from guan.settings import MEDIA_ROOT
urlpatterns = [
path('admin/', admin.site.urls),
#配置上传文件的访问处理函数
path('media/<path:path>',serve,{'document_root':MEDIA_ROOT}),
]
1.安装PyMYSQL
pip install PyMYSQL
2.在项目guan下的guan目录下的__init__.py中
import pymysql
pymysql.install_as_MySQLdb()
3.在settings.py中
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': "guanwang",
'USER':'root',
'PASSWORD':'(数据库密码)',
'HOST':"127.0.0.1",
'PORT':'3306',
'OPTIONS':{'init_command':'SET default_storage_engine=INNODB;'}
}
}
4.执行数据更新命令
python manage.py makemigrations
python manage.py migrate
5.创建超级用户
python manage.py createsuperuser
Username:用户名
Email:邮箱
Password:自定义一个不少于8位的密码(密码不显示的)
Password(again):确认密码
在apps和extra_apps上分别,右键→Mark Directory as→Sources Root
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))#在这行下面添加如下代码
import sys
sys.path.insert(0,BASE_DIR)
sys.path.insert(0,os.path.join(BASE_DIR,'apps'))
sys.path.insert(0,os.path.join(BASE_DIR,'extra_apps'))
1.将DjangoUeditor导入extra_apps中
2.在settings.py中注册
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'company.apps.CompanyConfig',
'DjangoUeditor',
]
3.在urls.py中增加配置信息
#.....
from django.urls import include
urlpatterns = [
#......
path('ueditor/',include('DjangoUeditor.urls' )),
]
import xadmin
from xadmin import views
class BaseSetting(object):
enable_themes = True
use_bootswatch = True
class GlobalSettings(object):
site_title = "落忆网络科技后台管理系统"
site_footer = "luoyikeji"
# menu_style = "accordion"
xadmin.site.register(views.BaseAdminView, BaseSetting)
xadmin.site.register(views.CommAdminView, GlobalSettings)
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'company.apps.CompanyConfig',
'DjangoUeditor',
'crispy_forms',
'xadmin'
]
pip install django-crispy-forms django-reversion django-formtools future httplib2 six django-import-export
pip install xlwt xlsxwriter
import xadmin
urlpatterns = [
path('xadmin/', xadmin.site.urls),
#....
]
python manage.py makemigrations
python manage.py migrate
1.在settings.py中
LANGUAGE_CODE = 'zh-hans'
TIME_ZONE = 'Asia/Shanghai'
USE_I18N = True
USE_L10N = True
USE_TZ = False
2.在apps/company/apps.py中
from django.apps import AppConfig
class CompanyConfig(AppConfig):
name = 'company'
verbose_name = '公司信息'
访问:http://127.0.0.1:8000/xadmin/ 然后用超级用户的身份登录
效果图