updateteacheraction.java

为基于J2EE（Java2 Platform

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xsl

package com.huang.actions;

import java.util.ArrayList;
import java.util.HashMap;

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.huang.common.DB.DBtool;
import com.huang.forms.UpdateTeacherForm;

public class UpdateTeacherAction extends Action {


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		UpdateTeacherForm updateTeacherForm = (UpdateTeacherForm) form;
		// TODO Auto-generated method stub
		
		String index = (String)request.getParameter("index");
		
		if(index.equals("first")) {
			String teacher_id = (String)request.getParameter("id");
			ArrayList list = DBtool.getDataList("tb_teacher",new String[]{"teacher_name","teacher_sex","teacher_label"});
			String teacher_name = ((HashMap)list.get(0)).get("teacher_name").toString();
			String teacher_sex = ((HashMap)list.get(0)).get("teacher_sex").toString();
			String teacher_label = ((HashMap)list.get(0)).get("teacher_label").toString();
			
			request.setAttribute("teacher_id",teacher_id);
			request.setAttribute("teacher_name",teacher_name);
			request.setAttribute("teacher_sex",teacher_sex);
			request.setAttribute("teacher_label",teacher_label);
			return mapping.findForward("fail");
			
		}
		if(index.equals("update")) {
			String teacher_id = (String)request.getParameter("id");
			String teacher_name = updateTeacherForm.getTeacher_name();
			String teacher_sex = updateTeacherForm.getTeacher_sex();
			String teacher_label = updateTeacherForm.getTeacher_label();
			
			String sql = "update tb_teacher set teacher_name='"+teacher_name+"',teacher_sex='"+teacher_sex+"',teacher_label='"+teacher_label+"' where teacher_id='"+teacher_id+"' ";
			DBtool.updateData(sql);
			return mapping.findForward("success");
		}
		return null;
	}

}