useraction.java

来自「利用当前管理信息系统科学的、实用的理论」· Java 代码 · 共 55 行

package com.haizi.struts.action;

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.haizi.struts.datebase.DBConnect;
import com.haizi.struts.formbean.UserForm;

public class UserAction extends Action {
	
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {
		
			int no =((UserForm) form).getUser_no();
			String name = ((UserForm) form).getName();
			String depname = ((UserForm) form).getDep_name();
			String quanxian = ((UserForm)form).getQuanxian();
			String pwd = ((UserForm)form).getPassword();
			String sex = ((UserForm)form).getSex();
			String phone = ((UserForm)form).getPhone();
			DBConnect dbc = null;
			try{
				dbc  = new DBConnect();
				dbc.prepareStatement("Insert into user_info(user_no,name,password,quanxian,sex,phone,dep_name) values (?,?,?,?,?,?,?)");
				dbc.setInt(1,no) ;
				dbc.setString(2,name);
				dbc.setString(3,pwd);
				dbc.setString(4,quanxian);
				dbc.setString(5,sex);
				dbc.setString(6,phone);
				dbc.setString(7,depname);
				dbc.executeUpdate();
				
			}catch(Exception e){
				return mapping.findForward("error");
			}finally{
				try{
					dbc.close();
				}catch(Exception e){
					e.printStackTrace();
				}
			}
			return mapping.findForward("user");
		} 
	}