实验室设备安排系统

备管理系统备管理系统、需求分析 !二、 概要设计 5三、详细设计 13四、调试分析 37五、用户手册 37六、附录 38、需求分析需求背景a、够类型(2b、.够名称、数、属性d、够e、够借还需求户分：员不身份之间的户具有不特权；员够类型(2设户其具有增、删、改权；够查看其具有借还权利；够查看其具有借还、实验室、借还。a.分为物、化学和软件每个不同类型中二实验室中可以查看实验室列表可以对实验室行增、删、改操作借列表老师老师自己账号陆老师老师两a.实验室中老师只查看实验室列表不有更改等操作学生学生自己账号陆学生学生两ab二、概要计模块用户登录借还查看借还验借还统块 块

a、学生学生借还学生借还借出管理归还管理老师老师借还借出管理归还管理c、管理员模块该模块为管理员提供操作：管理员可通过该模块所提供的功能进行查看设备管理、实验室管理、借还实验设备。如下图所示：理 理 归验用 还修 改

的修删改除加、数据库表学生信息表信息表管理员信息表中光光度仪表借出设备1()、存储、各种定义以及他们间联系。2况。独立于系统实现。学生实体：学生实体：方式老师实体电话性别位住址姓名编号密码管理员电话性别位住址仪：实验室：借出的设备ER、 详细计系统功能概述及核心代码a.。核实登录信息跳转到界核心代码：<%@ page contentType="text/html; language="java"import="java.sql.*"errorPage=""%><%@pageimport=".URLEncoder"%><%Stringmasname=request.getParameter("username");//获取管登 陆 网 账 号 maspassword=request.getParameter("password");//获取登陆网密码%><scripttype="text/javascript">alert("用户名或密码能空！");//判断登录账号密码得空window.document.location.href="admin-login.jsp"; //登录界面</script><%}else{Stringurl="jdbc:sqlserver://localhost:1433;DataBaseName=test";Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connectionconn=DriverManager.getConnection(url,"ylq","11205201")//"selectmasname,maspasswordfrommasterwheremasname=andmaspassword=?";//PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1,masname);pstmt.setString(2,maspassword);ResultSetrs=pstmt.executeQuery();if (rs.next())话 session.setAttribute("loginname",masname);response.sendRedirect("master-index.jsp");//实主页面}else{%><scripttype="text/javascript">window.document.location.href="master-login.jsp"; /陆用户或密码错误，返回登录界面</script><%}rs.close();conn.close();pstmt.close();}%><%@ page contentType="text/html; language="java"import="java.sql.*"errorPage=""%><%@pageimport=".URLEncoder"%><%String teaname=request.getParameter("username");//Stringteapassword=request.gerParameter("password");//if((teaname=="")||(teapassword=="")){%><scripttype="text/javascript">alert("不能为空！");//判断window.document.location.href="teacher-login.jsp"/老</script><%}else{Stringurl="jdbc:sqlserver://localhost:1433;DataBaseName=test";Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connectionconn=DriverManager.getConnection(url,"ylq","11205201");Stringsql="selectteaname,teapasswordfromteacherwhereteaname=?andteapassword=?";PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1,teaname);pstmt.setString(2,teapassword);ResultSetrs=pstmt.executeQuery();if(rs.next()){session.setAttribute("teaname",teaname);//编会话session.setAttribute("loginname",teaname);主页面}else{%><scripttype="text/javascript">alert("用户名或密码错误！");window.document.location.href="teacher-login.jsp";//登录界面</script><%}rs.close();conn.close();pstmt.close();}%>学生登录，跳转到学生界面：<%@ page contentType="text/html; language="java"import="java.sql.*"errorPage=""%><%@pageimport=".URLEncoder"%>Stringstuname=request.getParameter("username");//Stringstupassword=request.gerParameter("password");//获if((stuname=="")||(stupassword=="")){%><scripttype="text/javascript">alert("不能为空！"); //判断录面号，不得为空window.document.location.href="student-login.jsp"//返回学录界面</script><%}else{Stringurl="jdbc:sqlserver://localhost:1433;DataBaseName=test";Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection conn = DriverManager.getConnection(url,"ylq","11205201");//Stringsql"selectstuname,stupasswordfromstudentwherestuname=andstupassword=?";//PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1,stuname);pstmt.setString(2,stupassword);ResultSetrs=pstmt.executeQuery();if(rs.next()){session.setAttribute("stuname",stuname);//编session.setAttribute("loginname",stuname);response.sendRedirect("student-index.jsp");/实主界面}else{%><scripttype="text/javascript">window.document.location.href="student-login.jsp"; 登陆的名或密码错误，返回学生登录界面</script><%}rs.close();pstmt.close();conn.close();} %><%request.setCharacterEncoding("GB2312");Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=test";Connection conn = DriverManager.getConnection(url, "11205201");//Statementstmt=conn.createStatement();Stringsql"select* fromfenxihuaxue//%><h3></h3><tableborder="1"width="800"style="font-size:12px"><tr><thheight="235"</th><th>仪器名称</th><th</th><th>属性</th><th</th><th>操作</th></tr>//建表显示的信息<%ResultSetrs=stmt.executeQuery(sql);while(rs.next()){Stringfennamers.getString("fenname");//获取的%><tr><td><%=rs.getString("fenname")%></td>//仪器的编号<td><%=rs.getString("fenmingcheng")%></td>//仪器的名称<td><%=rs.getString("fenno")%></td>//仪器的数量<td><%=rs.getString("feninformation")%><//td>/仪器的详细信息<td><%=rs.getString("fenrukuhao")%></td><td>//仪器的入库号<a href='fenxihuaxue-change.jsp?fenname=<%=fenname%>'> 修 改</a><br><br><a href='fenxihuaxue-delete.jsp?fenname=<%=fenname%>'> 删 除</a><br><br></td></tr><%}rs.close();stmt.close();conn.close(); //数据库连接关闭%></table><ahref="fenxixiangqing.jsp"></a><br><br><ahref="fenxihuaxue-add.jsp"></a><br><br><ahref="master-index.jsp"></a></center><%request.setCharacterEncoding("GB2312");//中文Stringfengname=request.getParameter("fengname");//仪器编号Stringfengmingcheng=request.getParameter("fengmingcheng");//仪器名称Stringfengno=request.getParameter("fengno");//仪器数量Stringfenginformation=request.getParameter("fenginformation");//仪器详细信息Stringfengrukuhao=request.getParameter("fengrukuhao");//仪器入库号Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=test";Connectionconn=DriverManager.getConnection(url,"ylq",//建立数据库连接Stringsql="insertFenguangguangduqiset fengmingcheng=?fengno=?,fenginformation=?,fengrukuhao=? fengname=?"//新建数据库插入语句PreparedStatementpstmt=pstmt.setString(1,fengmingcheng);pstmt.setString(2,fengno);pstmt.setString(3,fenginformation);pstmt.setString(4,fengrukuhao);pstmt.setString(5,fengname);pstmt.executeUpdate();//执行该语句成pstmt.close();conn.close();//%><h1>(*^^*)……！恭喜成功咯！</h1>修改：<%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*"%><%request.setCharacterEncoding("GB2312");Stringhengname=request.getParameter("hengname");//的仪器编号Stringhengmingcheng=request.getParameter("hengmingcheng");//Stringhengno=request.getParameter("hengno");//Stringhenginformation=request.getParameter("henginformation");//Stringhengrukuhao=request.getParameter("hengrukuhao"Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=test";Connection conn = DriverManager.getConnection(url, "ylq","11205201");//jStringsql="updatehengwenxiangset hengmingcheng=?,hengno=?,henginformation=?,hengrukuhao=?wherehengname?";//PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1,hengmingcheng);pstmt.setString(2,hengno);pstmt.setString(3,henginformation);pstmt.setString(4,hengrukuhao);pstmt.setString(5,hengname);pstmt.executeUpdate();// 句response.setHeader("refresh","2;URL=wuhuaxiangqing.jsp");pstmt.close();conn.close();//%><h1>(*^^*)……！恭喜成功咯！</h1><%StringDBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";StringDBURL="jdbc:sqlserver://localhost:1433;DataBaseName=test";StringDBUSER="ylq";StringDBPASSWORD="11205201";Connectionconn=null;PreparedStatementpstmt=null;Stringsql=null;%><%request.setCharacterEncoding("GB2312");Stringfengname=request.getParameter("fengname");//仪器编号//语句Class.forName(DBDRIVER);conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);/建立数据库连接pstmt=conn.prepareStatement(sql);pstmt.setString(1,fengname);pstmt.execute/语句response.setHeader("refresh","2;URL=fenxixiangqing.jsp");pstmt.close();conn.close(//库连接关闭%><h1>(*^^*</h1>3.实验室列表<%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*,java.text.SimpleDateFormat"%><%Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=test";Connection conn = DriverManager.getConnection(url, "11205201");//建立数据连接Statementstmt=conn.createStatement();Stringsql"select* fromlab";//建立题目的数据库查询语句%><h3>实验室列表</h3><tableborder="1"width="800"style="font-size:12px"><tr><thheight="235"</th><th></th<th></th><th</th><th</th><th</th><th</th><th</th></tr>//体信息<%ResultSetrs=stmt.executeQuery(sql);while(rs.next()){Stringlabname=rs.getString("labname");%><tr>

<td ><%=rs.getString("labname")%></td>//获取并<td><%=rs.getString("labno")%></td>//获取并数量<td><%=rs.getString("labguimo")%></td>//获取并管理员

<td><%=rs.getString("labcellphone")%></td>//获取并<td><%=rs.getString("labaddress")%></td>//获取并<td><%=rs.getString("labuser")%></td>//获取并使者<td><%=rs.getString("labtype")%></td>//获取并

<td width="80"><ahref='lab-change.jsp?labname=<%=labnam</a><br><br><a href='lab-delete.jsp?labname=<%=labname%>> 除</a><td><br><br></t><%}rs.close();stmt.close();conn.close();%></table><ahref="lab-add.jsp"></a></td><br><br><ahref="master-index.jsp"></a></center><%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*,java.text.SimpleDateFormat"%><%request.setCharacterEncoding("GB2312");Stringloginname=(String)session.getAttribute("loginname");//Stringsoftname=request.getParameter("softname");//session.setAttribute("jie_softname",softname);%><formaction="software-jiechu-do.jsp"><h2><%=loginname%> ,hello</h2>software<%=softname%><br><inputtype="text"name="softno"/><br><inputtype"submit/></form><%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*"%><%request.setCharacterEncoding("GB2312");Stringsoftname=(String)session.getAttribute("jie_softname");/仪器名称Stringsoftno=request.getParameter("softno");//借出的数量Stringloginname=(String)session.getAttribute("loginname");//登录名Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=test";Connectionconn=DriverManager.getConnection(url,"ylq","11205201");/建立数据连接Stringsql="insertintosoftjie(softno,softname,name)values(?,?,?);";//建立数据库增加语句PreparedStatementpstmt=conn.prepareStatement(sql);pstmt.setString(1,softno);pstmt.setString(2,softname);pstmt.setString(3,loginname);intrs=pstmt