application.py
#coding=utf-8
__author__ = 'duanpeng'
import MySQLdb
from flask import Flask,request,render_template,session, redirect, url_for, escape
app = Flask(__name__,static_folder='static',static_url_path='/static')
#定义首页
@app.route('/')
def hello_world():
user_agent = request.headers.get('User-Agent')
return 'welcom! ,you browser is %s' % user_agent
#定义404错误页面
@app.errorhandler(404)
def not_found(error):
return render_template('error.html'), 404
#定义动态页面
@app.route('/user/<username>')
def show_user_profile(username):
# show the user profile for that user
return 'User %s' % username
#限制请求方式
@app.route('/sayHello',methods=['post'])
def sayHello():
return "hello,who are you?"
#限制请求只能为get方式
@app.route('/touch',methods=['get'])
def touch():
return render_template('bank.html')
#我的账号页面，与数据库交互，实现动态数据处理
@app.route('/myaccount',methods=['get'])
def mydata():
try:
#加载驱动 连接数据库 host ->ip port->端口
conn = MySQLdb.connect(host='192.168.1.124',user='root',passwd='abcdef',db='abcdef',port=3306,charset='gb2312')
cursor = conn.cursor()
cursor.execute("select * from osc_users t where t.login_name = 'rainbow07693'")
result = cursor.fetchone()
print(result[4])
cursor.close()
conn.close()
return render_template('oscuser.html',userinfo=result)
except MySQLdb.Error,e:
print e
if __name__ == '__main__':
app.run(debug=True)
