package test.bo;
import java.util.*;
import java.sql.*;
import test.models.*;
import test.db.*;

public class CategoryBO {
  Category category;

  public CategoryBO() {
  }

  public Collection allCategory() throws Exception {
  Collection ret = new ArrayList();
  try {
    DBAccess dba = new DBAccess();
    String sql = "select * from category";
    ResultSet rs = dba.openSelect(sql);
    while (rs.next()) {
      Category category = new Category();
      category.setCatid(rs.getString("catid"));
      category.setName(rs.getString("name"));
      category.setDescn(rs.getString("descn"));

      ret.add(category);
    }
  }
  catch (Exception e) {
    e.printStackTrace();
  }
  return ret;
}

}