productsqlmapdao.java

来自「Java/J2EE框架Jdon-Framework系统的源代码」· Java 代码 · 共 71 行

/**
 * User: Clinton Begin Date: Jul 13, 2003 Time: 7:20:54 PM
 */
package com.jdon.framework.samples.jpetstore.persistence.dao.sqlmapdao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.StringTokenizer;

import com.ibatis.sqlmap.client.SqlMapExecutor;
import com.jdon.framework.samples.jpetstore.domain.Product;
import com.jdon.framework.samples.jpetstore.persistence.dao.SqlMapDaoTemplateFactory;
import com.jdon.framework.samples.jpetstore.persistence.dao.iface.ProductDao;

public class ProductSqlMapDao implements ProductDao {

    private SqlMapExecutor sqlMapDaoTemplate;

    public ProductSqlMapDao(SqlMapDaoTemplateFactory sqlMapDaoTemplateFactory) {
        sqlMapDaoTemplate = sqlMapDaoTemplateFactory.getSqlMapDaoTemp();
    }

    public List  getProductIDsListByCategory(String categoryId, int start, int pagessize) throws SQLException {
        return sqlMapDaoTemplate.queryForList(
                "getProductListByCategory", categoryId, start, pagessize);
    }

    public int getProductIDsListByCategoryCount(String categoryId) throws SQLException{
        Integer countI = (Integer)sqlMapDaoTemplate.queryForObject(
                "getProductListByCategoryCount", categoryId);
        return countI.intValue();
    }
    
    public Product getProduct(String productId) throws SQLException {
        return (Product) sqlMapDaoTemplate.queryForObject("getProduct",
                productId);
    }

    public List searchProductIDsList(String keywords, int start, int pagessize) throws SQLException {
        Object parameterObject = new ProductSearch(keywords);
        return sqlMapDaoTemplate.queryForList("searchProductList",
                parameterObject, start,  pagessize);
    }

    public int searchProductIDsListCount(String keywords) throws SQLException{
        Object parameterObject = new ProductSearch(keywords);
        Integer countI = (Integer)sqlMapDaoTemplate.queryForObject("searchProductListCount",
                parameterObject);
        return countI.intValue();
    }
    
    /* Inner Classes */

    public static class ProductSearch {
        private List keywordList = new ArrayList();

        public ProductSearch(String keywords) {
            StringTokenizer splitter = new StringTokenizer(keywords, " ", false);
            while (splitter.hasMoreTokens()) {
                keywordList.add("%" + splitter.nextToken() + "%");
            }
        }

        public List getKeywordList() {
            return keywordList;
        }
    }

}