Simple Basketball Information Management System with CRUD and Pagination Using Django

The article introduces a simple basketball information management system built with Django, aiming to share the implementation details and invite feedback from fellow developers.

Features : the system supports creating, reading, updating, and deleting player records, and displays the data on a front‑end page with pagination.

Main code (view function) :

def qiuyuan(request):
    qiuyuans = models.qiuyuan.objects.all()
    pn = request.GET.get('pn', 1)
    try:
        pn = int(pn)
    except:
        pn = 1
    # search
    keyword = request.GET.get('keyword', None)
    if keyword is not None:
        qiuyuans = models.qiuyuan.objects.filter(xingming__icontains=keyword).all()
    else:
        qiuyuans = models.qiuyuan.objects.all()
    # pagination
    paginator = Paginator(qiuyuans, 5)  # a1: query set, a2: items per page
    try:
        qiuyuans = paginator.page(pn)  # get records of the requested page
    except (EmptyPage, InvalidPage, PageNotAnInteger) as e:
        pn = 1
        qiuyuans = paginator.page(pn)
    num_pages = qiuyuans.paginator.num_pages
    # pagination number display logic
    if num_pages >= 5:
        if pn <= 2:
            start = 1
            end = 6
        elif pn > num_pages - 2:
            start = num_pages - 1
            end = num_pages + 1
        else:
            start = pn - 2
            end = pn + 3
    else:
        start = 1
        end = num_pages + 1
    numbers = range(start, end)
    context = {
        'qiuyuan': 'active',
        'qiuyuans': qiuyuans,
        'num_pages': num_pages,
        'numbers': numbers,
        'pn': pn,
    }
    return render(request, 'houtai/qiuyuan.html', context)

2. Add Information Template (HTML table with Django template tags):

{% extends 'houtai/base.html' %}
{% block main %}
<table class="table table-bordered" method="post">
<tr>
<th>ID</th><th>球员姓名</th><th>球员国籍</th><th>球衣号码</th><th>场上位置</th><th>球员年龄</th><th>球员身高</th><th>球员体重</th><th>所在俱乐部</th><th>操作</th>
</tr>
{% for qy in qiuyuans %}
<tr>
<td>{{ qy.id }}</td>
<td>{{ qy.xingming }}</td>
<td>{{ qy.guoji }}</td>
<td>{{ qy.haoma }}</td>
<td>{{ qy.weizhi }}</td>
<td>{{ qy.nianling }}</td>
<td>{{ qy.shenggao }}</td>
<td>{{ qy.tizhong }}</td>
<td>{{ qy.jlb.mingcheng }}</td>
<td><a href="{% url 'houtai:qy_del' %}?id={{qy.id}}" onclick="return confirm('你确定要删除吗')">删除</a> <a href="{% url 'qy_edit' %}?id={{qy.id}}">修改</a></td>
</tr>
{% endfor %}
</table>
<tr><submit><a href="{% url 'qy_add' %}">添加</a></submit></tr>
{% include 'houtai/qy_page.html' %}
{% endblock %}

3. Edit Information Form (HTML form with Django variables):

<form class="form-vertical" action="?id={{qy.id}}" method="post">
<div class="form-group col-md-6 col-md-offset-3">
    &lt;lable&gt;球员姓名&lt;/lable&gt;
    &lt;input type="text" class="form-control" placeholder="球员姓名" name="xingming" value="{{qy.xingming}}"&gt;
</div>
<div class="form-group col-md-6 col-md-offset-3">
    &lt;lable&gt;球员国籍&lt;/lable&gt;
    &lt;input type="text" class="form-control" placeholder="球员国籍" name="guoji" value="{{qy.guoji}}"&gt;
</div>
<!-- additional fields for number, position, age, height, weight -->
<div class="form-group col-md-6 col-md-offset-3">
    &lt;lable&gt;所在俱乐部&lt;/lable&gt;
    &lt;select class="form-control" name="jlb_id"&gt;
        {% for jj in jianjies %}
            {% if jj.id == qy.jlb_id %}
                &lt;option value="{{jj.id}}" selected="selected"&gt;{{jj.mingcheng}}&lt;/option&gt;
            {% else %}
                &lt;option value="{{jj.id}}"&gt;{{jj.mingcheng}}&lt;/option&gt;
            {% endif %}
        {% endfor %}
    &lt;/select&gt;
</div>
<div class="form-group col-md-6 col-md-offset-3">
    &lt;input type="submit" class="form-control btn btn-danger" value="修改"&gt;
</div>
&lt;/form&gt;

The article also includes screenshots of the administrator interface, front‑end pages, and login page, demonstrating the visual result of the system.