package xg.action;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import xg.uitl.*;
import java.sql.*;
/**
* MyEclipse Struts
* Creation date: 08-21-2012
*
* XDoclet definition:
* @struts.action path="/serachStaff" name="serachStaffForm" input="/jsp/serach_staff.jsp" scope="request" validate="true"
* @struts.action-forward name="error" path="/jsp/error.jsp"
* @struts.action-forward name="success" path="/jsp/search_staff.jsp"
*/
public class SerachStaffAction extends Action {
/*
* Generated Methods
*/
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
DynaActionForm serachStaffForm = (DynaActionForm) form;// TODO Auto-generated method stub
String staffId1 = (String)(serachStaffForm.get("staff_id"));
String staffName1 = (String)serachStaffForm.get("staff_name");
String staffSex1 = (String)serachStaffForm.get("staff_sex");
String staffAge1 = (String)(serachStaffForm.get("staff_age"));
String departName1= (String)(serachStaffForm.get("depart_name"));
String positionName1 = (String)(serachStaffForm.get("position_name"));
try
{ String staffId = new String(staffId1.getBytes("ISO8859-1"), "gb2312");
String staffName = new String(staffName1.getBytes("ISO8859-1"), "gb2312");
String staffSex = new String(staffSex1.getBytes("ISO8859-1"), "gb2312");
String staffAge = new String(staffAge1.getBytes("ISO8859-1"), "gb2312");
String departName = new String(departName1.getBytes("ISO8859-1"), "gb2312");
String positionName = new String(positionName1.getBytes("ISO8859-1"), "gb2312");
if(null == staffId || staffId.equals(""))
{
staffId="%";
}
else
{
//staffId="%"+staffId+"%";
}
if(null == staffName || staffName.equals(""))
{
staffName="%";
}
else
{
staffName="%"+staffName+"%";
}
if(null == staffSex || staffSex.equals(""))
{
staffSex="%";
}
else
{
staffSex="%"+staffSex+"%";
}
if(null == staffAge || staffAge.equals(""))
{
staffAge="%";
}
else
{
//staffAge="%"+staffAge+"%";
}
if(null == departName || departName.equals(""))
{
departName="%";
}
else
{
departName="%"+departName+"%";
}
if(null == positionName || positionName.equals(""))
{
positionName="%";
}
else
{
positionName="%"+positionName+"%";
}
String sql ="SELECT a.nStaff_id,a.cStaff_name,a.cStaff_sex,a.nStaff_age,b.cDepart_name,c.cPosition_name FROM tb_staff AS a INNER JOIN tb_department AS b ON a.nDepart_id = b.nDepart_id INNER JOIN tb_position AS c ON a.nPosition_id = c.nPosition_id WHERE a.nStaff_id LIKE '"+staffId+"' AND a.cStaff_name LIKE '"+staffName+"' AND a.cStaff_sex LIKE '"+staffSex+"' AND a.nStaff_age LIKE '"+staffAge+"' AND b.cDepart_name LIKE '"+departName+"' AND c.cPosition_name LIKE '"+positionName+"'";
ResultSet rs = AdminLogin.DB.query(sql);
request.setAttribute("staff_info", rs);
return mapping.findForward("success");
}
catch(Exception e)
{
return mapping.findForward("error");
}
}
}
AA.rar_jdbc crud_jdbc多张表项目_structs1_项目管理
版权申诉
94 浏览量
2022-09-23
12:23:54
上传
评论
收藏 11.58MB RAR 举报
AA.rar_jdbc crud_jdbc多张表项目_structs1_项目管理 （126个子文件） 
UpDateAction.class 4KB Add_StaffAction.class 4KB SerachStaffAction.class 3KB Add_DepartAction.class 3KB DepartUpdateAction.class 3KB ConnDb.class 3KB SearchDepartAction.class 3KB LoginAction.class 2KB BeforeUpDateAction.class 2KB Depart_StaffAction.class 2KB Staff_infoAction.class 2KB Depart_BefoeUpdateAction.class 2KB Depart_infoAction.class 2KB AdminLogin.class 2KB DepartDeleteAction.class 2KB DeleteAction.class 2KB All_depart_infoAction.class 1KB All_staff_infoAction.class 1KB LogoutAction.class 1KB .classpath 4KB
aspectjweaver.jar 1.79MB jasperreports-1.3.4.jar 1.61MB itext-1.3.jar 1.08MB freemarker.jar 795KB poi-2.5.1.jar 783KB c3p0-0.9.1.1.jar 594KB jxl.jar 590KB struts.jar 537KB mysql-connector-java-3.1.10-bin.jar 409KB velocity-1.5.jar 384KB spring-beans.jar 381KB log4j-1.2.14.jar 359KB cglib-nodep-2.1_3.jar 315KB spring-aop.jar 302KB spring-webmvc.jar 278KB commons-httpclient.jar 271KB commons-lang.jar 237KB spring-jdbc.jar 222KB spring-core.jar 179KB spring-context.jar 158KB spring-web.jar 149KB spring-dao.jar 128KB jotm.jar 121KB commons-dbcp.jar 118KB spring-portlet.jar 115KB aspectjrt.jar 114KB spring-hibernate3.jar 105KB velocity-tools-view-1.3.jar 105KB spring-jpa.jar 96KB xapool.jar 89KB commons-io.jar 82KB persistence.jar 71KB jakarta-oro-2.0.8.jar 63KB spring-jdo.jar 61KB spring-toplink.jar 57KB cos.jar 55KB commons-fileupload.jar 53KB commons-logging.jar 52KB commons-codec.jar 46KB commons-attributes-api.jar 36KB asm-util-2.2.3.jar 35KB asm-2.2.3.jar 35KB commons-attributes-compiler.jar 29KB spring-struts.jar 25KB spring-ibatis.jar 24KB portlet-api.jar 15KB asm-commons-2.2.3.jar 15KB spring-tomcat-weaver.jar 5KB aopalliance.jar 5KB spring-agent.jar 2KB SerachStaffAction.java 3KB Add_StaffAction.java 3KB UpDateAction.java 3KB ConnDb.java 2KB SearchDepartAction.java 2KB Add_DepartAction.java 2KB DepartUpdateAction.java 2KB LoginAction.java 2KB BeforeUpDateAction.java 1KB Depart_StaffAction.java 1KB Staff_infoAction.java 1020B Depart_infoAction.java 934B Depart_BefoeUpdateAction.java 873B AdminLogin.java 848B All_staff_infoAction.java 670B DepartDeleteAction.java 668B DeleteAction.java 653B All_depart_infoAction.java 635B LogoutAction.java 531B add_staff.jsp 2KB search_staff.jsp 2KB left.jsp 2KB update_staff.jsp 2KB login.jsp 2KB search_depart.jsp 1KB update_depart.jsp 1KB all_depart_info.jsp 1KB all_staff_info.jsp 1KB staff_info.jsp 1KB add_depart.jsp 1KB共 126 条
- 1
- 2
资源评论
