WEB課程設(shè)計宿舍管理系統(tǒng)

1、2016 - 2017 學(xué)年第1學(xué)期信息學(xué)部- 計算機(jī)學(xué)院課程名稱：WEB開發(fā)技術(shù)基礎(chǔ)報告性質(zhì)：作業(yè)報告實(shí)驗(yàn)報告學(xué)號：姓名：任課教師：課程性質(zhì)：實(shí)踐課程學(xué)分：2學(xué)時：32班級：成績：小組成員：教師評語：2016年 12月 16日1目錄系統(tǒng)結(jié)構(gòu)系統(tǒng)模塊流程圖系統(tǒng)模塊功能圖數(shù)據(jù)庫設(shè)計子模塊設(shè)計登錄注冊模塊管理模塊瀏覽模塊功能模塊插入數(shù)據(jù)刪除數(shù)據(jù)修改數(shù)據(jù)查看數(shù)據(jù)存在的問題其他核心技術(shù)學(xué)生宿舍管理信息系統(tǒng)1818101214現(xiàn)場修改過程20錄入信息流程圖b.一、系統(tǒng)結(jié)構(gòu)1. 系統(tǒng)模塊流程圖a.登錄注冊流程圖C. 輸出信息流程圖插入信息流程圖d.e.修改信息流程圖2.系統(tǒng)模塊功能圖注冊密碼不正確丄退出系

2、統(tǒng)密碼正確進(jìn)入系統(tǒng)宿舍管理系統(tǒng)登錄-r普通用戶管理員錄 入 信 息查 看 信 息修 改 信 息插 入 信 息刪 除 信 息查 看 信 息二、數(shù)據(jù)庫設(shè)計SQL Server本系統(tǒng)所使用的所有的數(shù)據(jù)，均存放在數(shù)據(jù)庫中。該系統(tǒng)使用的是Management Studio。在數(shù)據(jù)庫中建立一個dorm數(shù)據(jù)庫，在dorm數(shù)據(jù)庫中建立三個表，分別為管理員表、 普通用戶表、信息表。管理員表：列名數(shù)據(jù)類型是否為空備注user namenchar(10)否用戶名p asswordnchar(10)否密碼普通用戶表:列名數(shù)據(jù)類型是否為空備注user name1 nchar(10)否用戶名p asswordnchar(

3、10)否密碼信息表:列名數(shù)據(jù)類型是否為空備注snonchar(10)否學(xué)號n amenchar(10)否姓名classnchar(10)否班級sexnchar(10)否性別agenchar(10)否年齡buildnchar(10)否樓號homenchar(10)否宿舍號然后在JSP使用JAVA語句對數(shù)據(jù)進(jìn)行連接。具體代碼如下：<%Stri ng JDriver ="com.microsoft.sqlserver.jdbc.SQLServerDriver"Stri ng conn ectDB ="jdbc:sqlserver:/127.0.0.1:1433;D

4、atabaseName=JAVA"tryClass.forName(JDriver);catch (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗"); System.exit(O); tryString user = "Iph"String password ="123"Conn ecti on con = DriverMa nager.getC onn ectio n(c onn ectDB, user, password);Stateme nt st

5、mt = con .createStateme nt();rs.close();stmt.close();con. close();catch (SQLExce pti on e)e.prin tStackTrace();System.exit(0);%>最后對數(shù)據(jù)庫進(jìn)行錄入、增加、刪除、修改等功能的實(shí)現(xiàn)。二、子模塊設(shè)計1. 登錄注冊模塊用戶各 密碼版權(quán)所?邛上2016/11/27該模塊主要代碼如下：登錄判斷：<%request.setCharacterE ncodi ng("utf-8");Stri ng user name=request.get Param

6、eter("username");String password仁request.getParameter("password");String name=request.getParameter( "user");Stri ng JDriver = "com.microsoft.sqIserver.jdbc.SQLServerDriver"Stri ng conn ectDB ="jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=JAVA"tryClass

