def get_user_count(self): sql = "select * from user_info" querys = db_manager.sqlserver().execute_query(sql) if (len(querys) >= 5): self.out = '业务办理失败,此用户在全国范围内办理号码已经超过了5个!' else: self.out = '审核通过!'
def get_user_count(): order_id = self.in_param sql = "select * from user_info where id = "+ order_id +"" querys = db_manager.sqlserver().execute_query(sql) for x in querys: print x if(len(querys) >= 5): self.out_param = '业务办理失败,此用户在全国范围内办理号码已经超过了5个!' else: self.out_param = '审核通过!'
def query_test(self): sql = "select * from user_info" querys = db_manager.sqlserver().execute_query(sql) for row in querys: print(row)
def update_test(self): sql = "update user_info set user_name = 'aaaa' where user_name = '6666'" db_manager.sqlserver().execute_update(sql)
def delete_test(self): sql = "delete from user_info where id='4'" db_manager.sqlserver().execute_update(sql)
def insert_test(self): sql = "insert into user_info(user_name,user_pwd) values('ssss','ssssbb')" db_manager.sqlserver().execute_update(sql)