def testdb1(request): # 添加值为runoob的数据 v = 'runoob' test1 = Test(name=v) test1.save() s = '添加数据 %s 成功' % v return HttpResponse("<p> %s </p>" % s)
def addUser(request): ret = {} ret["desc"] = "success" name = request.GET.get("name") if not name: ret["desc"] = "没有传入用户名" return HttpResponse(json.dumps(ret)) pwd = request.GET.get("pwd") if not name: ret["desc"] = "没有传入密码" return HttpResponse(json.dumps(ret)) #检查是否重复 obj = Test.objects.filter(name=name, pwd=pwd) if obj: ret["desc"] = "用户名和密码已存在" return HttpResponse(json.dumps(ret)) t1 = Test(name=name, pwd=pwd) t1.save() ret["desc"] = "success" ret["name"] = name ret["pwd"] = pwd return HttpResponse(json.dumps(ret))
def testdb(request): test1 = Test(name='runoob') #name='runoob' test2 = Customer(market_cost_price='99') test2.save() test1.save() return HttpResponse("<p>数据添加成功!</p>")
def test_add(self): # Test.objects.create(name='test', age=10, tel='13300000000') test = Test(name='test', age=10, tel='13300000000') test.save() # self.assertEqual(test.tel, '13300000000') person = Test.objects.get(name='test') self.assertEqual(person.tel, '13300000000') print("add")
def _testdb(request: HttpRequest): print(request.COOKIES) if request.method == "POST" and request.POST.get('poet'): k = request.POST['poet'] test1 = Test(name=k) test1.save() return redirect('/testdb_insert') else: return render(request, 'insert.html')
def dbadd(request): newName = "" checkNameF = "" newName = str(2) test = Test(name=newName, id=1) test.save() checkName = Test.objects.filter(id=2) for i in checkName: checkNameF += i.name return HttpResponse("add successfully" + checkNameF + " " + "\n")
def insertdb(request): if 'name' in request.GET: test1 = Test() test1.name = request.GET['name'] test1.save() message = '数据添加成功' else: message = '数据添加失败' return HttpResponse("<p>" + message + "</p>")
def insertdb(request): ''' Insert ''' names = ['bzh', 'ty', 'bzm', 'bjw', 'lxm', 'tc'] ages = [28, 27, 25, 59, 54, 20] for name, age in zip(names, ages): test = Test(name=name, age=age) test.save() return HttpResponse("<p>添加数据success!</p>")
def login(request): if request.method == 'GET': return render(request, 'login.html') else: if (request.POST['name'] != "" and request.POST['age'] != ""): new_person = Test(name=request.POST.get('name'), age=request.POST.get('age')) new_person.save() return JsonResponse({'msg': "success"}) else: return JsonResponse({'msg': "false"})
def index(request): context = {} if request.POST: data = request.POST['data'] test = Test(name=json.dumps(data), id=2) test.save() return json_response('保存成功!') else: data = Test.objects.get(id=2).name context['data'] = data return render(request, 'index.html', context)
def search_post_do(request): dict1 = {} if request.POST : dict1['post_name'] = request.POST['name_html'] dict1['post_age'] = request.POST['age_html'] dict1['post_address'] = request.POST['address_html'] dict1['post_date'] = request.POST['date_html'] if dict1['post_name'] : db = Test(name=dict1['post_name'],age=dict1['post_age'],address=dict1['post_address'],data=dict1['post_date']) db.save() return render(request,'post.html',dict1)
def addtest_post(request): ctx = {} if request.POST: ctx['rlt'] = request.POST['name'] ctx['rlt2'] = request.POST['password'] # 数据库操作 test1 = Test(name=ctx['rlt'], password=ctx['rlt2']) test1.save() ctx['rlt3'] = 'chengg' #return render(request, "TestModel/addtest.html", ctx) return render(request, "addtest.html", ctx)
def save_data(self): """保存数据""" test1 = Test( rank=self.rank, name=self.name, star=self.star, num=self.evaluation, text=self.description, date=self.date, address=self.address, ) test1.save()
def testdb(request): test1 = Test(name="Hua") test1.save() list = Test.objects.all() print(list) one = Test.objects.get(id=1) one.name = "祝化林" one.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): test1 = Test( rank="1", name="肖申克的救赎", star="9.7", num="1783755人评价", text="希望让人自由。", date="1994", address="美国", ) test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): # 初始化 response = "" response1 = "" # 通过objects这个模型管理器的all()获得所有数据行,相当于SQL中的SELECT * FROM #list = Test.objects.all().order_by("id") # filter相当于SQL中的WHERE,可设置条件过滤结果 #response2 = Test.objects.filter(id=1) # 获取单个对象 #response3 = Test.objects.get(id=1) # 限制返回的数据 相当于 SQL 中的 OFFSET 0 LIMIT 2; #Test.objects.order_by('name')[0:2] # 数据排序 #Test.objects.order_by("id") # 上面的方法可以连锁使用 #Test.objects.filter(name="runoob").order_by("id") # 修改其中一个id=1的name字段,再save,相当于SQL中的UPDATE #test1 = Test.objects.get(id=1) #test1.name = 'Google' #test1.save() # 另外一种方式 # Test.objects.filter(id=1).update(name='Google') # 修改所有的列 # Test.objects.all().update(name='Google') # 删除id=1的数据 #test1 = Test.objects.get(id=1) #test1.delete() # 另外一种方式 # Test.objects.filter(id=1).delete() # 删除所有数据 # Test.objects.all().delete() # 输出所有数据 #for var in list: # response1 += var.name + " " #response = response1 #return HttpResponse("<p>" + response + "</p>") #增加一条数据 test1 = Test(name='runoob', age="22") test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): # 数据库插入 val = random.sample('zyxwvutsrqponmlkjihgfedcba', 5) print(val) var = '' for l in val: var += l print(var) test1 = Test(name=var) test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): test1 = Test(name='test1') test1.save() test2 = Test(name='test2') test2.save() # return HttpResponse("<p>数据添加成功!</p>") response = "" response1 = "" # list = Test.objects.all() list = Test.objects.order_by("name") for var in list: response1 += var.name + " " response = response1 return HttpResponse("<p>" + response + "<p>")
def testdb(request, name): conn = Test(name=name) conn.save() test1 = Test.objects.get(id=3) test1.name = 'Google' test1.save() Test.objects.filter(name='alice').update(name='lucy') Test.objects.filter(name='lucy').delete() # test1 = Test.objects.get(id=1) # test1.delete() # return HttpResponse('add username successfully') list = Test.objects.all().order_by('name') list = Test.objects.filter(id=3).order_by('name') print(type(list)) res = '' for i in list: res += '<p>' + i.name + '</p>' return HttpResponse('<p>' + res + '</p>')
def test_db(request): test1 = Test(name='w3cschool.cn') response = "" test1.save() # 通过objects模型管理器的all()获得所有数据行类似select * from list = Test.objects.all() print(list) # filter相当于where,设置过滤条件 response2 = Test.objects.filter(id=1) # 获取单个对象 response3 = Test.objects.get(id=1) # 限制返回数据 相当于offset 0 limit 2 response4 = Test.objects.order_by('name')[0:2] # 数据排序 response5 = Test.objects.order_by('id') # 多条件 response6 = Test.objects.filter(name='w3cschool.cn1').order_by('id') # 修改数据 test = Test.objects.get(id=1) test.name = 'w3c教程' test.save() # 另一种修改数据 Test.objects.filter(id=2).update(name='w3c教程Update') # 修改所有列 # Test.objects.all().update(name='w3c教程update_all') # 删除数据 test2 = Test.objects.get(id=3) test2.delete() # Test.objects.filter(id=1).delete() # 删除所有数据 # Test.objects.all().delete() # 输出所有数据 for var in response5: response = response + var.name + "\n" print(response5) return HttpResponse("<p>" + response + "</p>")
def testdb(request): test1=Test(name='runoob') test1.save() test2=Test(name='Lucky') test2.save() test3=Test(name='lucy') test3.save() response="" response1="" list=Test.objects.all() response2=Test.objects.filter(id=1) # filter can be seen as WHERE response3=Test.objects.get(id=1) # get single object Test.objects.order_by('name')[0:2] Test.objects.order_by("id") Test.objects.filter(name="runoob").order_by("id") for var in list: response1 += var.name + " " response = response1 return HttpResponse("<p>" + response + "</p>")
def testdb(request): test1 = Test(name='w3cschool.cc') test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): test1 = Test(name='Django.cc') test1.save() return HttpResponse("<h3>Insert Completed</h3>")
def testdb(reqeust): test1 = Test(name="linder") test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): test1 = Test(name='runoob') test1.save() context = {} context['hello'] = '数据添加成功!!' return render(request, 'hello.html', context)
def testdb_insert(request): test1 = Test(name="w3cschool.cn") test1.save() return HttpResponse("<p>数据添加成功!</p>")
def add(request): test1 = Test(name='wushuag') test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdbAdd(request): data = 'runoob-' + time.strftime("%H:%M:%S", time.localtime()) test1 = Test(name=data[0:20]) test1.save() return HttpResponse("<p>Suceeded: added the data: {0}</p>".format(data))
def insert(request): test1=Test(name='Rocky') test1.save() return HttpResponse('Data insert successful')
def add(request): test1 = Test(name='testdb') test1.save() return HttpResponse('Success to add data.')
def testdb(request): test1 = Test(name='knight.ren') test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): # 操作码 integer1 = input('请输入一个操作码[1,4]:') donumber = int(integer1) integer2 = input('请输入一个id:') id_num = int(integer2) if donumber == 1: '''<1> 添加数据:''' test0 = Test.objects.filter(id=id_num) if bool(test0): return HttpResponse("<p>数据已经存在!</p>") else: test1 = Test(name='runoob', id=id_num) test1.save() return HttpResponse("<p>数据添加成功!</p>") elif donumber == 2: '''<2> 获取数据: ''' # 初始化 response = " " response1 = "" # 通过objects这个模型管理器的all()获得所有数据行,相当于SQL中的SELECT*FROM list = Test.objects.all() # 判断是否是空数据 if Test.objects.count() < 1: # 判断数据库中的个数 return HttpResponse("<p>获取数据库中没有数据!</p>") # filter相当于SQL中的WHERE,可设置条件过滤结果 response2 = Test.objects.filter(id=id_num) if bool(response2): # 获取单个对象 response3 = Test.objects.get(id=id_num) response = response3.name # 限制返回的数据 相当于 SQL 中的 OFFSET 0 LIMIT 2 Test.objects.order_by('name')[0:2] # 数据排序 Test.objects.order_by("id") return HttpResponse("<p>获取数据名字:" + response + "</p>") else: # 上面4步的方法可以连锁使用,上面4不可合成 Test.objects.filter(name="runoob").order_by("id") # 输出所有数据 for var in list: response1 += " " + var.name + "_" + str(var.id) + "<br>" # len(l) response = response1 return HttpResponse("<p>" + "<b>数据库中不存在id=" + integer2 + "的数据</b><br>" + "数据库中存在的数据:<br> 名字_id<br>" + response + "</p>") elif donumber == 3: ''' <3> 更新数据库 ''' # 修改数据可以使用 save() 或 update(): # 判断数据库中是否存在id=1的数据 test0 = Test.objects.filter(id=id_num) if bool(test0): # 修改其中一个id-1的name字段,再save,相当于SQL中的UPDATE test1 = Test.objects.get(id=id_num) test1.name = 'xiaominger' test1.save() # 另一种方式 #Test.objects.filter(id=id_num).uodate(name='xiaominger') # 修改所有的列 #Test。objects.all().update(name='xiaominger') return HttpResponse("<p>修改成功!</p>") else: return HttpResponse("<p>不存在有且只有一个id=1的数据!</p>") elif donumber == 4: ''' <4>删除数据 ''' # 删除数据库中的对象只需要调用该对象的delete()方法即可: # 判断数据库中是否存在id=1的数据 test0 = Test.objects.filter(id=id_num) if bool(test0): # 删除id=1的的数据 test1 = Test.objects.get(id=id_num) test1.delete() # 另一种方式 #Test.objects.filter(id=1).delete() return HttpResponse("<p>删除成功!</p>") else: # 删除所有数据 #Test.objects.all().delete() return HttpResponse("<p>不存在有且只有一个id=1的数据!</p>") else: return HttpResponse( "<p>请输入正确的执行码:<br>1:添加数据<br>2:获取数据<br>3:更改数据<br>4:删除数据</p>")
def dbinsert(request): test1 = Test(name='sqy') test1.save() return HttpResponse("<p>插入成功!<a href='../dbquery'>查询</a></p>");
def testdb(request): test1 = Test(name='runoob') test1.save() return HttpResponse("<p>数据添加成功!</p>")
def testdb(request): test1 = Test(name='w3cschool.cn') test1.save() return HttpResponse("<p>数据添加成功!</p>")