📄 readsearchresult.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 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");
String id2= request.getParameter("id1");
    if(ErrMeg1==null){
    	ErrMeg1 = " ";
    }else if(ErrMeg1.equals("success")){
    	ErrMeg1 = "用户"+id2+"数据修改成功";
    }
%>
<html>
<head><title>搜索结果</title></head>
<body>
 <br>
   <h1><blockquote>所有符合您查询条件的信息如下</blockquote></h1>
    <h1><blockquote><font color= red><%=ErrMeg %></font></blockquote></h1>
    <h1><blockquote><font color= red><%=ErrMeg1 %></font></blockquote></h1>
   <br>
     <table border="0" width = 500 height = 300 Align = "left">
       <tr><th align = left>卡号</th><th align = left>姓名</th><th align = left>学号</th><th align = left>学院</th><th align = left>专业</th></tr>

       <%
     Vector w = (Vector)session.getAttribute("rdsearchresult");
     String name = "";
     String stuno = "";
     String  xueyuan = "";
     String zhuanye = "";
%>
<% for(int i =0;i<w.size();i++){
             String id = (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 reader where readerid ='"+id+"'";
             ResultSet rs=stmt.executeQuery(query);
             while(rs.next())
             {
                     name=rs.getString("name");
                     stuno = rs.getString("stuno");
                     xueyuan = rs.getString("xueyuan");
                     zhuanye = rs.getString("zhuanye");
             }
       %>
        <tr><td><%=id %></td><td><%=name %></td><td><%=stuno %></td>
    	    <td><%=xueyuan %></td><td><%=zhuanye %></td><td><a href = ./readerdetail.jsp?id=<%=id %>>详细信息</a></td></tr>
              <%} %>
              <tr><td><a href = ./searchreader.jsp>返回</a></td></tr>
              </table>
</body>
</html>
⌨️ 快捷键说明

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