锐客网

  1. 首页 > 睿知 > >

JSP分页

睿知


JSP分页

文章插图
JSP分页

文章插图

//实体类
package entity;
public class note {
PRivate int id;
private String title;
private String author;
private String content;

public note(){}
public note(String title,String author,String content)
{
this.title=title;
this.author=author;
this.content=content;
}
public note(int id,String title,String author,String content)
{
this.id=id;
this.title=title;
this.author=author;
this.content=content;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}

}
//连接数据库的基类
package dao;
import java.sql.*;
【JSP分页】public abstract class BaseJdbcDao {
private static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String DBURL = "jdbc:sqlserver://localhost:1433;DataBaseName=notetest";
private static final String DBUSER="sa";
private static final String DBPASS="sa";

protected Connection conn=null;
protected Statement stmt=null;
protected PreparedStatement pstmt=null;
protected ResultSet rst=null;

public Connection getConn()
{
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
// System.out.println("连接成功");
}catch(ClassNotFoundException e)
{
System.out.println("没有找到驱动");
e.getMessage();
}catch(SQLException e)
{
System.out.println("数据库联接失败");
e.getMessage();
}finally
{
return conn;
}
}

public void CloseAll()
{
if(rst!=null)
{
try{
rst.close();
}catch(SQLException e)
{
e.toString();
}
}
if(pstmt!=null)
{
try{
pstmt.close();
}catch(SQLException e)
{
e.toString();
}
}
if(stmt!=null)
{
try{
stmt.close();
}catch(SQLException e)
{
e.toString();
}
}
if(conn!=null)
{
try{
conn.close();
}catch(SQLException e)
{
e.toString();
}
}
}
}
//业务类
package dao;
import java.sql.*;
import java.util.*;
import entity.note;
public class noteDao extends BaseJdbcDao{
int count=0;
//得到所有记录数
public int getNoteCount()
{
String sql1="select count(*) from note";
int pageCount=0;
conn=super.getConn();
try{
pstmt=conn.prepareStatement(sql1);
rst=pstmt.executeQuery();
rst.next();
count=rst.getInt(1);

}catch(SQLException e)
{
e.toString();
}finally
{
super.CloseAll();
}
return count;
}
//分页显示
public List ShowNotesByPage(int page,int pageSize)
{
List listnote=new ArrayList();
note nn=null;
int preCount = pageSize*(page-1);
int pageCount=0;
String sql="select top " pageSize " * from note where id not in (select top " preCount " id from note order by id desc) order by id desc";
conn=super.getConn();
try{
if(count%pageSize==0){
pageCount=count/pageSize;
}
else
{
pageCount=count/pageSize 1;
}
pstmt=conn.prepareStatement(sql);
rst=pstmt.executeQuery();
while(rst.next())
{
nn=new note();
nn.setId(rst.getInt("id"));
nn.setTitle(rst.getString("title"));
nn.setAuthor(rst.getString("author"));
nn.setContent(rst.getString("content"));
listnote.add(nn);
}
}catch(SQLException e)
{
e.toString();
}finally
{
super.CloseAll();
}
return listnote;
}
}
//页面中的代码


推荐阅读


上一篇：诗情画意的语录

下一篇：风云岛行动翩翩技能详解 翩翩技能全面解析