python - Django - 无法在下拉列表中检索数据库中的数据

Question

嗨，我真的需要这方面的帮助，尝试了很多天，但仍然无法做到。我对 Django 很陌生。

问题:我无法检索 MySQL 数据库中的数据以将其显示在下拉列表中。有人能帮助我吗？非常感谢!

models.py

class paper(models.Model):
id = models.CharField(max_length=70, primary_key=True, null=False)
year = models.TextField(null=True)
month = models.TextField(null=True)
number = models.IntegerField(null=True)

def __str__(self):
    return str(self.id)

Views.py

def dropdown_list(request):
paper = paper.objects.all()
pname = request.GET.get('paper_id')
context = {
    "paper": paper,
    "name": pname
}
return render(request, 'exampapersNew/exampaper.html', context)

exampaper.html

        <form id="form1" method="GET">
      {% csrf_token %}
      <u>SELECT YEAR</u><br><br>
      <select>
        {% if paper %}
        {% for p in paper %}
            <option value="{{ p.id }}">{{ p.year }} {{ p.month }} Paper {{ p.number }}</option>
        {% endfor %}
        {% endif %}
      </select>
    </form>

urls.py

urlpatterns = [
  url(r'^admin/', admin.site.urls),
  url(r'^feedback/', include('feedback.urls')),
  url(r'^exampapersNew/', include('exampapersNew.urls')),
  url(r'^$', views.HomeView, name = 'home'),
  url(r'^feedback', views.FeedbackM, name = 'feedback'),
  url(r'^exampapersNew', views.ExampapersNewView, name = 'exampapersNew'),
  url(r'^frequentlyasked', views.FrequentlyaskedView, name = 'frequentlyasked'),
  url(r'^api/', include(v1_api.urls)),

  url(r'^exampapersNew/<int:paper_id>/', views.EMaths_Menu, name = 'paper_archive'),
  url(r'^formula', views.e_math_concept, name = 'formula'),
]

表单.py

class DropdownForm(forms.Form):
class Meta:
    model = paper
    fields = ['id', 'year', 'month', 'number']

mySQL 表

mysql> SELECT * from exampapersnew_paper;
+-----------+------+----------+--------+
| id        | year | month    | number |
+-----------+------+----------+--------+
| 200801001 | 2008 | November |      1 |
| 200801002 | 2008 | November |      2 |
| 200901001 | 2009 | November |      1 |
+-----------+------+----------+--------+
3 rows in set (0.00 sec)

Answer 1

在您的选择中尝试一下

{% if paper %}
{% for p in paper %}
    <option value="{{ p.id }}">{{ p.year }} {{ p.month }} Paper {{ p.number }} </option>
{% endfor %}
{% endif %}

另请参阅本教程，django tutorial part 3 .

Django 模型还有一个默认的主键属性，您也可以使用它。