sqlmapmapcompositiondao.java

来自「esri的ArcGIS Server超级学习模板程序（for java）」· Java 代码 · 共 88 行

package com.esri.solutions.jitk.personalization.dao;

import java.util.*;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.dao.DataAccessException;

/**
* @author Susan Herdina
* @version 1.0
* @created 05-Nov-2007 10:29:29 AM
* 
* This class implements the IMapCompositionDAO and provides functionality to read and write 
* Map Composition Records to and from the database.
*/
public class SqlMapMapCompositionDAO extends SqlMapClientDaoSupport implements IMapCompositionDAO {

	public void insert(MapCompositionRecord mapComp)
			throws PersonalizationDAOException {
		try{
			mapComp.setTimeModified(new java.sql.Timestamp(System.currentTimeMillis()));
			getSqlMapClientTemplate().insert("insertMapComposition", mapComp);	
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}		
	}

	public List<MapCompositionInfoRecord> selectAll(Criteria criteria)
			throws PersonalizationDAOException {
		try{
			return getSqlMapClientTemplate().queryForList("selectAllMapCompositions", criteria);
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}

	public int selectAllCount(Criteria criteria) throws PersonalizationDAOException {
		try{
			return Integer.parseInt(getSqlMapClientTemplate().queryForObject("selectCountMapCompositions", criteria).toString());
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}
	
	public List<MapCompositionInfoRecord> selectPage(Criteria criteria, PageInfo pageInfo)
			throws PersonalizationDAOException {
		try{
			int skipResults = pageInfo.getPageIndex() * pageInfo.getPageSize();
			return getSqlMapClientTemplate().queryForList("selectPageMapCompositions", criteria, skipResults, pageInfo.getPageSize());
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}	
	
	public MapCompositionRecord selectOne(String id)
			throws PersonalizationDAOException {
		try{
			return (MapCompositionRecord)getSqlMapClientTemplate().queryForObject("selectOneMapComposition", id);
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}	

	public void update(MapCompositionRecord mapComp)
			throws PersonalizationDAOException {
		try{
			mapComp.setTimeModified(new java.sql.Timestamp(System.currentTimeMillis()));
			getSqlMapClientTemplate().update("updateMapComposition", mapComp);	
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}
	
	public void delete(String id) throws PersonalizationDAOException {
		try{
			getSqlMapClientTemplate().delete("deleteMapComposition", id);
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}
}