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

一、实验要求

系统后台开发具体要求(课本第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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]--></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><!-- sideMenu End --> <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><!--[if lt IE 9]>
<script src="http://libs.baidu.com/jquery/1.11.1/jquery.min.js"></script>
<script src="http://cdn.staticfile.org/modernizr/2.8.3/modernizr.js"></script>
<script src="assets/js/polyfill/rem.min.js"></script>
<script src="assets/js/polyfill/respond.min.js"></script>
<script src="assets/js/amazeui.legacy.js"></script>
<![endif]--> <!--[if (gte IE 9)|!(IE)]><!--> 
<script src="assets/js/amazeui.min.js"></script>
<!--<![endif]--></Font></Body></HTML>
</body>
</html>

（1）实现查询用户列表

代码：

<%--<%--Created by IntelliJ IDEA.User: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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><!--[if lt IE 9]>
<script src="http://libs.baidu.com/jquery/1.11.1/jquery.min.js"></script>
<script src="http://cdn.staticfile.org/modernizr/2.8.3/modernizr.js"></script>
<script src="assets/js/polyfill/rem.min.js"></script>
<script src="assets/js/polyfill/respond.min.js"></script>
<script src="assets/js/amazeui.legacy.js"></script>
<![endif]--> <!--[if (gte IE 9)|!(IE)]><!--> 
<script src="assets/js/amazeui.min.js"></script>
<!--<![endif]--></Font></Body></HTML>
</body>
</html>

（5）添加商品

代码：

<%--<%--Created by IntelliJ IDEA.User: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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: corrineDate: 2019-05-16Time: 21:31To 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>
<!--[if lte IE 9]><p class="browsehappy">升级你的浏览器吧！ <a href="http://www.htmlsucai.com" target="_blank">升级浏览器</a>以获得更好的体验！</p><![endif]-->
<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><!-- sideMenu End --> <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对象
%>

附带连接：