4.在my_site内的子文件my_site内的[settings.py]文件内容 DATABASES 配置项修改成:
ATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql', # 数据库引擎
'NAME': 'my_datas',
'HOST' :'localhost',
'PORT': 3306,
'USER': 'root',
'PASSWORD' : '123456',
}
}
6.在testdb.py文件代码整理后:
代码如下(示例):
import mysql.connector
from django.http import HttpResponse
def index(request):
my_db = mysql.connector.connect(
host='localhost',
user='root',
passwd='123456',
database='my_datas' # 创建后加入
)
my_cursor = my_db.cursor()
#创建数据库:
my_cursor.execute("CREATE DATABASE my_datas")
#检验数据库创建是否成功:
print(my_db)
输出:<mysql.connector.connection_cext.CMySQLConnection object at 0x000001D63040AFD0> #标明已经创建成功了.
#数据库中创建数据表:
my_cursor.execute('CREATE TABLE table_01 (name VARCHAR(255), url VARCHAR(255))'
my_cursor.execute("SELECT * FROM table_01")
my_result = my_cursor.fetchall()
# val = ()
# for x in my_result:
#增加数据:
# my_cursor.execute("INSERT INTO table_01(name, url) VALUES ('Jingdong', 'https://www.jd.com/')")
# my_cursor.execute("INSERT INTO table_01(name, url) VALUES ('Amazon','https://www.amazon.cn/')")
#删除数据:
# my_cursor.execute('DELETE FROM table_01 WHERE name ="jingdong"')
# my_cursor.execute('DELETE FROM table_01 WHERE name ="Amazon"')
my_db.commit()
list = []
for val in my_result:
list.append(val)
list.append('<br>')
return HttpResponse(list)
8.在my_sites内的my_sites子文件中url.py整理后:
代码如下(示例):
from django.urls import path
from my_site import testdb
urlpatterns = [
path('index/', testdb.index),
]
> 最后剩下以上代码
9.启动项目:
python manage.py runserver IP(自己定义,默认8000)