📄 m_search.jsp

📁 留学生信息管理系统我的工程实习的项目
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<jsp:directive.page import="news.sql_data"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<jsp:directive.page import="com.sun.corba.se.impl.protocol.RequestCanceledException"/>
<%
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 'M_add.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>
  <jsp:useBean id="db" scope="session" class="news.sql_data"/>
  <jsp:useBean id="PageCt" scope="session" class="util.PageCt"/>
  <link rel="stylesheet" href="m_style.css" type="text/css">
  <body>
  <script>
function openWindow1(url){
   window.open(url,'','width=750 height=400 top=200 left=180 scrollbars=yes');
}

</script>
    <%	request.setCharacterEncoding("gb2312");
    	String cnname=request.getParameter("keyword");
          
    	String mysql="select * from news_table where cnname='"+cnname+"'";
    	ResultSet rs=db.executeQuery(mysql);   	
    	rs.last();
    	  //实现分页参数设置
    	long data_num=rs.getRow();	
    	rs.beforeFirst();
    	long Current_Page = 0;
		String currentpage=(String)request.getParameter("currentpage");
		if (currentpage != null && !currentpage.equals(""))
		{
			Current_Page = Integer.parseInt(request.getParameter("currentpage"));
		}
			String Query_Page=(String)request.getParameter("Query_Page");
		if (Query_Page!=null && !Query_Page.equals(""))
		{
			Current_Page = Integer.parseInt(request.getParameter("Query_Page"))-1;
		}
		PageCt.Init(Current_Page,data_num);
		long l_start = PageCt.getStart();
		long l_end = PageCt.getEnd();    
		long i=0; 
    	while((i<l_start) && rs.next())//用来控制一页中要显示的数据
		{
			i++;
		}
     %>
     <form >
 		  <table 	border="1" align="center"  >
											
                	<tr><td align="center" colspan="8">查询结果</td></tr>
                	<tr>
  						<th>数据id</th><th>序号</th><th>中文姓名</th><th>用户密码</th><th>曾用外文名</th><th>性别</th><th>出生日期</th><th>其他信息</th>
  					</tr>

                <%        
             try{   
              while(rs.next()&& (i<l_end) ){     
           String   dataid=rs.getString(1);      	
                  %> 
 		 <tr>
 		 
  			<td><%=dataid%></td>
 			<td><%=rs.getString(2)%></td> 
 			<td><%=rs.getString(3)%></td> 
  			<td><%=rs.getString(4)%></td>
  			<td><%=rs.getString(5)%></td>
  			<td><%=rs.getString(6)%></td>
  			<td><%=rs.getString(7)%></td>
  			<td><a href="manager/M_search2.jsp?dataid=<%=dataid%>">allinfo

  			 </td>
  			

  		</tr>
  		<tr>		
				<td colspan="8" align="center">共记 <%=PageCt.getTotalnum()%> 条信息&nbsp;&nbsp;&nbsp;
				<%=PageCt.getCurpage()+1%>/<%=PageCt.getTotalpage()%> 页&nbsp;&nbsp;&nbsp;
				查看第 <input type=text name=Query_Page size=3>页
				<input type="submit"  value="确定"  >  &nbsp;&nbsp;&nbsp;&nbsp;
				<a href=manager/M_showinfo.jsp?currentpage=<%=PageCt.getPrepage()%>>上页</a>&nbsp;
				<a href=manager/M_showinfo.jsp?currentpage=<%=PageCt.getNextpage()%>>下页</a>
				</td>	
					

		</tr>
			<%}
			
			rs.close();
		db.closeStmt();
		db.closeConn();
           }catch(Exception exc1){
           
				out.println("在执行数据库访问时发生了错误！");
				exc1.printStackTrace();
				}                           
            
         %>  
        
         </table>
     </form>
  
    
    
  </body>
</html>
⌨️ 快捷键说明

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