目录

1 概述

2 数据库表

3 关键代码

4 效果演示

1 概述

外事管理系统是一套信息化的管理软件，是我们通过从网上查找资料，最后针对企业外事管理工作的特点，定制开发的一套针对性的外事管理软件。本系统集涉外处、国际礼宾友好交流处、市友协、侨政处管理于一体，并提供多种方式的统计报表功能，最终设计的一套管理软件。该软件的实现很大程度上的提高了外事工作效率，节约了外事工作的人力和物力。该系统首先对系统进行分析设计，然后完成论文的写作。外事管理系统主要实现了涉外处因公出国管理、签证提请函办理、领事保护；国际礼宾友好交流处外事接待管理、境外非政府组织管理、境外记者采访管理；市友协友协建设、友情工作；侨政处归侨来访管理、登记人简况管理；管理员管理等功能。

2 数据库表

表5 lsbh领事保护

表6 qzyq签证邀请函办理

表7 wsjd外事接待管理

3 关键代码

package servlet.admin;import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Date;
import java.text.SimpleDateFormat;import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.InsertUpdateDelBean;
import bean.SelectBean;
import util.MD5;import util.Validate;public class gqlfServlet extends HttpServlet {/*** Constructor of the object.*/public gqlfServlet() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {Validate vd = new Validate();//打开编辑页面要用的值if(request.getParameter("action")==null){String id = vd.getUnicode(request.getParameter("id"));//if(id==null)id=vd.getUnicode(request.getParameter("ID"));SelectBean ib = new SelectBean();String sql2 = "select * from gqlf where id="+id;String[] args2 = {"id","lfrmc","sex","sf","gzdw","phone","address","jdr","lfdate"};//编辑时取值ArrayList al2 = ib.select(args2,sql2);request.setAttribute("gqlf", al2);	}//保存编辑或新增的表单if(request.getParameter("action")!=null){//String id = vd.getUnicode(request.getParameter("id"));InsertUpdateDelBean ib = new InsertUpdateDelBean();String id = vd.getUnicode(request.getParameter("id"));String lfrmc = vd.getUnicode(request.getParameter("lfrmc"));String sex = vd.getUnicode(request.getParameter("sex"));String sf = vd.getUnicode(request.getParameter("sf"));String gzdw = vd.getUnicode(request.getParameter("gzdw"));String phone = vd.getUnicode(request.getParameter("phone"));String address = vd.getUnicode(request.getParameter("address"));String jdr = vd.getUnicode(request.getParameter("jdr"));String lfdate = vd.getUnicode(request.getParameter("lfdate"));//取得当前的时间//SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//String times = sdf.format(new Date());//  md5加密//				sql = "update admin set userpw='"+MD.MD5(newpsw)+"' where userid='"+id+"'";String ok="";String error="";String alert="";if(request.getParameter("action").equals("save_update")){//保存编辑表单String sql ="update gqlf set lfrmc='"+lfrmc+"',sex='"+sex+"',sf='"+sf+"',gzdw='"+gzdw+"',phone='"+phone+"',address='"+address+"',jdr='"+jdr+"',lfdate='"+lfdate+"' where id='"+id+"'";ib.insertANDupdateANDdel(sql);ok="2";}else if(request.getParameter("action").equals("save_new")){//保存新增表单String sql = "insert into gqlf (lfrmc,sex,sf,gzdw,phone,address,jdr,lfdate)values('"+lfrmc+"','"+sex+"','"+sf+"','"+gzdw+"','"+phone+"','"+address+"','"+jdr+"','"+lfdate+"')";int flag = ib.insertANDupdateANDdel(sql);if(flag == -1){error="1";}else{ok="1";}}if(ok != null && ok.equals("2"))alert="alert('添加成功!');";if(ok != null && ok.equals("1"))alert="alert('添加成功!');";if(error != null && error.equals("1"))alert="alert('添加成功!');";PrintWriter pw = response.getWriter();pw.write("<script language='javascript'>"+vd.getGb2312(alert)+"location.href='/wsglxt/admin/gqlf_manage.jsp';</script>");}}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doGet(request,response);}/*** Initialization of the servlet. <br>** @throws ServletException if an error occure*/public void init() throws ServletException {// Put your code here}}

4 效果演示

idea或eclipse开发,mysql数据库