showselectbooks.jsp
来自「里面包含了一个网上书店要的大致的文件。主要是现实前台的jsp页面。」· JSP 代码 · 共 137 行
JSP
137 行
<%@ 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">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'showSelectBooks.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>
<%!
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;
}
}
%>
<body>
<jsp:useBean id="datapagebean" class="com.iss.bean.dataPageBean" scope="session"/>
<%
Statement stmt=SQLParser.getInstance().getStmt();
String sql=(String) session.getAttribute("sql");
if(sql.equals("have"))
{
String target=request.getParameter("target");
String method=request.getParameter("method1");
sql="select * from book where title like '%"+target.trim()+"%'";
if(method.equals("title"))
{
sql="select * from book where title like '%"+target.trim()+"%'";
}
if(method.equals("publisher")){
sql="select * from book where publishername like '%"+target.trim()+"%'";}
if(method.equals("author")){
sql="select * from book where author like '%"+target.trim()+"%'";}
session.setAttribute("sql",sql);
}
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("path")+"\""+"</TD>");
out.print("<TD align='left'>title :"+rs.getString("title")+"</TD>");
// Integer temp=Integer.parseInt(rs.getInt("quantity"));
out.print(" <TD align='right'>price :"+rs.getString("price")+"</TD>");
out.print("<TD align='right'>");
out.print("<form action='showdetail.jsp' method='post'>");
out.print("<input type='hidden'name='ISBN' value='"+rs.getString("isbn")+"'> </input> <input type='submit' value='detail'></input>");
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).getCurrentPage()+codeToString("页,当前第")+(datapagebean).getCountPage()+codeToString("页,每页")+(datapagebean).getsizePage()+codeToString("条记录"));
if((datapagebean).getCurrentPage()!=1)
{
out.print("<a href=showSelectBooks.jsp?dipage=1>"+codeToString("首页")+"</a>,");
out.print("<a href=showSelectBooks.jsp?dipage="+((datapagebean).getCurrentPage()-1)+">"+codeToString("上一页")+"</a>,");
}
if((datapagebean).getCountPage()==(datapagebean).getCurrentPage())
{
}
else
{
out.print("<a href=showSelectBooks.jsp?dipage="+((datapagebean).getCurrentPage()+1)+">"+codeToString("下一页")+"</a>,");
out.print("<a href=showSelectBooks.jsp?dipage="+((datapagebean).getCountPage())+">"+codeToString("末页")+"</a>,");
}
out.print("</TD></tr>");
out.print("</Table>");
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?