《JSP程序设计》手机销售网后台设计

xiaoxiao2022-07-13 184

一、实验要求

系统后台开发具体要求(课本第10章的项目基础上)： 1.在导航条中添加一个后台管理菜单。 2.后台页面分成左右两个框，左边显示一个树形菜单，右边根据菜单选择显示相应的交互界面。 3.实现对用户，产品分类，产品，订单等的后台管理。 4.具体界面自行设计。

二、功能说明

（一）用户端

1、主页

2、登录

3、注册

4、浏览手机

5、查询手机

6、查看购物车

7、查看订单

（二）后台管理

1、数据库

（1）管理员表

（2）用户表

（3）商品分类表

（4）商品表

（5）订单表

2、后台管理员登录

功能说明：用户端连接数据库表bsmstaff验证是否登录成功

代码：bsMlogin.jsp

<%@ page contentType="text/html;charset=GB2312" %> <jsp:useBean id="bsloginBean" class="mybean.data.bsMlogin" scope="session"/> <HTML><HEAD><%@ include file="head.txt" %></HEAD> <BODY bgcolor=pink><font size=2> <div align="center"> <table border=2> <tr> <th>登录</th></tr> <FORM action="bsMloginServlet" Method="post"> <tr><td>用户名:<Input type=text name="logid"></td></tr> <tr><td>密码:<Input type=password name="password"></td></tr> </table> <Input type=submit name="g" value="提交"> </form> </div > <div align="center" > 登录反馈信息:<br> <jsp:getProperty name="bsloginBean" property="backNews"/> <br>登录名称:<br><jsp:getProperty name="bsloginBean" property="logid"/> </div> </font> </BODY></HTML>

HandlebsMlogin.java(servlet类

package myservlet.control; import mybean.data.*; import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.util.*; public class HandlebsMlogin extends HttpServlet{ public void init(ServletConfig config) throws ServletException{ super.init(config); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} } public String handleString(String s){ try{ byte bb[]=s.getBytes("iso-8859-1"); s=new String(bb); } catch(Exception ee){} return s; } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ Connection con; Statement sql; String logid=request.getParameter("logid").trim(), password=request.getParameter("password").trim(); logid=handleString(logid); password=handleString(password); String uri="jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; boolean boo=(logid.length()>0)&&(password.length()>0); try{ con=DriverManager.getConnection(uri); String condition="select * from bsmstaff where logid= '"+logid+ "' and password ='"+password+"'"; sql=con.createStatement(); if(boo){ ResultSet rs=sql.executeQuery(condition); boolean m=rs.next(); if(m==true){ //调用登录成功的方法: success(request,response,logid,password); response.sendRedirect(request.getContextPath()+"/bsM.jsp"); //RequestDispatcher dispatcher= // request.getRequestDispatcher("/bsM.jsp");//转发 //dispatcher.forward(request,response); } else{ String backNews="您输入的用户名不存在，或密码不般配"; //调用登录失败的方法: fail(request,response,logid,backNews); } } else{ String backNews="请输入用户名和密码"; fail(request,response,logid,backNews); } con.close(); } catch(SQLException exp){ exp.printStackTrace(); String backNews=""+exp; fail(request,response,logid,backNews); } } public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ doPost(request,response); } public void success(HttpServletRequest request,HttpServletResponse response ,String logid,String password) { bsMlogin bsloginBean=null; HttpSession session=request.getSession(true); try{ bsloginBean=(bsMlogin)session.getAttribute("bsloginBean"); if(bsloginBean==null){ bsloginBean=new bsMlogin(); //创建新的数据模型 session.setAttribute("bsloginBean",bsloginBean); bsloginBean=(bsMlogin)session.getAttribute("bsloginBean"); } String id =bsloginBean.getLogid(); if(id.equals(logid)) { bsloginBean.setBackNews(logid+"已经登录了"); bsloginBean.setLogid(logid); session.setAttribute("backNews","登录成功"); } else { //数据模型存储新的登录用户 bsloginBean.setBackNews(logid+"登录成功"); bsloginBean.setLogid(logid); session.setAttribute("backNews","登录成功"); } } catch(Exception ee){ ee.printStackTrace(); bsloginBean=new bsMlogin(); session.setAttribute("bsloginBean",bsloginBean); bsloginBean.setBackNews(logid+"登录成功"); bsloginBean.setLogid(logid); session.setAttribute("backNews","登录成功"); } } public void fail(HttpServletRequest request,HttpServletResponse response ,String logid,String backNews) { response.setContentType("text/html;charset=GB2312"); try { PrintWriter out=response.getWriter(); out.println("<html><body>"); out.println("<h2>"+logid+"登录反馈结果<br>"+backNews+"</h2>") ; out.println("返回登录页面或主页<br>"); out.println("<a href =bsMlogin.jsp>登录页面</a>"); out.println("<br><a href =index.jsp>主页</a>"); out.println("</body></html>"); } catch(IOException exp){ exp.printStackTrace(); } } }

)

