📄 showbypage.jsp

📁 可以让初学者有一个感性的认识

💻 JSP

字号:

<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=white><Font size=3>
<%!	int pageSize=3;
	int pageCount=0;
%>

<FORM action="" method=get>
输入页码数：
	<INPUT type="text" name="showPage" size=4>
	<INPUT type="submit" value="提交" name="g">
</FORM>

<%		
	Connection con;
	Statement sql;
	ResultSet rs;

	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException e){}
	try
	{
		con=DriverManager.getConnection("jdbc:odbc:sun","","");
		sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
		rs=sql.executeQuery("SELECT * FROM students" );
		rs.last();
		int lastRow=rs.getRow();
		pageCount=(lastRow%pageSize==0)?(lastRow/pageSize):(lastRow/pageSize+1);
		int showPage=1;
%>

<P>共有<%=pageCount%>页
<P>每页显示<%=pageSize%>条记录

<%		String integer=request.getParameter("showPage");
		if(integer ==null) integer ="1";
		try
		{
			showPage=Integer.parseInt(integer);
		}catch(NumberFormatException e) {showPage=1;}
		if(showPage<=1)
			showPage=1;
		if(showPage>=pageCount)
			showPage=pageCount;
%>

<BR>目前显示第<%=showPage%>页

<%
		int position=(showPage-1)*pageSize+1;
		rs.absolute(position);
		out.print("<Table Border>");
			out.print("<TR>");
				out.print("<TH width=100>"+"学号");
				out.print("<TH width=100>"+"姓名");
				out.print("<TH width=50>" +"数学成绩");
				out.print("<TH width=50>" +"英语成绩");
				out.print("<TH width=50>" +"物理成绩");
			out.print("</TR>");
			for(int i=1;i<=pageSize;i++)
			{
				out.print("<TR>");
					out.print("<TD>"+ rs.getString(1)+"</TD>");
					out.print("<TD>"+ rs.getString(2)+"</TD>");
					out.print("<TD>"+ rs.getInt("数学成绩")+"</TD>");
					out.print("<TD>"+ rs.getInt("英语成绩")+"</TD>");
					out.print("<TD>"+ rs.getInt("物理成绩")+"</TD>");
				out.print("</TR>");
				rs.next();
			}
		out.print("</Table>");
		con.close();
	}catch(SQLException e2){}
%>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -