应用程序设计与开发课程基础项目部分

概数据库表结 用户表模块表角色表角色信息视图dbo.usersONdbo.roles.rolename=dbo.users.rolenameINNERJOINdbo.modulesINNER

dbo.rolesINNER登录功 实现效11.3.2登录界面<div<div<div }if(e.keyCode==13)}$.messager.alert("提示","用户名不能为空}$.messager.alert("提示 }var$.messager.alert("提示

11.3.3后端代码packageimportimportimportimportjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importimportcom.tjut.dbutil.DbHelper;importcom.tjut.util.WebUtil;publicclassLoginServiceextendsHttpServlet{privatestaticfinallongserialVersionUID=1L;publicLoginService(){}doPost(request,response);}tryStringsql="select*fromuserswhereusername=?andpassword=?";Objectargs[]={username,password};if(list.size()>0)HttpSessionsession=request.getSession();}else }}}}主界面功 实现效<%@pageStringpath=HttpSessionmySession=request.getSession();Stringsession_username=mySession.getAttribute("username").toString();<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""<base 理工大学学生信息管理系统<linkrel="stylesheet"type="text/css"href="css/default.css"<linkrel="stylesheet"type="text/css"href="css/icon.css"<linkrel="stylesheet"type="text/css"href="css/easyui.css"<scripttype="text/javascript"<scripttype="text/javascript"<scripttype="text/javascript"src="js/left.js"><scriptvar<bodyclass="easyui-layout"style="overflow-y:hidden"<divregion="north"split="trueborder="false"style="overflowhidden;height50px;background:url(images/left/layout-browser-hd-bg.gif)#7f99berepeat-xcenter50%;line-height:40px;color:#fff;font-family:Verdana,微软雅黑,黑体">;"%><%%>

/><divregion="westhide="true"split="true"title="导航菜单style="width:200px<divid="nav"class="easyui-accordion"fit="true" <divid="mainPanle"region="center"style="background:#eee;overflow-<divid="tabs"class="easyui- <divtitle="我的任务" "<div<h1style="font-<h1style="font-11.4.3左侧功能树的实现 {"icon":"icon- name":"系统管理 {"icon":"icon- name":"用户管理{"icon":"icon- name":"角色管理{"icon":"icon- name":"模块信{"icon":"icon- name":"学生管理 {"icon":"icon- name":"学生信息{"icon":"icon- name":"基础数据 {"icon":"icon- name":"通用数据","pid":"0500","url":" packageimportjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importimportjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importcom.alibaba.fastjson.JSON;importcom.tjut.util.WebUtil;privatestaticfinallongserialVersionUID=1L;publicSystemManageServices(){}doPost(request,response);}Stringusername=WebUtil.getRequestParameter(request,"username");}Stringret="";List<Object>list=newArrayList<Object>();StringStringsql="selectmnoas id,mnameas name,imageasicon,url fromvwuserrolewherepmno=''andusername='"+username+"'orderbymno";ArrayList<HashMap<String,String>>dt=DbHelper.executeQuery(sql);for(inti=0;i<dt.size();i++){