package achievo.dtree.service;

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

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

public class StudentService {
	private DBManager db;

	private List<StudentBean> list;

	private ResultSet rs;

	private StudentBean bean;

	public List<StudentBean> getStudentBeanList(int cid) {
		db = new DBManager();
		list = new ArrayList<StudentBean>();
		rs = db.getResultSet("select * from student where cid=" + cid + "");
		System.out.println(cid);
		StudentBean[] sb=new StudentBean[999];
		try {
			while (rs.next()) {
				bean = new StudentBean();
				bean.setCid(rs.getInt("cid"));
				bean.setSid(rs.getInt("sid"));
				bean.setSname(rs.getString("sname"));
				bean.setAge(rs.getInt("sage"));
				bean.setSemail(rs.getString("semail"));
				bean.setSsex(rs.getString("ssex"));
				list.add(bean);
				System.out.println(list);
				System.out.println("&***************");
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} finally {
			db.close();
		}
	}
}