bsMlogin.java

package mybean.data; public class bsMlogin{ String logid="", backNews="未登录"; public String getLogid() { return logid; } public void setLogid(String logid) { this.logid = logid; } public String getBackNews() { return backNews; } public void setBackNews(String backNews) { this.backNews = backNews; } }

2.后台首页

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> <style type="text/css"> #admin{margin:100px 0px 0px 0px;} </style> </head> <body>  </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <img src="img/welcome.jpg" width=500 height=400 ></img> </div> </div> </div>   <script src="assets/js/amazeui.min.js"></script>  </Font></Body></HTML> </body> </html>

（1）实现查询用户列表

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <h2>查询用户</h2> <%@ page contentType="text/html;charset=GB2312" %> <HTML> <FORM action="byname.jsp" Method="post"> <BR>输入用户名:<Input type=text name="na"> <Input type=submit name="g" value="提交"> </FORM> </HTML> <p> </p> </div> </div> </div> </div> <div id="footer"> made by zct </div> </body> </html>

（2）用户注册

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <h2>用户注册</h2> <FORM action="registerServlet" method="post" name=form> <table> <tr><td>用户名:</td><td><Input type=text name="logname" ></td> <td>密码:</td><td><Input type=password name="password"> </td></tr> <tr><td>重复密码:</td><td> <Input type=password name="again_password"></td> <td>联系方式:</td><td><Input type=text name="phone"></td></tr> <tr><td>邮寄地址:</td><td><Input type=text name="address"></td> <td>真实姓名:</td><td><Input type=text name="realname"></td> </table> <BR><Input type="submit" name="b" value="提交"> <p> </p> </div> </body> </html>

（3）用户注销

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 100px 0px 300px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String na=request.getParameter("version"); if(na==null) na =""; byte [] bb=na.getBytes("iso-8859-1"); na = new String(bb); %> <inquire:DelRecord name="<%=na%>" /> <BR>user表删除记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="user" user="root" password=""/> <BR> <%=queryResult %> </HTML> </div> </div> </div> </body> </html>

