📄 showlist.jsp

📁 这套JSP学习资料
💻 JSP
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<%@page import="PageNumber" %>

<jsp:useBean id="handlePage" class="PageNumber" scope="session">
</jsp:useBean>

<BODY bgcolor=white><Font size=3>
<%!	Connection con=null;

	public void showList(ResultSet rs,javax.servlet.jsp.JspWriter out,int n)
	{
		try
		{
			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<=n;i++)
			{
				out.print("<TR>");
					String number=rs.getString(1);
					out.print("<TD>"+number+"</TD>");
					String name=rs.getString(2);
					out.print("<TD>"+name+"</TD>");
					int math=rs.getInt("数学成绩");
					out.print("<TD>"+math+"</TD>");
					int english=rs.getInt("英语成绩");
					out.print("<TD>"+english+"</TD>");
					int physics=rs.getInt("物理成绩");
					out.print("<TD>"+physics+"</TD>");
				out.print("</TR>");
				rs.next();
			}
			out.print("</Table>");
		}catch(Exception e1){}
	}
%>

<%		
	Statement sql=null;
	ResultSet rs=null;
	int rowCount=0;
	if(con==null)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){out.print(e);}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
			sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
			rs=sql.executeQuery("SELECT * FROM students");
			rs.last();
			int number=rs.getRow();
			rowCount=number;
			handlePage.setPageSize(2);
			handlePage.setPageCount(rowCount,handlePage.getPageSize());
			out.print("共有"+handlePage.getPageCount()+"页,");
			out.print("每页显示"+handlePage.getPageSize()+"条记录");
		} catch(SQLException e){ out.print(e);}
	}
	else
	{
		synchronized(con)
		{
			try
			{
				sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
				rs=sql.executeQuery("SELECT * FROM students");
				rs.last();
				int number=rs.getRow();
				rowCount=number;
				handlePage.setPageSize(2);
				handlePage.setPageCount(rowCount,handlePage.getPageSize());
				out.print("共有"+handlePage.getPageCount()+"页,");
				out.print("每页显示"+handlePage.getPageSize()+"条记录");
			} catch(SQLException e){ out.print(e);}
		}
	}
%>

<%	String str=response.encodeRedirectURL("showList.jsp");
%>

<FORM action="<%=str%>" method=post>
	显示下一页：<INPUT type="hidden" name="a" value="next">
	<INPUT type="submit" value="next" >
</FORM>

<FORM action="<%=str%>" method=post>
	显示上一页：<INPUT type="hidden" name="a" value="previous">
	<INPUT type="submit" value="previous" >
</FORM>

<FORM action="<%=str%>" method=post>
	输入欲要显示的页：<INPUT type="text" name="a" value="1">
	<INPUT type="submit" value="submit" >
</FORM>

<%	String s=request.getParameter("a");
	if(s==null)s="1";
	if(s.equals("next"))
	{
		int n=handlePage.getShowPage();
		n=n+1;
		if(n> handlePage.getPageCount())n=1;
		handlePage.setShowPage(n);
		out.print("目前显示第"+handlePage.getShowPage()+"页");
		rs.absolute((n-1)*handlePage.getPageSize()+1);
		showList(rs,out,handlePage.getPageSize());
	}
	else if(s.equals("previous"))
	{
		int n=handlePage.getShowPage();
		n=n-1;
		if(n<=0)n=handlePage.getPageCount();
		handlePage.setShowPage(n);
		out.print("目前显示第"+handlePage.getShowPage()+"页");
		rs.absolute((n-1)*handlePage.getPageSize()+1);
		showList(rs,out,handlePage.getPageSize());
	}

	else
	{
		int m=Integer.parseInt(s);
		handlePage.setShowPage(m);
		out.print("目前显示第"+handlePage.getShowPage()+"页");
		int n= handlePage.getShowPage();
		rs.absolute((n-1)*handlePage.getPageSize()+1);
		showList(rs,out,handlePage.getPageSize());
	}
%>

</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明

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