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" >
<trvalign="bottom">
<td><Ahref="inputRegisterMess.jsp"><font size=2>注册</font></A></td>
<td><Ahref="login.jsp"><font size=2>登录</font></A></td>
<td><Ahref="lookMobile.jsp"><font size=2>浏览手机</font></A></td>
<td><Ahref="searchMobile.jsp"><font size=2>查询手机</font></A></td>
<td><Ahref="lookShoppingCar.jsp"><font size=2>查看购物车</font></A></td>
<td><Ahref="lookOrderForm.jsp"><font size=2>查看订单</font></A></td>
<td><Ahref="exitServlet"><font size=2>退出</font></A></td>
<td><Ahref="index.jsp"><font size=2>主页</font></A></td>
<td><Ahref="1.jsp"><font size=2>后台管理</font></A></td>
</tr>
</Font>
</table>
</div>
index.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<HEAD><%@includefile="head.txt"%></HEAD>
<title>首页</title>
<CENTER><h1><fontSize=4color=blue>
欢迎光临“智多星”智能手机销售网
</font></h1>
<imgsrc="image/welcome.jpg"width=500height=400></img>
</CENTER>
</body>
</html>
2.后台主页面截图如上
2.后台主页面界面实现代码如下
导入dtree.js,dtree.css文件
1.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<basehref="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<metahttp-equiv="pragma"content="no-cache">
<metahttp-equiv="cache-control"content="no-cache">
<metahttp-equiv="expires"content="0">
<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
<metahttp-equiv="description"content="This is my page">
<!--
<linkrel="stylesheet" type="text/css"href="styles.css">
-->
<title>Destroydrop»Javascripts»Tree</title>
<linkrel="StyleSheet"href="dtree.css"type="text/css"/>
<scripttype="text/javascript"src="dtree.js"></script>
</head>
<bodybgcolor=PapayaWhip>
<h1>智能手机销售网管理后台</h1>
<divclass="dtree"style="height:300px;float:left">
<p><ahref="javascript: d.openAll();">open all</a>| <ahref="javascript: d.closeAll();">close all</a></p>
<scripttype="text/javascript">
d =newdTree('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>
3.功能实现模块
(1).用户管理模块
浏览用户信息
页面截图如上
界面实现代码如下
lookUser.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<%@pageimport="java.sql.*"%>
<HTML>
<head>
<basehref="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<metahttp-equiv="pragma"content="no-cache">
<metahttp-equiv="cache-control"content="no-cache">
<metahttp-equiv="expires"content="0">
<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
<metahttp-equiv="description"content="This is my page">
<!--
<linkrel="stylesheet" type="text/css"href="styles.css">
-->
<title>Destroydrop»Javascripts»Tree</title>
<linkrel="StyleSheet"href="dtree.css"type="text/css"/>
<scripttype="text/javascript"src="dtree.js"></script>
</head>
<bodybgcolor=PapayaWhip>
<divid="ww"style="background-color:cyan;height:700px;width:900px;float:right">
<divalign="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>
<divclass="dtree"style="height:300px;float:left">
<p><ahref="javascript: d.openAll();">open all</a>| <ahref="javascript: d.closeAll();">close all</a></p>
<scripttype="text/javascript">
d =newdTree('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
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<basehref="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<metahttp-equiv="pragma"content="no-cache">
<metahttp-equiv="cache-control"content="no-cache">
<metahttp-equiv="expires"content="0">
<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
<metahttp-equiv="description"content="This is my page">
<!--
<linkrel="stylesheet" type="text/css"href="styles.css">
-->
<title>Destroydrop»Javascripts»Tree</title>
<linkrel="StyleSheet"href="dtree.css"type="text/css"/>
<scripttype="text/javascript"src="dtree.js"></script>
</head>
<bodybgcolor=PapayaWhip>
<divid="ww"style="background-color:cyan;height:700px;width:900px;float:right">
<divalign="center">
<h2>查询用户信息平台</h2><br>
<FORMaction="searchUserServlet"Method="post">
输入查询信息:<inputtype=textname="xinxi"><br><br><br>
<inputtype=radioname="radio"value="user_name">通过用户名查询
<inputtype=radioname="radio"value="rluser_name">通过真名查询
<inputtype=radioname="radio"value="phone">通过手机号查询<br><br><br>
<inputtype=submitname="g"value="提交">
</FORM>
<FORMaction="lookUser.jsp"method="post">
<inputtype=submitname="g"value="浏览用户信息">
</FORM>
</div></div>
<h1>智能手机销售网管理后台</h1>
<divclass="dtree"style="height:300px;float:left">
<p><ahref="javascript: d.openAll();">open all</a>| <ahref="javascript: d.closeAll();">close all</a></p>
<scripttype="text/javascript">
d =newdTree('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>
显示查询结果的页面jsp
searchUser_show.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<basehref="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<metahttp-equiv="pragma"content="no-cache">
<metahttp-equiv="cache-control"content="no-cache">
<metahttp-equiv="expires"content="0">
<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
<metahttp-equiv="description"content="This is my page">
<!--
<linkrel="stylesheet" type="text/css"href="styles.css">
-->
<title>Destroydrop»Javascripts»Tree</title>
<linkrel="StyleSheet"href="dtree.css"type="text/css"/>
<scripttype="text/javascript"src="dtree.js"></script>
</head>
<%@pageimport="mybean.data.DataByPage"%>
<%@pageimport="com.sun.rowset.*"%>
<jsp:useBeanid="dataBean"class="mybean.data.DataByPage"scope="session"/>
<html><Bodybgcolor=PapayaWhip>
<divid="ww"style="background-color:cyan;height:700px;width:900px;float:right">
<divalign="center"><h1>查询用户信息平台</h1>
<BR>当前显示的内容是:
<tableborder=2>
<tr>
<th>用户名</th>
<th>密码</th>
<th>联系电话</th>
<th>邮件地址</th>
<th>真实姓名</th>
</tr>
<jsp:setPropertyname="dataBean"property="pageSize"param="pageSize"/>
<jsp:setPropertyname="dataBean"property="currentPage"param="currentPage"/>
<%
CachedRowSetImpl rowSet=dataBean.getRowSet();
if(rowSet==null) {
out.print("没有查询到结果,无法浏览");
return;
}
rowSet.last();
inttotalRecord=rowSet.getRow();
out.println("全部记录数"+totalRecord); //全部记录数
intpageSize=dataBean.getPageSize(); //每页显示的记录数
inttotalPages = dataBean.getTotalPages();
if(totalRecord%pageSize==0)
totalPages = totalRecord/pageSize;//总页数
else
totalPages = totalRecord/pageSize+1;
dataBean.setPageSize(pageSize);
dataBean.setTotalPages(totalPages);
if(totalPages>=1) {
if(dataBean.getCurrentPage()<1)
dataBean.setCurrentPage(dataBean.getTotalPages());
if(dataBean.getCurrentPage()>dataBean.getTotalPages())
dataBean.setCurrentPage(1);
intindex=(dataBean.getCurrentPage()-1)*pageSize+1;
rowSet.absolute(index); //查询位置移动到currentPage页起始位置
booleanboo=true;
for(inti=1;i<=pageSize&&boo;i++) {
String logname=rowSet.getString(1);
String password=rowSet.getString(2);
String phone=rowSet.getString(3);
String address=rowSet.getString(4);
String realname=rowSet.getString(5);
out.print("<tr>");
out.print("<td>"+logname+"</td>");
out.print("<td>"+password+"</td>");
out.print("<td>"+phone+"</td>");
out.print("<td>"+address+"</td>");
out.print("<td>"+realname+"</td>");
out.print("</tr>");
boo=rowSet.next();
}
}
%>
</table>
<br><br><br>
<FORMaction="lookUser.jsp"method=post>
<Inputtype=submitname="g"value="浏览用户信息"></FORM>
<FORMaction="searchUser.jsp"method=post>
<Inputtype=submitname="g"value="返回查询界面"></FORM>
</div>
</div>
<h1>智能手机销售网管理后台</h1>
<divclass="dtree"style="height:300px;float:left">
<p><ahref="javascript: d.openAll();">open all</a>| <ahref="javascript: d.closeAll();">close all</a></p>
<scripttype="text/javascript">
d =newdTree('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
SearchUser.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 SearchUser 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 void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
request.setCharacterEncoding("gb2312");
String searchMess= request.getParameter("xinxi");
String radioMess= request.getParameter("radio");
if(searchMess==null||searchMess.length()==0) {
fail(request,response,"没有查询信息,无法查询");
return;
}
String condition="";
if(radioMess.equals("user_name")) {
condition =
"SELECT * FROM user where logname LIKE '%"+searchMess+"%'";
}
else if(radioMess.equals("rluser_name")) {
condition =
"SELECT * FROM user where realname LIKE '%"+searchMess+"%'";
}
else if(radioMess.equals("phone")) {
condition =
"SELECT * FROM user where phone ='"+searchMess+"'";
}
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(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs=sql.executeQuery(condition);
rowSet=new CachedRowSetImpl(); //创建行集对象
rowSet.populate(rs);
dataBean.setRowSet(rowSet); //行集数据存储在dataBean中
con.close(); //关闭连接
}
catch(SQLException exp){}
response.sendRedirect("searchUser_show.jsp");//重定向到byPageShow.jsp
}
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 =searchUser.jsp>查询界面</a>");
out.println("</body></html>");
}
catch(IOException exp){}
}
}
删除用户信息
页面截图如上
界面实现代码如下
deleteUser.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<basehref="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<metahttp-equiv="pragma"content="no-cache">
<metahttp-equiv="cache-control"content="no-cache">
<metahttp-equiv="expires"content="0">
<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
<metahttp-equiv="description"content="This is my page">
<!--
<linkrel="stylesheet" type="text/css"href="styles.css">
-->
<title>Destroydrop»Javascripts»Tree</title>
<linkrel="StyleSheet"href="dtree.css"type="text/css"/>
<scripttype="text/javascript"src="dtree.js"></script>
</head>
<bodybgcolor=PapayaWhip>
<divid="ww"style="background-color:cyan;height:700px;width:900px;float:right">
<divalign="center">
<h2>删除用户信息平台</h2><br>
<Formaction="deleteUserServlet"method="post">
输入要删除的用户名:<inputtype=textname="xinxin"><br><br><br>
<inputtype=submitname="g"value="提交"><br><br>
</Form>
<Formaction="lookUser.jsp"method="post">
<inputtype=submitname="g"value="浏览用户信息">
</Form>
</div></div>
<h1>智能手机销售网管理后台</h1>
<divclass="dtree"style="height:300px;float:left">
<p><ahref="javascript: d.openAll();">open all</a>| <ahref="javascript: d.closeAll();">close all</a></p>
<scripttype="text/javascript">
d =newdTree('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>");
}
catch(IOException exp){}
}
public void success(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("<a href =deleteUser.jsp>返回删除用户信息界面</a>");
out.println("</body></html>");}
catch(IOException exp){}}}
因篇幅关系,手机管理模块以及订单管理模块只放出截图,代码参考上文
浏览手机信息截图查询手机信息截图删除手机信息截图删除订单信息截图
不足之处:
没有实现手机信息的添加功能,修改功能没有实现订单的修改功能没有实现进入后台需要管理员登录功能
感想:自己对知识运用不够到位,时间紧没有精修页面效果,啥也不说了,认真学习!