jiehundaoimp.java

Java项目 婚姻介绍系统 jsp+struts+hibernate+spring 开发环境 Eclipse+oracle9i+tomcat 高质量代码 可用于学生论文

package com.xdf.marry.dao.hibernate;

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

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.xdf.marry.bean.Jiehun;
import com.xdf.marry.dao.IJiehunDAO;

public class JiehunDAOImp extends BaseDAO implements IJiehunDAO{

	public List findJiehun(final String xingming,final String id,final String dengjishijian) {
		
		//通过HibernateCallback()来使用hibernate session
		List list = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria c = session.createCriteria(Jiehun.class);
				c.createAlias("yuyue","y");
				c.createAlias("y.man","m");
				c.createAlias("y.woman","w");
				if(xingming!=null&&!xingming.equals("")) {
					c.add(Restrictions.or(
							Restrictions.eq("m.mxingming",xingming),
							Restrictions.eq("w.wxingming",xingming)));
				}
				if(id!=null&&!id.equals("")) {
					c.add(Restrictions.or(
							Restrictions.eq("m.mzhengjianhaoma",id),
							Restrictions.eq("w.wzhengjianhaoma",id)));
				}
				if(dengjishijian!=null&&!dengjishijian.equals("")) {
					c.add(Restrictions.eq("dengjishijian",dengjishijian));
				}
				c.addOrder(Order.asc("jiehunid"));
				return c.list();
			}
		});
		return list;
	}
	public int findJiehunnum(final String xingming,final String id,final String dengjishijian) {
		
		//通过HibernateCallback()来使用hibernate session
		List list = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria c = session.createCriteria(Jiehun.class);
				c.createAlias("yuyue","y");
				c.createAlias("y.man","m");
				c.createAlias("y.woman","w");
				if(xingming!=null&&!xingming.equals("")) {
					c.add(Restrictions.or(
							Restrictions.eq("m.mxingming",xingming),
							Restrictions.eq("w.wxingming",xingming)));
				}
				if(id!=null&&!id.equals("")) {
					c.add(Restrictions.or(
							Restrictions.eq("m.mzhengjianhaoma",id),
							Restrictions.eq("w.wzhengjianhaoma",id)));
				}
				if(dengjishijian!=null&&!dengjishijian.equals("")) {
					c.add(Restrictions.eq("dengjishijian",dengjishijian));
				}
				c.setProjection(Projections.rowCount());
				return c.list();
			}
		});
		Integer a = (Integer)list.get(0);
		return a.intValue();
	}
}