goteacheraction.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.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.Action;

import bean.TeacherBean;

import dao.DataStoreDao;

public class GoTeacherAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		HttpSession session = request.getSession(true);
		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 mapping.findForward("go");
	}

}