在django项目中用layui为我的高血压网站建一个后台系统,后台导航栏内容包括药品信息管理菜单,下边设置两个下拉菜单显示药品信息管理和药品相互作用管理内容,药品信息管理页面对mysql库drug_db中的drug_list表(id drug_name)进行增删改查操作,药品相互作用信息管理负责对mysql库drug_db中的drug_interaction(drug_id drug1 drug2 interaction )中的内容进行增删改查操作
时间: 2023-06-27 17:02:36 浏览: 54
好的,首先你需要在django项目中安装并配置layui,具体可以参考layui官方文档。然后创建一个后台系统,包括导航栏和菜单。在导航栏中添加药品信息管理和药品相互作用管理两个菜单项,并设置下拉菜单。
接着,在药品信息管理页面中,你需要使用django提供的ORM框架,连接drug_db数据库中的drug_list表,并实现增删改查操作。例如:
```python
# models.py
from django.db import models
class Drug(models.Model):
drug_name = models.CharField(max_length=50)
# views.py
from django.shortcuts import render, redirect
from .models import Drug
def drug_list(request):
drugs = Drug.objects.all()
return render(request, 'drug_list.html', {'drugs': drugs})
def add_drug(request):
if request.method == 'POST':
drug_name = request.POST.get('drug_name')
drug = Drug(drug_name=drug_name)
drug.save()
return redirect('drug_list')
return render(request, 'add_drug.html')
def edit_drug(request, drug_id):
drug = Drug.objects.get(id=drug_id)
if request.method == 'POST':
drug_name = request.POST.get('drug_name')
drug.drug_name = drug_name
drug.save()
return redirect('drug_list')
return render(request, 'edit_drug.html', {'drug': drug})
def delete_drug(request, drug_id):
drug = Drug.objects.get(id=drug_id)
drug.delete()
return redirect('drug_list')
# urls.py
from django.urls import path
from . import views
urlpatterns = [
path('drug_list/', views.drug_list, name='drug_list'),
path('add_drug/', views.add_drug, name='add_drug'),
path('edit_drug/<int:drug_id>/', views.edit_drug, name='edit_drug'),
path('delete_drug/<int:drug_id>/', views.delete_drug, name='delete_drug'),
]
```
在药品相互作用信息管理页面中,你需要连接drug_db数据库中的drug_interaction表,并实现相应的增删改查操作。例如:
```python
# models.py
from django.db import models
from .drug import Drug
class DrugInteraction(models.Model):
drug = models.ForeignKey(Drug, on_delete=models.CASCADE)
drug1 = models.CharField(max_length=50)
drug2 = models.CharField(max_length=50)
interaction = models.TextField()
# views.py
from django.shortcuts import render, redirect
from .models import Drug, DrugInteraction
def drug_interaction_list(request):
interactions = DrugInteraction.objects.all()
return render(request, 'drug_interaction_list.html', {'interactions': interactions})
def add_interaction(request):
if request.method == 'POST':
drug_id = request.POST.get('drug_id')
drug = Drug.objects.get(id=drug_id)
drug1 = request.POST.get('drug1')
drug2 = request.POST.get('drug2')
interaction = request.POST.get('interaction')
interaction = DrugInteraction(drug=drug, drug1=drug1, drug2=drug2, interaction=interaction)
interaction.save()
return redirect('drug_interaction_list')
drugs = Drug.objects.all()
return render(request, 'add_interaction.html', {'drugs': drugs})
def edit_interaction(request, interaction_id):
interaction = DrugInteraction.objects.get(id=interaction_id)
if request.method == 'POST':
drug_id = request.POST.get('drug_id')
drug = Drug.objects.get(id=drug_id)
drug1 = request.POST.get('drug1')
drug2 = request.POST.get('drug2')
interaction_text = request.POST.get('interaction')
interaction.drug = drug
interaction.drug1 = drug1
interaction.drug2 = drug2
interaction.interaction = interaction_text
interaction.save()
return redirect('drug_interaction_list')
drugs = Drug.objects.all()
return render(request, 'edit_interaction.html', {'interaction': interaction, 'drugs': drugs})
def delete_interaction(request, interaction_id):
interaction = DrugInteraction.objects.get(id=interaction_id)
interaction.delete()
return redirect('drug_interaction_list')
# urls.py
from django.urls import path
from . import views
urlpatterns = [
path('drug_interaction_list/', views.drug_interaction_list, name='drug_interaction_list'),
path('add_interaction/', views.add_interaction, name='add_interaction'),
path('edit_interaction/<int:interaction_id>/', views.edit_interaction, name='edit_interaction'),
path('delete_interaction/<int:interaction_id>/', views.delete_interaction, name='delete_interaction'),
]
```
最后,在layui中添加对应的页面和表格样式即可完成后台系统的药品管理功能。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)