categorydao.java

一个基于java工厂模式的 的实现

/*
 * CategoryDAO.java
 *
 * Created on 2007年4月17日, 下午3:40
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.ebuy.dataaccess;

import com.ebuy.common.dao.IDAO;
import com.ebuy.entities.CategoryEntity;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 *
 * @author Administrator
 */
public class CategoryDAO extends DAOAdapter
{
    
    /** Creates a new instance of CategoryDAO */
    public CategoryDAO()
    {
    }
        
    public List findByQueryString(String sql)
    {
        List list=new ArrayList();
        try
        {
            JDBCServer server=new JDBCServer();
            java.sql.ResultSet rs=server.execQuery(sql);
            CategoryEntity entity=new CategoryEntity();
            while(rs.next())
            {
                entity=new CategoryEntity();
                entity.setCategoryid(rs.getInt(1));
                entity.setCategoryname(rs.getString(2));
                entity.setDescription(rs.getString(3));
                list.add(entity);
            }
            server.closeConnection();
        } 
        catch (SQLException ex)
        {
            ExceptionManager.handlerException(ex);
        }
        return list;        
    }
    public List findAll()
    {
        String sql="select * from Categories order by CategoryID";
        java.util.List list= this.findByQueryString(sql);
        return list;
    }
  
    
}