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

1、北京工業(yè)大學2016 - 20仃學年 第1學期信息學部一計算機學院課程名稱：WEB開發(fā)技術(shù)基礎(chǔ)報告性質(zhì)：作業(yè)報告實驗報告學號：姓名：任課教師：課程性質(zhì)：實踐課程學分：2學時：32班級：成績：小組成員：教師評語：2016年 12月 16日學生宿舍管理信息系統(tǒng) 目錄系統(tǒng)結(jié)構(gòu) 1系統(tǒng)模塊流程圖1系統(tǒng)模塊功能圖2數(shù)據(jù)庫設(shè)計 3子模塊設(shè)計 4登錄注冊模塊4管理模塊6瀏覽模塊7.功能模塊8插入數(shù)據(jù)8刪除數(shù)據(jù)1.Q修改數(shù)據(jù)1.2.查看數(shù)據(jù)1.4.存在的問題 1 8其他核心技術(shù) 18現(xiàn)場修改過程 20、系統(tǒng)結(jié)構(gòu)1.系統(tǒng)模塊流程圖a.登錄注冊流程圖b.錄入信息流程圖r*開始開始注冊錄入信息保存到數(shù)據(jù)庫返回主菜單

2、進入系統(tǒng)結(jié)束1結(jié)束C.輸出信息流程圖開始d.插入信息流程圖開始從數(shù)據(jù)庫讀插入信息保存到數(shù)據(jù)庫顯示返回主菜單返回主菜單結(jié)束結(jié)束e.刪除信息流程圖開始f.修改信息流程圖r*開始刪除信息修改信息從數(shù)據(jù)庫中刪除保存到數(shù)據(jù)庫返回主菜單返回主菜單結(jié)束結(jié)束2.系統(tǒng)模塊功能圖本系統(tǒng)所使用的所有的數(shù)據(jù)，均存放在數(shù)據(jù)庫中。該系統(tǒng)使用的是SQL ServerMan ageme nt Studio。在數(shù)據(jù)庫中建立一個dorm數(shù)據(jù)庫，在dorm數(shù)據(jù)庫中建立三個表，分別為管理員表、普通用戶表、信息表。管理員表：列名數(shù)據(jù)類型是否為空備注user namenchar(10)否用戶名passwordnchar(10)否密碼普通

3、用戶表:列名數(shù)據(jù)類型是否為空備注user namenchar(10)否用戶名passwordnchar(10)否密碼信息表:列名數(shù)據(jù)類型是否為空備注snonchar(10)否學號n amenchar(10)否姓名classnchar(10)否班級sexnchar(10)否性別agenchar(10)否年齡buildnchar(10)否樓號homenchar(10)否佰舍號然后在JSP使用JAVA語句對數(shù)據(jù)進行連接。具體代碼如下：<%Stri ng JDriver =tryClass.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)

4、據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onnection(conn ectDB,user,password);Stateme nt stmt = con .createStateme nt();rs.close();stmt.close();con. close(); catch (SQLException e)e.pri ntStackTrace();System.ex

