📄 searchbookresult.jsp

📁 学习jsp时做的一个书馆
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>    
<%@ page import="java.sql.* ,java.util.Vector;"%> 
<%String ErrMeg = request.getParameter("jieguo");
    if(ErrMeg==null){
    	ErrMeg = " ";
    }else if(ErrMeg.equals("failed1")){
    	ErrMeg = "您目前所借书中有书超过还书期限的书，请在归还相应的书籍并缴清罚款后再来借书";
    }else if(ErrMeg.equals("failed2")){
    	ErrMeg = "该书已经借出，请选择其它同类书籍";
    }else if(ErrMeg.equals("success")){
    	ErrMeg = "您已成功借阅书籍";
    }
%>
<html>
<head><title>搜索结果</title></head>
<body>
 <br>
   <h1><blockquote>所有符合您查询条件的信息如下</blockquote></h1>
   <h3><blockquote><font color= red><%=ErrMeg %></font></blockquote></h3>
   <br>
     <table border="0" width = 700 height = 300 Align = "left">
       <tr><th align = left>书名</th><th align = left>作者</th><th align = left>出版社</th><th align = left>出版时间 </th><th align = left>ISBN</th><th  align = left>在馆数量</th></tr>

<%
     Vector w = (Vector)session.getAttribute("searchbookresult");
     String findid = "";
     String name = "";
     String auther= "";
     String publisher = "";
     String publishdata = "";
     String isbn = "";
     String isinno = "";
     
%>
<% for(int i =0;i<w.size();i++){
             findid = (String)w.get(i);
             Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
             String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=gb2312" ;
             Connection conn= DriverManager.getConnection(url); 
             Statement stmt=conn.createStatement();
             String query="select * from books where isbn ='"+findid+"'";
             ResultSet rs=stmt.executeQuery(query);
             while(rs.next())
             {
                     name=rs.getString("name");
                     auther = rs.getString("auther");
                     publisher = rs.getString("publisher");
                     publishdata = rs.getString("publdata");
                     isbn =  rs.getString("isbn");
                     isinno =  rs.getString("isinno");
             }
       %>
        <tr><td><%=name %></td><td><%=auther %></td>
    	    <td><%=publisher %></td><td><%=publishdata %></td><td><%=isbn %></td><td><%=Integer.parseInt(isinno)  %></td><td><a href = ./bookdetail.jsp?id=<%=findid %> >详细信息</a></td></tr>
              <%} %>
              <tr><td><a href = ./search.jsp>返回</a></td></tr>
              </table>
</body>
</html>
⌨️ 快捷键说明

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