（4）商品列表

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{font-family:"微软雅黑";font-size:18px;margin:100px 200px 0px 100px;float:right;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ page import="tom.jiafei.QueryBean" %> <jsp:useBean id="base" class="tom.jiafei.QueryBean" scope="session"/> <jsp:setProperty name="base" property="databaseName" value="warehourse"/> <jsp:setProperty name="base" property="tableName" value="mobileform"/> <jsp:setProperty name="base" property="user" value="root"/> <jsp:setProperty name="base" property="password" value=""/> <HTML><Body bgcolor=grey> 在<jsp:getProperty name="base" property="tableName"/>表查询到记录: <BR> <jsp:getProperty name="base" property="queryResult"/> </div> </div> </div> </div>   <script src="assets/js/amazeui.min.js"></script>  </Font></Body></HTML> </body> </html>

（5）添加商品

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <h2>添加商品</h2> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <FORM action="newdatabase.jsp" method=post> <table> <tr><td> 手机产品号：</td><td><Input type="text" name="mobile_version"></td></tr> <tr><td>手机名称：</td><td><Input type="text" name="mobile_name"></td></tr> <tr><td>手机制造商：</td><td><Input type="text" name="mobile_made"></td></tr> <tr><td>手机价格：</td><td><Input type="text" name="mobile_price"></td></tr> <tr><td> 手机产品介绍：</td><td><Input type="text" name="mobile_mess"></td></tr> <tr><td> 手机产品图像：</td><td><Input type="text" name="mobile_pic"></td></tr> <tr><td> 手机分类号号：</td><td><Input type="text" name="id"></td></tr> </table> <BR><Input type="submit" name="b" value="提交"> <p> </p> </div> </div> </div> <div id="footer"> made by zct </div> </body> </html>

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <%! String handleStr(String s) { try { byte bb[]=s.getBytes("iso-8859-1"); return new String(bb); } catch(Exception exp){} return s; } %> <% String ve=handleStr(request.getParameter("mobile_version")); String na=handleStr(request.getParameter("mobile_name")); String ma=handleStr(request.getParameter("mobile_made")); String pr=handleStr(request.getParameter("mobile_price")); String me=handleStr(request.getParameter("mobile_mess")); String pi=handleStr(request.getParameter("mobile_pic")); String Id=handleStr(request.getParameter("id")); %> <inquire:AddRecord mobile_version="<%=ve%>" mobile_name="<%=na%>" mobile_made="<%=ma%>" mobile_price="<%=pr%>" mobile_mess="<%=me%>" mobile_pic="<%=pi%>" id="<%=Id%>"/> <BR>mobileform表添加新记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="mobileform" user="root" password=""/> <BR> <%=queryResult %> </HTML> </div> </div> </div> </body> </html>

（6）商品下架

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> .re{margin:0px 100px 0px 200px;} #admin{font-size:18px;font-family:"微软雅黑";margin:100px 300px 0px 50px;float:right;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <FORM action="delete.jsp" method=post> 删除记录：<BR>输入被删除的记录的产品号： <Input type="text" name="number" size=8> <BR><Input type="submit" name="b" value="提交"> <BR>mobileform表删除前的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="mobileform" user="root" password=""/> <BR><div class="re"><%=queryResult %> </div> </FORM></HTML> </div> </div> </div> </Font></BODY></HTML>

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String num=request.getParameter("number"); if(num==null) num =""; byte [] bb=num.getBytes("iso-8859-1"); num = new String(bb); %> <inquire:DelRecord1 number="<%=num%>" /> <BR>moblieform表删除记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="mobileform" user="root" password=""/> <BR> <%=queryResult %> <%--queryResult是QueryTag.tag返回的对象--%> </HTML> </div> </div> </div> </body> </html>

（7）查询订单

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <h2>查询订单</h2> <%@ page contentType="text/html;charset=GB2312" %> <HTML> <FORM action="byname1.jsp" Method="post"> 根据用户名查询 <BR>输入用户名:<Input type=text name="na"> <Input type=submit name="g" value="提交"> </Form> <FORM action="bynum.jsp" Method="post"> 根据订单序号查询 <BR> 输入订单序号:<Input type=text name="number"> <Input type=submit name="g" value="提交"> </Form> </HTML> <p> </p> </div> </div> </div> </body> </html>

按用户名查询

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String name=request.getParameter("na"); if(name==null) name =""; byte [] bb =name.getBytes("iso-8859-1"); name=new String(bb); %> <inquire:NameConditon1 name="<%=name%>" /> 根据用户名<%=name%>查询到的记录: <BR><%=queryResultByname%> <%--queryResultByname是Tag文件返回的对象--%> </HTML> </div> </div> </div> </body> </html>

按订单号查询

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String number=request.getParameter("number"); if(number==null) number =""; byte [] bb =number.getBytes("iso-8859-1"); number=new String(bb); %> <inquire:NumberConditon1 number="<%=number%>" /> 根据订单序号号<%=number%>查询到的记录: <BR><%=queryResultByNumber1%> <%--queryResultByNumber1是Tag文件返回的对象--%> </HTML> </div> </div> </div> </body> </html>

（8）添加订单

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;font-family:"微软雅黑";font-size:18px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <h2>添加订单</h2> <FORM action="newdatabase1.jsp" method=post> <table border=1> <tr><td>订单序号：</td><td><Input type="text" name="id"></td></tr> <tr><td>用户名：</td><td><Input type="text" name="logname"></td></tr> <tr><td>订单信息：</td><td><Input type="text" name="mess"></td></tr> <tr><td>所订价格总共和：</td><td><Input type="text" name="sum"></td></tr> </table> <BR><Input type="submit" name="b" value="提交"> <p> </p> </div> </div> made by cwt </div> </body> </html>

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <%! String handleStr(String s) { try { byte bb[]=s.getBytes("iso-8859-1"); return new String(bb); } catch(Exception exp){} return s; } %> <% String Id=handleStr(request.getParameter("id")); String na=handleStr(request.getParameter("logname")); String me=handleStr(request.getParameter("mess")); String su=handleStr(request.getParameter("sum")); %> <inquire:AddRecord1 id="<%=Id%>" logname="<%=na%>" mess="<%=me%>" sum="<%=su%>"/> <BR>orderform表添加新记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="orderform" user="root" password=""/> <BR> <%=queryResult %> <%-- queryResult是QueryTag文件返回的对象--%> </HTML> </div> </div> </div> </body> </html>

（9）删除订单

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=utf-8" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;font-family:"微软雅黑";font-size:18px;position:relative;} #foot{positon:absolute;bottom:0px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <FORM action="delete2.jsp" method=post> 删除记录：<BR>输入要删除的订单号： <Input type="text" name="number" size=8> <BR><Input type="submit" name="b" value="提交"> <BR>orderform删除记录前的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="orderform" user="root" password=""/> <BR> <%=queryResult %> </HTML> </div> </div> </div> </body> </html>

代码：

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 200px 0px 100px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ page contentType="text/html;charset=GB2312" %> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String num=request.getParameter("number"); if(num==null) num =""; byte [] bb=num.getBytes("iso-8859-1"); num = new String(bb); %> <inquire:DelRecord2 number="<%=num%>" /> <BR>orderform表删除记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="orderform" user="root" password=""/> <BR> <%=queryResult %> <%--queryResult是QueryTag.tag返回的对象--%> </HTML> </div> </div> </div> </body> </html>

三、附录

（一）查询用户剩余代码：

byname.jsp

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=utf-8" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 0px 0px 0px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <p> </p> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String name=request.getParameter("na"); if(name==null) name =""; byte [] bb =name.getBytes("iso-8859-1"); name=new String(bb); %> <inquire:NameConditon name="<%=name%>" /> 根据用户名<%=name%>查询到的记录: <BR><%=queryResultByName%> </HTML> <p> </p> </div> </div> </div> </div> </body> </html>

（二）用户注销剩余代码

<%-- <%-- Created by IntelliJ IDEA. User: corrine Date: 2019-05-16 Time: 21:31 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=GB2312" %> <html class="no-js"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Amaze UI Admin index Examples</title> <meta name="description" content="这是一个 index 页面"> <meta name="keywords" content="index"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="renderer" content="webkit"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <link rel="icon" type="image/png" href="assets/i/favicon.png"> <link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"> <meta name="apple-mobile-web-app-title" content="Amaze UI" /> <link rel="stylesheet" href="assets/css/amazeui.min.css"/> <link rel="stylesheet" href="assets/css/admin.css"> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/app.js"></script> </head> <body>  <style type="text/css"> #admin{margin:100px 100px 0px 300px;} .content{font-size:18px;font-family:"微软雅黑";width:900px;height:490px;display:none;padding:5px;overflow-y:auto;line-height:30px;float:right} #footer{width:900px;height:30px;margin:0 auto;background-color:#ccc;line-height:30px;text-align:center;} .content1 {width:740px;height:490px;display:block;padding:5px;overflow-y:auto;line-height:30px;} </style> </head> <body> <header class="am-topbar admin-header"> <div class="am-topbar-brand"><img src="assets/i/logo.png"></div> </header> <div class="am-cf admin-main"> <div class="nav-navicon admin-main admin-sidebar"> <div class="sideMenu am-icon-dashboard" style="color:#aeb2b7; margin: 10px 0 0 0;"> 欢迎系统管理员</div> <div class="sideMenu"> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 用户管理</a></h3> <ul> <li><a href="searchuser.jsp">用户列表</li> <li><a href="adduser.jsp">用户注册</li> <li><a href="deleteuser.jsp">用户注销</li> </ul> <h3 class="am-icon-flag"><em></em> <a href="#">商品管理</a></h3> <ul> <li><a href="bsMgoods.jsp">商品列表</a></li> <li><a href="modifyphone.jsp">添加新商品</a></li> <li><a href="deletemobile.jsp">商品回收站</li> <li>商品分类</li> <li>库存管理 </li> </ul> <h3 class="am-icon-cart-plus"><em></em> <a href="#"> 订单管理</a></h3> <ul> <li><a href="searchorder.jsp">订单列表</li> <li>合并订单</li> <li><a href="modifyorder.jsp">添加订单</li> <li><a href="deleteorder.jsp">删除订单</li> <li>发货单列表</li> <li>换货单列表</li> </ul> </div>  <script type="text/javascript"> jQuery(".sideMenu").slide({ titCell:"h3", //鼠标触发对象 targetCell:"ul", //与titCell一一对应，第n个titCell控制第n个targetCell的显示隐藏 effect:"slideDown", //targetCell下拉效果 delayTime:300 , //效果时间 triggerTime:150, //鼠标延迟触发时间（默认150） defaultPlay:true,//默认是否执行效果（默认true） returnDefault:true //鼠标从.sideMen移走后返回默认状态（默认false） }); </script> </div> <div class=" admin-content"> <div class="daohang"> <ul> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs"> 首页 </li> <li><a href="index.jsp"><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">主页</button></a></li> <li><button type="button" class="am-btn am-btn-default am-radius am-btn-xs">帮助中心<a href="javascript: void(0)" class="am-close am-close-spin" data-am-modal-close="">×</a></button></li> </ul> </div> </div> </div> <div id="admin"> <div id="welcome" class="content" style="display:block;"> <div align="center"> <%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%> <HTML> <% String na=request.getParameter("version"); if(na==null) na =""; byte [] bb=na.getBytes("iso-8859-1"); na = new String(bb); %> <inquire:DelRecord name="<%=na%>" /> <BR>user表删除记录后的记录是： <inquire:QueryTag dataBaseName="warehourse" tableName="user" user="root" password=""/> <BR> <%=queryResult %> </HTML> </div> </div> </div> </body> </html>

（三）tag文件的代码：

<%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="mobile_version" required="true" %> <%@ attribute name="mobile_name" required="true" %> <%@ attribute name="mobile_made" required="true" %> <%@ attribute name="mobile_price" required="true" %> <%@ attribute name="mobile_mess" required="true" %> <%@ attribute name="mobile_pic" required="true" %> <%@ attribute name="id" required="true" %> <% StringBuffer result; result=new StringBuffer(); float p=Float.parseFloat(mobile_price); String condition= "INSERT INTO moblieform VALUES"+ "("+"'"+mobile_version+"','"+mobile_name+"','"+mobile_made+"',"+p+"','"+mobile_mess+"','"+mobile_pic+"','"+id+")"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehouse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="mobile_version" required="true" %> <%@ attribute name="mobile_name" required="true" %> <%@ attribute name="mobile_made" required="true" %> <%@ attribute name="mobile_price" required="true" %> <%@ attribute name="mobile_mess" required="true" %> <%@ attribute name="mobile_pic" required="true" %> <%@ attribute name="id" required="true" %> <% float p=Float.parseFloat(mobile_price); String condition= "INSERT INTO mobileform VALUES"+ "("+"'"+mobile_version+"','"+mobile_name+"','"+mobile_made+"',"+p+",'"+mobile_mess+"','"+mobile_pic+"','"+id+"')"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="id" required="true" %> <%@ attribute name="logname" required="true" %> <%@ attribute name="mess" required="true" %> <%@ attribute name="sum" required="true" %> <% float s=Float.parseFloat(sum); String condition= "INSERT INTO orderform VALUES"+ "("+"'"+id+"','"+logname+"','"+mess+"','"+s+"')"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="name" required="true" %> <% String condition = "DELETE FROM user WHERE logname= '"+name+"'"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); con=DriverManager.getConnection(uri,"root",""); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="number" required="true" %> <% String condition = "DELETE FROM mobileform WHERE mobile_version = '"+number+"'"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); con=DriverManager.getConnection(uri,"root",""); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="number" required="true" %> <% String condition = "DELETE FROM orderform WHERE id = '"+number+"'"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); con=DriverManager.getConnection(uri,"root",""); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); } catch(Exception e){ out.print(""+e); } %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="name" required="true" %> <%@ variable name-given="queryResultByName" scope="AT_END" %> <% StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0; try{ result.append("<table border=1>"); String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,"user",null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); String condition= "SELECT * FROM user Where logname ='"+name+"'"; rs=sql.executeQuery(condition); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append(e); } jspContext.setAttribute("queryResultByName",new String(result)); %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="name" required="true" %> <%@ variable name-given="queryResultByname" scope="AT_END" %> <% StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0; try{ result.append("<table border=1>"); String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,"orderform",null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); String condition= "SELECT * FROM orderform Where logname ='"+name+"'"; rs=sql.executeQuery(condition); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append(e); } jspContext.setAttribute("queryResultByname",new String(result)); %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="number" required="true" %> <%@ variable name-given="queryResultByNumber" scope="AT_END" %> <% StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0; try{ result.append("<table border=1>"); String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,"moblieform",null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); String condition= "SELECT * FROM moblieform Where mobile_version ='"+number+"'"; rs=sql.executeQuery(condition); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append(e); } jspContext.setAttribute("queryResultByNumber",new String(result)); %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="number" required="true" %> <%@ variable name-given="queryResultByNumber1" scope="AT_END" %> <% StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0; try{ result.append("<table border=1>"); String uri= "jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,"orderform",null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); String condition= "SELECT * FROM orderform Where id ='"+number+"'"; rs=sql.executeQuery(condition); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append(e); } jspContext.setAttribute("queryResultByNumber1",new String(result)); %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="priceMax" required="true" %> <%@ attribute name="priceMin" required="true" %> <%@ variable name-given="queryResultByPrice" scope="AT_END" %> <% float max=Float.parseFloat(priceMax); float min=Float.parseFloat(priceMin); StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0; try{ result.append("<table border=1>"); String uri="jdbc:mysql://127.0.0.1/warehourse"; con=DriverManager.getConnection(uri,"root",""); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,"moblieform",null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); String condition= "SELECT * FROM moblieform Where mobile_price <="+max+" AND "+"mobile_price >= "+min; rs=sql.executeQuery(condition); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append(e); } jspContext.setAttribute("queryResultByPrice",new String(result)); %> <%@ tag pageEncoding="GB2312" %> <%@ tag import="java.sql.*" %> <%@ attribute name="dataBaseName" required="true" %> <%@ attribute name="tableName" required="true" %> <%@ attribute name="user" required="true" %> <%@ attribute name="password" required="false" %> <%@ variable name-given="biao" scope="AT_END" %> <%@ variable name-given="queryResult" scope="AT_END" %> <% StringBuffer result; result=new StringBuffer(); try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ result.append("<table border=1>"); String uri="jdbc:mysql://127.0.0.1/warehourse?"+ "user=root&password=&characterEncoding=gb2312"; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,tableName,null); int 字段个数=0; result.append("<tr>"); while(rs1.next()){ 字段个数++; String clumnName=rs1.getString(4); result.append("<td>"+clumnName+"</td>"); } result.append("</tr>"); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM "+tableName); while(rs.next()){ result.append("<tr>"); for(int k=1;k<=字段个数;k++) result.append("<td>"+rs.getString(k)+"</td>"); result.append("</tr>"); } result.append("</table>"); con.close(); } catch(SQLException e){ result.append("请输入正确的用户名和密码"); } //返回对象queryResult： jspContext.setAttribute("queryResult",new String(result)); jspContext.setAttribute("biao",tableName); //返回biao对象 %>

附带连接：

最新回复(0)