Simple Basketball Information Management System with Django

The author shares a simple basketball information management system and invites feedback from fellow developers.

Features: The system implements create, read, update, and delete (CRUD) operations for player information and displays the data on a front‑end page.

Main code: The following Django view handles player queries, keyword search, pagination, and renders the admin template.

<code><span><span>def</span> <span>qiuyuan</span>(<span>request</span>):</span>
<span>    qiuyuans = models.qiuyuan.objects.<span>all</span>()</span>
<span>    pn=request.GET.get(<span>'pn'</span>,<span>1</span>)</span>
<span>    <span>try</span>:</span>
<span>        pn=<span>int</span>(pn)</span>
<span>    <span>except</span>:</span>
<span>        pn=<span>1</span></span>
<span>    <span>#搜索</span></span>
<span>    keyword=request.GET.get(<span>'keyword'</span>,<span>None</span>)</span>
<span>    <span>if</span> keyword <span>is</span> <span>not</span> <span>None</span>:</span>
<span>        qiuyuans=models.qiuyuan.objects.<span>filter</span>(xingming__icontains=keyword).<span>all</span>()</span>
<span>    <span>else</span>:</span>
<span>        qiuyuans=models.qiuyuan.objects.<span>all</span>()</span>
<span>    <span>#分页，分上一页和下一页</span></span>
<span>    paginator=Paginator(qiuyuans,<span>5</span>) <span>#a1:查询结果集 a2:每页显示记录数</span></span>
<span>    <span>try</span>:</span>
<span>        qiuyuans=paginator.page(pn)  <span>#获取某一页记录</span></span>
<span>    <span>except</span> (EmptyPage,InvalidPage,PageNotAnInteger) <span>as</span> e:</span>
<span>        pn=<span>1</span></span>
<span>        qiuyuans=paginator.page(pn)</span>
<span>    <span>#获取总页数</span></span>
<span>    num_pages=qiuyuans.paginator.num_pages</span>
<span>    <span>#分页数字显示</span></span>
<span>    <span>#显示5个数字，当前页数放在中间（高亮显示）</span></span>
<span>    <span>if</span> num_pages&gt;=<span>5</span>:  <span>#总页数大于你想要的显示的分页数字</span></span>
<span>        <span>if</span> pn&lt;=<span>2</span>:</span>
<span>            start=<span>1</span></span>
<span>            end=<span>6</span></span>
<span>        <span>elif</span> pn&gt;num_pages-<span>2</span>:</span>
<span>            start=num_pages-<span>1</span></span>
<span>            end=num_pages+<span>1</span></span>
<span>        <span>else</span>:</span>
<span>            start=pn-<span>2</span></span>
<span>            end=pn+<span>3</span></span>
<span>    <span>else</span>:</span>
<span>        start=<span>1</span></span>
<span>        end=num_pages+<span>1</span></span>
<span>    numbers=<span>range</span>(start,end)</span>
<span>    context = {</span>
<span>        <span>'qiuyuan'</span>: <span>'active'</span>,</span>
<span>        <span>'qiuyuans'</span>: qiuyuans,</span>
<span>        <span>'num_pages'</span>:num_pages,</span>
<span>        <span>'numbers'</span>:numbers,</span>
<span>        <span>'pn'</span>:pn,</span>
<span>    }</span>
<span>    <span>return</span> render(request,<span>'houtai/qiuyuan.html'</span>,context)</span></code>

Add information template: This Django template extends a base layout and renders a table of player fields with actions for deletion and modification, plus a link to add new records.

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

Edit information template: This form allows updating a player's details, including name, nationality, number, position, age, height, weight, and club selection.

<code><span>&lt;form class="form-vertical" action="?id={{qy.id}}" method="post"&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球员姓名&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球员姓名" name="xingming" value="{{qy.xingming}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球员国籍&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球员国籍" name="guoji" value="{{qy.guoji}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球衣号码&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球衣号码" name="haoma" value="{{qy.haoma}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;场上位置&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="场上位置" name="weizhi" value="{{qy.weizhi}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球员年龄&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球员年龄" name="nianling" value="{{qy.nianling}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球员身高&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球员身高" name="shenggao" value="{{qy.shenggao}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;球员体重&lt;/lable&gt;</span>
<span>        <span>&lt;input type="text" class="form-control" placeholder="球员体重" name="tizhong" value="{{qy.tizhong}}"&gt;</span>
<span>    <span>&lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;lable&gt;所在俱乐部&lt;/lable&gt;</span>
<span>        <span>&lt;select class="form-control" name="jlb_id"&gt;</span>
<span>            {% for jj in jianjies %}</span>
<span>                {% if jj.id == qy.jlb_id %}</span>
<span>                    &lt;option value="{{jj.id}}" selected="selected"&gt;{{jj.mingcheng}}&lt;/option&gt;</span>
<span>                {% else %}</span>
<span>                    &lt;option value="{{jj.id}}"&gt;{{jj.mingcheng}}&lt;/option&gt;</span>
<span>                {% endif %}</span>
<span>            {% endfor %}</span>
<span>        &lt;/select&gt;</span>
<span>    &lt;/div&gt;</span>
<span>    <span>&lt;div class="form-group col-md-6 col-md-offset-3"&gt;</span>
<span>        <span>&lt;input type="submit" class="form-control btn btn-danger" value="修改"&gt;</span>
<span>    &lt;/div&gt;</span>
<span>&lt;/form&gt;</span></code>

The article also includes screenshots of the admin interface, front‑end page, and login screen to illustrate the system’s appearance.

Finally, a promotional note encourages readers to follow the public account, star the post, and scan a QR code to receive free Python learning resources.