📄 bookdel0.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>删除图书</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<style type="text/css">
<!--
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.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;
Date pbdate = null;
Float price = null;
String message = "";
String bookid = null;
java.sql.ResultSet rs = null;
%>
<%
request.setCharacterEncoding("GB2312");
bookid = (String) session.getAttribute("bookid");
//out.println(bookid);
type = request.getParameter("type");
if (type == null)
type = "";
if (bookid != null) {
sql = "select * from book where bookid='" + bookid + "'";
//out.println(sql);
try {
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();
message = "该记录已被删除!";
}
if (type.equals("delete")) {
sql = "delete from book where bookid='" + bookid + "'";
//out.println(sql);
try {
int i = myRs.executeUpdate(sql);
message = "记录被成功删除!";
} catch (Exception e) {
e.printStackTrace();
message = "删除失败!";
} finally {
myRs.close();
}
}
}
if (bookid == null)
bookid = "";
if (bookname == null)
bookname = "";
if (auther == null)
auther = "";
if (publisher == null)
publisher = "";
if (pbdate == null)
pbdate = new Date();
if (price == null)
price = Float.valueOf("0");
if (detail == null)
detail = "";
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" height="300" border="0"
background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" height="160" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookInfo.jsp">图书信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookQuery.jsp">书号查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookQuery.jsp">书名查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookAdd.jsp">增加图书</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookDel.jsp">删除图书</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookMod.jsp">修改图书</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<form name="form1" method="post"
action="BookDel.jsp?type=delete">
<table width="100%" border="1">
<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>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -