基于Python+Django+MySQL实现Web版的增删改查

为了实现Web版的增删改查（CRUD），你需要使用Python的Django框架和MySQL数据库。以下是实现CRUD操作的基本步骤和示例代码：

1. 安装Django和MySQL的Python库：

pip install django
pip install mysqlclient

2. 创建Django项目和应用：

django-admin startproject myproject
cd myproject
python manage.py startapp myapp

3. 配置settings.py以使用MySQL数据库：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mydatabase',
        'USER': 'mydatabaseuser',
        'PASSWORD': 'mypassword',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

4. 定义模型（models.py）：

from django.db import models
 
class MyModel(models.Model):
    name = models.CharField(max_length=100)
    description = models.TextField()

5. 迁移数据库和创建超级用户：

python manage.py makemigrations
python manage.py migrate
python manage.py createsuperuser

6. 在视图（views.py）中创建CRUD操作：

from django.shortcuts import render
from .models import MyModel
from django.http import HttpResponseRedirect
 
def create(request):
    if request.method == 'POST':
        name = request.POST['name']
        description = request.POST['description']
        MyModel.objects.create(name=name, description=description)
        return HttpResponseRedirect('/')
 
    return render(request, 'create.html')
 
def read(request):
    items = MyModel.objects.all()
    return render(request, 'read.html', {'items': items})
 
def update(request, pk):
    item = MyModel.objects.get(pk=pk)
    if request.method == 'POST':
        item.name = request.POST['name']
        item.description = request.POST['description']
        item.save()
        return HttpResponseRedirect('/')
 
    return render(request, 'update.html', {'item': item})
 
def delete(request, pk):
    item = MyModel.objects.get(pk=pk)
    if request.method == 'POST':
        item.delete()
        return HttpResponseRedirect('/')
 
    return render(request, 'delete.html', {'item': item})

7. 创建对应的HTML模板：

• create.html
• read.html (使用循环显示所有记录)
• update.html
• delete.html

8. 配置URLs（urls.py）：

from django.urls import path
from .views import create, read, update, delete
 
urlpatterns = [
    path('create/', create, name='create'),
    path('', read, name='read'),
    path('update/<int:pk>/', update, name='update'),
    path('delete/<int:pk>/', delete, name='delete'),
]

9. 运行Django开发服务器：

pyth