INNER CODE UNIT · Python
query
TechXueXi/TechXueXi · SourcePackages/challengeAnswerBank.py:57
def query(self, sql, param=None):
"""
查询语句
sql:sql语句
param:参数,可为None
retutn:成功返回True
"""
# print('sql=', sql, 'param=', param)
if param is None:
self.c.execute(sql)
else:
self.c.execute(sql, param)
return self.c.fetchall()
def search(keyword='', tableName='tiku', page=1, rows=10):
limit = (page - 1) * rows
db = DbTool()
total = db.query(