def get(self, *args, **kwargs):
# 渲染页面
handler_page = u'user_list.html'
arguments = get_arguments_analysis(self.request.arguments)
if 'ajax' not in arguments: # 直接访问页面,非ajax
# 渲染页面
render_page = assert_path + handler_page
# 查询语句
sql = u'select user.*,GroupName from user join user_group on user.UserGroupID = user_group.ID;'
mysql_query_result = query.query(sql)
self.render(render_page,user_list=mysql_query_result)
else: # ajax get方式访问页面
if arguments['action'] == 'add':
try:
if self.__AddUser(
UserName=arguments['UserName'],
Password=arguments['Password'],
UserGroupID=arguments['UserGroupID'],
Fullname=arguments['Fullname'] if 'Fullname' in arguments else '',
isPermit=arguments['isPermit'] if 'isPermit' in arguments else '1',
TellphoneNumber=arguments['TellphoneNumber'] if 'TellphoneNumber' in arguments else '',
Description=arguments['Description'] if 'Description' in arguments else ''
):
self.write_error('true')
else:
self.write_error('false')
except Exception,err:
print err
self.write('aaa')
def get(self, request_page=None, *args, **kwargs):
# 获取get参数
arguments = self.request.arguments
# 遍历一次,key-value化
if 'action' in arguments and arguments and isinstance(arguments,dict):
arguments_keyvalue = {key:u''.join(value) for key,value in arguments.items()}
action = arguments_keyvalue['action']
# 定义一个action-sql字典
action_sql = {
'show': 'show tables;',
'get_user': ''
}
mysql_query_result = query.query(action_sql[action])
self.write(json.dumps(mysql_query_result))
else:
self.write(json.dumps({}))
