sqlitetest(txt,footer):
cx = sqlite3.connect(
"D:Python-TestStuProjectdb.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-TestStuProjectdblog.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})
Python连接Sqlite数据库及Django获取接收Html数据
标签：local with values model insert 接收 ret body else
本文系统来源：https://www.cnblogs.com/acer-haitao/p/8403562.html
【说明】：
本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！