課程設(shè)計說明書企業(yè)信息管理系統(tǒng)網(wǎng)站設(shè)計1需求分析(1)用戶登錄模塊：只有注冊了的用戶才可以登錄系統(tǒng)，需要提供登錄的用戶名和(2)用戶注冊模塊：未注冊的用戶可以提供簡單的個人信息注冊成為注冊用戶。該模塊的輸入數(shù)據(jù)項包括：用戶名、密碼和E-mail。(4)通訊錄管理模塊：用作當(dāng)前的登錄用戶添加、修改、刪除和查看自己的日程安閱讀。(7)工作記錄模塊：用作當(dāng)前的登錄用戶添加、修改、刪除和查看自己的工作日志(8)公司公告模塊：用戶發(fā)送通知，大家都可以查看，只有發(fā)送通知的用戶才有權(quán)課程設(shè)計說明書注冊該系統(tǒng)采用JSP技術(shù)實現(xiàn)頁面的設(shè)計，主要頁面組成如表2.1所示：工作記錄頁面名稱JSP頁面頁面名稱JSP頁面頁面名稱JSP頁面登陸頁面login.jsp登陸頁面login.jsp通訊錄頁address.jworklog.jnotice.jspmeeting.jpp短消息頁sms.jsp面頁面jsp注冊頁面register.welcome.j注冊頁面register.welcome.jworklogemeeting類型長度int10索引)usernamevarchar50passwordvarchar50varchar50usernamear接收者用戶名ar發(fā)送者用戶名message——arrendvarchar1是否已讀usernamemobileostcodeusernamemontharararararararararchar422——公司公告表charchar——sendtimevarchar公告發(fā)布時間O.6ususernamemonthption員用戶名422charchar————charscharcharcharcharchar間間————O.7沈陽大學(xué)<%@page<%@page<%@page<%@page<%@pageStringdrv=Stringurl=Stringusr="root";Stringpwd="123456";%>select*fromuserwhereusername=‘username’response.setContentType("text/xml");response.setHeader("Cache-Control","no-cache");Stringusername=request.getParameter("username");booleanisValid=false;Stringsql="select*fromuserwhereusername='"+username+"'";yClass.forName(drv).newInstance();O.8Connectionconn=DriverManager.getConnection(url,usrStatementstm=conn.createStatement();ResultSetrs=stm.executeQuery(sql);rs.close();stm.close();conn.close();}catch(Exceptione){e.printStackTrace();out.println(e);}finally{}if(isValid){out.println("<content>該用戶名已經(jīng)存在！</content>");}else{out.println("<content>ok</content>");}沈陽大學(xué)p<%@pagelanguage="java"pageEncoding="UTF-8"%><%@includefile="../inc/db.jsp"%>Stringusername=request.getParameter("username");Stringpassword=request.getParameter("password");booleanisValid=false;Stringsql="select*fromuserwhereusername='"+username+"'andpassword='"+password+"'";try{Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();ResultSetrs=stm.executeQuery(sql);rs.close();O.9stm.conn.close();}catch(Exceptione){e.printStackTrace();out.println(e);}finally{}if(isValid){session.setAttribute("username",username);response.sendRedirect("../welcome.jsp");}else{response.sendRedirect("../login.jsp");}%>沈陽大學(xué)<%@pagelanguage="java"pageEncoding="UTF-8"%><%@includefile="../inc/db.jsp"%>Stringusername=request.getParameter("username");Stringpassword1=request.getParameter("password1");Stringemail=request.getParameter("email");booleanisValid=false;Stringsql="select*fromuserwhereusername='"+username+"'";try{Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();ResultSetrs=stm.executeQuery(sql);if(!rs.next()){sql="insertintouser(username,password,email)values('"+username+"','"+password1+"','"+email+"')";stm.execute(sql);isValid=true;}rs.close();stm.close();conn.close();}catch(Exceptione){e.printStackTrace();out.println(e);}if(isValid){response.sendRedirect("../login.jsp");}else{response.sendRedirect("../register.jsp");}%>沈陽大學(xué)<%@pagelanguage="java"pageEncoding="UTF-8"%><%@page<%@page<%@page<%@includefile="../inc/db.jsp"%>Stringmethod=request.getParameter("method");Stringtopage="../address.jsp";if(session.getAttribute("username")==null){topage="../login.jsp";}else{Stringusername=(String)session.getAttribute("username");//當(dāng)前登錄用戶名StringpageSize=request.getParameter("pageSize");//每頁顯示行數(shù)StringpageNo=request.getParameter("pageNo");//當(dāng)前顯示頁次if(pageSize==null){//為空時設(shè)置默認(rèn)頁大小為25pageSize="25";}ifpageNonull默認(rèn)為第1頁pageNo="1";}//保存分頁參數(shù)，傳遞給下一個頁面request.setAttribute("pageSize",pageSize);request.setAttribute("pageNo",pageNo);if(method.equals("list")){//列表操作list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../address.jsp";//跳到列表頁}elseif(method.equals("delete")){//刪除操作delete(request,drv,url,usr,pwd,username);//執(zhí)行刪除沈陽大學(xué)list(request,drv,url,usr,pwd,username,pageSize,pageNo);//查詢數(shù)據(jù)topage="../address.jsp";//跳到列表頁}elseif(method.equals("add")){//新增操作topage="../address_add.jsp";//跳到新增頁}elseif(method.equals("insert")){//插入操作insert(request,drv,url,usr,pwd,username);//執(zhí)行插入list(request,drv,url,usr,pwd,username,pageSize,pageNo);//查詢數(shù)據(jù)topage="../address.jsp";//跳到列表頁}elseif(method.equals("edit")){//修改操作select(request,drv,url,usr,pwd,username);//執(zhí)行查詢topage="../address_edit.jsp";//跳到修改頁}elseif(method.equals("update")){//更新操作update(request,drv,url,usr,pwd,username);//更新數(shù)據(jù)list(request,drv,url,usr,pwd,username,pageSize,pageNo);//查詢數(shù)據(jù)topage="../address.jsp";//跳到列表頁}}%><jsp:forwardpage="<%=topage%>"/><%!publicbooleanlist(HttpServletRequestrequest,Stringdrv,Stringurl,Stringusr,Stringpwd,Stringusername,StringstrPageSize,StringstrPageNo){try{//創(chuàng)建數(shù)據(jù)庫連接Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();intpageSize=Integer.parseInt(strPageSize);intpageNo=Integer.parseInt(strPageNo);intstart=pageSize*(pageNo-1);Stringsql1="selectcount(*)ascountallfromaddresswhereusername='"+username+"'";ResultSetrs1=stm.executeQuery(sql1);Stringcountall=rs1.getString("countall");introwCount=Integer.parseInt(countall);request.setAttribute("rowCount",rowCount);intpageCount=rowCount%pageSize==0rowCount/pageSize:rowCount/pageSize+1;request.setAttribute("pageCount",pageCount);intpageFirstNo=1;//首頁intpageLastNo=pageCount;//尾頁沈陽大學(xué)intpagePreNo=pageNo>1pageNo-1:1;//前一頁intpageNextNo=pageNo<pageCountpageNo+1:pageCount;//后一頁request.setAttribute("pageFirstNo",pageFirstNo);request.setAttribute("pageLastNo",pageLastNo);request.setAttribute("pagePreNo",pagePreNo);request.setAttribute("pageNextNo",pageNextNo);}rs1.close();//取得當(dāng)前頁數(shù)據(jù)SQLStringsql2="select*fromaddresswhereusername='"+username+"'orderbynamelimit"+start+","+pageSize;List<Hashtable<String,String>>list=newArrayList<Hashtable<String,String>>();ResultSetrs2=stm.executeQuery(sql2);ResultSetMetaDatarsmd=rs2.getMetaData();intcols=rsmd.getColumnCount();while(rs2.next()){//查詢每行數(shù)據(jù)的各個字段數(shù)據(jù)Hashtable<String,String>hash=newHashtable<String,String>();for(inti=1;i<=cols;i++){Stringfield=(String)(rsmd.getColumnName(i));//字段名Stringvalue=(String)(rs2.getString(i));//字段值if(value==null)value="";hash.put(field,value);}//保存當(dāng)前行l(wèi)ist.add(hash);}//保存所有行數(shù)據(jù)列表傳遞給下一個頁面request.setAttribute("list",list);rs2.close();stm.close();conn.close();}catch(Exceptione){e.printStackTrace();returnfalse;}finally{}returntrue;<%!publicbooleandelete(HttpServletRequestrequest,Stringdrv,Stringurl,Stringusr,Stringpwd,Stringusername){try{//創(chuàng)建數(shù)據(jù)庫連接Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);NO.13課程設(shè)計說明書Statementstm=conn.createStatement();課程設(shè)計說明書沈陽大學(xué)Stringid=request.getParameter("id");Stringsql="deletefromaddresswhereid="+id;stm.executeUpdate(sql);stm.close();conn.close();}catch(Exceptione){e.printStackTrace();returnfalse;}finally{}returntrue;<%!publicbooleaninsert(HttpServletRequestrequest,Stringdrv,Stringurl,Stringusr,Stringpwd,Stringusername){try{//創(chuàng)建數(shù)據(jù)庫連接Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();Stringname=request.getParameter("name");Stringsex=request.getParameter("sex");Stringmobile=request.getParameter("mobile");Stringemail=request.getParameter("email");Stringqq=request.getParameter("qq");Stringcompany=request.getParameter("company");Stringaddress=request.getParameter("address");Stringpostcode=request.getParameter("postcode");Stringsql="insertintoaddress(username,name,sex,mobile,email,qq,company,address,postcode)";sql+="values('"+username+"','"+name+"','"+sex+"','"+mobile+"','"+email+"','"+qq+"','"+company+"','"+address+"','"+postcode+"')";sql=newString(sql.getBytes("ISO8859-1"),"UTF-8");stm.executeUpdate(sql);stm.close();conn.close();}catch(Exceptione){e.printStackTrace();returnfalse;}finally{}returntrue;沈陽大學(xué)<%!publicbooleanselect(HttpServletRequestrequest,Stringdrv,Stringurl,Stringusr,Stringpwd,Stringusername){try{//創(chuàng)建數(shù)據(jù)庫連接Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();Stringid=request.getParameter("id");Stringsql="select*fromaddresswhereid="+id;ResultSetrs=stm.executeQuery(sql);request.setAttribute("id",(String)(rs.getString("id")));request.setAttribute("username",(String)(rs.getString("username"))request.setAttribute("name",(String)(rs.getString("name")));request.setAttribute("sex",(String)(rs.getString("sex")));request.setAttribute("mobile",(String)rs.getString("mobile"));request.setAttribute("email",(String)rs.getString("email"));request.setAttribute("qq",(String)rs.getString("qq"));request.setAttribute("company",(String)rs.getString("company"));request.setAttribute("address",(String)rs.getString("address"));request.setAttribute("postcode",(String)rs.getString("postcode"));}rs.close();stm.close();conn.close();}catch(Exceptione){e.printStackTrace();returnfalse;}finally{}returntrue;<%!publicbooleanupdate(HttpServletRequestrequest,Stringdrv,Stringurl,Stringusr,Stringpwd,Stringusername){Class.forName(drv).newInstance();Connectionconn=DriverManager.getConnection(url,usr,pwd);Statementstm=conn.createStatement();Stringid=request.getParameter("id");Stringname=request.getParameter("name");Stringsex=request.getParameter("sex");Stringmobile=request.getParameter("mobile");沈陽大學(xué)Stringemail=request.getParameter("email");Stringqq=request.getParameter("qq");Stringcompany=request.getParameter("company");Stringaddress=request.getParameter("address");Stringpostcode=request.getParameter("postcode");Stringsql="updateaddresssetname='"+name+"',sex='"+sex+"',mobile='"+mobile+"',email='"+email+"',qq='"+qq+"',company='"+company+"',address='"+address+"',postcode='"+postcode+"'whereid="+id;sql=newString(sql.getBytes("ISO8859-1"),"UTF-8");stm.executeUpdate(sql);stm.close();conn.close();}catch(Exceptione){e.printStackTrace();returnfalse;}finally{}returntrue;<%@pagelanguage="java"pageEncoding="UTF-8"%><%@page<%@page<%@page<%@includefile="../inc/db.jsp"%>Stringmethod=request.getParameter("method");//操作方法Stringtopage="../schedule.jsp";//跳轉(zhuǎn)頁地址沈陽大學(xué)if(session.getAttribute("username")==null){topage="../login.jsp";}else{Stringusername=(String)session.getAttribute("username");//當(dāng)前登錄用戶名StringpageSize=request.getParameter("pageSize");//每頁顯示行數(shù)StringpageNo=request.getParameter("pageNo");//當(dāng)前顯示頁次if(pageSize==null){//為空時設(shè)置默認(rèn)頁大小為25pageSize="25";}if(pageNo==null){//為空時設(shè)置默認(rèn)為第1頁pageNo="1";}request.setAttribute("pageSize",pageSize);request.setAttribute("pageNo",pageNo);if(method.equals("list")){//列表操作list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../schedule.jsp";//跳到列表頁}elseif(method.equals("delete")){//刪除操作delete(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../schedule.jsp";//跳到列表頁}elseif(method.equals("add")){//新增操作topage="../schedule_add.jsp";//跳到新增頁}elseif(method.equals("insert")){//插入操作insert(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../schedule.jsp";//跳到列表頁}elseif(method.equals("edit")){//修改操作select(request,drv,url,usr,pwd,username);topage="../schedule_edit.jsp";//跳到修改頁}elseif(method.equals("update")){//更新操作//更新數(shù)據(jù)update(request,drv,url,usr,pwd,username);//查詢數(shù)據(jù)list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../schedule.jsp";//跳到列表頁}}%>沈陽大學(xué)<%@pagelanguage="java"pageEncoding="UTF-8"%><%@page<%@page<%@page<%@includefile="../inc/db.jsp"%>Stringmethod=request.getParameter("method");//操作方法Stringtopage="../sms.jsp";//跳轉(zhuǎn)頁地址if(session.getAttribute("username")==null){topage="../login.jsp";}else{Stringusername=(String)session.getAttribute("username");//當(dāng)前登錄用戶名StringpageSize=request.getParameter("pageSize");//每頁顯示行數(shù)StringpageNo=request.getParameter("pageNo");//當(dāng)前顯示頁次if(pageSize==null){//為空時設(shè)置默認(rèn)頁大小為25pageSize="25";}if(pageNo==null){//為空時設(shè)置默認(rèn)為第1頁pageNo="1";}request.setAttribute("pageSize",pageSize);request.setAttribute("pageNo",pageNo);if(method.equals("list")){//列表操作list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../sms.jsp";//跳到列表頁}elseif(method.equals("delete")){//刪除操作delete(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../sms.jsp";//跳到列表頁}elseif(method.equals("add")){//新增操作topage="../sms_add.jsp";//跳到新增頁}elseif(method.equals("insert")){//插入操作insert(request,drv,url,usr,pwd,username);沈陽大學(xué)list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../sms.jsp";//跳到列表頁}elseif(method.equals("read")){//更新操作read(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../sms.jsp";//跳到列表頁}}%><%@pagelanguage="java"pageEncoding="UTF-8"%><%@page<%@page<%@page<%@includefile="../inc/db.jsp"%>Stringmethod=request.getParameter("method");//操作方法Stringtopage="../worklog.jsp";//跳轉(zhuǎn)頁地址if(session.getAttribute("username")==null){topage="../login.jsp";}else{Stringusername=(String)session.getAttribute("username");//當(dāng)前登錄用戶名StringpageSize=request.getParameter("pageSize");//每頁顯示行數(shù)StringpageNo=request.getParameter("pageNo");//當(dāng)前顯示頁次if(pageSize==null){//為空時設(shè)置默認(rèn)頁大小為25pageSize="25";}ifpageNonull默認(rèn)為第1頁pageNo="1";}沈陽大學(xué)request.setAttribute("pageSize",pageSize);request.setAttribute("pageNo",pageNo);if(method.equals("list")){//列表操作list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../worklog.jsp";//跳到列表頁}elseif(method.equals("delete")){//刪除操作delete(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../worklog.jsp";//跳到列表頁}elseif(method.equals("add")){//新增操作topage="../worklog_add.jsp";//跳到新增頁}elseif(method.equals("insert")){//插入操作insert(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../worklog.jsp";//跳到列表頁}elseif(method.equals("edit")){//修改操作select(request,drv,url,usr,pwd,username);topage="../worklog_edit.jsp";//跳到修改頁}elseif(method.equals("update")){//更新操作update(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../worklog.jsp";//跳到列表頁O.20}%><%@pagelanguage="java"pageEncoding="UTF-8"%><%@page沈陽大學(xué)<%@page<%@page<%@includefile="../inc/db.jsp"%>Stringmethod=request.getParameter("method");//操作方法Stringtopage="../notice.jsp";//跳轉(zhuǎn)頁地址if(session.getAttribute("username")==null){topage="../login.jsp";}else{Stringusername=(String)session.getAttribute("username");//當(dāng)前登錄用戶名StringpageSize=request.getParameter("pageSize");//每頁顯示行數(shù)StringpageNo=request.getParameter("pageNo");//當(dāng)前顯示頁次if(pageSize==null){//為空時設(shè)置默認(rèn)頁大小為25pageSize="25";}if(pageNo==null){//為空時設(shè)置默認(rèn)為第1頁pageNo="1";}request.setAttribute("pageSize",pageSize);request.setAttribute("pageNo",pageNo);if(method.equals("list")){//列表操作list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../notice.jsp";//跳到列表頁}elseif(method.equals("delete")){//刪除操作delete(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../notice.jsp";//跳到列表頁}elseif(method.equals("add")){//新增操作topage="../notice_add.jsp";//跳到新增頁}elseif(method.equals("insert")){//插入操作insert(request,drv,url,usr,pwd,username);list(request,drv,url,usr,pwd,username,pageSize,pageNo);topage="../notice.jsp";//跳到列表頁}elseif(method.equals("edit")){//修改操作select(request,drv,url,usr,pwd,username);topage="../notice_edit.jsp";//跳到修改頁}elseif(method.equals("update")){//更新操作update(request,drv,url,usr,pwd,username);list(requ