JSP智能手机销售网后台设计
1.手机主页面截图如上
1.主页面界面实现代码如下
head.txt
<%@ page contentType="text/html;charset=GB2312" %>
<div align="center">
<H2>“智多星”智能手机销售网</H2>
<table cellSpacing="1" cellPadding="1" width="660" align="center" border="0" >
<tr valign="bottom">
<td><A href="inputRegisterMess.jsp"><font size=2>注册</font></A></td>
<td><A href="login.jsp"><font size=2>登录</font></A></td>
<td><A href="lookMobile.jsp"><font size=2>浏览手机</font></A></td>
<td><A href="searchMobile.jsp"><font size=2>查询手机</font></A></td>
<td><A href="lookShoppingCar.jsp"><font size=2>查看购物车</font></A></td>
<td><A href="lookOrderForm.jsp"><font size=2>查看订单</font></A></td>
<td><A href="exitServlet"><font size=2>退出</font></A></td>
<td><A href="index.jsp"><font size=2>主页</font></A></td>
<td><A href="1.jsp"><font size=2>后台管理</font></A></td>
</tr>
</Font>
</table>
</div>
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<HEAD><%@ include file="head.txt" %></HEAD>
<title>首页</title>
<CENTER> <h1><font Size=4 color=blue>
欢迎光临“智多星”智能手机销售网
</font></h1>
<img src="image/welcome.jpg" width=500 height=400 ></img>
</CENTER>
</body>
</html>
2.后台主页面截图如上
2.后台主页面界面实现代码如下
导入dtree.js,dtree.css文件
1.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<title>Destroydrop » Javascripts » Tree</title>
<link rel="StyleSheet" href="dtree.css" type="text/css" />
<script type="text/javascript" src="dtree.js"></script>
</head>
<body bgcolor=PapayaWhip>
<h1>智能手机销售网管理后台</h1>
<div class="dtree" style="height:300px;float:left">
<p><a href="javascript: d.openAll();">open all</a> | <a href="javascript: d.closeAll();">close all</a></p>
<script type="text/javascript">
d = new dTree('d');
d.add(0,-1,'管理目录');
d.add(1,0,'用户管理');
d.add(2,1,'修改用户信息','','','','img/globe.gif');
d.add(3,1,'删除用户信息','deleteUser.jsp','','','img/globe.gif');
d.add(4,0,'订单管理');
d.add(5,4,'修改订单信息','','','','img/globe.gif');
d.add(6,4,'删除订单信息','deleteOrderform.jsp','','','img/globe.gif');
d.add(7,0,'手机信息管理');
d.add(8,7,'查询手机信息 ','searchMobile1.jsp','','','img/globe.gif');
d.add(9,7,'修改手机信息','','','','img/globe.gif');
d.add(10,7,'删除手机信息','deleteMobile.jsp','','','img/globe.gif');
d.add(11,0,'退出后台管理系统','index.jsp','','','img/trash.gif');
d.add(12,1,'查询用户信息','searchUser.jsp','','','img/globe.gif');
d.add(13,1,'浏览用户信息','lookUser.jsp','','','img/globe.gif');
d.add(14,7,'浏览手机信息','lookMobileform.jsp','','','img/globe.gif');
d.add(15,4,'浏览订单信息','lookOrderForm1.jsp','','','img/globe.gif');
d.add(16,4,'查询订单信息','','','','img/globe.gif');
document.write(d);
</script>
</div>
</body>
</html>
页面截图如上
界面实现代码如下
lookUser.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page import="java.sql.*" %>
<HTML>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<title>Destroydrop » Javascripts » Tree</title>
<link rel="StyleSheet" href="dtree.css" type="text/css" />
<script type="text/javascript" src="dtree.js"></script>
</head>
<body bgcolor=PapayaWhip>
<div id="ww" style="background-color:cyan;height:700px;width:900px;float:right">
<div align="center">
<h2>用户信息全览</h2><br>
<% try { Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
String uri="jdbc:mysql://127.0.0.1/wwy?"+
"user=root&password=&characterEncoding=gb2312";
Connection con;
Statement sql;
ResultSet rs;
try {
con=DriverManager.getConnection(uri);
sql=con.createStatement();
rs=sql.executeQuery("SELECT * from user");
out.print("<table border=2");
out.print("<tr>");
out.print("<th width=100>"+"用户名");
out.print("<th width=100>"+"密码");
out.print("<th width=100>"+"联系电话");
out.print("<th width=100>"+"邮件地址");
out.print("<th width=100>"+"真实姓名");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getString(4)+"</td>");
out.print("<td>"+rs.getString(5)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException e){
out.print(e);
}
%>
</div>
</div>
<h1>智能手机销售网管理后台</h1>
<div class="dtree" style="height:300px;float:left">
<p><a href="javascript: d.openAll();">open all</a> | <a href="javascript: d.closeAll();">close all</a></p>
<script type="text/javascript">
d = new dTree('d');
d.add(0,-1,'管理目录');
d.add(1,0,'用户管理');
d.add(2,1,'修改用户信息','','','','img/globe.gif');
d.add(3,1,'删除用户信息','deleteUser.jsp','','','img/globe.gif');
d.add(4,0,'订单管理');
d.add(5,4,'修改订单信息','','','','img/globe.gif');
d.add(6,4,'删除订单信息','deleteOrderform.jsp','','','img/globe.gif');
d.add(7,0,'手机信息管理');
d.add(8,7,'查询手机信息 ','searchMobile1.jsp','','','img/globe.gif');
d.add(9,7,'修改手机信息','','','','img/globe.gif');
d.add(10,7,'删除手机信息','deleteMobile.jsp','','','img/globe.gif');
d.add(11,0,'退出后台管理系统','index.jsp','','','img/trash.gif');
d.add(12,1,'查询用户信息','searchUser.jsp','','','img/globe.gif');
d.add(13,1,'浏览用户信息','lookUser.jsp','','','img/globe.gif');
d.add(14,7,'浏览手机信息','lookMobileform.jsp','','','img/globe.gif');
d.add(15,4,'浏览订单信息','lookOrderForm1.jsp','','','img/globe.gif');
d.add(16,4,'查询订单信息','','','','img/globe.gif');
document.write(d);
</script>
</div>
</BODY></HTML>
查询用户信息
页面截图如上
界面实现代码如下
searchUser.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<title>Destroydrop » Javascripts » Tree</title>
<link rel="StyleSheet" href="dtree.css" type="text/css" />
<script type="text/javascript" src="dtree.js"></script>
</head>
<body bgcolor=PapayaWhip>
<div id="ww" style="background-color:cyan;height:700px;width:900px;float:right">
<div align="center">
<h2>查询用户信息平台</h2><br>
<FORM action="searchUserServlet" Method="post">
输入查询信息:<input type=text name="xinxi"><br><br><br>
<input type=radio name="radio" value="user_name">通过用户名查询
<input type=radio name="radio" value="rluser_name">通过真名查询
<input type=radio name="radio" value="phone">通过手机号查询<br><br><br>
<input type=submit name="g" value="提交">
</FORM>
<FORM action="lookUser.jsp" method="post">
<input type=submit name="g" value="浏览用户信息">
</FORM>
</div></div>
<h1>智能手机销售网管理后台</h1>
<div class="dtree" style="height:300px;float:left">
<p><a href="javascript: d.openAll();">open all</a> | <a href="javascript: d.closeAll();">close all</a></p>
<script type="text/javascript">
d = new dTree('d');
d.add(0,-1,'管理目录');
d.add(1,0,'用户管理');
d.add(2,1,'修改用户信息','','','','img/globe.gif');
d.add(3,1,'删除用户信息','deleteUser.jsp','','','img/globe.gif');
d.add(4,0,'订单管理');
d.add(5,4,'修改订单信息','','','','img/globe.gif');
d.add(6,4,'删除订单信息','deleteOrderform.jsp','','','img/globe.gif');
d.add(7,0,'手机信息管理');
d.add(8,7,'查询手机信息 ','searchMobile1.jsp','','','img/globe.gif');
d.add(9,7,'修改手机信息','','','','img/globe.gif');
d.add(10,7,'删除手机信息','deleteMobile.jsp','','','img/globe.gif');
d.add(11,0,'退出后台管理系统','index.jsp','','','img/trash.gif');
d.add(12,1,'查询用户信息','searchUser.jsp','','','img/globe.gif');
d.add(13,1,'浏览用户信息','lookUser.jsp','','','img/globe.gif');
d.add(14,7,'浏览手机信息','lookMobileform.jsp','','','img/globe.gif');
d.add(15,4,'浏览订单信息','lookOrderForm1.jsp','','','img/globe.gif');
d.add(16,4,'查询订单信息','','','','img/globe.gif');
document.write(d);
</script>
</div>
</body>
</html>
页面截图如上
界面实现代码如下
deleteUser.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<title>Destroydrop » Javascripts » Tree</title>
<link rel="StyleSheet" href="dtree.css" type="text/css" />
<script type="text/javascript" src="dtree.js"></script>
</head>
<body bgcolor=PapayaWhip>
<div id="ww" style="background-color:cyan;height:700px;width:900px;float:right">
<div align="center">
<h2>删除用户信息平台</h2><br>
<Form action="deleteUserServlet" method="post">
输入要删除的用户名:<input type=text name="xinxin"><br><br><br>
<input type=submit name="g" value="提交"><br><br>
</Form>
<Form action="lookUser.jsp" method="post">
<input type=submit name="g" value="浏览用户信息">
</Form>
</div></div>
<h1>智能手机销售网管理后台</h1>
<div class="dtree" style="height:300px;float:left">
<p><a href="javascript: d.openAll();">open all</a> | <a href="javascript: d.closeAll();">close all</a></p>
<script type="text/javascript">
d = new dTree('d');
d.add(0,-1,'管理目录');
d.add(1,0,'用户管理');
d.add(2,1,'修改用户信息','','','','img/globe.gif');
d.add(3,1,'删除用户信息','deleteUser.jsp','','','img/globe.gif');
d.add(4,0,'订单管理');
d.add(5,4,'修改订单信息','','','','img/globe.gif');
d.add(6,4,'删除订单信息','deleteOrderform.jsp','','','img/globe.gif');
d.add(7,0,'手机信息管理');
d.add(8,7,'查询手机信息 ','searchMobile1.jsp','','','img/globe.gif');
d.add(9,7,'修改手机信息','','','','img/globe.gif');
d.add(10,7,'删除手机信息','deleteMobile.jsp','','','img/globe.gif');
d.add(11,0,'退出后台管理系统','index.jsp','','','img/trash.gif');
d.add(12,1,'查询用户信息','searchUser.jsp','','','img/globe.gif');
d.add(13,1,'浏览用户信息','lookUser.jsp','','','img/globe.gif');
d.add(14,7,'浏览手机信息','lookMobileform.jsp','','','img/globe.gif');
d.add(15,4,'浏览订单信息','lookOrderForm1.jsp','','','img/globe.gif');
d.add(16,4,'查询订单信息','','','','img/globe.gif');
document.write(d);
</script>
</div>
</body>
</html>
控制删除用户功能的servlet
DeleteUser.java
package myservlet.control;
import mybean.data.DataByPage;
import com.sun.rowset.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DeleteUser extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
CachedRowSetImpl rowSet=null;
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{
request.setCharacterEncoding("gb2312");
String deleteMess= request.getParameter("xinxin");
if(deleteMess==null||deleteMess.length()==0) {
fail(request,response,"没有相关用户信息，无法删除");
return;
}
String condition="DELETE from user WHERE logname Like '%"+deleteMess+"%'";
HttpSession session=request.getSession(true);
Connection con=null;
DataByPage dataBean=null;
try{
dataBean=(DataByPage)session.getAttribute("dataBean");
if(dataBean==null){
dataBean=new DataByPage(); //创建Javabean对象
session.setAttribute("dataBean",dataBean);
}
}
catch(Exception exp){
dataBean=new DataByPage();
session.setAttribute("dataBean",dataBean);
}
String uri = "jdbc:mysql://127.0.0.1/wwy?"+
"user=root&password=&characterEncoding=gb2312";
try{
con=DriverManager.getConnection(uri);
Statement sql=con.createStatement();
int a=sql.executeUpdate(condition);
con.close(); //关闭连接
}
catch(SQLException exp){}
success(request,response,"删除用户信息成功!");
return;
}
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException{
doPost(request,response);
}
public void fail(HttpServletRequest request,HttpServletResponse response,
String backNews) {
response.setContentType("text/html;charset=GB2312");
try {
PrintWriter out=response.getWriter();
out.println("<html><body>");
out.println("<h2>"+backNews+"</h2>") ;
out.println("返回:");
out.println("<a href =deleteUser.jsp>删除用户信息界面</a>");
out.println("</body></html>
因篇幅关系，手机管理模块以及订单管理模块只放出截图，代码参考上文
浏览手机信息截图查询手机信息截图删除手机信息截图删除订单信息截图
不足之处：
没有实现手机信息的添加功能，修改功能没有实现订单的修改功能没有实现进入后台需要管理员登录功能