?? kyokusyosearchaction.java
字號:
//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;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -