addstudentaction.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 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.AddStudentForm;

public class AddStudentAction extends Action {

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		AddStudentForm addStudentForm = (AddStudentForm) form;
		// TODO Auto-generated method stub
		
		String index = (String)request.getParameter("index");
		
		if(index.equals("first")) {
			ArrayList list = DBtool.getDataList("tb_profession",new String[]{"profession_id","profession_name"});
			request.setAttribute("profession",list);
			return mapping.findForward("first");
		}
		if(index.equals("add")) {
			String student_id = addStudentForm.getStudent_id();
			String student_name = addStudentForm.getStudent_name();
			String student_password = "111111";
			String student_sex = addStudentForm.getStudent_sex();
			String profession_id = addStudentForm.getProfession_id();
			
			String sql = "insert into tb_student values('"+student_id+"','"+student_name+"','"+student_password+"','"+student_sex+"',"+profession_id+")";
			DBtool.updateData(sql);
			return mapping.findForward("success");
		}
		return null;
	}

}