def sqlitetest(txt,footer):
cx = sqlite3.connect("D:\Python-Test\StuProject\db.sqlite3")
cu = cx.cursor()
#sql = '''insert into'comment_comment'(txt,'footer') values (\"%s\",\"%s\");'''%(pymysql.escape_string(txt),pymysql.escape_string(footer))# 字符串插入字符串 sql
sql = '''insert into'comment_comment'(txt,'footer') values (\"%s\",\"%s\");''' % (txt, footer) # 字符串插入字符串 sql
try:
cu.execute(sql)
cx.commit()
except Exception as e:
with open("D:\Python-Test\StuProject\dblog.txt",'a+') as f:
log = '''执行 sql 发生错误:%s \n 输出:%s'''%(e,sql)
#f.write(log)
pass
print(cu)
++++++++++++++++++++++++++++++++++++++++++++++++++++
cur_page = 1
def net163(request):
global cur_page# 处理报错 local variable 'cur_page1' referenced before assignment
try:
#cur_page = int(request.GET.get('cur_page', '1'))# 跳转页码
if request.POST:
cur_page = int(request.POST['num'])
elif request.GET:
cur_page = int(request.GET['cur_page'])
else:
print("数据传输有误")
except ValueError:
cur_page = 1
pagination = Pagination.create_pagination(
from_name='comment.models',
model_name='comment',
cur_page=cur_page,
start_page_omit_symbol='...',
end_page_omit_symbol='...',
one_page_data_size=30,# 每页显示数目
show_page_item_len=10)# 分页数目
return render(request, 'Net163.html', {'pagination': pagination})
来源: http://www.bubuko.com/infodetail-2484145.html