7、.forName(JDriver);catch (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗"); System.exit(O); tryString user ="Iph"String password ="123"Conn ecti on con = DriverMa nager.getC onn ectio n(c onn ectDB, user, password);Stateme nt stmt = con .createStateme nt();St

8、ri ng sql= "select * from "+n ame+ where n ame='" +user name+” andpassword='" + passwordi + "'"ResultSet rs=stmt.executeQuery(sql);Stri ng s1= "adm in"String s2= "stu"if (rs. next()if (s1.equals(name)session.setAttribute("login"

9、 , "true");response.sendRedirect( "main.html" );else session.setAttribute("login" , "true");response.sendRedirect( "main2.html" ); else out.print("用戶名或密碼錯誤，請重新輸入！");%><br><br>>返回 </ a></ p>vp><a href =&qu

10、ot;jiemian.jsp"<%stmt.close();con. close(); catch (SQLException e)e. prin tStackTrace();System.exit(O);%></td ><td align ="center" >Vnput /></ td ></tr>注冊代碼：<tr><td align ="center" >用戶名：type -'text" name="name"

11、required <tr ><td align ="center" >密碼：</td><td align ="center" ><input type -"text" name="password" required /></ td ></tr ><tr ><td cols pan ="2" alig n ="cen ter" ><input typ e -&qu

12、ot;submit" value ="注冊"/></ td ></tr > <%request.setCharacterE ncodi ng("utf-8");Stri ng n ame=request.get Parameter("n ame");String password1=request.getParameter("password");Stri ng JDriver ="com.microsoft.sqlserver.jdbc.SQLServerD

13、river"Stri ng conn ectDB ="jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=JAVA"tryClass.forName(JDriver); catch (ClassNotFoundException e)System.out.println("加載數(shù)據(jù)庫引擎失敗");System.exit(O); tryString user = "Iph"String password ="123"Conn ecti on con = DriverMa

14、nager.getC onn ectio n(c onn ectDB, user, password); Stateme nt stmt = con .createStateme nt();String sql= "INSERT INTO admin VALUES('" +name+','"+password1+"')"int i=stmt.executeUpdate(sql);stmt.close();con. close(); catch (SQLException e)e. prin tStackTrace

15、();System.exit(0);%>2. 管理模塊砧舍管理系纟先退出該模塊主要代碼：vbody bgcolor =#CFE3CAtext ="#004080" > vform methock"post" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </h1><hr width ="600" ></blockquote ><table width ="500"height =

16、"300" align ="center" border ="1" cellpadding ="0" cellspacing ="0" ><tr <tr <tr <tr <tr><td ><td ><td ><td ><tdalig n alig n alig n alig n alig n="cen ter" ="cen ter" ="cen ter

17、" ="cen ter" ="cen ter">管理員 </ td ></tr >href ="readmain.jsp" >查看學(xué)生信息 </ a> </ td ></tr > href ="i nsert.js p"href ="up date.js p"href ="delete.js p"><a><a ><a><a>插入學(xué)生信息v/a

18、x/tdx/tr >修改學(xué)生信息</a></td ></tr>刪除學(xué)生信息</a></td ></tr</ table ><br><br> <div align ="center" <a href -'jiemian.jsp" </body>>>退出 </ a></div >3. 瀏覽模塊宿舍管理系統(tǒng)查看學(xué)生信息查看全部學(xué)生信息按學(xué)號查看信息按宿舍號查看信息返回退出該模塊主要代碼：<b

19、ody bgcolor =#CFE3CAtext ="#004080" ><form method="post" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </ h1><hr width ="600" ></blockquote ><table width ="500"height ="300" align ="center" bord

20、er ="1" cellpadding ="0" cellspacing ="0" ><tr ><th align ="center">查看學(xué)生信息 </th ></tr ><tr ><td align ="center" ><a href ="read.jsp" >查看全部學(xué)生信息 </a> </td ></tr ><tr ><td

