ssh2

package pojo;

/**
* TbUserId entity. @author MyEclipse Persistence Tools
*/

public class TbUserId implements java.io.Serializable {

// Fields

private Integer id;
private String username;
private String password;
private String userLastLogTime;

// Constructors

/** default constructor */
public TbUserId() {
}

/** full constructor */
public TbUserId(Integer id, String username, String password,
String userLastLogTime) {
this.id = id;
this.username = username;
this.password = password;
this.userLastLogTime = userLastLogTime;
}

// Property accessors

public Integer getId() {
return this.id;
}

public void setId(Integer id) {
this.id = id;
}

public String getUsername() {
return this.username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return this.password;
}

public void setPassword(String password) {
this.password = password;
}

public String getUserLastLogTime() {
return this.userLastLogTime;
}

public void setUserLastLogTime(String userLastLogTime) {
this.userLastLogTime = userLastLogTime;
}

public boolean equals(Object other) {
if ((this == other))
return true;
if ((other == null))
return false;
if (!(other instanceof TbUserId))
return false;
TbUserId castOther = (TbUserId) other;

return ((this.getId() == castOther.getId()) || (this.getId() != null
&& castOther.getId() != null && this.getId().equals(
castOther.getId())))
&& ((this.getUsername() == castOther.getUsername()) || (this
.getUsername() != null
&& castOther.getUsername() != null && this
.getUsername().equals(castOther.getUsername())))
&& ((this.getPassword() == castOther.getPassword()) || (this
.getPassword() != null
&& castOther.getPassword() != null && this
.getPassword().equals(castOther.getPassword())))
&& ((this.getUserLastLogTime() == castOther
.getUserLastLogTime()) || (this.getUserLastLogTime() != null
&& castOther.getUserLastLogTime() != null && this
.getUserLastLogTime().equals(
castOther.getUserLastLogTime())));
}

public int hashCode() {
int result = 17;

result = 37 * result + (getId() == null ? 0 : this.getId().hashCode());
result = 37 * result
+ (getUsername() == null ? 0 : this.getUsername().hashCode());
result = 37 * result
+ (getPassword() == null ? 0 : this.getPassword().hashCode());
result = 37
* result
+ (getUserLastLogTime() == null ? 0 : this.getUserLastLogTime()
.hashCode());
return result;
}

}
Action
package action;

import service.MemberService;
import bean.PageBean;

import com.opensymphony.xwork2.ActionSupport;

public class ListMemberAction extends ActionSupport{
    //通过applicationContext.xml配置文件注入memberService的值
    private MemberService memberService;
    public void setMemberService(MemberService memberService) {
        this.memberService = memberService;
    }
   
    private int page;    //第几页
   
    public MemberService getMemberService() {
return memberService;
}

private PageBean pageBean;    //包含分布信息的bean
   
    public int getPage() {
        return page;
    }

    public void setPage(int page) {        //若URL中无此参数,会默认为第1页
        this.page = page;
    }

    public PageBean getPageBean() {
        return pageBean;
    }

    public void setPageBean(PageBean pageBean) {
        this.pageBean = pageBean;
    }
public  String list() throws Exception{
this.pageBean = memberService.queryForPage(2, page);
//listmember=memberService.list();
return SUCCESS;
}
    @Override
    public String execute() throws Exception {
        //分页的pageBean,参数pageSize表示每页显示记录数,page为当前页
        this.pageBean = memberService.queryForPage(2, page);
        return SUCCESS;
    }
}
DaoImpl
package dao.impl;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import dao.MemberDao;


public class MemberDaoImpl extends HibernateDaoSupport implements MemberDao {
       //省略了其他的代码   

    /** *//**
     * 分页查询
     * @param hql 查询的条件
     * @param offset 开始记录
     * @param length 一次查询几条记录
     * @return
     */
    public List queryForPage(final String hql,final int offset,final int length){
        List list = getHibernateTemplate().executeFind(new HibernateCallback(){
            public Object doInHibernate(Session session) throws HibernateException,SQLException{
                Query query = session.createQuery(hql);
                query.setFirstResult(offset);
                query.setMaxResults(length);
                List list = query.list();
                return list;
            }
        });
        return list;
    }
   
   
    /** *//**
     * 查询所有记录数
     * @return 总记录数
     */
    public int getAllRowCount(String hql){
        return getHibernateTemplate().find(hql).size();
    }

}


struts.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>

    <constant name="struts.enable.DynamicMethodInvocation" value="false" />
    <constant name="struts.devMode" value="false" />

    <include file="example.xml"/>



    <package name="default" namespace="/" extends="struts-default"> 
        <action name="list" class="listmember" method="list">
            <result type="success">/listmember.jsp</result>
        </action>
    </package>

    <!-- Add packages here -->

</struts>
spring xml
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation"
value="classpath:hibernate.cfg.xml">
</property>
</bean>

<bean id="listmember" class="action.ListMemberAction">
<property name="memberService">
<ref local="memberService"></ref>
</property>
</bean>
<bean id="memberService" class="service.impl.MemberServiceImpl">
<property name="memberDao">
<ref local="memberDao"></ref>
</property>
</bean>
   <bean id="memberDao" class="dao.impl.MemberDaoImpl">
<property name="hibernateTemplate" ref="hibernateTemplate"></property>
</bean>
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
   <property name="sessionFactory">
    <ref bean="sessionFactory"></ref>
   </property>
</bean>
</beans>

hibernate
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/dbshop
</property>
<property name="connection.username">root</property>
<property name="connection.password">HKEA60828</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="myeclipse.connection.profile">
mysqldriver
</property>
<mapping resource="pojo/TbUser.hbm.xml" />

</session-factory>

</hibernate-configuration>