def batch_insert(conn, cur): users = [] u1 = User('a', 11, 99) u2 = User('b', 12, 100) users.append(u1) users.append(u2) success = User.batch_insert(conn, cur, users) print('成功插入' + s(success) + '条用户数据')
def modify_user(self, conn, cur): sql = "UPDATE t_user SET name = '{_name}', age = '{_age}' WHERE id = {_id}".format(_name=s(self.name), _age=i(self.age), _id=i(self.id)) return mysql_util.operate(conn, cur, sql)
def info(self): print('ID:{_id}, Age:{_age}, Name:{_name}'.format(_id=s(self.id).rjust(5), _name=s(self.name), _age=s(self.age).rjust(3)))