chooseaction.java

学生选课 用java和sql server 2000用asp完成的学生选课管理系统

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.xuanke.action;

import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 com.xuanke.dao.Dao;

/**
 * MyEclipse Struts Creation date: 01-04-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="choose" path="/choose.do"
 */
public class ChooseAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws SQLException
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		// TODO Auto-generated method stub
		Dao dao = new Dao();
		String cource=request.getParameter("courcename");
		String xuehao = (String) request.getSession().getAttribute("username");
		ResultSet res = dao.selCource(cource);

		if (res.next()) {
			String courcename = res.getString("courcename");
			String teacher = res.getString("teacher");
			String jiaoshi = res.getString("jiaoshi");
			String time = res.getString("time");
			float score = res.getFloat("score");
			if (dao.addChoose(courcename, teacher, jiaoshi, time, score,xuehao)) {
				dao.onclose();
				return mapping.findForward("chooseok");
			} else
				return mapping.findForward("choosefail");
		}

		else {
			return mapping.findForward("choosefail");
		}

	}
}