一、实验要求
系统后台开发具体要求(课本第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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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: 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>
<!--[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对象
%>
附带连接: