📄 classmod.jsp

📁 JSP制作的图书管理系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	background-image: url(MainImages/background.gif);
}
.STYLE5 {font-family: "宋体"; font-size: 12px; color: #FFFFFF; }
.STYLE1 {
	color: #FFFFFF;
	font-size: 36px;
	font-weight: bold;
	font-family: "宋体";
}
.STYLE58 {color: #FFFFFF}
.STYLE64 {color: #FFFFFF; font-weight: bold; font-size: 18px; }
body,td,th {
	color: #FFFFFF;
}
.STYLE67 {
	font-size: 18px;
	font-weight: bold;
	font-family: "宋体";
}
.STYLE71 {	color: #FFFFFF;
	font-family: "宋体";
	font-size: 12px;
}
a:link {
	color: #FFFFFF;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #FFFFFF;
}
a:hover {
	text-decoration: none;
	color: #FFFFFF;
}
a:active {
	text-decoration: none;
	color: #FFFFFF;
}
.booktable {
	font-family: "宋体";
	font-size: 12px;
	font-style: normal;
	color: #FFFFFF;
	background-image: url(MainImages/background.gif);
}
-->
</style>
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
	<%
		String userid = (String) session.getAttribute("userid");
		if (userid == null)
			response.sendRedirect("../index.jsp?error=2");
	%>
	<%
		Integer level = (Integer) session.getAttribute("level");
		int l = level.intValue();
		if (level == null)
			response.sendRedirect("../index.jsp?error=2");
		if (!(l == 2))
			response.sendRedirect("../error.jsp");
	%>
	<%
		String sql = null;
		java.sql.ResultSet rs = null;
		String classid = null;
		String classname = null;
		Integer menbers = 0;
		Date Cdate = null;
		String type = "";
		String message = "";
	%>
	<%
		request.setCharacterEncoding("gb2312");
		classid = (String) session.getAttribute("classid");
		if (classid != null) {
			sql = "select * from class where classid='" + classid + "'";
			try {
				rs = myRs.executeQuery(sql);
				while (rs.next()) {
			classid = rs.getString("classid");
			classname = rs.getString("classname");
			menbers = Integer.valueOf(rs.getInt("menbers"));
			Cdate = rs.getDate("Cdate");
				}
			} catch (Exception e) {
				e.printStackTrace();
				message = "查询班级失败";
			}

			type = request.getParameter("type");
			if (type != null && type.equals("update")) {
				String Classid = request.getParameter("classid");
				classname = request.getParameter("classname");
				menbers = Integer.valueOf(request.getParameter("menbers"));
				String date = request.getParameter("Cdate");
				sql = "update class set ";
				if (classid != null) {
			sql += "classid='" + Classid + "',";
				}
				if (classname != null) {
			sql += "classname='" + classname + "',";
				}
				if (menbers != null) {
			sql += "menbers=" + menbers.intValue() + ",";
				}
				if (date != null) {
			sql += "Cdate=" + "'" + date + "',";
				}
				sql = sql.substring(0, sql.length() - 1);
				sql += " where classid='" + classid + "'";
				//out.println(sql);
				try {
			int i = myRs.executeUpdate(sql);
			message = "修改班级成功！";
			session.setAttribute("Classid", Classid);
				} catch (Exception e) {
			e.printStackTrace();
			message = "修改班级失败！请后退，或者重新修改！";
				} finally {
			myRs = null;
				}
			}
		}
	%>
<body>
<table width="100%" border="0">
  <tr>
    <td width="35%"><img src="MainImages/logo.gif" width="64" height="64" /><img src="MainImages/smutitle.gif" width="268" height="64" /></td>
    <td width="65%"><span class="STYLE1">教材管理系统</span></td>
  </tr>
  <tr>
    <td colspan="2"><hr /></td>
  </tr>
  <tr>
    <td colspan="2"><p>&nbsp;</p>
    </td>
  </tr>
</table>
<table width="100%" height="217" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
  <tr>
    <td width="13%" align="left" valign="top" background="MainImages/background.gif"><p>
      <table width="22%" border="0">
        <tr>
          <td><table width="23%" height="217" border="0" cellpadding="5" cellspacing="0" bgcolor="#FFFFFF">
            <tr>
              <td width="11%" align="center" background="MainImages/background.gif"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="96" height="27">
                  <param name="BGCOLOR" value="#306B9B" />
                  <param name="BGCOLOR" value="#306B9B" />
                  <param name="movie" value="MainImages/zhuyaogongneng.swf" />
                  <param name="quality" value="high" />
                  <embed src="MainImages/zhuyaogongneng.swf" width="96" height="27" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#306B9B" ></embed>
              </object></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE67"><a href="../Main.jsp">返回主页</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="ClassInfo.jsp">班级信息</a><a href="BookInfo.jsp"></a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="ClassQuery.jsp">班级号查询</a><a href="BookQuery.jsp"></a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="ClassQuery.jsp">班级名查询</a><a href="BookQuery.jsp"></a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="ClassAdd.jsp">增加班级</a><a href="BookAdd.jsp"></a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE67"><a href="ClassDel.jsp">删除班级</a><a href="BookDel.jsp"></a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE67"><a href="ClassMod.jsp">修改班级</a><a href="BookMod.jsp"></a></span></td>
            </tr>
          </table></td>
        </tr>
      </table>      <span class="STYLE58"></span></td>
    <td width="87%" align="center" valign="top" background="MainImages/background.gif">
	
	<table width="100%" height="100%" border="0" class="booktable">
      <tr>
        <td align="center" valign="top"><form name="form" method="post"
									action="ClassMod.jsp?type=update">
									<table width="100%" border="1" cellpadding="3" cellspacing="0" class="booktable">
										<tr>
											<td width="35%">
												<div align="right">
													班级编号：
												</div>
											</td>
											<td width="65%">
												<div align="left">
													<label>
														<input name="classid" type="text" size="40"
															value="<%=classid %>">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td>
												<div align="right">
													班级名称：
												</div>
											</td>
											<td>
												<div align="left">
													<label>
														<input name="classname" type="text" size="40"
															value="<%=classname %>">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td>
												<div align="right">
													班级人数：
												</div>
											</td>
											<td>
												<div align="left">
													<label>
														<input name="menbers" type="text" size="40"
															value="<%=menbers %>">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td>
												<div align="right">
													入学年份：
												</div>
											</td>
											<td>
												<div align="left">
													<label>
														<input name="Cdate" type="text" size="40"
															value="<%=Cdate %>">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td colspan="2">
												<div align="center">
													<label>
														<input type="submit" name="Submit" value="修改">
													</label>
												</div>
											</td>
										</tr>
			  </table>
								</form>
								<center>
									<%=message%>
								</center></td>
      </tr>
      
    </table></td>
  </tr>
</table>
<table width="100%" border="0" cellpadding="5">
  <tr>
    <td><div align="center"><span class="STYLE71"><strong>Copyright&copy;2008 </strong>上海海事大学信息053 </span></div></td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -