jsp实现mysql分页的当前页数_jsp+mysql分页实现

分页显示

人员列表

---

final String jspURL="list_person_true_spage.jsp";

%>

int lineSize = 10;//定业每页显示的记录数

int currentPage = 1; //定义当前是第几页

int pageSize = 0; //总页数=总记录数/每页显示数

int allRecorders =0;//总记录数

String keyword = null;

keyword = request.getParameter("kw");

request.setCharacterEncoding("gb2312");

try

{

currentPage = Integer.parseInt(request.getParameter("cp")) ;

}

catch(Exception e)

{}

%>

final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;

final String DBURL = "jdbc:mysql://localhost/spage" ;

final String DBUSER = "root" ;

final String DBPASSWORD = "mysql" ;

Connection conn = null ;

%>

try

{

Class.forName(DBDRIVER) ;

conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;

PreparedStatement pstmt = null ;

ResultSet rs =null;

String sql = null ;

if(keyword==null)

{

sql = "SELECT COUNT(id) from persondemo01";

}

else

{

sql = "select count(id) from persondemo01 where uid like ? or name like ?";

}

pstmt = conn.prepareStatement(sql) ;

if(keyword!=null)

{

pstmt.setString(1,"%"+keyword+"%");

pstmt.setString(2,"%"+keyword+"%");

}

rs = pstmt.executeQuery() ;

if(rs.next())

{

allRecorders = rs.getInt(1) ;

pageSize=(allRecorders)/lineSize+1;

}

rs.close() ;

pstmt.close() ;

if(keyword==null || keyword=="")

{

//假分页替换：sql = "SELECT * from persondemo01";

sql = "SELECT * from persondemo01 limit "+(currentPage-1)*lineSize+","+lineSize;

}

else

{

//假分页替换：sql = "select * from persondemo01 where uid like ? or name like ?";

sql = "select * from persondemo01 where uid like ? or name like ? limit "+(currentPage-1)*lineSize+","+lineSize;

}

pstmt = conn.prepareStatement(sql) ;

if(!(keyword==null||"".equals(keyword)))

{

pstmt.setString(1,"%"+keyword+"%");

pstmt.setString(2,"%"+keyword+"%");

}

rs = pstmt.executeQuery() ;

%>

function openPage(curpage)

{

document.spage.cp.value = curpage ;

//document.spage.cp.value=curpage;

// alert(cupage) ;

document.spage.submit() ;

}

function selOPenPage()

{

document.spage.cp.value = document.spage.selpage.value;

document.spage.submit();

}

总记录数为：

输入查询关键字："/>

/

跳转到

for(int x=1;x<=pageSize;x++)

{

%>

>

}

%>

页

编号

登陆名称

姓名

密码

操作

int i = 0 ;

/*假分页增加如下代码

for(int x=0;x

{

rs.next();

}

*/

for(int x=0;x

{

if(rs.next())

{

i++ ;

int id = rs.getInt(1) ;

String userid = rs.getString(2) ;

String name = rs.getString(3) ;

String password = rs.getString(4) ;

%>

更新删除

}

}

rs.close() ;

pstmt.close() ;

if(i==0)

{

%>

没有任何数据！！

}

%>

}

catch(Exception e)

{

%>

系统出错！！！

}

finally

{

conn.close() ;

}

%>

使用的数据库脚本如下：

-- 本分页系列程序数据库使用spage数据库

-- 删除表

drop table persondemo01;

-- 生成persondemo01表

create table persondemo01

(

id int auto_increment not null primary key,

uid varchar(32),

name varchar(32),

password varchar(20)

);

-- 插入数据

insert into persondemo01(uid,name,password) values('wjr01','王**01','530');

insert into persondemo01(uid,name,password) values('wjr02','王**02','530');

insert into persondemo01(uid,name,password) values('wjr03','王**03','530');

insert into persondemo01(uid,name,password) values('wjr04','王**04','530');

insert into persondemo01(uid,name,password) values('wjr05','王**05','530');

insert into persondemo01(uid,name,password) values('wjr06','王**06','530');

insert into persondemo01(uid,name,password) values('wjr07','王**07','530');

insert into persondemo01(uid,name,password) values('wjr08','王**08','530');

insert into persondemo01(uid,name,password) values('wjr09','王**09','530');

insert into persondemo01(uid,name,password) values('wjr10','王**10','530');

insert into persondemo01(uid,name,password) values('wjr11','王**11','530');

insert into persondemo01(uid,name,password) values('wjr12','王**12','530');

insert into persondemo01(uid,name,password) values('wjr13','王**13','530');

insert into persondemo01(uid,name,password) values('wjr14','王**14','530');

insert into persondemo01(uid,name,password) values('wjr15','王**15','530');

insert into persondemo01(uid,name,password) values('wjr16','王**16','530');

insert into persondemo01(uid,name,password) values('wjr17','王**17','530');

insert into persondemo01(uid,name,password) values('wjr18','王**18','530');

insert into persondemo01(uid,name,password) values('wjr19','王**19','530');

insert into persondemo01(uid,name,password) values('wjr20','王**20','530');

insert into persondemo01(uid,name,password) values('wjr21','王**21','530');

insert into persondemo01(uid,name,password) values('wjr22','王**22','530');

insert into persondemo01(uid,name,password) values('wjr23','王**23','530');

commit;