sqlmapbookmarkdao.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 IBookmarkDAO and provides functionality to read and write 
* Bookmark Records to and from the database.
*/
public class SqlMapBookmarkDAO extends SqlMapClientDaoSupport implements IBookmarkDAO {

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

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

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

	public void update(BookmarkRecord bookmark)
			throws PersonalizationDAOException {
		try{
			bookmark.setTimeModified(new java.sql.Timestamp(System.currentTimeMillis()));
			getSqlMapClientTemplate().update("updateBookmark", bookmark);	
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}
	
	public void delete(String id) throws PersonalizationDAOException {
		try{
			getSqlMapClientTemplate().delete("deleteBookmark", id);
		}
		catch(DataAccessException e){
			throw new PersonalizationDAOException( e );
		}
	}
}