📄 bookmod.jsp

📁 jsp+sqlserver2000+tomcat做的教材管理系统。基本功能全部实现
💻 JSP
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
	import="java.util.*,java.sql.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!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);
}
.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;
}
-->
</style>
<link href="booktable.css" rel="stylesheet" type="text/css" />
</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;
		String type = null;
		String bookname = null;
		String auther = null;
		String publisher = null;
		String detail = null;
		java.util.Date pbdate = null;
		Float price = null;
		String bookid = null;
		String message = "";
		java.sql.ResultSet rs = null;
		java.sql.ResultSet rs2 = null;
	%>
	<%
		request.setCharacterEncoding("GB2312");
		type = request.getParameter("type");
		if (type == null)
			type = "";
		bookid = (String) session.getAttribute("bookid");
		//out.println(bookid);
		if (bookid != null) {
			try {
				sql = "select * from book where bookid='" + bookid + "'";
				rs = myRs.executeQuery(sql);
				while (rs.next()) {
			bookname = rs.getString("bookname");
			auther = rs.getString("auther");
			publisher = rs.getString("publisher");
			price = Float.valueOf(rs.getFloat("price"));
			detail = rs.getString("detail");
			pbdate = rs.getDate("pbdate");
				}
			} catch (Exception e) {
				e.printStackTrace();
			}

			if (type.equals("mod")) {
				String bookid1 = request.getParameter("bookid");
				String bookname1 = request.getParameter("bookname");
				String auther1 = request.getParameter("auther");
				String pbate1 = request.getParameter("pbdate");
				Float price1 = Float.valueOf(request.getParameter("price"));
				String publisher1 = request.getParameter("publisher");
				String detail1 = request.getParameter("detail");
				String sql1 = "update book set ";
				String sql3 = "where bookid='" + bookid + "'";
				if (bookid1 != null) {
			sql1 += "bookid=" + "'" + bookid1 + "',";
				}
				if (bookname1 != null) {
			sql1 += "bookname=" + "'" + bookname1 + "',";
				}
				if (auther1 != null) {
			sql1 += "auther=" + "'" + auther1 + "',";
				}
				if (pbate1 != null) {
			sql1 += "pbdate=" + "'" + pbate1 + "',";
				}
				if (price1 != null) {
			sql1 += "price=" + price1 + ",";
				}
				if (publisher1 != null) {
			sql1 += "publisher=" + "'" + publisher1 + "',";
				}
				if (detail1 != null) {
			sql1 += "detail=" + "'" + detail1 + "',";
				}
				sql1 = sql1.substring(0, sql1.length() - 1);
				sql = sql1 + sql3;
				//out.print(sql);
				try {
			int i = myRs.executeUpdate(sql);
			if (bookid1 != null)
				session.setAttribute("bookid", bookid1);
			message = "共有" + i + "记录被修改!";
				} catch (Exception e) {
			e.printStackTrace();
			message = "记录修改失败!";
				}
			}
		}
		if (bookid == null)
			bookid = "";
		if (bookname == null)
			bookname = "";
		if (auther == null)
			auther = "";
		if (publisher == null)
			publisher = "";
		if (pbdate == null)
			pbdate = new java.util.Date();
		if (price == null)
			price = Float.valueOf("0");
		if (detail == null)
			detail = "";
	%>
	<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">
      <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="BookInfo.jsp">图书信息</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="BookQuery.jsp">书号查询</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="BookQuery.jsp">书名查询</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE64"><a href="BookAdd.jsp">增加图书</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE67"><a href="BookDel.jsp">删除图书</a></span></td>
            </tr>
            <tr>
              <td align="center" background="MainImages/background.gif"><span class="STYLE67"><a href="BookMod.jsp">修改图书</a></span></td>
            </tr>
          </table></td>
        </tr>
      </table>      <span class="STYLE58"></span></td>
    <td width="87%"  valign="top" background="MainImages/background.gif">
	<form name="form1" method="post" action="BookMod.jsp?type=mod">
	  <table width="100%" border="1" cellpadding="3" cellspacing="0" class="booktable">
        <tr>
          <td width="16%"><label> 图书编号： </label>
          </td>
          <td width="33%"><label>
            <input name="bookid" type="text" id="bookid"
														value="<%=bookid%>" />
            </label>
          </td>
          <td width="18%"> 图书名称： </td>
          <td width="33%"><label>
            <input name="bookname" +i+"" type="text" id="bookname"
														value="<%=bookname%>" />
            </label>
          </td>
        </tr>
        <tr>
          <td> 图书作者： </td>
          <td><label>
            <input name="auther" type="text" id="auther"
														value="<%=auther%>" />
            </label>
          </td>
          <td> 出版日期： </td>
          <td><label>
            <input name="pbdate" type="text" id="pbdate"
														value="<%=pbdate%>" />
            </label>
          </td>
        </tr>
        <tr>
          <td> 图书售价： </td>
          <td><label>
            <input name="price" +i+"" type="text" id="price"
														value="<%=price%>" />
            </label>
          </td>
          <td> 出版商： </td>
          <td><label>
            <input name="publisher" type="text" id="publisher"
														value="<%=publisher%>" />
            </label>
          </td>
        </tr>
        <tr>
          <td> 图书简介： </td>
          <td colspan="3"><label>
            <textarea name="detail" cols="80" rows="8"><%=detail%></textarea>
            </label>
          </td>
        </tr>
        <tr>
          <td colspan="4"><label>
              <div align="center">
                <input type="submit" name="Submit" value="修改" />
              </div>
            </label>
          </td>
        </tr>
      </table>
	</form>
	<center><%=message%></center></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 + -