连接数据库
历史记录存在数据库中首先要连接数据库,在settings.py中进行配置:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'correct',
'USER':'root',
'PASSWORD':'123456',
'HOST':'localhost',
'PORT':'3306',
}
}
定义实体
定义纪录类的实体用来获取数据:
class record(models.Model):
sid=models.CharField('sid',max_length=50)
sname=models.CharField('sname',max_length=10)
compos=models.TextField('compos',null=False)
revise=models.TextField('revise')
trevise=models.TextField('trevise')
stime=models.CharField('stime',max_length=10)
sclass=models.CharField('sclass',max_length=10)
label=models.CharField('label',max_length=10)
class Meta:
db_table='record'
要想获取数据,执行:
python3 manage.py makemigrations
获取迁移文件:
获取分页数据
获取全部数据后调用Paginator实现分页:
def artshow(request,pindex):
art_obj = record.objects.all()
art_list = []
sid=request.session['user_id']
for i in art_obj:
if i.sid==sid:
art_list.append(i)
paginator = Paginator(art_list, 2)
if pindex == "":
pindex = 1
else:
int(pindex)
page = paginator.page(pindex)
context = { "page": page}
return render(request,"history.html", context)