求分页的一些技术
求分页的代码：
1.数据库分页（求不同版本，求存储过程）。 
2.jsp分页 （求详细解释）。
3.ajax分页代码。
4.还有其他的。


------解决方案--------------------
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.*;

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