📄 searchbookresult.jsp

📁 学习jsp时做的一个书馆
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>    
<%@ page import="java.sql.* ,java.util.Vector;"%> 
<%
if(session.getAttribute("adlogin")!=null){
    String adlogin = (String)session.getAttribute("adlogin");
    if(!adlogin.equals("yes")){
        response.sendRedirect("./login.jsp?errMsg=weidenglu" );
    }
}else{
    response.sendRedirect("./login.jsp?errMsg=weidenglu" );
}
%>
<%String ErrMeg2 = request.getParameter("jieguo3");
String id2= request.getParameter("id1");
if(ErrMeg2==null){
	ErrMeg2 = " ";
}else if(ErrMeg2.equals("success")){
	ErrMeg2 = "书籍"+id2+"删除成功";
}else if(ErrMeg2.equals("failed1")){
	ErrMeg2 = "书籍"+id2+"还没归还，删除失败";
}%>
<%String ErrMeg = request.getParameter("jieguo");
String id1= request.getParameter("id");
    if(ErrMeg==null){
    	ErrMeg = " ";
    }else if(ErrMeg.equals("failed1")){
    	ErrMeg = "用户"+id1+"删除失败"+"原因是该用户没交罚款请在详细信息里查看";
    }else if(ErrMeg.equals("failed2")){
    	ErrMeg = "用户"+id1+"删除失败"+"原因是该用户还有书没还请在详细信息里查看";
    }else if(ErrMeg.equals("failed3")){
    	ErrMeg = "用户"+id1+"删除失败"+"原因是该用户还有书没还且没交罚款请在详细信息里查看";
    }
    String ErrMeg1 = request.getParameter("jieguo2");
    if(ErrMeg1==null){
    	ErrMeg1 = " ";
    }else{
    	ErrMeg1 = "书籍更新成功";
    }
%>
<html>
<head><title>搜索结果</title></head>
<body>
 <br>
     <h1><blockquote><font color= red><%=ErrMeg1 %></font></blockquote></h1>
     <h1><blockquote><font color= red><%=ErrMeg2 %></font></blockquote></h1>
   <h1><blockquote>所有符合您查询条件的信息如下</blockquote></h1>
    <h1><blockquote><font color= red><%=ErrMeg %></font></blockquote></h1>
    <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("rdsearchbookresult");
     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><td><a href= ./changebook.jsp?id=<%=findid %>>修改书籍</a></td></tr>
              <%} %>
              <tr><td><a href = ./searchBook.jsp>返回</a></td></tr>
              </table>
</body>
</html>
⌨️ 快捷键说明

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