⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 suoyou.jsp

📁 jsp写的学生管理系统 可以好好看看 初学者
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<html>
<body>
<font size=3>
<%   
   int pageSize=3;  
   int showPage=1;  
	 int recCount=0;  
	 int pageCount=0; 
	 	 String toPage = request.getParameter("toPage");
%>

<table width="760"  border="1" align="center" >
  <tr height="22" bgcolor="#99CCFF">
    <td width="30%" align="center">学号</td>
    <td width="10%" align="center">姓名</td>
    <td width="10%" align="center">性别</td>
    <td width="15%" align="center">专业</td>
    <td width="5%" align="center">高数</td>
    <td width="5%" align="center">C语言</td>
    <td width="5%" align="center">JAVA</td>
    <td width="5%" align="center">JSP</td>
    <td width="5%" align="center">英语</td>
  </tr>
<%
     ResultSet rs = null;
     Connection con = null;
     Statement sql = null;
     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException event){}
     try {
       con=DriverManager.getConnection("jdbc:odbc:student");
       sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
       String strSql = "select * from student";       
       rs = sql.executeQuery(strSql);     
	  
      if(rs.next()){
		     rs.last();
		     recCount=rs.getRow();
		     System.out.println("recCount="+recCount);
		     pageCount=((recCount%pageSize)==0?(recCount/pageSize):(recCount/pageSize)+1);
		     if(toPage!=null)
			       showPage=Integer.parseInt(toPage);
		     rs.absolute((showPage-1)*pageSize+1);
	   
		     for(int i=1;i<=pageSize;i++)
		     {  
			      String sno = rs.getString("sno");
                              String name = rs.getString("name");
			      String sex = rs.getString("sex");  
			      String zhuanye = rs.getString("zhuanye");
			      String  chinese = rs.getString("gaoshu");
			      String  maths = rs.getString("Cyuyan");
	          String  physics = rs.getString("JAVA");
            String  chemistry = rs.getString("JSP");
            String  chemistry = rs.getString("English");
			      out.println("<tr>");
                              out.println("<td align=center>"+sno+"</td>");
			      out.println("<td align=center>"+name+"</td>");
			      out.println("<td align=center>"+sex+"</td>");
			      out.println("<td align=center>"+zhuanye+"</td>");
			      out.println("<td align=center>"+gaoshu+"</td>");
			      out.println("<td align=center>"+Cyuyan+"</td>");
            out.println("<td align=center>"+JAVA+"</td>");
            out.println("<td align=center>"+JSP+"</td>");
             out.println("<td align=center>"+English+"</td>");
			      out.println("</tr>");      			  	   	   
                        if(!rs.next())
                           break;
                   } 
	  }
  }catch(Exception e){}
  finally{
	       rs.close();		   
		  }
%>
</table>
<br>
         
<table width="760" border="0" align="center">	 
	   <tr align="right">
	   
	   当前页<%=showPage%>/<%=pageCount%>&nbsp;&nbsp;&nbsp;&nbsp;
       <%  if(showPage!=1){ %>   <!-- 当前页非第一页 -->
	      <a href="suoyou.jsp?toPage=<%=1%>">首页</a>&nbsp;
	      <a href="suoyou.jsp?toPage=<%=showPage-1%>">上页</a>
		  
	   <%       }  %>   
	   <%  if(showPage!=pageCount){ %><!-- 当前页非最后一页 -->
	      <a href="suoyou.jsp?toPage=<%=showPage+1%>">下页</a>&nbsp;
	      <a href="suoyou.jsp?toPage=<%=pageCount%>">末页</a>
           
		<%      }  %>    
		<td></tr> 
</table>
</font>
<font size=2>
<p align=right>
<a href="tianjia.jsp">添加学生信息 </a>&nbsp;&nbsp;|&nbsp;&nbsp;
<a href="shanchu.jsp">删除学生信息</a>&nbsp;&nbsp;|&nbsp;&nbsp;
<a href="xiugai.jsp">修改学生信息</a>&nbsp;&nbsp;|&nbsp;&nbsp;
<a href="main.jsp">返回首页 >></a>
</font>
</body>
</html>

⌨️ 快捷键说明

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