📄 clean.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'clean.jsp' starting page</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">
	-->

  </head>
  
  <body>
   
    <%  
          String url="jdbc:mysql://localhost:3306/bookstore";
	      Class.forName("com.mysql.jdbc.Driver");
	      String username="root";
	      String password="ptnest";
	      Connection con=DriverManager.getConnection(url,username,password);
	      Statement stmt =  con.createStatement();
	      String sql="select * from book where storenum<=0";
	      ResultSet rs = stmt.executeQuery(sql);
	      
	 %>
	 
	 <table border="0" width="80%" cellspacing="0" cellpadding="0" align="center">
			<tr>
				<td width="100%" height="30" bgcolor="#3399ff"align="center">&nbsp;<font
					color="#ffffff">以下是书店已售完的书，请选择清除:</font></td>
			</tr>
			<tr></tr><tr></tr><tr></tr>
	</table>
	
		<%
			out.println("<table width='80%' align='center' bgcolor=#3399ff>");
			out.println("<tr>");
			out.println("<td width='100'><b>新书名称</b></td>");
			out.println("<td width='100'><b>出版社</b></td>");
			out.println("<td width='100'><b>库存</b></td>");
			out.println("<td width='100'><b>精品推荐</b></td>");
			out.println("<td width='100'><b>书的描述</b></td>");
			out.println("<td width='100'><b>详细描述</b></td>");
			out.println("</tr>");
			out.println("</table>");
			int searchnum = 0;
			while (rs.next()) {
				String name, publish_name, content;
				int storenum, commend, id, BN;
				name = new String(rs.getString("name").getBytes("gb2312"),"8859_1");
				publish_name = new String(rs.getString("publish_name").getBytes("gb2312"), "8859_1");
				storenum = rs.getInt("storenum");
				content = new String(rs.getString("content").getBytes("gb2312"), "8859_1");
				commend = rs.getInt("commend");
				id = rs.getInt("id");

				//输出
				out.println("<table width='80%' align='center'>");
				out.println("<tr>");
				out.println("<td width='10%' align='center'>" + name + "</td>");
				out.println("<td width='20%' align='center'>" + publish_name + "</td>");
				if (storenum > 0) {
					out.println("<td width='10%' align='center'>有</td>");
				} else {
					out.println("<td width='10%' align='center'>无</td>");
				}
				if (commend == 1) {
					out.println("<td width='30%' align='center'>精品</td>");
				} else
					out.println("<td width='30%' align='center'>非精品</td>");
				out.println("<td width='10%' align='left'>" + content + "</td>");
				out.println("<td width='20%' align='center'>");
				out.println("<a href=/bookstore/admin/deletebook.jsp?BN="+id+">[删除]</a></td>");
				out.println("<td width='100' align='center'>");
				out.println("</tr>");
				//out.println("<br>");
				searchnum++;
			}
			rs.close();
			out.println("<br>");
			out.println("<table width='770' align='center'>");
			out.println("<tr>");
			out.println("<td>");
			out.println("共搜索到<b><font color=red>" + searchnum
					+ "</font></b>条记录");
			out.println("</td>");
			out.println("</tr>");
			out.println("</table>");
			
			out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/index.jsp>点击此处返回上级目录</a></font></div>");
			//out.println("</table>");
		%>
  </body>
</html>
⌨️ 快捷键说明

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