📄 deletebook.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" />
<link href="myCss.css" rel="stylesheet" type="text/css" />
<%request.setCharacterEncoding("gb2312"); %>
<%@page import="java.sql.*" %>
<jsp:useBean id="alogin" class="login.jdbcBean" scope="page"/>
<title>无标题文档</title>
</head>
<%
String submit=request.getParameter("Submit");
String sql=null;
if(submit==null){sql="select * from books where typeID = '1'";}
if(submit!=null){
String search=request.getParameter("textfield");
String type=request.getParameter("select");
if(type.equals("9")){sql="select * from books where bookName like '%"+search+"%'";}
else{
if(search.equals("")){sql="select * from books where typeID = '"+type+"'";}
else{sql="select * from books where typeID = '"+type+"' and bookName like '%"+search+"%' ";}
String value[]=request.getParameterValues("checkbox");
if(value!=null){
for(int i=0;i<value.length;i++){
alogin.executeUpdate("delete from books where bookID = '"+value[i]+"'");
%>
<script language="javascript">
alert("已从数据库中删除");
</script>
<%}}}} %>
<body class="myCss">
<table width="696" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutDefaultTable-->
<tr>
<td width="96" height="30"> </td>
<td width="600"> </td>
</tr>
<tr>
<td height="600"> </td>
<td valign="top"><form id="form1" name="form1" method="post" action="/bookstore/admin/deleteBook.jsp">
<p><label>
<span class="STYLE7">
<span class="STYLE8">请输入查询内容</span>
<input name="textfield" type="text" class="myCss" size="15" />
</span></label>
<span class="STYLE7">
<label><span class="myCss">分类
<span class="STYLE8">
<select name="select" class="myCss">
<option value="1" selected="selected">程序设计</option>
<option value="2">数据库开发</option>
<option value="3">图形图像处理</option>
<option value="4">办公自动化</option>
<option value="5">网络管理</option>
<option value="6">计算机硬件</option>
<option value="7">计算机辅助设计</option>
<option value="8">其他</option>
<option value="9">所有图书</option>
</select>
</span></span> </label>
<span class="STYLE8">
<input name="Submit" type="submit" class="myCss" value="提交" />
</span></span> </p>
<table width="600" border="1" cellspacing="0" bordercolor="#99CCFF" class="myCss">
<tr>
<td width="38" height="30"><div align="center">选定</div></td>
<td width="124" height="30"><div align="center">booName</div></td>
<td width="141" height="30"><div align="center">publisher</div></td>
<td width="62" height="30"><div align="center">price</div></td>
<td width="57" height="30"><div align="center">vipPrice</div></td>
<td width="80" height="30"><div align="center">author</div></td>
<td width="52" height="30"><div align="center">pageNum</div></td>
</tr>
<%
ResultSet rs=alogin.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><div align="center">
<input type="checkbox" name="checkbox" value=<%=rs.getString("bookID")%> />
</div></td>
<td><div align="center"><%=rs.getString("bookName")%></div></td>
<td><div align="center"><%=rs.getString("publisher")%></div></td>
<td><div align="center"><%=rs.getString("price")%></div></td>
<td><div align="center"><%=rs.getString("vipPrice")%></div></td>
<td><div align="center"><%=rs.getString("author")%></div></td>
<td><div align="center"><%=rs.getString("pagNum")%></div></td>
</tr>
<%}%>
<tr>
<td colspan="7"><p> </p>
<p> <input name="Submit" type="submit" class="myCss" value="提交" />
<input name="Submit2" type="reset" class="myCss" value="重置" />
</p></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="340"> </td>
<td> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -