package com.mrmis.confirm;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.Action;
import java.sql.*;
import com.mrmis.util.*;
public class ConfirmAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
Connection conn=null;
Statement pstmt=null;
ResultSet rs=null;
DBUtil dbutil=new DBUtil();
String sql="";
ConfirmForm confirmForm=(ConfirmForm)form;
String pre_num=confirmForm.getPre_num();
String password=confirmForm.getPassword();
String kind=confirmForm.getKind();
try
{
conn=dbutil.getConnection();
if(kind.equals("结婚"))
{
sql="select * from PREMARRY where Pre_Num=\'"+pre_num+"\' and password=\'"+password+"\'";
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
if(rs.next())
{
String man_name=rs.getString("Man_Name");
String woman_name=rs.getString("Woman_Name");
String man_birth_date=rs.getString("Man_Birth_Date");
String woman_birth_date=rs.getString("Woman_Birth_Date");
String man_id_card=rs.getString("Man_Id_Card");
String woman_id_card=rs.getString("Woman_Id_Card");
String man_nation_name=rs.getString("Man_Nation_Name");
String woman_nation_name=rs.getString("Woman_Nation_Name");
String man_nationlity_name=rs.getString("Man_Nationlity_Name");
String woman_nationlity_name=rs.getString("Woman_Nationlity_Name");
String man_marital_status=rs.getString("Man_Marital_Status");
String woman_marital_status=rs.getString("Woman_Marital_Status");
String man_culture_name=rs.getString("Man_Culture_Name");
String woman_culture_name=rs.getString("Woman_Culture_Name");
String man_career_name=rs.getString("Man_Career_Name");
String woman_career_name=rs.getString("Woman_Career_Name");
String man_residence=rs.getString("Man_Residence");
String woman_residence=rs.getString("Woman_Residence");
request.setAttribute("man_name", man_name);
request.setAttribute("woman_name", woman_name);
request.setAttribute("man_birth_date", man_birth_date);
request.setAttribute("woman_birth_date", woman_birth_date);
request.setAttribute("man_id_card", man_id_card);
request.setAttribute("woman_id_card", woman_id_card);
request.setAttribute("man_nation_name", man_nation_name);
request.setAttribute("woman_nation_name", woman_nation_name);
request.setAttribute("man_nationlity_name", man_nationlity_name);
request.setAttribute("woman_nationlity_name", woman_nationlity_name);
request.setAttribute("man_marital_status", man_marital_status);
request.setAttribute("woman_marital_status", woman_marital_status);
request.setAttribute("man_culture_name", man_culture_name);
request.setAttribute("woman_culture_name", woman_culture_name);
request.setAttribute("man_career_name",man_career_name);
request.setAttribute("woman_career_name",woman_career_name);
request.setAttribute("man_residence", man_residence);
request.setAttribute("woman_residence", woman_residence);
}
return mapping.findForward("marry");
}
else if(kind.equals("离婚"))
{
sql="select * from PREUNMARRY where Pre_Num=\'"+pre_num+"\' and password=\'"+password+"\'";
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
if(rs.next())
{
String man_name=rs.getString("Man_Name");
String woman_name=rs.getString("Woman_Name");
String man_birth_date=rs.getString("Man_Birth_Date");
String woman_birth_date=rs.getString("Woman_Birth_Date");
String man_id_card=rs.getString("Man_Id_Card");
String woman_id_card=rs.getString("Woman_Id_Card");
String man_nation_name=rs.getString("Man_Nation_Name");
String woman_nation_name=rs.getString("Woman_Nation_Name");
String man_nationlity_name=rs.getString("Man_Nationlity_Name");
String woman_nationlity_name=rs.getString("Woman_Nationlity_Name");
String man_culture_name=rs.getString("Man_Culture_Name");
String woman_culture_name=rs.getString("Woman_Culture_Name");
String man_career_name=rs.getString("Man_Career_Name");
String woman_career_name=rs.getString("Woman_Career_Name");
String man_unmarry_reason=rs.getString("Man_Unmarry_Reason");
String woman_unmarry_reason=rs.getString("Woman_Unmarry_Reason");
String man_residence=rs.getString("Man_Residence");
String woman_residence=rs.getString("Woman_Residence");
String marry_time=rs.getString("Marry_Time");
String marry_cert_code=rs.getString("Marry_Cert_Code");
request.setAttribute("man_name", man_name);
request.setAttribute("woman_name", woman_name);
request.setAttribute("man_birth_date", man_birth_date);
request.setAttribute("woman_birth_date", woman_birth_date);
request.setAttribute("man_id_card", man_id_card);
request.setAttribute("woman_id_card", woman_id_card);
request.setAttribute("man_nation_name", man_nation_name);
request.setAttribute("woman_nation_name", woman_nation_name);
request.setAttribute("man_nationlity_name", man_nationlity_name);
request.setAttribute("woman_nationlity_name", woman_nationlity_name);
request.setAttribute("man_culture_name", man_culture_name);
request.setAttribute("woman_culture_name", woman_culture_name);
request.setAttribute("man_career_name",man_career_name);
request.setAttribute("woman_career_name",woman_career_name);
request.setAttribute("man_unmarry_reason",man_unmarry_reason);
request.setAttribute("woman_unmarry_reason",woman_unmarry_reason);
request.setAttribute("man_residence", man_residence);
request.setAttribute("woman_residence", woman_residence);
request.setAttribute("marry_time", marry_time);
request.setAttribute("marry_cert_code", marry_cert_code);
}
return mapping.findForward("unmarry");
}
else if(kind.equals("撤销"))
{
sql="select * from PREUNDO where Pre_Num=\'"+pre_num+"\' and password=\'"+password+"\'";
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
if(rs.next())
{
String man_name=rs.getString("Man_Name");
String woman_name=rs.getString("Woman_Name");
String man_birth_date=rs.getString("Man_Birth_Date");
String woman_birth_date=rs.getString("Woman_Birth_Date");
String man_id_card=rs.getString("Man_Id_Card");
String woman_id_card=rs.getString("Woman_Id_Card");
String man_nation_name=rs.getString("Man_Nation_Name");
String woman_nation_name=rs.getString("Woman_Nation_Name");
String man_nationlity_name=rs.getString("Man_Nationlity_Name");
String woman_nationlity_name=rs.getString("Woman_Nationlity
web 基于MVC的 婚姻登记系统 （439个子文件） 
MarryBean.class 12KB UnmarryBean.class 12KB UndoBean.class 11KB PreMarryAction.class 10KB MarryAction.class 10KB PreUnmarryBean.class 9KB UnmarryAction.class 9KB PreMarryBean.class 8KB BufaUnmarryBean.class 8KB BufaMarryBean.class 8KB PreUnmarryAction.class 8KB PreUndoBean.class 8KB UndoAction.class 8KB PreUndoAction.class 8KB ConfirmAction.class 8KB PlaceBean.class 7KB DepartmentBean.class 7KB CareerBean.class 7KB PreBufaUnmarryAction.class 7KB PreBufaMarryAction.class 7KB UserBean.class 6KB OperationBean.class 6KB NationlityBean.class 6KB CultureBean.class 6KB NationBean.class 6KB PreUnmarryForm.class 6KB UnmarryForm.class 6KB PreMarryForm.class 5KB PreUndoForm.class 5KB PreBufaUnmarryBean.class 5KB PreBufaMarryBean.class 5KB UndoForm.class 5KB MarryForm.class 5KB StatusBean.class 5KB StaticsNationlityAction.class 4KB StaticsCultureAction.class 4KB StaticsCareerAction.class 4KB StaticsNationAction.class 4KB StaticsReasonAction.class 4KB StaticsStatusAction.class 4KB BufaUnmarryAction.class 3KB BufaMarryAction.class 3KB DepartmentAction.class 3KB UserAction.class 3KB PlaceAction.class 3KB PreBufaUnMarryForm.class 3KB PreBufaMarryForm.class 3KB DepartmentForm.class 3KB BufaUnmarryForm.class 3KB BufaMarryForm.class 3KB PlaceForm.class 3KB CultureForm.class 3KB UserForm.class 3KB NationlityForm.class 3KB NationForm.class 3KB CareerForm.class 3KB NationlityAction.class 3KB LogonAction.class 3KB CultureAction.class 3KB CareerAction.class 3KB NationAction.class 3KB PrePrintForm.class 2KB RegisterForm.class 2KB PrePrintAction.class 2KB RegisterAction.class 2KB PasswordAction.class 2KB OperationAction.class 2KB StaticsNationlityForm.class 2KB StatusForm.class 2KB OperationForm.class 2KB StatusAction.class 2KB PBufaUnmarryAction.class 1KB PDepartmentAction.class 1KB PNationlityAction.class 1KB PasswordForm.class 1KB PBufaMarryAction.class 1KB PCultureAction.class 1KB PUnmarryAction.class 1KB PNationAction.class 1KB PCareerAction.class 1KB PPlaceAction.class 1KB PMarryAction.class 1KB PUserAction.class 1KB PUndoAction.class 1KB Counter.class 1KB SetCharacterEncodingFilter.class 1KB LogonForm.class 1KB DBUtil.class 1KB ConfirmForm.class 1022B StaticsNationlityBean.class 1013B StaticsCultureBean.class 986B StaticsCareerBean.class 977B StaticsReasonBean.class 977B StaticsNationBean.class 977B StaticsStatusBean.class 977B TestAge.class 945B DispatchActionForm.class 309B .classpath 1KB date.css 5KB yellow.css 3KB共 439 条
- 1
- 2
- 3
- 4
- 5
资源评论
