kyokusyopassupdateconfaction.java

用strutshibernate做的项目

package com.dut.struts.action;


import java.util.Iterator;
import java.util.List;

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.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.db.Kyokusyo;
import com.dut.struts.form.KensyoInputActionForm;

/**
 * MyEclipse Struts Creation date: 04-20-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/kyokusyoPassUpdateConfAction"
 *                name="kensyoInputActionForm"
 *                input="/pages/KyokusyoPassUpdateConf.jsp" scope="request"
 */
public class KyokusyoPassUpdateConfAction extends Action {

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		String flag = (String) request.getParameter("flag");

		if (flag.equals("yes")) {

			List list = (List) request.getSession().getAttribute("list2");
			System.out.println("list====>"+list);
			Iterator it = list.iterator();
			String KYOKU_ID ="";
			String KEN_ID ="";
			if (it.hasNext())
			{
				Kyokusyo temp = (Kyokusyo) it.next();
				KYOKU_ID = temp.getKyoku_id();
				KEN_ID = String.valueOf(temp.getKen_id());
				
			}

			String sql = "UPDATE KYOKUSYO SET PASSWORD='999999' WHERE KEN_ID='"+ KEN_ID + "'AND KYOKU_ID='" + KYOKU_ID + "'";
			System.out.println("sql999999==>"+sql);
			new BatchDBConnectionUtil().executeUpdate(sql);
		}

		return mapping.findForward("go_KensyoSearch");
	}

}