“智多星”智能手机销售网

信管1172谢胜祥

该销售网的全部代码文件及用到的图片均在如下百度网盘内链接：https://pan.baidu.com/s/14KRdjH7Hk_rX2njRT6OB1w
提取码：8oda
由于以上链接有所有代码，故接下来的报告内容只出现少部分代码，较多的是调试成功的截图以及说明。

目录：一、实验要求，二、开发环境，三、前端，四、后台管理，五、总结

一、实验要求

系统后台开发

1、在导航条中添加一个后台管理菜单

2、后台页面分成左右两个框，左边显示一个树形菜单，右边根据菜单选择显示相应的交互界面；

3、实现对用户、产品分类、产品、订单等的后台管理；

4、具体界面自行设计

二、开发环境&技术

Myecplise10 MySQL5.7

JSP技术 dtree树形组件

三、前端界面

为了加快开发进度，前端给我们提供了源代码（提供的源代码默认root用户的密码为空，如果自行设置了密码需要在每一个连接数据库时的代码把密码加上），由于提供了源代码故不做过多的解释，源代码的调试结果如下：

主页：

注册页面&注册：

登录页面及登录验证：

浏览手机&浏览结果：

查看购物车功能（可在浏览手机后直接放入购物车）：

生成订单：

退出登录：

四、后台管理实现对数据库中表的操作（增加、删除、更新、显示）

由于是实验，对可进入后台管理的用户没有做限制，可以直接进入后台管理（想限制为指定的用户名才可以进入，没有做成功）

1、在mobileshop数据库中有4张:user(用户表) mobileform(手机基本信息表) mobileclassify(手机类别表) orderform(订单信息表)

2、（1）在后台管理对user表有显示、删除、更新操作

（2）对mobileform表及mobileclassify表有增加、显示、删除、更新操作

（3）对orderform表有显示、删除操作

3、树形菜单是在网上下载的dtree树形组件，自己修改后拿来使用，代码如下：

houtai.jsp

<%@ page contentType="text/html;charset=GB2312" %>
<head><link rel="StyleSheet" href="dtree.css" type="text/css" /><script type="text/javascript" src="dtree.js"></script>
</head>
<body>
<h2>后台管理</h2>
<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,'更新用户信息');d.add(2,0,'更新手机类别');d.add(3,0,'更新手机信息');d.add(4,0,'更新订单信息');d.add(5,0,'<a href="index.jsp" target ="_top">返回主页</ a>');d.add(6,1,'<a href="lookUser.jsp" target="right">显示</a>');d.add(7,1,'<a href="updateUser.jsp" target="right">修改</a>');d.add(8,1,'<a href="delUser.jsp" target="right">删除</a>');	d.add(9,2,'<a href="addmobileClsssify.jsp" target="right">增加</a>');		d.add(10,2,'<a href="lookmobileClassify.jsp" target="right">显示</a>');d.add(11,2,'<a href="updatemobileClassify.jsp" target="right">修改</a>');d.add(12,2,'<a href="delmobileClassify.jsp" target="right">删除</a>');d.add(13,3,'<a href="addmobileForm.jsp" target="right">增加</a>');	d.add(14,3,'<a href="lookmobileForm.jsp" target="right">显示</a>');d.add(15,3,'<a href="updatemobileForm.jsp" target="right">修改</a>');d.add(16,3,'<a href="delmobileForm.jsp" target="right">删除</a>');d.add(18,4,'<a href="lookorder.jsp" target="right">显示</a>');d.add(19,4,'<a href="delorderForm.jsp" target="right">删除</a>');document.write(d);</script>
</div>
</body>
</html>

dtree.css:

.dtree {font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;font-size: 11px;color: #666;white-space: nowrap;
}
.dtree img {border: 0px;vertical-align: middle;
}
.dtree a {color: #333;text-decoration: none;
}
.dtree a.node, .dtree a.nodeSel {white-space: nowrap;padding: 1px 2px 1px 2px;
}
.dtree a.node:hover, .dtree a.nodeSel:hover {color: #333;text-decoration: underline;
}
.dtree a.nodeSel {background-color: #c0d2ec;
}
.dtree .clip {overflow: hidden;
}

