请高手来帮忙啊,关于JSP读数据库的内容分页,就是读内容然后按每页200个字来分页.
请问怎么来做到,我是刚学做JSP的什么也不懂.
希望高手给一个简单的代码指教.
就如下面读wuert数据库里content的数据内容按每页500个字来分页显示
<%
String id = request.getParameter("id");
String sql_piclist="select content from wuert where id=? order by id DESC";
pst = conn.prepareStatement(sql_piclist,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
pst.setString(1,id);
rs = pst.executeQuery();
if(rs.next()) {
String content=rs.getString("content");
}
rs.next();
rs.close();
pst.close();
conn.close();
%>
<%=content%>
请问怎么来做到,我是刚学做JSP的什么也不懂.
希望高手给一个简单的代码指教.
就如下面读wuert数据库里content的数据内容按每页500个字来分页显示
<%
String id = request.getParameter("id");
String sql_piclist="select content from wuert where id=? order by id DESC";
pst = conn.prepareStatement(sql_piclist,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
pst.setString(1,id);
rs = pst.executeQuery();
if(rs.next()) {
String content=rs.getString("content");
}
rs.next();
rs.close();
pst.close();
conn.close();
%>
<%=content%>
startRow = (currentPage - 1) * pageCounts
endRow = startRow + pageCounts 或者==totalCounts
if(totalCounts % pageCounts > 0)
{
totalPage = totalPage++;
}