5、it(O);%>最后對數(shù)據(jù)庫進行錄入、增加、刪除、修改等功能的實現(xiàn)二、子模塊設(shè)計1. 登錄注冊模塊用戶名!密碼版權(quán)所有 Iph 2016/11/27該模塊主要代碼如下：登錄判斷：<% request.setCharacterEncoding("utf-8");String username=request.getParameter("username");String password仁request.getParameter("password");String name=request.getParameter(&qu

6、ot;user");tryClass.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onnection(conn ectDB, user,password);Stateme nt stmt = con .createStateme nt();文案大全"&#

7、39;andStri ng sql= "select * from "+n ame+ " where n ame='"+user name+password='" + passwordl +"'"ResultSet rs=stmt.executeQuery(sql);String s1= "admin"String s2= "stu"if (rs. next()if (s1.equals( name)session.setAttribute("logi

8、n" , "true");resp on se.se ndRedirect("ma in .html" ); else session.setAttribute("login" , "true");resp on se.se ndRedirect("ma in 2.html");else out.print("用戶名或密碼錯誤，請重新輸入！ ");%>< br >< br >< p >< a href = "

9、jiemian.jsp" >返回 </ a></ p><%stmt.close();con. close();catch (SQLException e)e.pri ntStackTrace();System.exit(O);%>注冊代碼：<tr><td alig n= "ce nter" > 用戶名：</td >< td alig n= "ce nter" >< in puttype = "text" name = "

10、name" required /></ td >< /tr><tr >< td alig n = "ce nter" > 密碼：</ td >< td alig n = "ce nter" >< in puttype = "text" name = "password" required /></ td ></ tr >< tr >< tdcolspa n = "2

11、" alig n= "ce nter" >< in put type = "submit" value ="注冊"/></ td ></ tr><%request.setCharacterEncoding("utf-8");String name=request.getParameter( "name");String password仁request.getParameter("password");tryClass

12、.forName(JDriver); catch (ClassNotFoundException e)加載數(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,password);Stateme nt stmt = con. createStateme nt();String sql= "INSERT INT

13、O admin VALUES" +name+ "','" +password1+ "')"int i=stmt.executeUpdate(sql);stmt.close();con. close();catch (SQLException e) e.pri ntStackTrace(); System.exit(O);%>2. 管理模塊宿舍管理系統(tǒng)該模塊主要代碼：vbody bgcolor = #CFE3CA text = "#004080">vform method ="po

14、st" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </ h1 ><hr width = "600" ></ blockquote > < table width = "500"height = "300" alig n = "ce nter" border = "1" cellpaddi ng = "0" cellspaci ng = &

15、quot;0" ><tr >< td align :="center" > 管理員 </ td ></ tr ><tr >< td align :="center" >< a href ="readmain.jsp" > 查看學生信息 </ a></ td ></ tr><tr >< td align :="center" >< a href =&qu

16、ot;insert.jsp" > 插入學生信息 </ a></ td ></ tr ><tr >< td align :="center" >< a href ="update.jsp" > 修改學生信息 </ a></ td ></ tr ><tr >< td align :="center" >< a href ="delete.jsp" > 刪除學生信

17、息 </ a></ td ></ tr></ table >< br>< br>< div align ="center" >< a href = "jiemian.jsp" > 退出 </ a></ div > v/body>3. 瀏覽模塊宿舍管理系統(tǒng)查看學生信息查看全部學生信息按學號查看信息按宿舍號查看信息返回退出該模塊主要代碼：< body bgcolor = #CFE3CA text = "#004080&

18、quot; >vform method ="post" >vblockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </ h1 ><hr width = "600" ></ blockquote >< table width = "500"height = "300" alig n = "ce nter" border = "1" cellpaddi ng =

19、 "0" cellspaci ng = "0" ><tr >< th align ="center" > 查看學生信息 </ th ></ tr><tr >< td align = "center" >< a href ="read.jsp" > 查看全部學生信息 </ a>v/td></ tr><tr >< td align = "center&q

20、uot; >< a href ="read1.jsp" > 按學號查看信息 </ a></ td ></ tr >< tr >< td align= "center" >< a href ="read2.jsp" > 按宿舍號查看信息</ a></ td ></ tr> </ table >> 返回 </ a> <a href = "jiemian.jsp"

21、; >< br >< br > < div align ="center" >< a href = "main.html"退出 </ a> </ div > <% if (session.getAttribute( "c" )= null )response.sendRedirect("jiemian.jsp" ); %> v/body>4. 功能模塊1. 插入數(shù)據(jù)宿舍管理系統(tǒng)該模塊主要代碼：<tr><tda

22、lig n = "ce nter" > 學號：</ td >< td alig n ="cen ter" >< in puttype = "text" name = "sno" required /></ td ></tr><tr >< td alig n = "ce nter" > 姓名：</ td >< td alig n = "ce nter" ><

23、in puttype ="text" name = "name" required /></ td ></ tr ><tr >< td alig n = "ce nter" > 班級：</ td >< td alig n = "ce nter" >< in puttype ="text" name = "class" required /></ td ></ tr &g

24、t;<tr >< td alig n = "ce nter" > 年齡：</ td >< td alig n = "ce nter" >< in puttype ="text" name = "age" required /></ td ></ tr><tr >< td alig n = "ce nter" > 性別：</ td >< td alig n = "

25、ce nter" >< in puttype ="text" name = "sex" required /></ td ></ tr><tr >< td alig n = "ce nter" > 樓號：</ td >< td alig n = "ce nter" >< in puttype ="text" name = "build" required /><

26、;/ td ></ tr><tr >< td alig n = "ce nter" > 房間號：</td>< td alig n ="ce nter" >< in puttype ="text" name = "home" required /></ td ></ tr><tr>< tdcolspa n = "2" alig n= "ce nter" >

27、;< in puttype = "submit" value =" 插 入"/></ td ></ tr><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");String name=request.getParameter("name");String class仁request.getParameter("class");Str

28、ing sex=request.getParameter("sex");String age=request.getParameter("age");String build=request.getParameter( "build");String home=request.getParameter( "home");tryClass.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryStrin

29、g user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onnection(conn ectDB,user,password);Stateme nt stmt = con .createStateme nt();Stri ng sql= "INSERT INTO xinxiVALUES('"+s no+ "','"+ name+ "','" +class1+ &q

30、uot;','" +sex+ "','" +age+ "','"+build+ "','" +h ome+ "')"int i=stmt.executeUpdate(sql);stmt.close();con. close();catch (SQLException e)e.pri ntStackTrace();System.exit(O);%>2. 刪除數(shù)據(jù)宿舍管理系統(tǒng)延回退出該模塊主要代碼：vbody bgcolor = #

31、CFE3CA text = "#004080" > vform action ="function2.jsp"method = "post" >< blockquote >< h1 align ="center" > 宿舍管理系統(tǒng) </ h1 >< hr width = "600" > </ blockquote > < table width = "500" height = "300&

32、quot; alig n = "ce nter" border = "1" cellpaddi ng = "0" cellspaci ng = "0" ><tr >< td colspan = "2" align ="center" > 刪除學生信息 </ td ></ tr ><tr >< td alig n = "ce nter" > 學號：</ td ><

33、 td alig n = "ce nter" >< in puttype = "submit" value ="刪除> 返回 </ a> <a href = "jiemian.jsp" >type ="text" name = "sno" required /></ td ></ tr> <tr>< td colspa n = "2" alig n = "ce nte

34、r" >< in put "/></ td ></ tr> </ table ></ form > < br >< br > < div align ="center" >< a href = "main.html"退出 </ a> </ div > <%if (session.getAttribute("c" )= null )response.sendRedirect(&qu

35、ot;jiemian.jsp");%> v/body><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");Class.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ect

36、i on con = DriverMa nager.getC onn ectio n(c onn ectDB, user,password);Stateme nt stmt = con .createStateme nt();String sql= "delete from xi nxi where sno=”'+sno+ 1int i=stmt.executeUpdate(sql);stmt.close();con. close();catch (SQLException e)e.pri ntStackTrace();System.exit(O);%>< div

37、 align ="center" >< br> 刪除成功！ < br>< br><a href = "main.html" > 返回管理員界面 </ a> < br>< br>< a href = "delete.jsp" > 繼續(xù)刪除 </ a></ div ><%if (session.getAttribute("c" )= null )response.sendRedirect(

38、"jiemian.jsp");%></ body >3. 修改數(shù)據(jù)實用標準文檔宿舍管理系統(tǒng)返回退岀該模塊主要代碼：vbody bg color = #CFE3CA text = "#004080" >vform action ="function3.jsp" method = "post" >< blockquote ><h1 align ="center" > 宿舍管理系統(tǒng) </ h1 ><hr width = "

39、;600" ></ blockquote >< table width = "500"height ="100" alig n = "ce nter" border = "1" cellpaddi ng = "0" cellspaci ng = "0" >< tr >< td colspan = "2" align ="center" > 舊信息 </ td >

40、</ tr ><tr >< td align = "center" > 修改學生學號： </td>< td align ="center" >< input type = "text" name = "sno" required /></ td ></ tr></ table >< br >< br > < table width = "500" height

41、 = "300" alig n = "ce nter" border = "1" cellpaddi ng = "0" cellspaci ng = "0" >< tr >< td colspan = "2" align= "center" > 新信息 </ td ></ tr ><tr >< td alig n = "ce nter" > 新學號：</

42、 td >< td alig n ="ce nter" >< in puttype ="text" name = "sno1" required /></ td ></ tr ><tr >< td alig n = "ce nter" > 新姓名：</td>< td alig n ="ce nter" >< in puttype ="text" name = "

43、;name" required /></ td ></ tr ><tr >< td alig n = "ce nter" > 新班級：</ td >< td alig n = "ce nter" >< in puttype ="text" name = "class" required /></ td ></ tr ><tr >< td alig n = "ce n

44、ter" > 新年齡：</ td >< td alig n ="ce nter" >< in puttype ="text" name = "age" required /></ td ></ tr><tr >< td alig n = "ce nter" > 新性別：</td>< td alig n ="ce nter" >< in puttype ="t

45、ext" name = "sex" required /></ td ></ tr><tr >< td alig n = "ce nter" > 新樓號：</ td >< td alig n ="ce nter" >< in puttype ="text" name = "build" required /></ td ></ tr><tr >< td a

46、lig n = "ce nter" > 新房間號：</td>< td alig n ="ce nter" >< in puttype ="text" name = "home" required /></ td ></ tr><tr>< td colspa n= "2" alig n= "ce nter" >< in put type = "submit" va

47、lue ="修改 "/></ td ></ tr> </ table ></ form > < br >< br >< div align ="center" >< a href = "main.html"> 返回 </ a> < a href = "jiemian.jsp" >退出 </ a> </ div > <%if (session.getAttribu

48、te("c" )= null )response.sendRedirect("jiemian.jsp");%></body><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");String sno1=request.getParameter("sno1");String name=request.getParameter("name");Strin

49、g class仁request.getParameter("class");String sex=request.getParameter("sex");String age=request.getParameter("age");String build=request.getParameter( "build");String home=request.getParameter( "home");Class.forName(JDriver); catch (ClassNotFoundExce

50、ption e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onnection(conn ectDB,user,password);Stateme nt stmt = con .createStateme nt();+agString sql= "update xinxi setsno 二”'+sn o1+ "' ,n ame='

51、;" +n ame+ "',class=" +class1+ ",sex='" +sex+ "',age= e+ ",build='" +build+ "',home=" +home+ " where sno='" +sno+ "”'int i=stmt.executeUpdate(sql);stmt.close();con. close();catch (SQLException e)e.pri ntStac

52、kTrace();System.exit(O);%> < div align ="center" >< br> 修改成功！ < br>< br><a href = "main.html" > 返回管理員界面 </ a> < br>< br>< a href = "update.jsp" > 繼續(xù)修改 </ a></ div ><%if (session.getAttribute("c

53、" )= null )response.sendRedirect( "jiemian.jsp");%> </ body >4.查看數(shù)據(jù)宿舍管理系統(tǒng)魚看學生信息査看全郃學主信息該模塊主要代碼：vtable border = 1 align = "center" ><tr height =40>v th width =50> 學號 </ th >< th width = 50 > 姓名 </ th >< th width = 50> 班級 </ th &

54、gt;<th width = 50> 性別 </ th >< th width = 50> 年齡 </ th >< th width = 50> 樓號</ th >< th width = 50> 房間號 </ th ></ tr></table><% while (rs.next() %>< table border =1 align ="center" >< tr height = 40><tdwidth=50

55、><%out.println(rs.getObject(l);%> </ td><tdwidth=50><%out.println(rs.getObject(2);%> </ td><tdwidth=50><%out.println(rs.getObject(3);%> </ td><tdwidth=50><%out.println(rs.getObject)；%> </ td><tdwidth=50><%out.println(rs.ge

56、tObject(5);%> </ td><tdwidth=50><%out.println(rs.getObject(6);%> </ td><tdwidth=50><%out.println(rs.getObject(7);%> </ td></ tr></ table ><body bgcolor=#CFE3CA text = "#004080" >< form action="function4.jsp"method

57、= "post" >< blockquote><h1 alig n ="center" >宿舍管理系統(tǒng)</ h1 ><hr width =:"600" ></ blockquote >< table width = "500" height = "300" alig n = "ce nter" border = "1" cellpaddi ng = "0" cell

58、spaci ng = "0" >< tr >< td colspan = "2" align ="center" > 按學號查看信息 </ td ></ tr ><tr >< td alig n = "ce nter" > 請輸入學號：</td >< td alig n ="ce nter" >< in put type ="text" name = "sno

59、" required /></ td ></ tr><tr>< td colspa n= "2" alig n= "ce nter" x in put type = "submit" value ="查詢"/></ td ></ tr></ table ></ form >< br >< br >< div align ="center" ><

60、 a href = "readmain.jsp"> 返回 </ a> < ahref = "jiemian.jsp" > 退出 </ a> </ div > <%文案大全if(session.getAttribute( "c" )= null ) response.sendRedirect("jiemian.jsp");%>v/body><tr><td colspan="2"align="cent

61、er">按宿舍號查看信息 </td>v/tr><tr><td alig n="ce nter">請輸入宿舍號： </td><td alig n="ce nter"><inputtype ="text" name = "home" required /></ td ></ tr><tr>< td colspa n= "2" alig n= "ce nte

62、r" >< in put type = "submit" value ="查詢"/></ td ></ tr></ table ></ form >< br >< br ><div align ="center" >< a href = "readmain.jsp"> 返回 </ a> < ahref = "jiemian.jsp" >退出 <

63、/ a> </ div ><%if (session.getAttribute("c" )= null )response.sendRedirect("jiemian.jsp");%>文案大全</ body ><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");String home=request.getParameter("home");t

64、ryClass.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onnection(conn ectDB, user,password);Stateme nt stmt = con .createStateme nt();ResultSet rs = stmt.executeQ

65、uery( "SELECT * FROM xinxi where文案大全sno二”'+sno+ "' or home='" +home+ "”');%> < table border =1 align ="center" > <tr height =40>v th width =50> 學號 </ th >< th width = 50 > 姓名 </ th >< th width = 50> 班級 </ th &

66、gt; <th width =50> 性別</ th>< th width =50> 年齡</ th >< th width =50>樓號 </ th >< th width = 50> 房間號 </ th > </ tr></ table ><% while (rs.next() %>< table border =1 align ="center" >< tr height = 40><tdwidth :=50

67、><% out.println(rs.getObject(l);%> </ td ><tdwidth :=50><% out.println(rs.getObject(2);%> </ td ><tdwidth :=50><% out.println(rs.getObject(3);%> </ td ><tdwidth :=50><% out.println(rs.getObject)；%> </ td ><tdwidth :=50><%

68、out.println(rs.getObject(5);%> </ td ><tdwidth :=50><% out.println(rs.getObject(6);%> </ td ><tdwidth :=50><% out.println(rs.getObject(7);%> </ td ></ tr></ table ><% rs.close();stmt.close();con. close(); catch (SQLException e)e.pri ntStack

69、Trace();System.exit(O);%>< br >< div align ="center" >< a href = "readmain.jsp" > 返回 </ a> </ div ><%if (session.getAttribute("c" )= null )response.sendRedirect("jiemian.jsp");%>v/body>四、存在的問題該系統(tǒng)是本人自己獨立完成，故存在很多問題。一是界面不

70、太美觀，由于時間有限，再加上自己的知識的不足，很難做出漂亮的界 面，再者沒有借鑒網(wǎng)上的模板，若自己實現(xiàn)確實很難。但是，既然提出了這個問題，那我就要去面對，在此之后，我還會補充自己知識的不足，然后借鑒一些好的模板，然后 做出一個漂亮的界面。二是功能不是太完善，該系統(tǒng)的功能有基本的登錄、注冊功能；錄入信息、插入信 息、修改信息、刪除信息、查找信息等功能；雖然該系統(tǒng)已經(jīng)具備基本功能，但是我覺 得還需要加入宿舍新聞、公告、電費、水費、優(yōu)秀宿舍等功能，既然提出了這個問題， 我會盡我的努力把這些功能加上。該系統(tǒng)可能還有很多不足，我會在進行思考和修改。五、其它核心技術(shù)該系統(tǒng)中也運用了一些核心技術(shù)，如登錄時對

71、用戶名、密碼的判斷：Stri ng sql= "select * from " +n ame+ " where n ame='" +user name+ "' andpassword='" + password1 +"'"ResultSet rs=stmt.executeQuery(sql);String s1= "admin"String s2= "stu"if (rs. next()if (s1.equals( name)session.s

72、etAttribute( "login" , "true");resp on se.se ndRedirect( "ma in .html" ); else session.setAttribute("login" , "true");resp on se.se ndRedirect( "ma in 2.html" );else out.print("用戶名或密碼錯誤，請重新輸入！");如對數(shù)據(jù)庫的連接：<%Stri ng JDriver =文案大全

73、Class.forName(JDriver); catch (ClassNotFoundException e)加載數(shù)據(jù)庫引擎失敗");System.exit(0);tryString user = "lph"String password ="123"Conn ecti on con = DriverMa nager.getC onn ectio n(c onn ectDB, user,password);Stateme nt stmt = con .createStateme nt();rs.close();stmt.close();con

74、. close(); catch (SQLException e)e.pri ntStackTrace();System.exit(0);%>如對每個網(wǎng)頁的限定，沒有登錄，不能出現(xiàn)界面，并且跳到登錄界面:<% sessio n.setAttribute("c","c");%> <%if (session.getAttribute("c" )= null )resp on se.se ndRedirect("jiemia n.jsp");%>如對數(shù)據(jù)庫的各種操作：Stri ng sql= "INSERT