本系统的具体源码、mysql5.6.43数据库表、以及数据库连接驱动、部分实验结果图详情请打开百度网盘查看:
链接:https://pan.baidu.com/s/1-bBa4oPMWpTUg0QYMFx-oQ
提取码:hu59
手机销售网
1、数据库设计
本系统采用的是MySQL5.6.43,分别建立了四个表:user表、mobileClassify表、mobileForm表、orderForm表:
2、数据库连接
String uri= "jdbc:mysql://127.0.0.1/mobileshop?"+"user=root&password=&characterEncoding=GB2312";
con=DriverManager.getConnection(uri);
4、会员注册
5、会员登陆
6、查询手机
backhead.txt
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="mybean.data.Login" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="loginBean" class="mybean.data.Login" scope="session"/>
<HTML>
<title>my page</title>
<frameset cols="15%,*" rows="*" frameborder="1">
<frame src="tree.jsp" name="left">
</frame>
<frame src="backindex.jsp" name="right">
</frame>
</frameset>
<BODY bgcolor=yellow><font size=2>
<div align="center">
<% if(loginBean==null){
response.sendRedirect("login.jsp");//重定向到登录页面
}
else {
boolean b =loginBean.getLogname()==null||
loginBean.getLogname().length()==0;
if(b)
response.sendRedirect("login.jsp");//重定向到登录页面
}
%>
</div></font>
</BODY></HTML>
backindex.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML> <BODY>
<HEAD><%@ include file="backhead.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>
lookuser.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><BODY bgcolor=cyan><font size=2>
<HEAD><%@ include file="backhead.txt" %></HEAD>
<div align="center">
<%
Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
try { String uri= "jdbc:mysql://127.0.0.1/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
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">
</FONT></BODY></HTML>
finduser.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>查询用户信息<br>
<FORM action="byLogname.jsp" Method="post" >
<br>输入用户注册名:<Input type=text name="logname"><br>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
byLogname.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML>
<BODY bgcolor=#55BBDD><font size=2>
<% String logname= request.getParameter("logname");
if(logname==null)
logname="";
byte [] bb=logname.getBytes("iso-8859-1");
logname=new String(bb);
%>
<inquire:lognameCondition logname="<%= logname%>"/>
根据用户注册名<%= logname%>查询到的结果:
<BR><%=queryResultByLogname%>
</Font></BODY></HTML>
lognameCondition.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="logname" required="true" %>
<%@ variable name-given= "queryResultByLogname" 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/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
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();
rs=sql.executeQuery("SELECT * FROM user Where logname='"+logname+"'");
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("queryResultByLogname",new String(result));
%>
后台用户删除
deluser.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>删除用户信息<br>
<FORM action="deleteUser.jsp" Method="post" >
<br>输入用户注册名:<Input type=text name="logname"><br>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
deleteUser.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML>
<BODY bgcolor=#55BBDD><font size=2>
<% String logname= request.getParameter("logname");
if(logname==null)
logname="";
byte [] bb=logname.getBytes("iso-8859-1");
logname=new String(bb);
%>
<inquire:DelUserRecord logname="<%= logname%>"/>
<BR>删除成功
</Font></BODY></HTML>
DelUserRecord.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="logname" required="true" %>
<%
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/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
sql.executeUpdate("DELETE FROM user Where logname='"+logname+"'");
con.close();
}
catch(SQLException e){
out.print(""+e);
}
%>
lookproduct.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><BODY bgcolor=cyan><font size=2>
<HEAD><%@ include file="backhead.txt" %></HEAD>
<div align="center">
<%
Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
try { String uri= "jdbc:mysql://127.0.0.1/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM mobileForm");
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("<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("<td >"+rs.getString(6)+"</td>");
out.print("<td >"+rs.getString(7)+"</td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e){
out.print(e);
}
%>
</div">
</FONT></BODY></HTML>
addproduct.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>添加产品信息<br>
<FORM action="newProduct.jsp" Method="post" >
<table border=1>
<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="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
newProduct.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML> <BODY bgcolor=#55BBDD><font size=2>
<%!
String handleStr(String s){
try{
byte bb[]=s.getBytes("iso-8859-1");
return new String(bb);
}
catch(Exception exp){}
return s;
}
%>
<% String mobile_version=handleStr(request.getParameter("mobile_version"));
String mobile_name=handleStr(request.getParameter("mobile_name"));
String mobile_made=handleStr(request.getParameter("mobile_made"));
String mobile_price=handleStr(request.getParameter("mobile_price"));
String mobile_mess=handleStr(request.getParameter("mobile_mess"));
String mobile_pic=handleStr(request.getParameter("mobile_pic"));
String id=handleStr(request.getParameter("id"));
%>
<inquire:addProductRecord mobile_version="<%=mobile_version%>" mobile_name="<%=mobile_name%>"
mobile_made="<%=mobile_made%>" mobile_price="<%=mobile_price%>"
mobile_mess="<%=mobile_mess%>" mobile_pic="<%=mobile_pic%>" id="<%=id%>"/>
<BR>添加成功
</Font></BODY></HTML>
addProductRecord.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" %>
<%
float p=Float.parseFloat(mobile_price);
int i=Integer.parseInt(id);
String condition=
"INSERT INTO mobileForm VALUES"+
"("+"'"+mobile_version+"','"+mobile_name+"','"+mobile_made+"','"+p+"','"+mobile_mess+"','"+mobile_pic+"','"+i+"')";
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/mobileshop?"+"user=root&password=&characterEncoding=GB2312";
con=DriverManager.getConnection(uri);
sql=con.createStatement();
sql.executeUpdate(condition);
con.close();
}
catch(Exception e){
out.print(""+e);
}
%>
deleteProduct.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML>
<BODY bgcolor=#55BBDD><font size=2>
<% String mobile_version= request.getParameter("mobile_version");
if(mobile_version==null)
mobile_version="";
byte [] bb=mobile_version.getBytes("iso-8859-1");
mobile_version=new String(bb);
%>
<inquire:DelProductRecord mobile_version="<%=mobile_version%>"/>
<BR>删除成功
</Font></BODY></HTML>
delproduct.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>删除产品信息<br>
<FORM action="deleteProduct.jsp" Method="post" >
<br>输入产品标识符:<Input type=text name="mobile_version"><br>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
DelProductRecord.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="mobile_version" required="true" %>
<%
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/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
sql.executeUpdate("DELETE FROM mobileForm Where mobile_version='"+mobile_version+"'");
con.close();
}
catch(SQLException e){
out.print(""+e);
}
%>
lookclassify.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><BODY bgcolor=cyan><font size=2>
<HEAD><%@ include file="backhead.txt" %></HEAD>
<div align="center">
<%
Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
try { String uri= "jdbc:mysql://127.0.0.1/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM mobileClassify");
out.print("<table border=2>");
out.print("<tr>");
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("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e){
out.print(e);
}
%>
</div">
</FONT></BODY></HTML>
addclassify.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>添加产品分类<br>
<FORM action="newClassify.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="name"></td></tr>
</table>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
newClassify.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML> <BODY bgcolor=#55BBDD><font size=2>
<%!
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 name=handleStr(request.getParameter("name"));
%>
<inquire:addClassifyRecord id="<%=id%>" name="<%=name%>"/>
<BR>添加成功
</Font></BODY></HTML>
addClassifyRecord.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="id" required="true" %>
<%@ attribute name="name" required="true" %>
<%
int i=Integer.parseInt(id);
String condition=
"INSERT INTO mobileClassify VALUES"+
"("+"'"+i+"','"+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/mobileshop?"+"user=root&password=&characterEncoding=GB2312";
con=DriverManager.getConnection(uri);
sql=con.createStatement();
sql.executeUpdate(condition);
con.close();
}
catch(Exception e){
out.print(""+e);
}
%>
deleteClassify.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML>
<BODY bgcolor=#55BBDD><font size=2>
<% String id= request.getParameter("id");
if(id==null)
id="";
byte [] bb=id.getBytes("iso-8859-1");
id=new String(bb);
%>
<inquire:DelClassifyRecord id="<%= id%>"/>
<BR>删除成功
</Font></BODY></HTML>
delclassify.jsp
<%@ page contentType="text/html;charset=GB2312"%>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>删除产品分类<br>
<FORM action="deleteClassify.jsp" Method="post" >
<br>输入产品分类号:<Input type=text name="id"><br>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
DelClassifyRecord.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="id" required="true" %>
<%
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/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
sql.executeUpdate("DELETE FROM mobileClassify Where id='"+id+"'");
con.close();
}
catch(SQLException e){
out.print(""+e);
}
%>
lookorder.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><BODY bgcolor=cyan><font size=2>
<HEAD><%@ include file="backhead.txt" %></HEAD>
<div align="center">
<%
Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
try { String uri= "jdbc:mysql://127.0.0.1/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM orderForm");
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("</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("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e){
out.print(e);
}
%>
</div">
</FONT></BODY></HTML>
delOrder.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="backhead.txt" %></HEAD>
<BODY bgcolor=#55BBDD><font size=2>
<div align="center">
<br>删除订单序号<br>
<FORM action="deleteOrder.jsp" Method="post" >
<br>输入订单序号:<Input type=text name="id"><br>
<br><Input type=submit name="g" value="提交">
</Form>
</div>
</Font></BODY></HTML>
deleteOrder.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir = "/WEB-INF/tags" prefix = "inquire" %>
<HTML>
<BODY bgcolor=#55BBDD><font size=2>
<% String id= request.getParameter("id");
if(id==null)
id="";
byte [] bb=id.getBytes("iso-8859-1");
id=new String(bb);
%>
<inquire:DelOrderRecord id="<%= id%>"/>
<BR>删除成功
</Font></BODY></HTML>
DelOrderRecord.tag
<%@ tag pageEncoding = "GB2312" %>
<%@ tag import = "java.sql.*"%>
<%@ attribute name="id" required="true" %>
<%
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/mobileshop";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
sql.executeUpdate("DELETE FROM orderForm Where id='"+id+"'");
con.close();
}
catch(SQLException e){
out.print(""+e);
}
%>
本系统页面比较简洁,前端采用了servlet,后台采用dtree实现树形菜单,在后台管理系统中采用了tags文件进行相应,实现了用户、产品分类、产品信息、订单的查询与删除以及对产品分类和产品信息的添加,缺点是没有实现对用户、产品、订单的更新操作。