📄 index.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page import="java.sql.*"%><%@page import="page.PageNumber"%><%@page import="java.io.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <jsp:useBean id="pageNum" scope="page" class="page.PageNumber" /> <%! Connection con=null; Statement sql=null; ResultSet rs=null; int rowCount=0; int pageSize=5;//每页显示的记录集数 %> <% try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:mcpage"); sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=sql.executeQuery("select * from user"); %> <% //URL String str=response.encodeRedirectURL("index.jsp"); %> <jsp:setProperty name="pageNum" property="formValue" param="formValue"/> <jsp:setProperty name="pageNum" property="rs" value="<%=rs%>"/> <jsp:setProperty name="pageNum" property="pageSize" value="<%=pageSize%>"/> <jsp:setProperty name="pageNum" property="url" value="<%=str%>"/> <jsp:getProperty name="pageNum" property="page"/> <% rs.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); out.print(e); rs.close(); con.close(); } %> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -