selectteacheraction.java

学生管理系统的Java实现

package request.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import bean.TeacherBean;
import dao.DataStoreDao;

import request.forms.LoginForm;
import request.forms.SelectTeacherForm;

public class SelectTeacherAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		HttpSession session = request.getSession(true);
		SelectTeacherForm selectForm = (SelectTeacherForm) form;
		String selectkey = selectForm.getSelect();
		DataStoreDao db = DataStoreDao.getInstance();
		ArrayList<TeacherBean> listResult = new ArrayList<TeacherBean>();
		ResultSet st = null;
		String sql = "select id,name from teacher";
		st = db.read(sql);
		db.stop();
		while (st.next()) {
			TeacherBean teacher = new TeacherBean();
			teacher.setId((String) st.getString("id"));
			teacher.setName((String) st.getString("name"));
			listResult.add(teacher);
		}
		session.setAttribute("allteacher", listResult);
		return null;
	}
}