21、 align ="center" ><a href ="read1.jsp" >按學(xué)號查看信息 </a></td ></tr ><tr ><td align -"center" ><a href-"readZ.jsp" >按宿舍號查看信息 </a></td ></tr > </ table ><br><br>href -"main.html&qu

22、ot;>返回 </ a> <a href -"jiemian.jsp">退<div align -"center" ><a出 </ a> </div ><%"c" )= null ) "jiemia n.js p"); if (session.getAttribute(res pon se.se ndRedirect(%></body>4. 功能模塊1.插入數(shù)據(jù)宿舍管理系統(tǒng)>學(xué)號：v/td><td al

23、ign required /></ td ></tr> >姓名：</ td ><td alignrequired /></ td ></tr >年齡：</td><td align required /></ td ></tr > >性別：</ td ><td align required /></ td ></tr > >樓號：</ td ><td alignrequired />

24、</ td ></tr-"ce nter"><input-"ce nter"><input-"ce nter"><input>-"ce nter"><input-"ce nter"><input-"ce nter"><input>返回退岀該模塊主要代碼：<tr><td alig n ="cen ter" type -'text&q

25、uot; name="sno" <tr ><td align -"center" type -"text" name="name" required /></ td ></tr > <tr ><td align ="center" >班級：</td><td align : type -"text" name="class" <tr ><td alig

26、n -"center" type -"text" name="age" <tr ><td align -"center" type -"text" name="sex" <tr ><td align -"center" type -"text" name="build"<tr ><td align ="center" >房間號：v/td&

27、gt;Vd align ="center" ><input type -'text" name="home" required /></ td ></tr ><tr ><tdcols pan ="2" alig n ="cen ter" ><input type -"submit" value =" 插 入"/></ td ></tr >"utf-

28、8"); "sno");"n ame"); "class");"sex");"age");"build");"home");<%request.setCharacterE ncodi ng(Stri ng sno=request.get Parameter(Stri ng n ame=request.get Parameter(Stri ng class仁request.get Parameter(Stri ng sex=request.g

29、et Parameter(String age=request.get Parameter(Stri ng build=request.get Parameter(Stri ng home=request.get Parameter(Stri ng JDriver ="com.microsoft.sqlserver.jdbc.SQLServerDriver"Stri ng conn ectDB ="jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=JAVA"tryClass.forName(JDriver);catc

30、h (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗");System.exit(O); tryString user - "Iph"String password -"123"Conn ecti on con - DriverMa nager.getC onn ectio n(c onn ectDB, user, password); Stateme nt stmt - con .createStateme nt();Stri ng sql- "INSE

31、RT INTO xinxiVALUESC"+s no+"T"+n ame+','" +class1+"','"+sex+"','"+age+",'"+build+ "','"+home+')"int i=stmt.executeUpdate(sql);stmt.close();con. close(); catch (SQLException e)e. prin tStackTrace(

32、);System.exit(O);%>2. 刪除數(shù)據(jù)宿舍管理系統(tǒng)該模塊主要代碼：vbody bgcolor =#CFE3CAtext ="#004080" ><form action ="function2.jsp"method="post" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </h1><hr width ="600" ></ blockquote ><tabl

33、e width ="500"height ="300" alig n ="ce nter" border ="1" cell padd ing ="0" cells pacing ="0" ><tr ><td cols pan ="2" alig n ="ce nter" >刪除學(xué)生信息 </ td ></tr >>type ="submit" value

34、="刪除<tr ><td align ="center" >學(xué)號：v/td><td align ="center" xinput type ="text" name="sno" required /></ td ></tr <tr ><td cols pan ="2" alig n ="ce nter" ><input "/></ td ></

35、tr > </ table > </form> <br><br>>返回 </ a> <a href ="jiemian.jsp">退<div align ="center" ><a href ="main.html"出 </ a> </ div ><%if (session.getAttribute( "c" )=null )res pon se.se ndRedirect( &quo

36、t;jiemia n.jsp");%></body> <%request.setCharacterE ncodi ng("utf-8");String sno=request.getParameter("sno");Stri ng JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"Stri ng conn ectDB = "jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=JAVA"

37、 tryClass.forName(JDriver);catch (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗"); System.exit(O); tryString user ="Iph"String password ="123"Conn ecti on con = DriverMa nager.getC onn ectio n(c onn ectDB, user, password); Stateme nt stmt = con .createState

38、me nt();+sno+"'"String sql= "delete from xinxi where sno='"int i=stmt.executeUpdate(sql);stmt.close();con. close(); catch (SQLException e)e. prin tStackTrace(); System.exit(0);%>>vbr> 刪除成功！ <br><br>>返回管理員界面</a> <br><br>>繼續(xù)刪除<

39、;/a><div align ="center"<a href ="main.html"<a href ="delete.jsp"</div ><%if (session.getAttribute("c" )=null )II;res pon se.se ndRedirect( "jiemia n.jsp" ); %> </body>3. 修改數(shù)據(jù)宿舍管理系統(tǒng)舊信息修改學(xué)主學(xué)號:該模塊主要代碼：vbody bgcolor =#CFE3C

40、Atext ="#004080"vform action ="function3.jsp"method="post" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </ h1><hr width ="600" ></blockquote ><table width ="500"height ="100" align ="center"

41、; border ="1" cellpadding ="0" cellspacing ="0" ><tr ><td cols pan ="2" alig n ="ce nter"舊信息 </ td ></tr >>修改學(xué)生學(xué)號：v/td><td align ="center" xinput required /></ td ></tr ></table ><tr

42、><td align ="center" type ="text" name="sno" <br><br><table width ="500"height ="300" alig n ="ce nter" border ="1" cell paddi ng ="0" cells pacing ="0" > <tr ><td cols pan =&qu

43、ot;2" alig n ="ce nter" > 新信息 </ td ></tr >="ce nter"><input="ce nter"><input="ce nter"><input="ce nter"><input<tr ><td align ="center" >新學(xué)號：v/td><td aligntype ="text"

44、name="sno1" required /></ td ></tr ><tr ><td align ="center" >新姓名：v/td><td align type ="text" name="name" required /></ td ></tr > <tr ><td align ="center" >新班級：v/td><td align type =&q

45、uot;text" name="class" required /></ td ></tr > <tr ><td align ="center" >新年齡：v/td><td aligntype -'text" name="age" <tr ><td align ="center" type -"text" name="sex" <tr ><td a

46、lign -"center" type -"text" name="build"required /></ td ></tr >>新性別：v/td><td align ="center" ><input required /></ td ></tr >>新樓號：v/td><td align ="center" ><input required /></ td >

47、;</tr ><tr ><td align ="center" >新房間號：v/td>vtd align ="center" ><input type -"text" name="home" required /></ td ></tr ><tr ><td cols pan- "2" alig n -"ce nter" ><input typ e -"s

48、ubmit" value -"修改"/></ td ></tr ></ table ></form><br><br><div align -"center" ><a href -"main.html">返回 </ a> <a href -"jiemian.jsp">退出 </ a> </ div ><%if (session.getAttribute(

49、 "c" )- ull )res pon se.se ndRedirect( "jiemia n.jsp");%></body> <%);"sno");"sno1");"n ame"); "class");"sex");"age"); "build");"home");request.setCharacterE ncodi ng("utf-8"Stri

50、ng sno=request.get Parameter(Stri ng sn o1=request.get Parameter(Stri ng n ame=request.get Parameter(Stri ng class仁request.get Parameter(Stri ng sex=request.get Parameter(String age=request.get Parameter(Stri ng build=request.get Parameter(Stri ng home=request.get Parameter(Stri ng JDriver ="co

51、m.microsoft.sqIserver.jdbc.SQLServerDriver"Stri ng conn ectDB ="jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=JAVA"tryClass.forName(JDriver);catch (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗"); System.exit(O); tryString user ="Iph"String password =&qu

52、ot;123"Conn ecti on con = DriverMa nager.getC onn ectio n(c onn ectDB, user, password); Stateme nt stmt = con .createStateme nt();String sql= "up date xinxi setsno 二'"+sn o1+"' ,n ame='" +n ame+',class=" +class1+ ",sex='" +sex+"',a

53、ge=" +age+',b uild='" +build+ "',home=" +home+ where sno='"+sno +"'"int i=stmt.executeUpdate(sql);stmt.close(); con. close(); catch (SQLException e)e. prin tStackTrace(); System.exit(0);%>><br > 修改成功！ vbr ><br >>返回管理員界面&l

54、t;/a> <br><br>>繼續(xù)修改</a><div align ="center"<a href ="main.html"<a href ="update.jsp"</div ><%if (session.getAttribute("c" )=null )II;res pon se.se ndRedirect("jiemia n.jsp");%></body>4. 查看數(shù)據(jù)宿舍管理系統(tǒng)查看學(xué)

55、生仁息按宿舍號査看信息返回退岀該模塊主要代碼：vtabie border =1 aiign ="center" >vtr height =40>vth width =50>學(xué)號 v/th>vth width =50>姓名 v/th >vth width =50>班級 v/th>width =50>樓號 v/th ><thvth width =50>性別 v/ th >vth width =50>年齡 v/ th >vthwidth =50>房間號 v/th > v/ tr

56、>v/tabie> v%whiie (rs.next() %>vtabie border =1 aiig n ="ce nter" > vtr height =40>vtdvtdvtdvtdvtdvtdvtdv/ tr >width =50>v%)ut. printin (rs.getObject(l); width =50x%)ut. printin (rs.getObject(2); width =50>v%)ut. printin (rs.getObject (3); width =50>v%)ut. printi

57、n (rs.getObject ); width =50>v%)ut. printin (rs.getObject(5); width =50>v%)ut. printin (rs.getObject(6); width =50>v%)ut. printin (rs.getObject(7);</ tablevbody bgcoior =#CFE3CAtext ="#004080" > vform action ="function4.jsp"method="post" >vbiockquote &

58、gt;vh1 aiign ="center" > 宿舍管理系統(tǒng) v/h1>vhr width ="600" > v/biockquote >vtabie width ="500"%x/td > %x/td > %x/td > %x/td > %x/td > %x/td> %x/td>="0" ceiispacing ="0" >>type ="submit" vaiue ="查詢>返

59、回 v/a> va href ="jiemian.jsp" >height ="300" aiign ="center" border ="1" ceiipadding vtr >vtd coispan ="2" aiign ="center" >按學(xué)號查看信息 v/td>v/tr > vtr >vtd aiign ="center" >請輸入學(xué)號：v/td >vtd aiign ="cent

60、er" >vinput type ="text" name="sno" required />v/ td >v/tr vtr >vtd coispan ="2" aiign ="center" >vinput "/>v/ td >v/tr > v/ tabie > v/form> vbr>vbr> vdiv aiign ="center" >va href ="readmain.jsp&q

61、uot; 退出 v/a> v/div > v% if (session.getAttribute( "c" )=null )II;res pon se.se ndRedirect("jiemia n.jsp" );%> v/body><tr><td cols pan="2"alig n="ce nter">按宿舍號查看信息 </td></tr><tr><td alig n="ce nter">請輸入宿

62、舍號： v/td>vtd alig n="ce nter">v inputtype -'text" name="home" required /></ td ></tr >type -'submit" value ="查詢<tr ><td cols pan ="2" alig n ="ce nter" ><input"/></ td ></tr ></

63、table ></form><br><br>>返回 </a> <a href ="jiemian.jsp" ><div align ="center" ><a href -"readmain.jsp" 退出 </a> </div ><%if (session.getAttribute("c" )=null )II;);res pon se.se ndRedirect("jiemia n.

64、jsp"%> </body> <%request.setCharacterE ncodi ng("utf-8");String sno=request.getParameter("sno");Stri ng home=request.get Parameter( "home");Stri ng JDriver - "com.microsoft.sqlserver.jdbc.SQLServerDriver"Stri ng conn ectDB -"jdbc:sqlserve

65、r:/127.0.0.1:1433;DatabaseName=JAVA"tryClass.forName(JDriver);catch (ClassNotF oun dExce ptio n e)System.out.println("加載數(shù)據(jù)庫引擎失敗");System.exit(0); tryString user -"Iph"String password -"123"Conn ecti on con - DriverMa nager.getC onn ectio n(c onn ectDB, user, passwo

66、rd); Stateme nt stmt - con .createStateme nt();ResuItSet rs = stmt.executeQuery( "SELECT * FROM xinxi where sn o='" +sno+"' or home='" +home+”');%>vtabie border =1 aiign ="center" >vtr height =40>vth width =50>學(xué)號 v/th>vth width =50>姓名 v

67、/th >vth width =50>班級 v/th>width =50>樓號 v/th ><thvth width =50>性別 v/ th >vth width =50>年齡 v/ th >vthwidth =50>房間號 v/th > v/ tr >v/tabie >v%whiie (rs.next() %>vtabie border =1 aiig n ="ce nter" >width =50>v%out. printin (rs.getObject(l); wi

68、dth =50x%out. printin (rs.getObject(2); width =50>v%out. printin (rs.getObject (3); width =50>v%out. printin (rs.getObject(4); width =50>v%out. printin (rs.getObject (5); width =50>v%out. printin (rs.getObject (6); width =50>v%out. printin (rs.getObject(7);%x/td> %x/td > %x/td &

69、gt; %x/td > %x/td > %x/td > %x/td>vtr height =40>vtdvtdvtdvtdvtdvtdvtdv/ tr >v/ tabiev%rs.ciose();stmt.ciose();con. ciose(); catch (SQLException e)e. prin tStackTrace();System.exit(0);%>vbr>vdiv aiign ="center" >va href ="readmain.jsp">返回 v/ a> v/

70、div >v%if (session.getAttribute("c" )=null )II:res pon se.se ndRedirect("jiemia n.jsp" );%>v/body>四、存在的問題該系統(tǒng)是本人自己獨(dú)立完成，故存在很多問題。我還會補(bǔ)充自己知識的不足，然后借鑒一些好的模板，然后該系統(tǒng)的功能有基本的登錄、注冊功能；錄入信息、插入信 查找信息等功能；雖然該系統(tǒng)已經(jīng)具備基本功能，但是我覺一是界面不太美觀，由于時間有限，再加上自己的知識的不足，很難做出漂亮的界 面，再者沒有借鑒網(wǎng)上的模板，若自己實(shí)現(xiàn)確實(shí)很難。但是，既然

71、提出了這個問題，那 我就要去面對，在此之后， 做出一個漂亮的界面。二是功能不是太完善， 息、修改信息、刪除信息、得還需要加入宿舍新聞、公告、電費(fèi)、水費(fèi)、優(yōu)秀宿舍等功能，既然提出了這個問題， 我會盡我的努力把這些功能加上。該系統(tǒng)可能還有很多不足，我會在進(jìn)行思考和修改。五、其它核心技術(shù)該系統(tǒng)中也運(yùn)用了一些核心技術(shù)，如登錄時對用戶名、密碼的判斷：Stri ng sql= "select * from "+n ame+ where n ame='" +user name+” and p assword='"+passwordi + "&

72、#39;"ResultSet rs=stmt.executeQuery(sql);Stri ng s1= "adm in"String s2= "stu"if (rs. next()if (s1.equals(name)session.setAttribute("login" , "true");response.sendRedirect( "main.html" );else session.setAttribute("login" , "true");response.sendRedirect( "main2.html" );"用戶名或密碼錯誤，請重新輸入！"