recorddaoimpl.java

一个完整的物流系统

package jp.com.cost.dao.impl;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;


import jp.com.cost.dao.RecordDao;
import jp.com.cost.pojo.Record;
import jp.com.cost.xt.entity.XT6301ViewEntity1;

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

public class RecordDaoImpl extends HibernateDaoSupport implements RecordDao{
	private Session session;
	private Query query;
	
	/**
	 * 显示所有操作记录信息
	 */
	public List findAllRecord() {
		String sql = "select id,etable,etype,otime from record";
		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);
			XT6301ViewEntity1 xt6301 = new XT6301ViewEntity1();
			xt6301.setId((Integer)obj[0]);
			xt6301.setEtable(obj[1].toString());
			xt6301.setEtype(obj[2].toString());
			xt6301.setOtime(obj[3].toString());
			list1.add(xt6301);
		}
		session.close();
		return list1;		
	}
	/**
	 * 根据选择的表,查询相应的记录
	 */
	public List findRecordByCon(String name) {
		String sql = "select * from record where etable='"+name+"'";
		
		session = getHibernateTemplate().getSessionFactory()
				.openSession();
		query = session.createSQLQuery(sql);
		List<Object> list = query.list();
		System.out.println(list.size());
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XT6301ViewEntity1 xt6301 = new XT6301ViewEntity1();
			xt6301.setId((Integer)obj[0]);
			xt6301.setEtable(obj[1].toString());
			xt6301.setEtype(obj[2].toString());
			xt6301.setOtime(obj[3].toString());
			list1.add(xt6301);
		}
		session.close();
		return list1;
	}
	/**
	 *根据编号页面删除相应的信息
	 */
	public boolean delete(String id) {
		Record record = new Record();
		boolean bln=false;
		try {
				List list = getHibernateTemplate().find("from Record where id="+id);
				record =  (Record)list.get(0);
				getHibernateTemplate().delete(record);
				bln = true;
		}
		catch (Exception e) {
			e.printStackTrace();
		}
		return bln;
	}
	public void insert(String etable, String etype) {
		DateFormat d = new SimpleDateFormat("yyyy.MM.dd HH:mm:ss");
		String otime = d.format(new Date());

		Record record = new Record();
		
		
		record.setEtable(etable);
		record.setEtype(etype);
		record.setOtime(otime);
        getHibernateTemplate().save(record);
		
	}
}