jsp+java bean+mysql数据库进行分页显示

JAVA天地

浏览: 674109 次
性别:
来自: 太原

最近访客更多访客>>

yxjajl

jacket233

daimashun

anliguo131

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (715)

社区版块

存档分类

Bean JSP Java MySQL SQL

原来没有写过，听朋友说，比较难，就试一下，还是挺简单的，只不过，具体实用方面还得自己写，没有什么难的，自己看看就懂了。

bean文件：

package bean;
/**
* jsp+java bean+mysql数据库进行分页显示
* 这里连接的数据库是MYSQL
* 表的情况是test数据库中的test表，建表用语句create table test(id int,name char(50),age int)
* 用所得的结果进行分页显示
*/
import java.sql.*;
import java.util.Vector;

public class Conn {
/**
* 生成数据库连接
* @return
*/
public int resultPage;//用于取得最后是第几页的内容，因为给的要显示的页可能大于所有的页数，这时就要调整.
public int totalPage;
public Connection getConn()
{
Connection C=null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
C= DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=admin&useUnicode=true&characterEncoding=8859_1");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return C;
}
public void doDel(int ID)
{
Connection con=getConn();
try {
Statement st=con.createStatement();
st.execute("delete from test where id="+ID);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
/**
* 根据查询条件，将查询结果以Vector的形式返回
* @param pageSize 每页显示的记录条数
* @param currentPage 当前是第几页
* @param sql sql查询语句
* @return
*/
public Vector getResult(int pageSize,int currentPage,String sql)
{
int rowNum=0;
int page=0;
int beginRow=0;
Vector resultRows=new Vector();
try{
Statement st=getConn().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery(sql);
rs.last();
rowNum=rs.getRow();
if(rowNum%pageSize==0)
{
page=rowNum/pageSize;
}
else
page=rowNum/pageSize+1;
if(currentPage>page)
{
currentPage=page;
}
if(currentPage<1)
{
currentPage=1;
}
resultPage=currentPage;
totalPage=page;
beginRow=(currentPage-1)*pageSize+1;
//System.out.println("beginRow:"+beginRow);
rs.absolute(beginRow);
int i=1;
while(!rs.isAfterLast() && i<=pageSize)
{
Vector v=new Vector();
v.add(rs.getInt(1));
v.add(rs.getString(2));
v.add(rs.getInt(3));
resultRows.add(v);
i++;
rs.next();
}
//System.out.println("PageSize:"+pageSize);
//System.out.println("Total Page:"+page);
}
catch(Exception e)
{
e.printStackTrace();
}
return resultRows;
}
public static void main(String[] arg)
{
Conn c=new Conn();
Vector vector=c.getResult(5,2,"select * from test");
for(int i=0;i<vector.size();i++)
{
Vector v=new Vector();
v=(Vector)vector.elementAt(i);
//System.out.print(v.elementAt(0)+" ");
//System.out.print(v.elementAt(1)+" ");
//System.out.println(v.elementAt(2));
}
//System.out.println(Integer.parseInt(""));
}
}

JSP测试文件：

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<jsp:useBean id="xxx" scope="session" class="bean.Conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'index.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
This is my JSP page. <br>
<%
String request_page_s=request.getParameter("page");
int request_page;
int pageSize=3;
try{
if(request_page_s.length()==0)
request_page=1;
else
request_page=Integer.parseInt(request_page_s);
}
catch(Exception e)
{
request_page=1;
}
Vector vector=xxx.getResult(pageSize,request_page,"select * from test");
for(int i=0;i<vector.size();i++)
{
Vector v=(Vector)vector.elementAt(i);
out.print(v.elementAt(0)+" ");
out.print(v.elementAt(1)+" ");
out.print(v.elementAt(2)+"<br>");
}
out.print("<a href=index.jsp?page=1>首页</a> ");
int p_page=0;
int n_page=0;
if(xxx.resultPage==1)
p_page=1;
else
p_page=xxx.resultPage-1;
if(xxx.resultPage==xxx.totalPage)
n_page=xxx.resultPage;
else
n_page=xxx.resultPage+1;
out.print("<a href=index.jsp?page="+p_page+">上页</a> ");
out.print("<a href=index.jsp?page="+n_page+">下页</a> ");
out.print("<a href=index.jsp?page="+xxx.totalPage+">末页</a> ");
%>
<br>
</body>
</html>