|
<%
int pageSize = 5;
int newsSize;
int allPage;
int currentPage;
int newsPage;
java.lang.String strPage;
strPage = request.getParameter("page");
if(strPage==null || strPage=="" || strPage.equals("")){
currentPage = 1;
}
else{//将字符串转换成整型
currentPage = java.lang.Integer.parseInt(strPage);
if(currentPage<1) currentPage = 1;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:ele","sa","sa");
Statement stmt= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs= stmt.executeQuery("SELECT markettitle,marketid FROM market order by marketid DESC ");
rs.last();
newsSize = rs.getRow();
allPage = (newsSize+pageSize-1) / pageSize;
if(currentPage>allPage) currentPage = allPage;
rs.absolute((currentPage-1) * pageSize + 1);
//显示数据
int i = 0;
String markettitle,marketid;
while(i
<%
rs.next();
i++;
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
|