python + flask +sqlite3 数据显示问题

Question

本人小白，刚学python，不喜勿喷，学习过程中有问题求教：
数据库格式： 

--------
A X1
A X2
A X3
B X1
B X2
C X2
C X3
-----------
放到网页里面想变成这种效果
A
X1 
X2 
X3
B
X1 
X2 
C
X2 
X3
----------------------------------
实际上就是数据的一个嵌套，用python实现时，date_set=cur.fetchall()，可以使用web端{% for d1 in dateset %}显示查询结果，但是无法按照上面的显示出来，求大神有没有相关代码可参考！！

Answer 1

from itertools import groupby&nbsp;....&nbsp; &nbsp; curr.execute("select cate, valu from tb order by cate, valu")&nbsp; &nbsp; result = [&nbsp; &nbsp; &nbsp; &nbsp; (cate, [v[1] for v in valus])&nbsp; &nbsp; &nbsp; &nbsp; for cate, valus in groupby(curr, lambda row: row[0])&nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; return render_template('page.html', data = result)&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;page.html:{% for cate, vals in data %}<tr><td>{{ cate }}</td><td></td></tr>&nbsp; &nbsp; {% for val in vals %}&nbsp; &nbsp; <tr><td></td><td>{{ val }}</td></tr>&nbsp; &nbsp; {% endfor %}{% endfor %}