5.點(diǎn)擊按鈕跳到新頁面，并傳參數(shù)給新頁面。

上一篇是局部刷新的，點(diǎn)擊之后還在當(dāng)前頁面，這一個(gè)則跳轉(zhuǎn)到新的頁面。
index.html代碼：

<a href="main/statistic" target="_blank">生成行為報(bào)表</a>

點(diǎn)擊之后跳到下一個(gè)頁面statistic.html：

<table>
                    {% for i in u2 %}
                    <tr>
                        <td>  {{ i[0] }} </td>
                        <td>  {{ i[1] }} </td>
                        <td>  {{ i[2] }} </td>
                        <td>  {{ i[3] }} </td>
                    </tr>
                    {% endfor %}
</table>

后端代碼：

@app.route('/main/statistic')
def xiaoxi():
    xiaoxi_nameid = session.get('name_id')

    conn2 = pymysql.connect(host='127.0.0.1', user='root', password='123', db='ci', charset='utf8')
    cur2 = conn2.cursor()
    sqlll = "SELECT  `date`, `reason`, `result` FROM `retroactive` WHERE name_id =" + xiaoxi_nameid
    cur2.execute(sqlll)
    u21 = cur2.fetchall()
    u2 = []
    for i in range(len(u21)):
        list1 = list(u21[i])
        list1.insert(3, '補(bǔ)簽')
        u2.insert(i, list1)
    conn2.close()

    conn3 = pymysql.connect(host='127.0.0.1', user='root', password='123', db='ci', charset='utf8')
    cur3 = conn3.cursor()
    sqlll = "SELECT `date`, `reason`, `result` FROM `dayoff` WHERE name_id =" + xiaoxi_nameid
    cur3.execute(sqlll)
    u31 = cur3.fetchall()
    u3 = []
    for i in range(len(u31)):
        list2 = list(u31[i])
        list2.insert(3, '請(qǐng)假')
        u3.insert(i, list2)
    conn3.close()

    conn4 = pymysql.connect(host='127.0.0.1', user='root', password='123', db='ci', charset='utf8')
    cur4 = conn4.cursor()
    sqlll = "SELECT `date`, `reason`, `result` FROM `business_trip` WHERE name_id =" + xiaoxi_nameid
    cur4.execute(sqlll)
    u41 = cur4.fetchall()
    u4 = []
    for i in range(len(u41)):
        list3 = list(u41[i])
        list3.insert(3, '出差')
        u4.insert(i, list3)
    conn4.close()

    u2 = u2 + u3 + u4
    for i in range(len(u2)):
        u2[i][0] = str(u2[i][0])

    return render_template('statistic.html', u2 = u2)