📄 student_admin.jsp

📁 这个是我同学做的
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page  import="java.sql.ResultSet"%>
<script Language="vbscript">
sub check()
	c=document.form1.page.value
			if c<>"" then
				if not IsNumeric(c) then
				msgbox " 页数只能输入数字"
				document.form1.page.select()
				exit sub
				else
				
				end if
			else
				msgbox"请输入想要转到页数"
				document.form1.page.select()
				exit sub
			end if
			
				document.form1.submit()
end sub
</script>

<html>
<head>
<%!String keywords ;
   String topage;
  // 设置每张网业显示30笔记录
 int pagesize=30;
 //设置预显示的页数
 int showpage=1;
 // ResultSet记录的笔数
 int rowcount =0;
 // 分页后的总页数
 int pagecount=0;
 int id;
 String str1;
 String str2;
 String bg;
 String name;
 String sql;
 String sex;
 String classs;
 String no;
 %>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>

<body topmargin="0" leftmargin="0">
<%
	request.setCharacterEncoding("GBK");
    response.setCharacterEncoding("GBK");
    topage=request.getParameter("page");
	String keyword=request.getParameter("keyword");
    if( keyword==null ){
    keywords="所有人";
	}
    else{
    keywords=keyword;
    }
 %>
<p>
<p align="center"><font class=test1>学生统计管理

</font><br>
<a href=""></a></p>
<div align="center">
  <center>
 
  <table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
  
    <form method="post" name=form2 action="student_admin.jsp">
   <tr>
     
      <td align="center" colspan="5">以下为姓名为<font color=red> <%=keywords%> </font>的学生&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
       <input type="text" name="keyword" size="20" > <input type="submit" value="查找" name="B1"></td>
   
    </tr>
</form> 
     <tr>
      <td align="center" bgcolor="#CBEFDC">编号</td>
      <td align="center" bgcolor="#CBEFDC">考生姓名</td>
      <td align="center" bgcolor="#CBEFDC">性别</td>
      <td align="center" bgcolor="#CBEFDC">班号</td>
      <td align="center" bgcolor="#CBEFDC">学号</td>
      <td align="center" bgcolor="#CBEFDC">删除</td>
    </tr>
 
<% if(keywords.equals("所有人")){
  sql="select * from student";
}else{
  sql="select * from student where name like '%"+keyword+"%'  order by id desc";
}
    DBConn db=new DBConn();
   ;
    
     ResultSet rs=db.Query(sql);
     rs.last();
     rowcount=rs.getRow();
     pagecount=((rowcount%pagesize)==0?
                        (rowcount/pagesize):(rowcount/pagesize+1));
	
	 %>
<%if(topage!=null){
   showpage=Integer.parseInt(topage);
   if(showpage>pagecount) 
   {
     showpage=pagecount;
   }
   else if(showpage<=0)
   {
     showpage=1;
   }
  
  } 
rs.absolute((showpage-1)*pagesize+1); %>

<%for(int i=1;i<=pagesize;){%>
<% if(rowcount==0){%>
<tr><td colspan=5><center><font color=red>没有你查的试题信息</font></center></td></tr>
<%break;}%> 
<% i++;
   id=rs.getInt("id");
	name=rs.getString("name"); 
	sex=rs.getString("sex"); 
	classs=rs.getString("class"); 
	no=rs.getString("no"); 
    
   if(i%2==0)
   {
   bg="#E9F8F0";
   }else{
   bg="#ffffff";
   }
  %>

	 <tr bgcolor=<%=bg%>>
      <td align="center"><%=id%></td>
      <td><%=name%></td>
      <td><%=sex%></td>
      <td><%=classs%></td>
      <td><%=no%></td>
      
      <td align="center"><a href="stuent_admin_del.jsp?id=<%=id%>">删除</a></td>
    </tr>
<%if(!rs.next()){
    break;}%>
	<%}%>

  


	


   <tr>
      <td colspan="5" align="center">
       <p align="center">
 <form action=student_admin.jsp method="post" name=form1  > 
	  	30条一页&nbsp;&nbsp; <a href="student_admin.jsp?page=1" target="right">第一页</a>
⌨️ 快捷键说明

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