package achievo.dtree.service;

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

import achievo.dtree.bean.ClassBean;
import achievo.dtree.dbmanager.DBManager;

public class ClassService {
	private DBManager db;// = new DBManager();
	private List<ClassBean> list ;
	private ResultSet rs;
	private ClassBean bean;
	public List<ClassBean> getClassBeanList() {
		db = new DBManager();
		list = new ArrayList<ClassBean>();
		rs = db.getResultSet("select * from class");
		try {
			while(rs.next()) {
				bean = new ClassBean();
				bean.setCid(rs.getInt("cid"));
				bean.setCname(rs.getString("cname"));
				list.add(bean);
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			db.close();
		}
		return null;
	}
}