areaserviceimpl.java

SSH示范

package com.iplan.portal.admin.service;

import java.util.List;

import com.iplan.portal.admin.pojo.Area;
import com.iplan.portal.framework.base.BaseService;

/**
 * http://www.hao-se.cn
 * 
 * @author ws
 */
public class AreaServiceImpl extends BaseService implements IAreaService {
	/**
	 * 根据id获得pojo
	 * 
	 * @param id id
	 * @return
	 */
	public Area getAreaById(String id) {
		return (Area) this.getCommonDAO().get(Area.class, id);
	}

	/**
	 * 获得pojo的list
	 * 
	 * @return
	 */
	public List getAreaList() {
		StringBuffer sql = new StringBuffer();
		sql.append("select area.guid as guid, area.areaname as areaname,area.flg as flg,user.username as username from AREA area ");
		sql.append("INNER JOIN USER user ON user.guid = area.userid ");
		sql.append("order by area.TIMENUM DESC");
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();

		return list;
	}

	/**
	 * 获得pojo的list
	 * 
	 * @param userId userId
	 * @return
	 */
	public List getAreaListByUserId(String userId) {
		StringBuffer sql = new StringBuffer();
		sql.append("select area.guid as guid, area.areaname as areaname,area.flg as flg,user.username as username from AREA area ");
		sql.append("INNER JOIN USER user ON user.guid = area.userid ");
		sql.append("where area.userId=? order by area.TIMENUM DESC");		
		List list = this.getCommonDAO().findBySQL(sql.toString(),
				new Object[] { userId }).getRows();

		return list;
	}

	/**
	 * 获得pojo的list
	 * 
	 * @param userId userId
	 * @return
	 */
	public List getUsedAreaListByUserId(String userId) {
		StringBuffer sql = new StringBuffer();
		sql.append("select * from AREA where userId=? and flg='0' order by TIMENUM DESC");
		List list = this.getCommonDAO().findBySQL(sql.toString(),
				new Object[] { userId }).getRows();

		return list;
	}
	
	/**
	 * 保存pojo
	 * 
	 * @param area
	 */
	public void saveArea(Area area) {
		this.getCommonDAO().save(area);
	}

	/**
	 * 修改pojo
	 * 
	 * @param area
	 */
	public void updateArea(Area area) {
		this.getCommonDAO().update(area);
	}

	/**
	 * 删除pojo
	 * 
	 * @param area
	 */
	public void deleteArea(Area area) {
		this.getCommonDAO().update(area);
	}
}