JSP分页
来源:互联网 发布:java 泛型 通配符 编辑:程序博客网 时间:2024/05/21 05:06
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.*;
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;
}
}
//页面中的代码
<%@ page language="java" import="java.util.*,entity.*,dao.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
- jsp分页
- JSP分页
- Jsp分页
- jsp分页
- jsp分页
- JSP分页
- jsp 分页
- jsp分页
- jsp分页
- JSP分页
- JSP分页
- jsp分页
- jsp分页
- JSP 分页
- jsp分页
- Jsp分页
- jsp分页
- JSP分页
- Socket详解
- 【汉化】DevExpress插件中RichEdit控件的自定义汉化方法 - ExDevilLee
- JSP自定义标签学习笔记
- session丢失是怎么解决的
- 苏州北大青鸟分享:快速、简便的使用AJAX技术操作的三部曲
- JSP分页
- Linux的七个运行级别原理概述
- HI3531由DMA 发起PCIe 事务
- 一般公司不太可能让应届生在面试的时候手写那么多的代码
- DecimalFormat使用
- javascript基础拾遗——词法作用域
- Python语言的Human-Readable Print(Pretty Print)
- word2007快捷使用方式
- lua入门之一:c/c++ 调用lua