Hibernate分页

风晨四方

浏览: 26374 次
性别:
来自: 武汉

最近访客更多访客>>

多喝热水

lovelinability

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2011-06 ( 28)
更多存档...

Hibernate Struts Apache Myeclipse Oracle

//数据库表
create table Student
(
stuid varchar(32) primary key,
stuname varchar(32),
stuage int,
stusex char(2),
stuaddr varchar(50)
)
//////////////////////////com.svse.entity///////////////////////////
//Student实体
package com.svse.entity;

public class Student {

private String stuid;
private String stuname;
private int stuage;
private String stusex;
private String stuaddr;

public Student() {
// TODO Auto-generated constructor stub
}

public Student(String stuaddr, int stuage, String stuid, String stuname,
String stusex) {
super();
this.stuaddr = stuaddr;
this.stuage = stuage;
this.stuid = stuid;
this.stuname = stuname;
this.stusex = stusex;
}

public String getStuid() {
return stuid;
}

public void setStuid(String stuid) {
this.stuid = stuid;
}

public String getStuname() {
return stuname;
}

public void setStuname(String stuname) {
this.stuname = stuname;
}

public int getStuage() {
return stuage;
}

public void setStuage(int stuage) {
this.stuage = stuage;
}

public String getStusex() {
return stusex;
}

public void setStusex(String stusex) {
this.stusex = stusex;
}

public String getStuaddr() {
return stuaddr;
}

public void setStuaddr(String stuaddr) {
this.stuaddr = stuaddr;
}

}

//Student.hbm.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>

   <class name="com.svse.entity.Student" table="Student">
      <id name="stuid" column="stuid" type="string" length="32">
         <generator class="assigned"></generator>
      </id>
      <property name="stuname" column="stuname" type="string" length="32"></property>
       <property name="stuage" column="stuage" type="integer"></property>
        <property name="stusex" column="stusex" type="string" length="32"></property>
         <property name="stuaddr" column="stuaddr" type="string" length="32"></property>
   </class>

</hibernate-mapping>

//////////////////////////com.svse.util///////////////////////////
//分页辅助类

package com.svse.util;
public class PageHelp {

int totalcount;//总行数
int linesize;//每页显示的条数
int totalpage;// 总页数
int currentpage;//当前页

public PageHelp() {
// TODO Auto-generated constructor stub
}

public PageHelp(int currentpage, int linesize, int totalcount, int totalpage) {
super();
this.currentpage = currentpage;
this.linesize = linesize;
this.totalcount = totalcount;
this.totalpage = totalpage;
}

public int getTotalcount() {
return totalcount;
}

public void setTotalcount(int totalcount) {
this.totalcount = totalcount;
}

public int getLinesize() {
return linesize;
}

public void setLinesize(int linesize) {
this.linesize = linesize;
}

public int getTotalpage() {
return totalpage;
}

//设置总页数
public void setTotalpage() {
if(this.getTotalcount()%this.getLinesize()==0)
{
this.totalpage = this.getTotalcount()/this.getLinesize();
}
else
{
this.totalpage = this.getTotalcount()/this.getLinesize()+1;
}

}

public int getCurrentpage() {
return currentpage;
}

public void setCurrentpage(int currentpage) {
this.currentpage = currentpage;
}

}
//字符过滤器
package com.svse.util;

import java.io.IOException;

import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

public class Filter implements javax.servlet.Filter {

public void destroy() {
// TODO Auto-generated method stub

}

public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
// TODO Auto-generated method stub

request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("text/html;charset=utf-8");
chain.doFilter(request, response);
}

public void init(FilterConfig arg0) throws ServletException {
// TODO Auto-generated method stub

}

}
//SessionFactory类
package com.svse.util;

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

public class DefaultSessionFactory {

public static Session getSession()
{

return new Configuration().
configure().buildSessionFactory().openSession();

}
}
/////////////////////////////com.svse.dao/////////////////////////////
//StudentDao类
package com.svse.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.svse.entity.Student;
import com.svse.util.DefaultSessionFactory;

public class StudentDao {

private Session session=null;
public StudentDao() {
this.session=DefaultSessionFactory.getSession();
}

//查询所有记录的条数
public long getTotalCount()
{
String hql="select count(stuname) from Student";
Query query=this.session.createQuery(hql);

return (Long)query.uniqueResult();
}

//获取当前分页后的集合
public List<Student> getCurrentList(int currentPage,int lineSize)
{
String hql="from Student";
Query query=this.session.createQuery(hql);
query.setFirstResult((currentPage-1)*lineSize);
query.setMaxResults(lineSize);
return query.list();
}

public List findAll()
{
String hql="from Student";
Query query=this.session.createQuery(hql);
return query.list();

}

}

