/** * 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; }
@Override public int count() { // TODO Auto-generated method stub int i = 0 ; Session session = HibernateUtil.currentSession(); Transaction ts = null; try { ts = session.beginTransaction(); Query query = session.createQuery("select count(*) from User"); i = (Integer) query.uniqueResult();
} catch (HibernateException e) { // TODO Auto-generated catch block
e.printStackTrace(); if (ts != null) { ts.rollback(); }
}finally{ session.close(); }
return i;
}
}
pageAction.java
Java代码 package page;
import java.util.List;
import hibernate.User;
import com.opensymphony.xwork2.ActionSupport;
public class PageAction extends ActionSupport { int i=1;//中间变量 private int k;//储存最大页面数 private int pageNow=1; //页码数,初始为1 private int pageSize = 5 ; //页面行数 private int intRowCount = 0;//总行数 private int intPageCount = 1;//总页数 // private Admin admin; // private List<Admin> Adminss; private User user;
private List<User> users;
private int id; private int aid;
public User getUser() { return user; }
public void setUser(User user) { this.user = user; }
public List<User> getUsers() { return users; }
public void setUsers(List<User> users) { this.users = users; }
public int getId() { return id; }
public void setId(int id) { this.id = id; } public int getAid() { return aid; }
public void setAid(int aid) { this.aid = aid; }
public int getPageNow() { return pageNow; }
public void setPageNow(int pageNow) { this.pageNow = pageNow; }
public int getPageSize() { return pageSize; }
public void setPageSize(int pageSize) { this.pageSize = pageSize; } public int getIntRowCount() { return intRowCount; }
public void setIntRowCount(int intRowCount) { this.intRowCount = intRowCount; }
public int getIntPageCount() { return intPageCount; }
public void setIntPageCount(int intPageCount) { this.intPageCount = intPageCount; } public int getK() { return k; }
public void setK(int k) { this.k = k; } @SuppressWarnings("unchecked") @Override //显示列表 public String execute() throws Exception {
</tr> <s:iterator value="users" id = "user"> <tr> <td><s:property value = "#user.id"/></td> <td><s:property value = "#user.userName"/></td> <td><s:property value = "#user.password"/></td>