sharedaoimpl.java

一个完整的物流系统

package jp.com.cost.dao.impl;

import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import jp.com.cost.common.ComTool;
import jp.com.cost.common.Log;
import jp.com.cost.dao.ShareDao;
import jp.com.cost.pojo.Account;
import jp.com.cost.pojo.Share;

import jp.com.cost.xs.entity.XS3301ViewEntity1;

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

public class ShareDaoImpl extends HibernateDaoSupport implements ShareDao {
	Query query;
	Session session;

	

	public List findAll(String id) {

		String sql = "select   guest.oid ,   guest.uname , guest.tel , guest.sort from  guest  where guest.delstate='"
				+ ComTool.UDL
				+ "'"
				+ "and  guest.oid in  (select number from share where share.dnumber="
				+ id + " )";
		
		session = getHibernateTemplate().getSessionFactory()
				.openSession();
		query = session.createSQLQuery(sql);
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XS3301ViewEntity1 a = new XS3301ViewEntity1();
			a.setOid((Integer) obj[0]);
			a.setUname(obj[1].toString());
			a.setTel(obj[2].toString());
			a.setSort(obj[3].toString());

			list1.add(a);
		}

		session.close();
		return list1;
	}

	public List findByCon(String oid, String name, String area) {
		StringBuffer sql = new StringBuffer();
		sql.append("select   guest.oid ,   guest.uname , guest.tel , guest.sort from  guest  where guest.delstate='"
						+ ComTool.UDL + "'");
		if (null != oid && oid.trim().length() > 0) {
			sql.append(" AND guest.oid like '%");
			sql.append(oid);
			sql.append("%'");
		}
		if (null != name && name.trim().length() > 0) {
			sql.append(" AND guest.uname like '%");
			sql.append(name);
			sql.append("%'");
		}
		if (null != area && area.trim().length() > 0) {
			sql.append(" AND guest.area like '%");
			sql.append(area);
			sql.append("%'");
		}

		session = getHibernateTemplate().getSessionFactory()
				.openSession();
		query = session.createSQLQuery(sql.toString());
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XS3301ViewEntity1 a = new XS3301ViewEntity1();
			a.setOid((Integer) obj[0]);
			a.setUname(obj[1].toString());
			a.setTel(obj[2].toString());
			a.setSort(obj[3].toString());

			list1.add(a);
		}

		session.close();
		return list1;
	}

	public Share findByID(String oid) {
		List list = getHibernateTemplate().find("from Share where oid=" + oid);
		Share share = (Share) list.get(0);
		return share;

	}

	public List showShared(String number) {
		// TODO Auto-generated method stub
		String sql = " select * from account  where  account.id  in (select  share.dnumber  from share where  share.number="+number+")";
		session = getHibernateTemplate().getSessionFactory()
				.openSession();
		query = session.createSQLQuery(sql).addEntity(Account.class);
		List list = new ArrayList(); 
		list = query.list();
		session.close();
		return list;
	}

	public List showNotShared(String number) {
		// TODO Auto-generated method stub
		String sql = " select * from account  where  account.id not in (select  share.dnumber  from share where  share.number="+number+")";
		session = getHibernateTemplate().getSessionFactory()
				.openSession();
		query = session.createSQLQuery(sql).addEntity(Account.class);
		List list = new ArrayList(); 
		list = query.list();
		session.close();
		return list; 
	}

	public boolean delete(String number) {
		// TODO Auto-generated method stub
		boolean bln=false;
		String sql="delete from share where number="+number;
		try {
			 session = getHibernateTemplate().getSessionFactory()
			.openSession();
			Statement stmt = session.connection().createStatement();
			stmt.execute(sql);
			Log.insert("share", "delete");
			bln=true;
		}catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return bln;
	}

	public boolean insert(Share share) {
		// TODO Auto-generated method stub
		boolean bln=false;
		try {
			getHibernateTemplate().save(share);
			Log.insert("share", "insert");
			bln=true;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return bln;
	}


}