啟動項目命令
python manage.py runserver
動態獲取當前時間
javascript實現數據動態更新代碼
<script>setInterval(function() {var currentTimeElement = document.getElementById('current-time');var currentTime = new Date();currentTimeElement.textContent = 'Current time: ' +currentTime.getFullYear() + '-' +(currentTime.getMonth() + 1) + '-' +currentTime.getDate() + ' ' + currentTime.getHours() + ':'+ currentTime.getMinutes() + ':' + currentTime.getSeconds();}, 1000); // Update every second</script>
實現數據添加功能
實現數據刪除功能
創建django項目命令,在需要生成項目的文件夾中打開終端運行
django-admin startproject mysite
數據庫啟動
mysql -u root -p
生成app命令
python manage.py startapp app01
注冊app
orm建成數據庫表(外鍵),性別約束
?自己創建數據庫
啟動mysql服務
mysql -u root -p
自帶工具創建數據庫
create database t_day1 DEFAULT CHARSET utf8 COLLATE utf8_general_ci
修改setting.py文件里面數據庫的內容
DATABASES = {'default': {'ENGINE': 'django.db.backends.mysql','NAME':'dbname','USER': 'root','PASSWORD': 'xxx','HOST': '','PORT': '',}
}
django命令生成數據庫表
python manage.py makemigrations
python manage.py migrate
查看數據庫表
表結構創建成功
靜態文件和模板文件(jQuery以及bootstrap有需要的可以私信)
部門管理
先體驗
后續:Django中提供Form和ModelForm組件(方便)
使用bootstrap表格樣式
{% load static %}
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="{% static 'plugins/bootstrap-3.3.5/css/bootstrap.css' %}"><style>.navbar{border-radius: 0;}</style>
</head>
<body>
<nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button><a class="navbar-brand" href="#">聯通用戶管理系統</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav"><li><a href="#">Link</a></li></ul><ul class="nav navbar-nav navbar-right"><li><a href="#">Link</a></li><li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a><ul class="dropdown-menu"><li><a href="#">Action</a></li><li><a href="#">Another action</a></li><li><a href="#">Something else here</a></li><li role="separator" class="divider"></li><li><a href="#">Separated link</a></li></ul></li></ul></div></div>
</nav>
<script src="/static/js/jquery-3.7.1.min.js"></script>
<script src="/static/plugins/bootstrap-3.3.5/js/bootstrap.js"></script>
</body>
</html>
構建按鈕樣式
{% load static %}
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="{% static 'plugins/bootstrap-3.3.5/css/bootstrap.css' %}"><style>.navbar{border-radius: 0;}</style>
</head>
<body>
<nav class="navbar navbar-default"><div class="container"><div class="navbar-header"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse"data-target="#bs-example-navbar-collapse-1" aria-expanded="false"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button><a class="navbar-brand" href="#">聯通用戶管理系統</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav"><li><a href="/depart/list/">部門管理</a></li><li><a href="#">Link</a></li></ul><ul class="nav navbar-nav navbar-right"><li><a href="#">登錄</a></li><li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"aria-expanded="false">張三 <span class="caret"></span></a><ul class="dropdown-menu"><li><a href="#">個人資料</a></li><li><a href="#">我的信息</a></li><li role="separator" class="divider"></li><li><a href="#">注銷</a></li></ul></li></ul></div></div>
</nav><div><div class="container"><div style="margin-bottom: 10px"><a class="btn btn-success" href="#"><span class="glyphicon glyphicon-plus-sign" aria-hidden="true"></span>新建部門</a></div><div class="panel panel-default"><!-- Default panel contents --><div class="panel-heading"><span class="glyphicon glyphicon-th-list" aria-hidden="true"></span>部門列表</div><!-- Table --><table class="table table-bordered"><thead><tr><th>ID</th><th>名稱</th><th>操作</th></tr></thead><tbody><tr><th>1</th><td>銷售部</td><td><a class="btn btn-primary btn-xs">編輯</a><a class="btn btn-danger btn-xs">刪除</a></td></tr></tbody></table></div></div>
</div>
<script src="/static/js/jquery-3.7.1.min.js"></script>
<script src="/static/plugins/bootstrap-3.3.5/js/bootstrap.js"></script>
</body>
</html>
讀取數據庫數據顯示在頁面上
target="_blank"表示可以在新建頁面打開
表格數據新建部門增加面板
{% load static %}
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="{% static 'plugins/bootstrap-3.3.5/css/bootstrap.css' %}"><style>.navbar{border-radius: 0;}</style>
</head>
<body>
<nav class="navbar navbar-default"><div class="container"><div class="navbar-header"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse"data-target="#bs-example-navbar-collapse-1" aria-expanded="false"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button><a class="navbar-brand" href="#">聯通用戶管理系統</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav"><li><a href="/depart/list/">部門管理</a></li><li><a href="#">Link</a></li></ul><ul class="nav navbar-nav navbar-right"><li><a href="#">登錄</a></li><li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"aria-expanded="false">張三 <span class="caret"></span></a><ul class="dropdown-menu"><li><a href="#">個人資料</a></li><li><a href="#">我的信息</a></li><li role="separator" class="divider"></li><li><a href="#">注銷</a></li></ul></li></ul></div></div>
</nav><div><div class="container"><div style="margin-bottom: 10px"><a class="btn btn-success" href="/depart/add/" target="_blank"><span class="glyphicon glyphicon-plus-sign" aria-hidden="true"></span>新建部門</a></div><div class="panel panel-default"><!-- Default panel contents --><div class="panel-heading"><span class="glyphicon glyphicon-th-list" aria-hidden="true"></span>部門列表</div><!-- Table --><table class="table table-bordered"><thead><tr><th>ID</th><th>名稱</th><th>操作</th></tr></thead><tbody>{% for obj in queryset %}<tr><th>{{ obj.id }}</th><td>{{ obj.title }}</td><td><a class="btn btn-primary btn-xs">編輯</a><a class="btn btn-danger btn-xs">刪除</a></td></tr>{% endfor %}</tbody></table></div></div>
</div>
<script src="/static/js/jquery-3.7.1.min.js"></script>
<script src="/static/plugins/bootstrap-3.3.5/js/bootstrap.js"></script>
</body>
</html>
bootstrap中文網全局 CSS 樣式 · Bootstrap v3 中文文檔 | Bootstrap 中文網 (bootcss.com)中也可以使用這樣的方式去拿組件
必須要加{% csrf_token %}
表格數據刪除部門
第二種傳參方式
實現部門數據修改操作
使用模板,占位符
模板代碼
{% load static %}
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="{% static 'plugins/bootstrap-3.3.5/css/bootstrap.css' %}"><style>.navbar{border-radius: 0;}</style>
</head>
<body>
<nav class="navbar navbar-default"><div class="container"><div class="navbar-header"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse"data-target="#bs-example-navbar-collapse-1" aria-expanded="false"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button><a class="navbar-brand" href="#">聯通用戶管理系統</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav"><li><a href="/depart/list/">部門管理</a></li><li><a href="#">Link</a></li></ul><ul class="nav navbar-nav navbar-right"><li><a href="#">登錄</a></li><li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"aria-expanded="false">張三 <span class="caret"></span></a><ul class="dropdown-menu"><li><a href="#">個人資料</a></li><li><a href="#">我的信息</a></li><li role="separator" class="divider"></li><li><a href="#">注銷</a></li></ul></li></ul></div></div>
</nav><div>{% block content %}{% endblock %}
</div>
<script src="/static/js/jquery-3.7.1.min.js"></script>
<script src="/static/plugins/bootstrap-3.3.5/js/bootstrap.js"></script>
</body>
</html>
繼承模板
{% extends 'layout.html' %}{% block content %}<div class="container"><div class="panel panel-default"><div class="panel-heading"><h3 class="panel-title">新建部門</h3></div><div class="panel-body"><form method="post">{% csrf_token %}<div class="form-group"><label>標題</label><input type="text" class="form-control" placeholder="標題" name="title"></div><button type="submit" class="btn btn-primary">提 交</button></form></div></div></div>
{% endblock %}
可以嵌套多個
用戶管理
查看數據庫命令
show databases; use t_day2; show tables; desc app01_userinfo;
+-------------+---------------+------+-----+---------+----------------+
| Field ? ? ? | Type ? ? ? ? ?| Null | Key | Default | Extra ? ? ? ? ?|
+-------------+---------------+------+-----+---------+----------------+
| id ? ? ? ? ?| bigint ? ? ? ?| NO ? | PRI | NULL ? ?| auto_increment |
| name ? ? ? ?| varchar(16) ? | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| password ? ?| varchar(64) ? | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| age ? ? ? ? | int ? ? ? ? ? | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| account ? ? | decimal(10,2) | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| create_time | datetime(6) ? | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| gender ? ? ?| smallint ? ? ?| NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
| depart_id ? | bigint ? ? ? ?| NO ? | MUL | NULL ? ?| ? ? ? ? ? ? ? ?|
+-------------+---------------+------+-----+---------+----------------+
datetime轉字符串數據類型
取字段對應的值
怎么根據外鍵取到對應的值的方法
Django頁面展示