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")+"'>&nbsp</input>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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 + -
显示快捷键?