params均是前端参数
1.增
k = ",".join([i for i in params.keys()]) v = ",".join([f"'{i}'" for i in params.values()]) sql_key = f"insert into excel ({k}) values ({v})"
2.删
delet_excel_sql = f"DELETE FROM 表名 WHERE 列名= '{params['biaoti']}'"
3.改
set_sql = ','.join(['%s="%s"' % (i, j) for i, j in params.items()]) UPDATE_excel_sql = "UPDATE excel SET %s WHERE biaoti='%s'" % (set_sql,params1[1]["maodian"])
4. 查
params["is_delete"] = "0" where_sql = ' and '.join([f'{i} like "%{j}%"' for i, j in params.items()]) # print(where_sql) select_sql = f"select * from excel where {where_sql}"