一、主要代码:
1、python文件
#coding=utf-8
from tornado.ioloop import IOLoop
from tornado.web import RequestHandler
from tornado.web import Application
import MySQLdb
#创建与数据库的连接
def __getConn():
return MySQLdb.connect(host='127.0.0.1',user='root',passwd='123',db='tronado',port=3306)
#显示注册界面
class IndexHandler(RequestHandler):
def get(self, *args, **kwargs):
self.render('templates/register.html')
#实现注册
class RegisterHandler(RequestHandler):
def initialize(self,conn):
self.conn = conn
def post(self, *args, **kwargs):
#获取请求参数
uname = self.get_argument('name')
print uname
pwd = self.get_argument('pwd')
print pwd
#实现在数据库插入数据
try:
cursor = self.conn.cursor()
cursor.execute('insert into db_test1 values(null "%s","%s",now()'%(uname,pwd))
self.conn.commit()
self.write('注册成功!')
except Exception as e:
# self.conn.rollback()
self.write('注册失败!')
app = Application([
(r'/',IndexHandler),
(r'/register/',RegisterHandler,{'conn':__getConn}),
])
if __name__ == '__main__':
app.listen(8000)
IOLoop.current().start()
2、templates内代码:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>地下城与勇士注册界面</title>
</head>
<body>
<div align="center">
<h1>地下城与勇士注册界面</h1>
<hr color="red" size="4px">
<form action="/register/" method="post">
<p>账 号:<input type="text" name="name"></p>
<p>密 码:<input type="password" name="pwd"></p>
<p><input type="submit" value="提交注册"></p>
</form>
</div>
</body>
</html>
二、数据库表


三、pycharm运行环境如下:

四、存在问题,在网页提交数据后显示注册失败。
1、
2、
五、自己无法解决(代码检查过 没有写错)