struts2.0+hibernate+oracle的分页详解

struts2.0 + hibernate + oracle 分页问题
最近弄了下 struts2.0 + hibernate + oracle 分页问题的

从网上搜了些资料。总觉得不是很合心意。自己做了例子。

ueser.sql

Sql代码
DROP TABLE "SCOTT"."T_USER" cascade constraints;
DROP SEQUENCE "SCOTT"."Q_USER";

CREATE TABLE T_USER
(
    ID       CHAR(4 BYTE) NOT NULL ENABLE,
    USERNAME VARCHAR2(20 BYTE) NOT NULL ENABLE,
    PASSWORD VARCHAR2(20 BYTE) NOT NULL ENABLE,
    CONSTRAINT T_USER_PK PRIMARY KEY (ID) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE SYSTEM ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE SYSTEM ;


CREATE SEQUENCE "SCOTT"."Q_USER" MINVALUE 1 MAXVALUE 9999 INCREMENT BY 1 START WITH 121 CACHE 20 NOORDER NOCYCLE ;

Insert into T_USER (ID,USERNAME,PASSWORD) values (Q_USER.nextval,'222','222');

DROP TABLE "SCOTT"."T_USER" cascade constraints;
DROP SEQUENCE "SCOTT"."Q_USER";

HibernateUtil.java

Java代码
package hibernate;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

/**
* Hibernate的工具类.
* @author AmigoXie
*/
public class HibernateUtil {
    private static SessionFactory sessionFactory;

    /** 持有一个单态的Session实例. */
    private static final ThreadLocal threadLocal = new ThreadLocal();

    /** 持有一个单态的configuration实例. */
    private static final Configuration cfg = new Configuration();
    private static String CONFIG_FILE_LOCATION = "hibernate/hibernate.cfg.xml";

    static {
        try {
            sessionFactory = new Configuration().configure(CONFIG_FILE_LOCATION)
                .buildSessionFactory();
        } catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    /**
     * 获得当前的Session实例.
     * @return Session
     * @throws HibernateException
     */
    public static Session currentSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

        //if (session == null) {
        if(session==null||session.isOpen()==false){
            if (sessionFactory == null) {
                try {
                    cfg.configure(CONFIG_FILE_LOCATION);
                    sessionFactory = cfg.buildSessionFactory();
                }
                catch (Exception e) {
                    System.err.println("%%%% Error Creating SessionFactory %%%%"
                            + e.getMessage());
                }
            }
            session = sessionFactory.openSession();
            threadLocal.set(session);
        }

        return session;
    }
}
User.java

Java代码
package hibernate;

public class User {


    private String id ;
    private String userName;
    private String password;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getUserName() {
        return userName;
    }
    public void setUserName(String userName) {
        this.userName = userName;
    }
    public String get

补充：软件开发 , Java ,