北京工业大学2016 - 2017 学年第 1 学期信息学部—计算机学院2016年12月16日学生宿舍管理信息系统目录系统结构 (1)系统模块流程图 (1)系统模块功能图 (2)数据库设计 (3)子模块设计 (4)登录注册模块 (4)管理模块 (6)浏览模块 (7)功能模块 (8)插入数据 (8)删除数据 (10)修改数据 (12)查看数据 (14)存在的问题 (18)其他核心技术 (18)现场修改过程 (20)一、系统结构1.系统模块流程图a.登录注册流程图b.录入信息流程图c.输出信息流程图d.插入信息流程图e.删除信息流程图f.修改信息流程图2.系统模块功能图本系统所使用的所有的数据，均存放在数据库中。
该系统使用的是SQL Server Management Studio。
在数据库中建立一个dorm数据库，在dorm数据库中建立三个表，分别为管理员表、普通用户表、信息表。
信息表：然后在JSP使用JAVA语句对数据进行连接。
具体代码如下：<%String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();rs.close();stmt.close();con.close();} catch (SQLException e)e.printStackTrace();System.exit(0);}%>最后对数据库进行录入、增加、删除、修改等功能的实现。
三、子模块设计1.登录注册模块该模块主要代码如下：登录判断：<% request.setCharacterEncoding("utf-8");String username=request.getParameter("username");String password1=request.getParameter("password");String name=request.getParameter("user");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA"; try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();String sql="select * from "+name+" where name='"+username+"' and password='"+ password1 + "'";ResultSet rs=stmt.executeQuery(sql);String s1="admin";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");}}else{out.print("用户名或密码错误，请重新输入！ ");%><br><br><p><a href="jiemian.jsp">返回</a></p><%}stmt.close();con.close();}catch (SQLException e){e.printStackTrace();System.exit(0);}%>注册代码：<tr><td align="center">用户名：</td><td align="center"><inputtype="text"name="name"required/></td></tr><tr><td align="center">密码：</td><td align="center"><inputtype="text"name="password"required/></td></tr><tr><tdcolspan="2"align="center"><input type="submit"value="注册"/></td></tr><%request.setCharacterEncoding("utf-8");String name=request.getParameter("name");String password1=request.getParameter("password");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();String sql="INSERT INTO admin VALUES('"+name+"','"+password1+"')";int i=stmt.executeUpdate(sql);stmt.close();con.close();}catch (SQLException e){e.printStackTrace();System.exit(0);}%>2.管理模块该模块主要代码：<body bgcolor=#CFE3CA text="#004080"><form method="post"><blockquote><h1align="center">宿舍管理系统</h1><hr width="600"></blockquote><table width="500"height="300"align="center"border="1"cellpadding="0"cellspacing="0"><tr><td align="center">管理员</td></tr><tr><td align="center"><a href="readmain.jsp">查看学生信息</a></td></tr> <tr><td align="center"><a href="insert.jsp">插入学生信息</a></td></tr><tr><td align="center"><a href="update.jsp">修改学生信息</a></td></tr><tr><td align="center"><a href="delete.jsp">删除学生信息</a></td></tr></table><br><br><div align="center"><a href="jiemian.jsp">退出</a></div></body>3.浏览模块该模块主要代码：<body bgcolor=#CFE3CA text="#004080"><form method="post"><blockquote><h1align="center">宿舍管理系统</h1><hr width="600"></blockquote><table width="500"height="300"align="center"border="1"cellpadding="0"cellspacing="0"><tr><th align="center">查看学生信息</th></tr><tr><td align="center"><a href="read.jsp">查看全部学生信息</a></td></tr> <tr><td align="center"><a href="read1.jsp">按学号查看信息</a></td></tr><tr><td align="center"><a href="read2.jsp">按宿舍号查看信息</a></td></tr> </table><br><br><div align="center"><a href="main.html">返回</a><a href="jiemian.jsp">退出</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp"); }%></body>4.功能模块1.插入数据该模块主要代码：<tr><td align="center">学号：</td><td align="center"><inputtype="text"name="sno"required/></td></tr><tr><td align="center">姓名：</td><td align="center"><inputtype="text"name="name"required/></td></tr><tr><td align="center">班级：</td><td align="center"><inputtype="text"name="class"required/></td></tr><tr><td align="center">年龄：</td><td align="center"><inputtype="text"name="age"required/></td></tr><tr><td align="center">性别：</td><td align="center"><inputtype="text"name="sex"required/></td></tr><tr><td align="center">楼号：</td><td align="center"><inputtype="text"name="build"required/></td></tr><tr><td align="center">房间号：</td><td align="center"><inputtype="text"name="home"required/></td></tr><tr><td colspan="2"align="center"><input type="submit"value="插入"/></td></tr><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");String name=request.getParameter("name");String class1=request.getParameter("class");String sex=request.getParameter("sex");String age=request.getParameter("age");String build=request.getParameter("build");String home=request.getParameter("home");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();String sql="INSERT INTO xinxiVALUES('"+sno+"','"+name+"','"+class1+"','"+sex+"','"+age+"','"+build+"','" +home+"')";int i=stmt.executeUpdate(sql);stmt.close();con.close();}catch (SQLException e){e.printStackTrace();System.exit(0);%>2.删除数据该模块主要代码：<body bgcolor=#CFE3CA text="#004080"><form action="function2.jsp"method="post"><blockquote><h1align="center">宿舍管理系统</h1><hr width="600"></blockquote><table width="500"height="300"align="center"border="1"cellpadding="0"cellspacing="0"><tr><td colspan="2"align="center">删除学生信息</td></tr><tr><td align="center">学号：</td><td align="center"><inputtype="text"name="sno"required/></td></tr><tr><td colspan="2"align="center"><input type="submit"value="删除"/></td></tr></table></form><br><br><div align="center"><a href="main.html">返回</a><a href="jiemian.jsp">退出</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp");%></body><%request.setCharacterEncoding("utf-8");String sno=request.getParameter("sno");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();String sql="delete from xinxi where sno='"+sno+"'";int i=stmt.executeUpdate(sql);stmt.close();con.close();}catch (SQLException e){e.printStackTrace();System.exit(0);}%><div align="center"><br>删除成功！<br><br><a href="main.html">返回管理员界面</a><br><br><a href="delete.jsp">继续删除</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp");}%></body>3.修改数据该模块主要代码：<body bg color=#CFE3CA text="#004080"><form action="function3.jsp"method="post"><blockquote><h1align="center">宿舍管理系统</h1><hr width="600"></blockquote><table width="500"height="100"align="center"border="1"cellpadding="0"cellspacing="0"> <tr><td colspan="2"align="center">旧信息</td></tr><tr><td align="center">修改学生学号：</td><td align="center"><input type="text"name="sno"required/></td></tr></table><br><br><table width="500"height="300"align="center"border="1"cellpadding="0"cellspacing="0"> <tr><td colspan="2"align="center">新信息</td></tr><tr><td align="center">新学号：</td><td align="center"><inputtype="text"name="sno1"required/></td></tr><tr><td align="center">新姓名：</td><td align="center"><inputtype="text"name="name"required/></td></tr><tr><td align="center">新班级：</td><td align="center"><inputtype="text"name="class"required/></td></tr><tr><td align="center">新年龄：</td><td align="center"><inputtype="text"name="age"required/></td></tr><tr><td align="center">新性别：</td><td align="center"><inputtype="text"name="sex"required/></td></tr><tr><td align="center">新楼号：</td><td align="center"><inputtype="text"name="build"required/></td></tr><tr><td align="center">新房间号：</td><td align="center"><inputtype="text"name="home"required/></td></tr><tr><td colspan="2"align="center"><input type="submit"value="修改"/></td></tr></table></form><br><br><div align="center"><a href="main.html">返回</a><a href="jiemian.jsp">退出</a></div><%if(session.getAttribute("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");String class1=request.getParameter("class");String sex=request.getParameter("sex");String age=request.getParameter("age");String build=request.getParameter("build");String home=request.getParameter("home");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();String sql="update xinxi setsno='"+sno1+"',name='"+name+"',class="+class1+",sex='"+sex+"',age="+age+",b uild='"+build+"',home="+home+" where sno='"+sno+"'";int i=stmt.executeUpdate(sql);stmt.close();con.close();}catch (SQLException e){e.printStackTrace();System.exit(0);}%><div align="center"><br>修改成功！<br><br><a href="main.html">返回管理员界面</a><br><br><a href="update.jsp">继续修改</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp");}%></body>4.查看数据该模块主要代码：<table border=1align="center"><tr height=40><th width=50>学号</th><th width=50>姓名</th><th width=50>班级</th><th width=50>性别</th><th width=50>年龄</th><th width=50>楼号</th><thwidth=50>房间号</th></tr></table><%while (rs.next()){ %><table border=1align="center"><tr height=40><td width=50><%out.println(rs.getObject(1)); %></td><td width=50><%out.println(rs.getObject(2)); %></td><td width=50><%out.println(rs.getObject(3)); %></td><td width=50><%out.println(rs.getObject(4)); %></td><td width=50><%out.println(rs.getObject(5)); %></td><td width=50><%out.println(rs.getObject(6)); %></td><td width=50><%out.println(rs.getObject(7)); %></td></tr></table><body bgcolor=#CFE3CA text="#004080"><form action="function4.jsp"method="post"><blockquote><h1align="center">宿舍管理系统</h1><hr width="600"></blockquote><table width="500"height="300"align="center"border="1"cellpadding="0"cellspacing="0"><tr><td colspan="2"align="center">按学号查看信息</td></tr><tr><td align="center">请输入学号：</td><td align="center"><inputtype="text"name="sno"required/></td></tr><tr><td colspan="2"align="center"><input type="submit"value="查询"/></td></tr></table></form><br><br><div align="center"><a href="readmain.jsp">返回</a><a href="jiemian.jsp">退出</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp");}%></body><tr><td colspan="2"align="center">按宿舍号查看信息</td></tr><tr><td align="center">请输入宿舍号：</td><td align="center"><inputtype="text"name="home"required/></td></tr><tr><td colspan="2"align="center"><input type="submit"value="查询"/></td></tr></table></form><br><br><div align="center"><a href="readmain.jsp">返回</a><a href="jiemian.jsp">退出</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");String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JAVA";try{Class.forName(JDriver);} catch (ClassNotFoundException e){System.out.println("加载数据库引擎失败");System.exit(0);}try{String user = "lph";String password = "123";Connection con = DriverManager.getConnection(connectDB, user,password);Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM xinxi where sno='"+sno+"' or home='"+home+"'");%><table border=1align="center"><tr height=40><th width=50>学号</th><th width=50>姓名</th><th width=50>班级</th><th width=50>性别</th><th width=50>年龄</th><th width=50>楼号</th><thwidth=50>房间号</th></tr></table><%while (rs.next()){ %><table border=1align="center"><tr height=40><td width=50><%out.println(rs.getObject(1)); %></td><td width=50><%out.println(rs.getObject(2)); %></td><td width=50><%out.println(rs.getObject(3)); %></td><td width=50><%out.println(rs.getObject(4)); %></td><td width=50><%out.println(rs.getObject(5)); %></td><td width=50><%out.println(rs.getObject(6)); %></td><td width=50><%out.println(rs.getObject(7)); %></td></tr></table><% }rs.close();stmt.close();con.close();} catch (SQLException e){e.printStackTrace();System.exit(0);}%><br><div align="center"><a href="readmain.jsp">返回</a></div><%if(session.getAttribute("c")==null){response.sendRedirect("jiemian.jsp");}%></body>四、存在的问题该系统是本人自己独立完成，故存在很多问题。