warehouseserviceimpl.java

一个java程序!!!数据库很特别!!请大家看看!!很有学习和使用的价值

package com.iplan.portal.order.service;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;

import com.iplan.portal.framework.base.BaseService;
import com.iplan.portal.order.pojo.Warehouse;

/**
 * http://www.5ai7.net
 * 
 * @author ws
 */
public class WarehouseServiceImpl extends BaseService implements
		IWarehouseService {
	/**
	 * 根据id获得pojo
	 * 
	 * @param id id
	 * @return
	 */
	public Warehouse getWarehouseById(String id) {
		return (Warehouse) this.getCommonDAO().get(Warehouse.class, id);
	}

	/**
	 * 根据warehouseId获得pojo
	 * 
	 * @param warehouseId
	 * @return
	 */
	public Warehouse getWarehouse(String warehouseId) {
		DetachedCriteria dc = DetachedCriteria.forClass(Warehouse.class);
		dc.add(Restrictions.eq("warehouseId", warehouseId));

		List list = this.getCommonDAO().findByCriteria(dc);
		if (list != null && !list.isEmpty()) {
			return (Warehouse) list.get(0);
		}

		return null;
	}

	/**
	 * 获得pojo的list
	 * 
	 * @return
	 */
	public List getWarehouseList() {
		StringBuffer sql = new StringBuffer();
		sql.append("select * from WAREHOUSE order by CREATETIME DESC");
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();

		return list;
	}

	/**
	 * 保存pojo
	 * 
	 * @param warehouse
	 */
	public void saveWarehouse(Warehouse warehouse) {
		this.getCommonDAO().save(warehouse);
	}

	/**
	 * 修改pojo
	 * 
	 * @param warehouse
	 */
	public void updateWarehouse(Warehouse warehouse) {
		this.getCommonDAO().update(warehouse);
	}

	/**
	 * 删除pojo
	 * 
	 * @param warehouse
	 */
	public void deleteWarehouse(Warehouse warehouse) {
		this.getCommonDAO().delete(warehouse);
	}
}