dtree.js:

// Node objectfunction Node(id, pid, name, url, title, target, icon, iconOpen, open) {this.id = id;this.pid = pid;this.name = name;this.url = url;this.title = title;this.target = target;this.icon = icon;this.iconOpen = iconOpen;this._io = open || false;this._is = false;this._ls = false;this._hc = false;this._ai = 0;this._p;};// Tree objectfunction dTree(objName) {this.config = {target					: null,folderLinks			: true,useSelection		: true,useCookies			: true,useLines				: true,useIcons				: true,useStatusText		: false,closeSameLevel	: false,inOrder					: false}this.icon = {root				: 'img/base.gif',folder			: 'img/folder.gif',folderOpen	: 'img/folderopen.gif',node				: 'img/page.gif',empty				: 'img/empty.gif',line				: 'img/line.gif',join				: 'img/join.gif',joinBottom	: 'img/joinbottom.gif',plus				: 'img/plus.gif',plusBottom	: 'img/plusbottom.gif',minus				: 'img/minus.gif',minusBottom	: 'img/minusbottom.gif',nlPlus			: 'img/nolines_plus.gif',nlMinus			: 'img/nolines_minus.gif'};this.obj = objName;this.aNodes = [];this.aIndent = [];this.root = new Node(-1);this.selectedNode = null;this.selectedFound = false;this.completed = false;};// Adds a new node to the node arraydTree.prototype.add = function(id, pid, name, url, title, target, icon, iconOpen, open) {this.aNodes[this.aNodes.length] = new Node(id, pid, name, url, title, target, icon, iconOpen, open);};// Open/close all nodesdTree.prototype.openAll = function() {this.oAll(true);};dTree.prototype.closeAll = function() {this.oAll(false);};// Outputs the tree to the pagedTree.prototype.toString = function() {var str = '<div class="dtree">\n';if (document.getElementById) {if (this.config.useCookies) this.selectedNode = this.getSelected();str += this.addNode(this.root);} else str += 'Browser not supported.';str += '</div>';if (!this.selectedFound) this.selectedNode = null;this.completed = true;return str;};// Creates the tree structuredTree.prototype.addNode = function(pNode) {var str = '';var n=0;if (this.config.inOrder) n = pNode._ai;for (n; n<this.aNodes.length; n++) {if (this.aNodes[n].pid == pNode.id) {var cn = this.aNodes[n];cn._p = pNode;cn._ai = n;this.setCS(cn);if (!cn.target && this.config.target) cn.target = this.config.target;if (cn._hc && !cn._io && this.config.useCookies) cn._io = this.isOpen(cn.id);if (!this.config.folderLinks && cn._hc) cn.url = null;if (this.config.useSelection && cn.id == this.selectedNode && !this.selectedFound) {cn._is = true;this.selectedNode = n;this.selectedFound = true;}str += this.node(cn, n);if (cn._ls) break;}}return str;};// Creates the node icon, url and textdTree.prototype.node = function(node, nodeId) {var str = '<div class="dTreeNode">' + this.indent(node, nodeId);if (this.config.useIcons) {if (!node.icon) node.icon = (this.root.id == node.pid) ? this.icon.root : ((node._hc) ? this.icon.folder : this.icon.node);if (!node.iconOpen) node.iconOpen = (node._hc) ? this.icon.folderOpen : this.icon.node;if (this.root.id == node.pid) {node.icon = this.icon.root;node.iconOpen = this.icon.root;}str += '<img id="i' + this.obj + nodeId + '" src="' + ((node._io) ? node.iconOpen : node.icon) + '" alt="" />';}if (node.url) {str += '<a id="s' + this.obj + nodeId + '" class="' + ((this.config.useSelection) ? ((node._is ? 'nodeSel' : 'node')) : 'node') + '" href="' + node.url + '"';if (node.title) str += ' title="' + node.title + '"';if (node.target) str += ' target="' + node.target + '"';if (this.config.useStatusText) str += ' onmouseover="window.status=\'' + node.name + '\';return true;" onmouseout="window.status=\'\';return true;" ';if (this.config.useSelection && ((node._hc && this.config.folderLinks) || !node._hc))str += ' onclick="javascript: ' + this.obj + '.s(' + nodeId + ');"';str += '>';}else if ((!this.config.folderLinks || !node.url) && node._hc && node.pid != this.root.id)str += '<a href="javascript: ' + this.obj + '.o(' + nodeId + ');" class="node">';str += node.name;if (node.url || ((!this.config.folderLinks || !node.url) && node._hc)) str += '</a>';str += '</div>';if (node._hc) {str += '<div id="d' + this.obj + nodeId + '" class="clip" style="display:' + ((this.root.id == node.pid || node._io) ? 'block' : 'none') + ';">';str += this.addNode(node);str += '</div>';}this.aIndent.pop();return str;};// Adds the empty and line iconsdTree.prototype.indent = function(node, nodeId) {var str = '';if (this.root.id != node.pid) {for (var n=0; n<this.aIndent.length; n++)str += '<img src="' + ( (this.aIndent[n] == 1 && this.config.useLines) ? this.icon.line : this.icon.empty ) + '" alt="" />';(node._ls) ? this.aIndent.push(0) : this.aIndent.push(1);if (node._hc) {str += '<a href="javascript: ' + this.obj + '.o(' + nodeId + ');"><img id="j' + this.obj + nodeId + '" src="';if (!this.config.useLines) str += (node._io) ? this.icon.nlMinus : this.icon.nlPlus;else str += ( (node._io) ? ((node._ls && this.config.useLines) ? this.icon.minusBottom : this.icon.minus) : ((node._ls && this.config.useLines) ? this.icon.plusBottom : this.icon.plus ) );str += '" alt="" /></a>';} else str += '<img src="' + ( (this.config.useLines) ? ((node._ls) ? this.icon.joinBottom : this.icon.join ) : this.icon.empty) + '" alt="" />';}return str;};// Checks if a node has any children and if it is the last siblingdTree.prototype.setCS = function(node) {var lastId;for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n].pid == node.id) node._hc = true;if (this.aNodes[n].pid == node.pid) lastId = this.aNodes[n].id;}if (lastId==node.id) node._ls = true;};// Returns the selected nodedTree.prototype.getSelected = function() {var sn = this.getCookie('cs' + this.obj);return (sn) ? sn : null;};// Highlights the selected nodedTree.prototype.s = function(id) {if (!this.config.useSelection) return;var cn = this.aNodes[id];if (cn._hc && !this.config.folderLinks) return;if (this.selectedNode != id) {if (this.selectedNode || this.selectedNode==0) {eOld = document.getElementById("s" + this.obj + this.selectedNode);eOld.className = "node";}eNew = document.getElementById("s" + this.obj + id);eNew.className = "nodeSel";this.selectedNode = id;if (this.config.useCookies) this.setCookie('cs' + this.obj, cn.id);}};// Toggle Open or closedTree.prototype.o = function(id) {var cn = this.aNodes[id];this.nodeStatus(!cn._io, id, cn._ls);cn._io = !cn._io;if (this.config.closeSameLevel) this.closeLevel(cn);if (this.config.useCookies) this.updateCookie();};// Open or close all nodesdTree.prototype.oAll = function(status) {for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n]._hc && this.aNodes[n].pid != this.root.id) {this.nodeStatus(status, n, this.aNodes[n]._ls)this.aNodes[n]._io = status;}}if (this.config.useCookies) this.updateCookie();};// Opens the tree to a specific nodedTree.prototype.openTo = function(nId, bSelect, bFirst) {if (!bFirst) {for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n].id == nId) {nId=n;break;}}}var cn=this.aNodes[nId];if (cn.pid==this.root.id || !cn._p) return;cn._io = true;cn._is = bSelect;if (this.completed && cn._hc) this.nodeStatus(true, cn._ai, cn._ls);if (this.completed && bSelect) this.s(cn._ai);else if (bSelect) this._sn=cn._ai;this.openTo(cn._p._ai, false, true);};// Closes all nodes on the same level as certain nodedTree.prototype.closeLevel = function(node) {for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n].pid == node.pid && this.aNodes[n].id != node.id && this.aNodes[n]._hc) {this.nodeStatus(false, n, this.aNodes[n]._ls);this.aNodes[n]._io = false;this.closeAllChildren(this.aNodes[n]);}}}// Closes all children of a nodedTree.prototype.closeAllChildren = function(node) {for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n].pid == node.id && this.aNodes[n]._hc) {if (this.aNodes[n]._io) this.nodeStatus(false, n, this.aNodes[n]._ls);this.aNodes[n]._io = false;this.closeAllChildren(this.aNodes[n]);		}}}// Change the status of a node(open or closed)dTree.prototype.nodeStatus = function(status, id, bottom) {eDiv	= document.getElementById('d' + this.obj + id);eJoin	= document.getElementById('j' + this.obj + id);if (this.config.useIcons) {eIcon	= document.getElementById('i' + this.obj + id);eIcon.src = (status) ? this.aNodes[id].iconOpen : this.aNodes[id].icon;}eJoin.src = (this.config.useLines)?((status)?((bottom)?this.icon.minusBottom:this.icon.minus):((bottom)?this.icon.plusBottom:this.icon.plus)):((status)?this.icon.nlMinus:this.icon.nlPlus);eDiv.style.display = (status) ? 'block': 'none';};// [Cookie] Clears a cookiedTree.prototype.clearCookie = function() {var now = new Date();var yesterday = new Date(now.getTime() - 1000 * 60 * 60 * 24);this.setCookie('co'+this.obj, 'cookieValue', yesterday);this.setCookie('cs'+this.obj, 'cookieValue', yesterday);};// [Cookie] Sets value in a cookiedTree.prototype.setCookie = function(cookieName, cookieValue, expires, path, domain, secure) {document.cookie =escape(cookieName) + '=' + escape(cookieValue)+ (expires ? '; expires=' + expires.toGMTString() : '')+ (path ? '; path=' + path : '')+ (domain ? '; domain=' + domain : '')+ (secure ? '; secure' : '');};// [Cookie] Gets a value from a cookiedTree.prototype.getCookie = function(cookieName) {var cookieValue = '';var posName = document.cookie.indexOf(escape(cookieName) + '=');if (posName != -1) {var posValue = posName + (escape(cookieName) + '=').length;var endPos = document.cookie.indexOf(';', posValue);if (endPos != -1) cookieValue = unescape(document.cookie.substring(posValue, endPos));else cookieValue = unescape(document.cookie.substring(posValue));}return (cookieValue);};// [Cookie] Returns ids of open nodes as a stringdTree.prototype.updateCookie = function() {var str = '';for (var n=0; n<this.aNodes.length; n++) {if (this.aNodes[n]._io && this.aNodes[n].pid != this.root.id) {if (str) str += '.';str += this.aNodes[n].id;}}this.setCookie('co' + this.obj, str);};// [Cookie] Checks if a node id is in a cookiedTree.prototype.isOpen = function(id) {var aOpen = this.getCookie('co' + this.obj).split('.');for (var n=0; n<aOpen.length; n++)if (aOpen[n] == id) return true;return false;};// If Push and pop is not implemented by the browserif (!Array.prototype.push) {Array.prototype.push = function array_push() {for(var i=0;i<arguments.length;i++)this[this.length]=arguments[i];return this.length;}};if (!Array.prototype.pop) {Array.prototype.pop = function array_pop() {lastElement = this[this.length-1];this.length = Math.max(this.length-1,0);return lastElement;}};

效果如图：

4、左边显示树形菜单，右边显示交互界面：（代码如下）

<%@ page contentType="text/html;charset=GB2312" %>
<html>
<title>左右显示</title><frameset cols="15%,*" rows="*" frameborder="1"><frame src="houtaigl.jsp" name="left"></frame><frame src="" name="right"></frame></frameset>
<body>
</body>
</html>

效果如图：