kyokusyoregistconfaction.java

用strutshibernate做的项目

package com.dut.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
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.struts.form.KyokusyoInputActionForm;

/**
 * MyEclipse Struts Creation date: 04-12-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action input="/pages/KyokusyoRegistConf.jsp" validate="true"
 */
public class KyokusyoRegistConfAction 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) {

		KyokusyoInputActionForm kyokusyoInputActionForm = (KyokusyoInputActionForm) request
				.getSession().getAttribute("kyokusyoInputActionForm");

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

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

			String KYOKU = kyokusyoInputActionForm.getKYOKU_ID();
			String KEN_ID = null;
			String KYOKU_ID = null;
			String ZIPCD_MAE = kyokusyoInputActionForm.getZIPCD_MAE();
			String ZIPCD_ATO = kyokusyoInputActionForm.getZIPCD_ATO();
			String KYOKUSYO_MEI = kyokusyoInputActionForm.getKYOKUSYO_MEI();
			String JUSYO = kyokusyoInputActionForm.getJUSYO();
			String TEL = kyokusyoInputActionForm.getTEL();
			String PASSWORD = "12345";
			Date INSERT_DATE = new Date();
			Date UPDATE_DATE = new Date();

			if (KYOKU.length() > 3) {
				KEN_ID = KYOKU.substring(0, 2);
				KYOKU_ID = KYOKU.substring(2);
			}
			ResultSet rs = new BatchDBConnectionUtil()
					.executeQuery("SELECT * FROM KYOKUSYO WHERE KEN_ID = "
							+ KEN_ID + " AND KYOKU_ID = '" + KYOKU_ID);

			ActionErrors errors = new ActionErrors();

			try {
				if (rs.next()) {

					errors.add("errors", new ActionError(
							"KyokusyoInput.db.KYOKU_ID.is.error"));

				} else {

					new BatchDBConnectionUtil()
							.executeUpdate("INSERT INTO KYOKUSYO VALUES("
									+ KEN_ID + ",'" + KYOKU_ID + "',"
									+ ZIPCD_MAE + "," + ZIPCD_ATO + ",'"
									+ KYOKUSYO_MEI + "','" + JUSYO + "','"
									+ TEL + "','" + PASSWORD + "',"
									+ INSERT_DATE + "," + UPDATE_DATE + ")");
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}

			saveErrors(request, errors);
		}
		return mapping.findForward("go_KyokusyoInput");
	}
}