django增删查改操作sqlserver源码demo

1、后台代码：

from django.shortcuts import render
from HelloWorld import mssqlDB
from django.http import HttpResponse
from django.views.decorators.csrf import csrf_exempt
import json
from HelloWorld import pager

db = mssqlDB.MSSQL()
# Create your views here.
def blog_index(request):
    #ms = mssqlDB.MSSQL(host="10.10.15.55",user="sa",pwd="Aa123456",db="testDB")
    #resList = ms.GetQuery("select * from tUsers")
    blog_list = db.GetQuery("select * from tUsers") # 获取所有数据
    #test=json.dumps(blog_list)
    return render(request,'index.html', {'blog_list':blog_list})   # 返回index.html
    
#视图-添加用户
def blog_Add_V(request):
    return render(request,'add.html')  

#视图-分页
def pagelist(request):
    pagenum = request.GET.get('page')
    if pagenum == None:
        pagenum = 1
    #获取数据集合
    datalist = db.GetQueryPage("""select * from 
                        (select ROW_NUMBER() OVER (order by id desc )AS RowNumber,* from tUsers) as temp
                        where RowNumber between 10*({0}-1) and 10*{0};SELECT COUNT(1) total FROM tUsers""".format(pagenum))
    all_count = datalist.get("datapage")[0].get("total") 
    # 获取要显示数据库的总数据条数
    page_info = pager.PageInfo(request.GET.get('page'), all_count, 'pagelist.htm',) 
    print(page_info.start_data()) 
    #page_info.pager()
    # 利用分页对象获取当前页显示数据
    return render(request, 'pagelist.html', {'page_info': page_info,'datalist':datalist}) 

#DB-添加用户
@csrf_exempt #增加装饰器，作用是跳过 csrf 中间件的保护
def blog_Add_DB(request):
    sql=""
    if request.POST:
        sql = "INSERT INTO tUsers(name,age) VALUES('%s',%s)"%(request.POST['xingMing'],request.POST['nianLing'])
    else:
        sql = "INSERT INTO tUsers(name,age) VALUES('%s',%s)"%(request.GET['xingMing'],request.GET['nianLing'])
    print(sql)
    ret = db.ExecQuery(sql)
    if ret > 0:
        return HttpResponse('操作成功')
    else:
        return HttpResponse('操作失败')

#删除数据
def blog_Del_DB(request):
    sql = "delete from tUsers where id={}".format(request.GET['id'])
    ret = db.ExecQuery(sql)
    if ret > 0:
        return HttpResponse('操作成功')
    else:
        return HttpResponse('操作失败')
View Code

（1）sql帮助类-mssqlDB.py：https://www.cnblogs.com/guangang/articles/9258683.html

（2）分页模板类-pager.py：https://www.cnblogs.com/guangang/articles/9258773.html

2、查询列表代码：

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>分页组件</title>
{# 引入bootstrap样式#}
 <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css">
 <script src="https://cdn.bootcss.com/jquery/1.12.4/jquery.min.js"></script>
</head>
<body>
<div style="margin:3%">
<h1 style="float:right"><a type="button" class="btn btn-primary"  href="/add.htm">添加</a></h1>
<table class="table table-striped  table-condensed  table-bordered">
  <tr class="table title" style="font-weight:600; text-align:left">
      <td>序号</td>
      <td>编号</td>
      <td>姓名</td>
      <td>年龄</td>
      <td>操作</td>
  </tr>
  {% for blog in datalist.datalist %}
      <tr>
          <td>{{blog.RowNumber}}</td>
          <td>{{blog.id}}</td>
          <td>{{blog.name}}</td>
          <td>{{blog.age}}</td>
          <td><button type="button" class="btn btn-danger" onclick="optdel({{blog.id}})">删除</button></td>
      </tr>
  {% endfor %}
</table>

 
{#分页#}
 <nav aria-label="Page navigation">
  <ul class="pagination">
    {#    传入page_info.pager#}
    {{ page_info.pager|safe }}
  </ul>
 </nav>
</div>
</body>
</html>
<script>
  function optdel(id){
    if(window.confirm('你确定要删除吗？')){
      $.get("/optdel",{"id":id}, function(ret){
        alert(ret);
        location.reload();
      })
    }
  }
</script>
View Code

3、添加功能代码：

<!DOCTYPE html>
<html lang="zh-CN">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Starter Template for Bootstrap</title>

    <!-- Bootstrap core CSS -->
    <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="starter-template.css" rel="stylesheet">

  </head>

  <body>

    <nav class="navbar navbar-inverse navbar-fixed-top">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">W</a>
        </div>
        <div id="navbar" class="collapse navbar-collapse">
          <ul class="nav navbar-nav">
            <li class="active"><a href="/index.htm">Home</a></li>
            <li><a href="#about">About</a></li>
            <li><a href="#contact">Contact</a></li>
          </ul>
        </div><!--/.nav-collapse -->
      </div>
    </nav>

    <div class="container" style="margin-top: 50px;">
        <br><br>
      <div class="starter-template">
            <form>
                <div class="form-group">
                    <label for="xingMing">姓名</label>
                    <input type="text" class="form-control" id="xingMing" name="xingMing">
                </div>
                <div class="form-group">
                        <label for="nianLing">年龄</label>
                        <input type="text" class="form-control" id="nianLing" name="nianLing">
                    </div>
                <button type="button" class="btn btn-default" onclick="AddUser()">添加用户</button>
            </form>
      </div>

    </div><!-- /.container -->

    <script src="https://cdn.bootcss.com/jquery/1.12.4/jquery.min.js"></script>
    <script src="https://cdn.bootcss.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <script>
        //添加客户
        function AddUser(){
            var xingMing=$("#xingMing").val();
            if(xingMing==""){
                alert("请填写姓名！");return;
            }
                
            var nianLing=$("#nianLing").val();
            if(nianLing==""){
                alert("请填写年龄！");return;
            }
            $.post("/add",{"xingMing":xingMing,"nianLing":nianLing}, function(ret){
                alert(ret);
            })
            
        }
    </script>
  </body>
</html>
View Code

4、url配置：

from django.contrib import admin
from django.urls import path
from Web import views

urlpatterns = [
    path('add', views.blog_Add_DB),
    path('optdel', views.blog_Del_DB),
    path('pagelist.htm', views.pagelist),
]

 

posted @ 2018-07-04 09:02  狼人666  阅读(251)  评论(0)  编辑  收藏  举报