應(yīng)用程序設(shè)計與開發(fā)課程基礎(chǔ)項目部分

角色表角色信息視圖SELECTdbo.users.uid,dbo.users.username,dbo.users.password,dbo.users.rolename,dbo.modules.*FROM dbo.rolesINNERJOINdbo.usersONdbo.roles.rolename=dbo.users.rolenameINNERJOINdbo.modulesINNERdbo.roleinfoONdbo.modules.mno=dbo.roleinfo.mnoONdbo.roles.rolename=登錄界面<div<div<form<div<inputclass="easyui-textboxid="usernamename="usernamestyle="width:100%;height:40px;padding:12pxdata-options="prompt:'請輸入用戶<inputclass="easyui-textboxtype="password"id="password"name="password"style="width:100%;height:40px;padding:12pxdata-options="prompt:'請輸入密<spanstyle="font-size:14px;"><divclass="copyright">理工大學(xué)計算機科學(xué)與?2019技術(shù)話 JS<linktype="text/css"rel="stylesheet"href="css/icon.css"<scripttype="text/javascript"<scripttype="text/javascript"<script}if(e.keyCode==13)}}}var}packagecom.tjut.system;importjava.io.IOException;importjava.util.ArrayList;importjava.util.HashMap;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjavax.servlet.http.HttpSession;importcom.tjut.dbutil.DbHelper;importcom.tjut.util.WebUtil;publicclassLoginServiceextendsHttpServlet{privatestaticfinallongserialVersionUID=1L;publicLoginService(){}protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{doPost(request,response);}protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOExceptiontryStringpassword=WebUtil.getRequestParameter(request,"password");Stringsql="select*fromuserswhereusername=?andpassword=?";Objectargs[]={username,password};if(list.size()>0)HttpSessionsession=request.getSession();WebUtil.handleResponse(response,"success","");}else}}catch(Exceptione)WebUtil.handleResponse(responseerror操作失??！原因:"+e.getMessage());}}}<%@page<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-Stringpath=StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";HttpSessionmySession=request.getSession();Stringsession_username=mySession.getAttribute("username").toString();Stringinfo=newSimpleDateFormat("yyyy年mm月dd日").format(newDate());<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""<base<title>理工大學(xué)學(xué)生信息管理系統(tǒng)<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="true"border="false"style="overflow:hidden;height:50px;backgroundurl(images/left/layout-browser-hd-bg.gif7f99berepeat-xcenter50%;line-height:40px;color:#fff;font-family:Verdana,微軟雅黑,黑體"> <ahref="#"id="loginOut">退<spanstyle="padding-left:20px;font-size20px;float:leftimgsrc="images/logo.png"width="160height="40"align="left"/>學(xué)生信息管理系統(tǒng)<divregion="westhide="truesplit="truetitle="導(dǎo)航菜單style="width:200px<divid="nav"class="easyui-accordion"fit="true" <divid="mainPanle"region="center"style="background:#eee;overflow-<divid="tabs"class="easyui- fit="true"border="false"<divtitle="我的任務(wù)" "<div<h1style="font- }}left.jspackageimportjava.io.IOException;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importimportjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.alibaba.fastjson.JSON;importcom.tjut.dbutil.DbHelper;importcom.tjut.util.WebUtil;publicclassSystemManageServicesextendsHttpServlet{privatestaticfinallongserialVersionUID=1L;publicSystemManageServices(){}protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{doPost(request,response);}protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringusername=WebUtil.getRequestParameter(request,"username");Stringresult=getUserLeftInfo(username);WebUtil.handleResponse(response,result);privateStringgetUserLeftInfo(Stringusername){Stringret="";Map<String,Object>result=newHashMap<String,Object>();List<Object>list=newArrayList<Object>();StringArrayList<HashMap<String,String>>table=null;Stringsql="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++){ sql="selectmnoas id,pmnoaspid,mnamea