views.py
def index8(request):
cursor = connection.cursor() #获取游标
cursor.execute(“insert into book(id,name,author) values(null,‘三轩演义’,‘罗管中’)”) #执行插入数据库操作
rows = cursor.fetchall() #取行
for row in rows:
print(row)
return render(request,‘first.html’)
urls.py
path(‘index8/’,views.index8,name=‘index8’)
settings.py
DATABASES = {
‘default’: {
# ‘ENGINE’: ‘django.db.backends.sqlite3’,
# ‘NAME’: os.path.join(BASE_DIR, ‘db.sqlite3’),
# ‘ENGINE’: ‘C:\ProgramData\MySQL\MySQL Server 5.7\Data\db1’,
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘db1’,
‘USER’: ‘root’,
‘PASSWORD’: ‘xxxxx’,
‘HOST’: ‘localhost’,
‘PORT’: ‘3306’
}
}
http://127.0.0.1:8080/index8/执行一次即增加一行,
数据库如下