businesstypedto.java

教你一天学会struts

package com.soft136.strutsoneday.model;

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

import javax.sql.rowset.CachedRowSet;

import com.soft136.strutsoneday.dao.BusinessTypeDAO;

public class BusinessTypeDTO {

	public ArrayList<BusinessTypeBean> getBusinessType() throws SQLException,
			ClassNotFoundException {
		CachedRowSet crs = new BusinessTypeDAO().getBusinessType();
		if (crs != null) {
			ArrayList<BusinessTypeBean> list = new ArrayList<BusinessTypeBean>();
			list.add(new BusinessTypeBean(0,"请选择业务类型"));
			while (crs.next()) {
				list.add(new BusinessTypeBean(crs.getInt(1), crs.getString(2)));
			}
			return list;
		} else {
			return null;
		}
	}

	public ArrayList<BusinessTypeDetailBean> getBusinessTypeDetail(
			int businessTypeId) throws SQLException, ClassNotFoundException {
		CachedRowSet crs = new BusinessTypeDAO()
				.getBusinessTypeDetail(businessTypeId);
		if (crs != null) {
			ArrayList<BusinessTypeDetailBean> list = new ArrayList<BusinessTypeDetailBean>();
			list.add(new BusinessTypeDetailBean(0,0,"请选择详细业务类型"));
			while (crs.next()) {
				list.add(new BusinessTypeDetailBean(crs.getInt(1), crs
						.getInt(2), crs.getString(3)));
			}
			return list;
		} else {
			return null;
		}
	}
}