📄 list.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*"
	pageEncoding="gb2312"%>
<%
request.setCharacterEncoding("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>图书列表</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">
	-->

	<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body,td,th {
	font-family: 仿宋_GB2312;
	font-size: 18px;
	color: #006633;
}
.style1 {
	color: #FF0000;
	font-size: 29px;
	font-family: "华文隶书";
}
a:link {
	color: #CC0000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
-->
    </style></head>

	<body>
		<table width="770" border="0" align="center">
			<tr>
				<td>
                  <div align="center"><img src="img/2.gif" width="706" height="25"> </div></td>
			</tr>
			<tr>
			  <td><div align="center" class="style1">图书列表</div></td>
		  </tr>
		</table>
		<%
			String keyword = request.getParameter("keyword");
			String way = request.getParameter("way");
			String sql ="select *from book";
			Class.forName("com.mysql.jdbc.Driver");
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String dburl = "jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
			String user = "root";
			String pass = "ptnest";
			Connection con;
			con = java.sql.DriverManager.getConnection(dburl, user, pass);
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
		%>
		<div align="center">
		</div>
		<br>
		<%
			out.println("<table width='800' align='center' bgcolor=#FFC0CB>");
			out.println("<tr>");
			out.println("<td width='100'><b>书名</b></td>");
			out.println("<td width='100'><b>出版社</b></td>");
			out.println("<td width='60'><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, bookid, BN;
				name = new String(rs.getString("name").getBytes("iso8859_1"),"gb2312");
				publish_name = new String(rs.getString("publish_name").getBytes("iso8859_1"), "gb2312");
				storenum = rs.getInt("storenum");
				content = new String(rs.getString("content").getBytes("iso8859_1"), "gb2312");
				commend = rs.getInt("commend");
				bookid = rs.getInt("id");

				//输出
				out.println("<table width='800' align='center' bgcolor=fedcbd cellpadding=1>");
				out.println("<tr>");
				out.println("<td width='100'>" + name + "</td>");
				out.println("<td width='100'>" + publish_name + "</td>");
				if (storenum > 0) {
					out.println("<td width='60'>有</td>");
				} else {
					out.println("<td width='60'>无</td>");
				}
				if (commend == 1) {
					out.println("<td width='100'>精品</td>");
				} else
					out.println("<td width='100'>非精品</td>");
				out.println("<td width='100'>" + content + "</td>");
				out.println("<td width='100'>");
				out.println("<a href=files/imformation.jsp?BN=" + bookid
				+ " target=_blank>[察看]</a></td>");
				out.println("<td width='100'>");
				out.println("<a href=files/shopcart.jsp?CN=" + name
				+ " target=_blank>加入</a></td>");
				out.println("</tr>");
				out.println("</table>");
				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>");
		%>
		<p align="center"></p>
</body>
</html>
⌨️ 快捷键说明

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