📄 showmain.jsp

📁 里面包含了一个网上书店要的大致的文件。主要是现实前台的jsp页面。
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="com.iss.bean.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="com.iss.dataBase.*"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
	<head>

		<title>showBooks</title>
	</head>
	<body>

		<%--
    This example uses JSTL, uncomment the taglib directive above.
    To test, display the page like this: index.jsp?sayHello=true&name=Murphy
    --%>
		<%--
    <c:if test="${param.sayHello}">
        <!-- Let's welcome the user ${param.name} -->
        Hello ${param.name}!
    </c:if>
    --%>

		<%!public String codeToString(String str) {
		String s = str;
		try {
			byte tempB[] = s.getBytes("gb2312");
			s = new String(tempB);
			return s;
		} catch (Exception e) {
			return s;
		}
	}%>
		<jsp:useBean id="datapagebean" class="com.iss.bean.dataPageBean"
			scope="session" />
		<%
			Statement stmt = SQLParser.getInstance().getStmt();
			String sql = "select * from book ";
			ResultSet rs = stmt.executeQuery(sql);
			String pages = request.getParameter("dipage");
			rs.last();
			int countRecord = rs.getRow();
			int countPageRecord = 10;
			if (pages == null || (pages.trim()).length() == 0)
				datapagebean.setAll(countRecord, countPageRecord);
			else {
				try {
					datapagebean.setCurrentPage(Integer.parseInt(pages));
				} catch (Exception e) {
					out.println(codeToString("参数不正确"));
				}
			}

			int currentRecord = (datapagebean.getCurrentPage() - 1)
					* (datapagebean).getsizePage();
			if (currentRecord == 0)
				(rs).beforeFirst();
			else
				(rs).absolute(currentRecord);
			out.print("<Table>");
			int i = 0;
			while ((rs).next()) {
				out.print("<TR>");
				out.print("<TD>" + "<img src=" + "'" + rs.getString("pass")
				+ "'" + "</TD>");
				out.print("<TD>" + rs.getString("description") + "</TD>");
				out.print("<TD>");

				// Integer temp=Integer.parseInt(rs.getInt("quantity"));
				int temp = 1;
				if (temp > 0)
					out.print(codeToString("有货"));
				else
					out.print(codeToString("没有货"));
				out.print("</TD>");
				out.print("<TD>");
				out.print("<form action=\"fdafda\" method=\"post\">");
				out.print("<input type='submit' name='submit' value='");
				out.print(rs.getString("ISBN") + "'>");
				out.print("</form>");
				out.print("</TD>");
				out.print("</TR>");
				i++;
				if (i >= (datapagebean).getsizePage())
					break;
			}
			out.print("<TR><td>");
			out.print(codeToString("共 ") + (datapagebean).getCountRecord()
					+ codeToString("条记录 ,共") + (datapagebean).getCountPage()
					+ codeToString("页,当前第") + (datapagebean).getCountPage()
					+ codeToString("页，每页") + (datapagebean).getsizePage()
					+ codeToString("条记录"));
			if ((datapagebean).getCountPage() != 1) {
				out.print("<a href=showMain.jsp?dipage=1>" + codeToString("首页")
				+ "</a>,");
				out.print("<a href=showMain.jsp?dipage="
				+ ((datapagebean).getCountPage() - 1) + ">"
				+ codeToString("上一页") + "</a>,");

			}
			if ((datapagebean).getCountPage() == (datapagebean)
					.getCurrentPage()) {
			} else {
				out.print("<a href=showMain.jsp?dipage="
				+ ((datapagebean).getCurrentPage() + 1) + ">"
				+ codeToString("下一页") + "</a>,");
				out.print("<a href=showMain.jsp?dipage="
				+ ((datapagebean).getCountPage() - 1) + ">"
				+ codeToString("末页") + "</a>,");

			}
			out.print("</TD></tr>");
			out.print("</Table>");
		%>
	</body>
</html>
⌨️ 快捷键说明

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