1前台页面
2.重要步骤
树形菜单的实现:
tree.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<head>
<link rel="StyleSheet" href="dtree.css" type="text/css" />
<script type="text/javascript" src="dtree.js"></script>
</head>
<BODY><font size=5>
<b>后台管理</b>
<div class="dtree">
<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,'<FONT size=4>用户管理</FONT>');
d.add(2,1,'<a href="userAdd.jsp" target="right"><FONT size=4>添加用户</FONT></a>');
d.add(3,1,'<a href="userDelete.jsp" target="right"><FONT size=4>删除用户</FONT></a>');
d.add(5,0,'<FONT size=4>产品管理');
d.add(6,5,'<a href="productAdd.jsp" target="right"><FONT size=4>添加产品</FONT></a>');
d.add(7,5,'<a href="productDelete.jsp" target="right"><FONT size=4>删除产品</FONT></a>');
d.add(9,0,'<FONT size=4>产品分类');
d.add(10,9,'<a href="classifyAdd.jsp" target="right"><FONT size=4>添加类型</FONT></a>');
d.add(11,9,'<a href="classifyDelete.jsp" target="right"><FONT size=4>删除类型</FONT></a>');
d.add(13,0,'<FONT size=4>订单管理');
d.add(14,13,'<a href="orderAdd.jsp" target="right"><FONT size=4>添加订单</FONT></a>');
d.add(15,13,'<a href="orderDelete.jsp" target="right"><FONT size=4>删除订单</FONT></a>');
d.add(17,0,'<a href="index.jsp" target ="_top"><FONT size=4>返回主页</FONT></a>');
document.write(d);
</script>
</div>
</font>
</BODY>
</HTML>
用户的添加
添加原理:userAdd.jsp提交新的记录到newUser.jsp页面,该页面调用AddUserRecord.tag文件添加新的记录到user表,从而实现user表的添加。
QueryTag.tag:别的页面通过提交数据库名,表名,用户名,密码可以浏览表的内容
<%@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){
result.append("请输入正确的用户名和密码");
}
Connection con;
Statement sql;
ResultSet rs;
try{ result.append("<table border=1>");
String uri="jdbc:mysql://127.0.0.1/"+dataBaseName;
con=DriverManager.getConnection(uri,user,password);
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("请输入正确的用户名和密码");
}
jspContext.setAttribute("queryResult",new String(result));
jspContext.setAttribute("biao",tableName);
%>
userAdd.jsp
<%@page contentType="text/html;charset=gb2312"%>
<%@taglib tagdir="/WEB-INF/tags" prefix="inquire"%>
<HTML><BODY bgcolor=pink><FONT size=3>
<FORM action="newUser.jsp" method=post>
添加新纪录:
<table border=1>
<tr><td>用户名:</td><td><Input type="text" name="logname"></td></tr>
<tr><td>密码:</td><td><Input type="text" name="password"></td></tr>
<tr><td>电话:</td><td><Input type="text" name="phone"></td></tr>
<tr><td>邮箱地址:</td><td><Input type="text" name="address"></td></tr>
<tr><td>真实名字:</td><td><Input type="text" name="realname"></td></tr>
</table>
<BR><input type="submit" name="b" value="提交">
<BR>user表添加新纪录之前的记录是:
<inquire:QueryTag dataBaseName="mobileshop"
tableName="user"
user="root" password="" />
<BR><%=queryResult%>
<td><A href="index.jsp"><font size=2>返回主页</font></A></td>
</FONT></BODY></HTML>
AddUserRecord.jsp
<%@tag pageEncoding="GB2312"%>
<%@tag import="java.sql.*"%>
<%@attribute name="logname" required="true"%>
<%@attribute name="password" required="true"%>
<%@attribute name="phone" required="true"%>
<%@attribute name="address" required="true"%>
<%@attribute name="realname" required="true"%>
<% String condition="INSERT INTO user VALUES"+
"("+"'"+logname+"','"+