////////////////////////////com.svse.action///////////////////////////
//StudentAction类
/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.svse.struts.action;

import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.svse.dao.StudentDao;
import com.svse.entity.Student;
import com.svse.util.PageHelp;

/**
* MyEclipse Struts
* Creation date: 06-21-2011
*
* XDoclet definition:
* @struts.action validate="true"
*/
public class StudentAction extends DispatchAction {
/*
* Generated Methods
*/

/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
private StudentDao studao=new StudentDao();
public ActionForward findAllStu(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {

//int totalCount=(int)studao.getTotalCount();
int totalCount=studao.findAll().size();
System.err.println("xxxxxxxxx : "+totalCount);
PageHelp ph=new PageHelp();
ph.setTotalcount(totalCount);
ph.setLinesize(3);
ph.setTotalpage();

int currentPage=0;
if(request.getParameter("currentPage")==null)
{
currentPage=1;
}
else
{
currentPage=Integer.parseInt(request.getParameter("currentPage"));
    //防止下标越界的情况
if(currentPage<1)
    {
    currentPage=1;
    }
if(currentPage>ph.getTotalpage())
{
currentPage=ph.getTotalpage();
}
}

ph.setCurrentpage(currentPage);
List<Student> stulist=studao.getCurrentList(ph.getCurrentpage(), ph.getLinesize());
request.setAttribute("stulist", stulist);
request.setAttribute("pagehelp", ph);
System.err.println(stulist.size());
for (Student student : stulist) {
System.err.println(student.getStuname()+student.getStuid());
}

return mapping.findForward("tostulist");
}

}

//显示信息的JSP页面
<%@ page language="java" pageEncoding="utf-8" isELIgnored="false"%>

<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html:html lang="true">
<head>
    <html:base />

    <title>Hibernate分页</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head>

<body>
      <center>
          <table border="0" align="center" width="40%">
             <tr align="center" bgcolor="pink">
                <td colspan="5">学生详细信息</td>
             </tr>
              <tr align="center" bgcolor="pink">
                <td colspan="5"><hr></td>
             </tr>
             <tr bgcolor="pink">
                <td>编号</td>
                <td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>地址</td>
             </tr>
             <logic:iterate id="s" name="stulist">
               <tr bgcolor="pink">
                <td>${s.stuid }</td>
                <td>${s.stuname }</td>
<td>${s.stuage}</td>
<td>${s.stusex }</td>
<td>${s.stuaddr }</td>
             </tr>
             </logic:iterate>
               <tr align="center" bgcolor="pink">
                <td colspan="5"><hr></td>
              </tr>
      <tr bgcolor="pink">
                 <td colspan="5" width="700" align="center">
                 <a href="student.do?method=findAllStu&currentPage=1"><img src="image/head.gif" style="border: none;"/></a>  
                 <a href="student.do?method=findAllStu&currentPage=${pagehelp.currentpage-1 }"><img src="image/top.gif" style="border: none;"/></a>  
                 <a href="student.do?method=findAllStu&currentPage=${pagehelp.currentpage+1 }"><img src="image/next.gif" style="border: none;"/></a>  
                 <a href="student.do?method=findAllStu&currentPage=${pagehelp.totalpage }"><img src="image/end.gif" style="border: none;"/></a>
                </td>
             </tr>
              <tr align="center" bgcolor="pink">
                 <td colspan="5">
               <font color="red">当前是：【${pagehelp.currentpage}】页,   一共【${pagehelp.totalpage}】页</font>
                </td>
               </tr>

          </table>
     </center>
</body>
</html:html>

//Struts-config-xml配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">

<struts-config>
<form-beans />
<global-exceptions />
<global-forwards />
<action-mappings >
    <action path="/student"
    type="com.svse.struts.action.StudentAction"
    parameter="method"
     >
      <forward name="tostulist" path="/showstu.jsp"></forward>
    </action>

</action-mappings>

<message-resources parameter="com.svse.struts.ApplicationResources" />
</struts-config>

//Hibernate-cfg-xml配置文件
<?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">


<hibernate-configuration>

<session-factory>
<property name="connection.username">scott</property>
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:orcl
</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="myeclipse.connection.profile">oracle</property>
<property name="connection.password">tiger</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="com/svse/entity/Student.hbm.xml" />

</session-factory>

</hibernate-configuration>

分享到：