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)))
