📄 m_showinfo.jsp

📁 留学生信息管理系统我的工程实习的项目
💻 JSP
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<jsp:directive.page import="util.PageCt"/>

<%
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_showinfo.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>
  <%
  //实现分页参数设置
  ResultSet rs0 = db.executeQuery("select count(*) from news_table ");
rs0.next();
long data_num=rs0.getLong(1);
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; 
                  
  		

  		ResultSet rs=db.executeQuery("select * from news_table");   
  		while((i<l_start) && rs.next())//用来控制一页中要显示的数据
				{
					i++;
				}
               
   %>
   <form >
   <table 	border="1" align="center"  >

                	<tr><td align="center" colspan="9">成员列表</td></tr>
                	<tr>
  						<th>数据id</th><th>序号</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_modify.jsp?dataid=<%=dataid%>" target=_self >修改/
  			 <a href="manager/M_del.jsp?dataid=<%=dataid%>" target=_self  >删除
  			 </td>
  			<td><a href="manager/M_selfone_allinfo.jsp?dataid=<%=dataid%>"  >所有信息

  		</tr>
			<%
				i++;
			}
			
			//if(PageCt.getTotalpage()>1){//控制是否显示分页栏
			%>
			<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 + -