python_mssql

@app.route('/', methods=['GET', 'POST'])
def demo():
    conn=pymssql.connect(host='blablabla\SQLEXPRESS',user='blabla',password='123',database='x',charset='utf8')
    cur=conn.cursor()
    sqlquery=u"SELECT TOP 1000 [ID],[姓名],[内容] FROM demo_db"
    sqlquery=sqlquery.encode("utf8")
    cur.execute(sqlquery)
    row=cur.fetchone()
    cts = [dict(name=row[1],ct=row[2]) for row in cur.fetchall()]
    for i in cts:
        i['name']=i['name'].decode('utf8')
    conn.close()
    return render_template('demo.html',cts=cts)