HibernateTemplate

package com.hygj.dao.impl;

import java.util.ArrayList;
import java.util.List;

import com.hygj.bean.Outlist;
import com.hygj.dao.OutlistDAO;

public class OutlistDAOImpl extends BaseDAOImpl<Outlist> implements OutlistDAO {
	public List<Outlist> getListByCode(String code) {
		List<Outlist> ollist = new ArrayList<Outlist>();
		List<Object[]> list = this
				.getHibernateTemplate()
			.find("select ol,(select p.pname from Product p where p.id=ol.pid) from Outlist ol where ocode=?",
						new Object[] { code });
		for (Object[] objs : list) {
			Outlist ol = (Outlist) objs[0];
			ol.setPname(objs[1].toString());
			ollist.add(ol);
		}
		return ollist;
	}
}

转载于:https://my.oschina.net/wfire/blog/160931