kyokusyosearchaction.java

用strutshibernate做的项目

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

package com.dut.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;
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.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.logic.db.Kyokusyo;
import com.dut.logic.logic.KyoukusyoLogic;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.KyokusyoUpdateActionForm;

/**
 * MyEclipse Struts Creation date: 04-17-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/kyokusyoSearch" name="kyokusyoUpdateActionForm"
 *                scope="request" validate="true"
 */
public class KyokusyoSearchAction extends Action {

	// --------------------------------------------------------- Instance
	// Variables

	// --------------------------------------------------------- Methods

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		KyokusyoUpdateActionForm kyokusyoUpdateActionForm = (KyokusyoUpdateActionForm) form;
		ActionForward forward = new ActionForward();
		String w = ShujuyilanAction.W();
		if (request.getParameter("name") != null) {
			String ss = StringUtil.trans(request.getParameter("name"));

			if (ss.equals("xiaochu")) {
				ArrayList list2 = new ArrayList();
				System.out.println("aaaaaaaaaa");
				String ky1 = (String) request.getParameter("ky");
				System.out.println("bbbbbb" + ky1);
				String ky = StringUtil.trans(ky1);
				BatchDBConnectionUtil yy = new BatchDBConnectionUtil();
				ResultSet rs = yy
						.executeQuery("select * from kyokusyo where KYOKU_ID='"
								+ ky + "'");
				
				System.out.println("cccccccc");
				try {
					while (rs.next()) {
						System.out.println("dddddd");
						int ken=rs.getInt("ken_id");
						String kyy = StringUtil.trans_date(rs
								.getString("KYOKU_ID"));
						String kym = StringUtil.trans_date(rs
								.getString("KYOKUSYO_MEI"));
						int zm = rs.getInt("ZIPCD_MAE");
						int za = rs.getInt("ZIPCD_ato");

						String jy = StringUtil
								.trans_date(rs.getString("JUSYO"));
						String tel = StringUtil.trans_date(rs.getString("TEL"));
						Kyokusyo kk = new Kyokusyo();
						kk.setKyoku_id(ky);
						kk.setKen_id(ken);
						kk.setKyokusyo_mei(kym);
						kk.setZipcd_ato(za);
						kk.setZipcd_mae(zm);
						kk.setJusyo(jy);
						kk.setTel(tel);
						list2.add(kk);

					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				request.getSession().setAttribute("list2", list2);
				System.out.println("list2>>>>>"+list2);
				forward = mapping.findForward("KyokusyoDeleteConf");

			} else {
				String ky1 = (String) request.getParameter("ky");
				String ky = StringUtil.trans(ky1);
				BatchDBConnectionUtil yy = new BatchDBConnectionUtil();
				ResultSet rs = yy
						.executeQuery("select * from kyokusyo where KYOKU_ID='"
								+ ky + "'");
				ArrayList list1 = new ArrayList();
				try {
					while (rs.next()) {

						String kyy = StringUtil.trans_date(rs
								.getString("KYOKU_ID"));

						String kym = StringUtil.trans_date(rs
								.getString("KYOKUSYO_MEI"));
						int zm = rs.getInt("ZIPCD_MAE");
						int za = rs.getInt("ZIPCD_ato");

						String jy = StringUtil
								.trans_date(rs.getString("JUSYO"));
						String tel = StringUtil.trans_date(rs.getString("TEL"));
						Kyokusyo kk = new Kyokusyo();
						kk.setKyoku_id(ky);
						kk.setKyokusyo_mei(kym);
						kk.setZipcd_ato(za);
						kk.setZipcd_mae(zm);
						kk.setJusyo(jy);
						kk.setTel(tel);
						list1.add(kk);

					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				request.getSession().setAttribute("list1", list1);

				forward = mapping.findForward("KyokusyoUpdateInput");
			}
			if(ss.equals("xiuzheng")){
				String ky1 = (String) request.getParameter("ky");
				String ky=StringUtil.trans(ky1);
			   BatchDBConnectionUtil yy =new BatchDBConnectionUtil();
			   ResultSet rs=yy.executeQuery("select * from kyokusyo where KYOKU_ID='"+ky+"'");
			   ArrayList list1 = new ArrayList();
			   try {
			   while(rs.next())
			    {
				
			     String kyy = StringUtil.trans_date(rs.getString("KYOKU_ID"));
			     System.out.println(" ky ===="+ ky);
			     String kym = StringUtil.trans_date(rs.getString("KYOKUSYO_MEI"));
			     int zm = rs.getInt("ZIPCD_MAE");
			     int za = rs.getInt("ZIPCD_ato");
			     
			     String jy = StringUtil.trans_date(rs.getString("JUSYO"));
			     String tel = StringUtil.trans_date(rs.getString("TEL"));
			     Kyokusyo kk = new  Kyokusyo();
			     kk.setKyoku_id(ky);
			     kk.setKyokusyo_mei(kym);
			     kk.setZipcd_ato(za);
			     kk.setZipcd_mae(zm);
			     kk.setJusyo(jy);
			     kk.setTel(tel);
			     list1.add(kk);
	    	    		     			     
			    }
			  } catch (SQLException e) {
			   // TODO Auto-generated catch block
			   e.printStackTrace();
			  }
			     request.getSession().setAttribute("list1", list1);	
			   
			  ActionForward forward1=mapping.findForward("KyokusyoUpdateInput");
			  return forward1;
			  

				
			}
			
			
			
			
			if (ss.equals("qita")) {
				ArrayList list2 = new ArrayList();
				String ky1 = (String) request.getParameter("ky");
				System.out.println("bbbbbb" + ky1);
				String ky = StringUtil.trans(ky1);
				BatchDBConnectionUtil yy = new BatchDBConnectionUtil();
				ResultSet rs = yy
						.executeQuery("select * from kyokusyo where KYOKU_ID='"
								+ ky + "'");
				
				System.out.println("cccccccc");
				try {
					while (rs.next()) {
						System.out.println("dddddd");
						int ken=rs.getInt("ken_id");
						String kyy = StringUtil.trans_date(rs
								.getString("KYOKU_ID"));
						String kym = StringUtil.trans_date(rs
								.getString("KYOKUSYO_MEI"));
						int zm = rs.getInt("ZIPCD_MAE");
						int za = rs.getInt("ZIPCD_ato");

						String jy = StringUtil
								.trans_date(rs.getString("JUSYO"));
						String tel = StringUtil.trans_date(rs.getString("TEL"));
						Kyokusyo kk = new Kyokusyo();
						kk.setKyoku_id(ky);
						kk.setKen_id(ken);
						kk.setKyokusyo_mei(kym);
						kk.setZipcd_ato(za);
						kk.setZipcd_mae(zm);
						kk.setJusyo(jy);
						kk.setTel(tel);
						list2.add(kk);

					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				request.getSession().setAttribute("list2", list2);	
				forward = mapping.findForward("KyokusyoPassUpdateConf");
			
				
			}
		}
		KyoukusyoLogic gg = new KyoukusyoLogic();
		// int page = gg.getPage();
		if (request.getParameter("link") != null) {
			
			int page = 1;
			int maxpage = 0;

			ArrayList list1 = new ArrayList();
			ActionErrors errors = new ActionErrors();
			
			if (request.getParameter("link").equals("before")) {
				// gg.up();
				System.out.println("page++++" + page);
				KyoukusyoLogic kk = new KyoukusyoLogic();

				if (page <= 1) {
					System.out.println("page++++" + page);
					errors.add("message", new ActionError("up"));
					saveErrors(request, errors);
					return (new ActionForward(mapping.getInput()));
				} else {
					int maxRows = kk.getfiednum("select count(*)from Kyokusyo"
							+ w + "", page, 10);
					maxpage = gg.getFiednum(10, maxRows);

					list1 = kk.getCurrentPageData(page, 10, maxRows);
					request.getSession().setAttribute("list1", list1);
					page--;
					ActionForward forward1 = mapping
							.findForward("KyokusyoSearch");

				}

			}
			if (request.getParameter("link").equals("after")) {
				// gg.next();
				KyoukusyoLogic kk = new KyoukusyoLogic();

				if (page > maxpage) {
					errors.add("message", new ActionError("next"));
					saveErrors(request, errors);
					return (new ActionForward(mapping.getInput()));

				} else {
					int maxRows = kk.getfiednum("select count(*)from Kyokusyo"
							+ w + "", page, 10);
					maxpage = gg.getFiednum(10, maxRows);

					list1 = gg.getCurrentPageData(page, 10, maxRows);
					request.getSession().setAttribute("list1", list1);
					page++;
					ActionForward forward1 = mapping
							.findForward("KyokusyoSearch");
				}

			}
		}
		// TODO Auto-generated method stub
		return forward;

	}

}