10天冲刺第二天之完成后端
技术没有什么难度,主要是希望数据表中数据结构能够迎合我们的app需求
这里贴几个代码,后端也是顺利完成
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <html> <head lang="en"> <meta charset="UTF-8"> <title>新建餐厅</title> <link rel="stylesheet" href="css/bootstrap.min.css"/> <link rel="stylesheet" href="css/bootstrap-theme.min.css"/> <link rel="stylesheet" href="css/bootstrap-table.min.css" /> </head> <body> <div class="container"> <nav class="navbar navbar-default" role="navigation"> <div class="navbar-header"> <a class="navbar-brand" href="#">后台管理</a> </div> <div> <ul class="nav navbar-nav"> <li><a href="userManager.do">用户管理</a></li> <li class="active"><a href="shopManager.do">餐厅&菜谱管理</a></li> <li><a href="orderManager.do">订单&评论管理</a></li> </ul> </div> </nav> <hr> <form role="form" id="form" enctype="multipart/form-data"> <div class="form-group"> <label for="shopname">名称</label> <input type="text" class="form-control" id="shopname" placeholder="请输入名称" required> </div> <div class="form-group"> <label for="address">地址</label> <input type="text" class="form-control" id="address" placeholder="请输入地址" required> </div> <div class="form-group"> <label for="phonenum">电话号码</label> <input type="text" class="form-control" id="phonenum" placeholder="请输入电话号码" required> </div> <div class="form-group"> <label for="intro">简介</label> <input type="text" class="form-control" id="intro" placeholder="请输入简介"> </div> <div class="form-group"> <label for="level">等级</label> <input type="text" class="form-control" id="level" placeholder="请输入等级" required> </div> <div class="form-group"> <label for="pic">选择图片</label> <!-- <input type="file" id="pic" name="pic"> --> <input type="text" id="pic" name="pic" class="form-control" placeholder="请输入图片网址"> </div> <button type="submit" class="btn btn-success" id="submit">提交</button> </form> </div> <script src="js/jQuery.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/bootstrap-table.min.js"></script> <script src="js/bootstrap-table-zh-CN.min.js"></script> <script> var $submit = $('#submit'); $(function () { var shop_id="${shop.shop_id}"; console.log(shop_id); if(shop_id!="") { $("#shopname").val("${shop.shopname}"); $("#address").val("${shop.address}"); $("#phonenum").val("${shop.phonenum}"); $("#intro").val("${shop.intro}"); $("#level").val("${shop.level}"); $("#pic").val("${shop.pic}"); } $submit.click(function () { var shopname=$("#shopname").val(); var address=$("#address").val(); var phonenum=$("#phonenum").val(); var intro=$("#intro").val(); var level=$("#level").val(); var pic=$("#pic").val(); if(shop_id!="") $.ajax({ cache: true, type: "POST", url:"updateShop.do", data:{shopname:shopname,address:address,phonenum:phonenum,intro:intro,level:level,pic:pic,shop_id:shop_id}, async: false, error: function(request) { alert("连接失败"); }, success: function(data) { if(data.success==1) alert("修改成功"); else alert("修改失败"); } }); else { $.ajax({ cache: true, type: "POST", url:"insertShop.do", data:{shopname:shopname,address:address,phonenum:phonenum,intro:intro,level:level,pic:pic}, async: false, error: function(request) { alert("连接失败"); }, success: function(data) { if(data.success==1) alert("增加成功"); else alert("增加失败"); } }); } }); }); </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <html> <head lang="en"> <meta charset="UTF-8"> <title>菜谱管理</title> <link rel="stylesheet" href="css/bootstrap.min.css"/> <link rel="stylesheet" href="css/bootstrap-theme.min.css"/> <link rel="stylesheet" href="css/bootstrap-table.min.css" /> </head> <body> <div class="container"> <nav class="navbar navbar-default" role="navigation"> <div class="navbar-header"> <a class="navbar-brand" href="#">后台管理</a> </div> <div> <ul class="nav navbar-nav"> <li><a href="userManager.do">用户管理</a></li> <li ><a href="shopManager.do">餐厅&菜谱管理</a></li> <li class="active"><a href="orderManager.do">订单&评论管理</a></li> </ul> </div> </nav> <div id="toolbar" class="fixed-table-toolbar" style="margin-bottom: -40px"> </div> <table id="table" data-toggle="table" data-url="getAllOrder.do" data-click-to-select="true" data-query-params="queryParams" data-pagination="false" data-search="true" data-height="600"> <thead> <tr> <th data-field="username">用户名</th> <th data-field="foodname">菜谱名称</th> <th data-field="shopname">餐厅名称</th> <th data-field="price">价钱</th> <th data-field="ordertime">订餐时间</th> <th data-field="suggesttime">配餐时间</th> <th data-field="content">评论</th> <th data-field="action" data-formatter="actionFormatter" data-events="actionEvents">操作</th> </tr> </thead> </table> </div> <script src="js/jQuery.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/bootstrap-table.min.js"></script> <script src="js/bootstrap-table-zh-CN.min.js"></script> <script> function queryParams() { return { type: 'owner', sort: 'updated', direction: 'desc', per_page: 100, page: 1 }; } var $table = $('#table'), $add = $('#add'); $(function () { /* $table.on('check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table', function () { $add.prop('disabled', !$table.bootstrapTable('getSelections').length); }); */ }); function actionFormatter(value, row, index) { return [ '<button class="btn btn-danger delete">删除评论</button>' ].join(''); } function picFormatter(value, row, index) { console.log(value, row, index); return [ '<img src='+value+' width="50p" height="50px"></img>' ].join(''); } window.actionEvents = { 'click .delete': function (e, value, row, index) { $.ajax({ cache: true, type: "POST", url:"deleteComment.do", data:{order_id:row.order_id}, async: false, error: function(request) { alert("连接失败"); }, success: function(data) { if(data.success==1) alert("评论删除成功"); else alert("评论删除失败"); } }); } } </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <html> <head lang="en"> <meta charset="UTF-8"> <title>餐厅管理</title> <link rel="stylesheet" href="css/bootstrap.min.css"/> <link rel="stylesheet" href="css/bootstrap-theme.min.css"/> <link rel="stylesheet" href="css/bootstrap-table.min.css" /> </head> <body> <div class="container"> <nav class="navbar navbar-default" role="navigation"> <div class="navbar-header"> <a class="navbar-brand" href="#">后台管理</a> </div> <div> <ul class="nav navbar-nav"> <li><a href="userManager.do">用户管理</a></li> <li class="active"><a href="shopManager.do">餐厅&菜谱管理</a></li> <li><a href="orderManager.do">订单&评论管理</a></li> </ul> </div> </nav> <div id="toolbar" class="fixed-table-toolbar" style="margin-bottom: -40px"> <button id="add" class="btn btn-danger remove"> 新增餐厅 </button> </div> <table id="table" data-toggle="table" data-url="getAllShops.do" data-click-to-select="true" data-row-style="rowStyle" data-query-params="queryParams" data-pagination="false" data-search="true" data-height="600"> <thead> <tr> <th data-field="shop_id">ID</th> <th data-field="shopname">店铺名称</th> <th data-field="address">地址</th> <th data-field="phonenum">电话</th> <th data-field="intro">简介</th> <th data-field="pic" data-formatter="picFormatter">图片</th> <th data-field="level">等级</th> <th data-field="action" data-formatter="actionFormatter" data-events="actionEvents">操作</th> </tr> </thead> </table> </div> <script src="js/jQuery.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/bootstrap-table.min.js"></script> <script src="js/bootstrap-table-zh-CN.min.js"></script> <script> function rowStyle(row, index) { var classes = ['active', 'success', 'info', 'warning', 'danger']; if (row.level=='1') { return { classes: 'danger' }; } if (row.level=='2') { return { classes: 'warning' }; } if (row.level=='5') { return { classes: 'active' }; } return {}; } function queryParams() { return { type: 'owner', sort: 'updated', direction: 'desc', per_page: 100, page: 1 }; } var $table = $('#table'), $add = $('#add'); $(function () { $table.on('check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table', function () { $remove.prop('disabled', !$table.bootstrapTable('getSelections').length); }); $add.click(function () { var newpage="newshopmanager.jsp"; window.open(newpage); }); }); function actionFormatter(value, row, index) { return [ '<button class="btn btn-primary update">修改</button>'+ '<button class="btn btn-danger delete">删除</button>'+ '<button class="btn btn-primary food">进入</button>' ].join(''); } function picFormatter(value, row, index) { console.log(value, row, index); return [ '<img src='+value+' width="50p" height="50px"></img>' ].join(''); } window.actionEvents = { 'click .update': function (e, value, row, index) { //alert('修改, row: ' + JSON.stringify(row)); console.log(value, row, index); var newpage="editShop.do?shop_id="+row.shop_id; window.open(newpage); }, 'click .delete': function (e, value, row, index) { $.ajax({ cache: true, type: "POST", url:"deleteShop.do", data:{shop_id:row.shop_id}, async: false, error: function(request) { alert("Connection error"); }, success: function(data) { if(data.success==1) alert("删除成功"); else alert("删除失败"); } }); }, 'click .food': function (e, value, row, index) { var newpage="foodManager.do?shop_id="+row.shop_id; window.open(newpage); } } </script> </body> </html>