Python连接Sqlite数据库及Django获取接收Html数据

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

 

Python连接Sqlite数据库及Django获取接收Html数据

标签：local   with   values   model   insert   接收   ret   body   else