开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
address_list_export.jsp
资源名称：NetOffice.rar　[点击查看]
上传用户：guhaomin
上传日期：2007-06-10
资源大小：23203k
文件大小：8k
源码类别：

电子政务应用

开发平台：

Java

address_list_export.jsp：源码内容
  1. <%@ page errorPage="/vnex/ErrorPage.jsp" %>
  2. <%@ page import="com.vnex.intranet.addresslist.value.*"%>
  3. <%@ page import="com.vnex.intranet.addresslist.proxy.*"%>
  4. <%@ page import="com.vnex.intranet.system.loader.ConfigParaLoader"%>
  5. <%@ page import="com.vnex.intranet.util.*"%>
  6. <%@ page import="java.util.*" %>
  7. <%@ page import="java.sql.*" %>
  8. <%@ page import="java.io.*" %>
  10. <jsp:useBean id="addressProxy" class="com.vnex.intranet.addresslist.proxy.AddressProxyBean" scope="application" />
  11. <jsp:useBean id="BusinessName" scope="session" class="com.vnex.intranet.pub.BusinessSession" />
  13. <%
  15.   String contactName = "";
  16.   String nickName = "";
  17.   String birthday = "";
  18.   String gender = "";
  19.   String emailAddress = "";
  20.   String anotherEmail = "";
  21.   String personalUrl = "";
  22.   String oicqNum = "";
  23.   String pagerNum = "";
  24.   String mobileNum = "";
  25.   String homeAddress = "";
  26.   String homePC = "";
  27.   String homeTeleNum = "";
  28.   String unit = "";
  29.   String position = "";
  30.   String unitAddress = "";
  31.   String unitTeleNum = "";
  32.   String unitPC = "";
  33.   String unitFaxNum = "";
  34.   String notes = "";
  35.   
  36.   FileWriter resultsFile = null;
  37.   String root = ConfigParaLoader.getParameter("rootUrl");
  38.       
  39.   if( request.getParameter("export")!=null && request.getParameter("export").equals("ok") )
  40.   {
  41.     
  42.     try
  43.     {
  44.       int empId = BusinessName.getEmpId();
  45.       Collection coll = null;
  46.       String condition = " where emp_id="+empId;;
  48.       coll = addressProxy.getContactList(condition);
  49.       AddresslistValueBean alvb = null;
  50.       
  51.       //是否目录存在
  52.       File f = new File(root+"\CSVFile\");
  53.       if(!f.isDirectory())
  54.       {
  55.         f.mkdir();
  56.       }
  57.       
  58.       resultsFile = new FileWriter(root+"\CSVFile\NetOffice"+BusinessName.getEmpId()+".csv");
  59.       PrintWriter toFile = new PrintWriter(resultsFile);
  60.       toFile.println(""姓名","昵称","生日","性别","电子邮件地址","备用邮件地址","个人 Web 页","OICQ","寻呼机","移动电话","家庭地址","家庭所在地的邮政编码","家庭电话","工作单位","职务","单位地址","单位电话","单位邮编","单位传真","备注"");
  61.       
  62.       if(coll != null && coll.size() != 0)
  63.       {
  64.         Iterator it = coll.iterator();
  65.         while( it.hasNext() )
  66.         {
  67.           alvb = (AddresslistValueBean)it.next();
  68.           
  69.           if(alvb.getContactName()!=null)
  70.             contactName = alvb.getContactName();
  71.           if(alvb.getNickName()!=null)
  72.             nickName = alvb.getNickName();
  73.           if(alvb.getBirthday()!=null)
  74.           {
  75.             Timestamp tt = TimeStamp.convertCalendarToTimestamp(alvb.getBirthday());
  76.             birthday = MyDateFormat.myDate(tt);
  77.           }
  78.           if(alvb.getGender()==0)
  79.             gender = "男";
  80.           if(alvb.getGender()==1)
  81.             gender = "女";
  82.           if(alvb.getEmailAddress()!=null)
  83.             emailAddress = alvb.getEmailAddress();
  84.           if(alvb.getAnotherEmail()!=null)
  85.             anotherEmail = alvb.getAnotherEmail();
  86.           if(alvb.getPersonalUrl()!=null)
  87.             personalUrl = alvb.getPersonalUrl();
  88.           if(alvb.getOicqNum()!=null)
  89.             oicqNum = alvb.getOicqNum();
  90.           if(alvb.getPagerNum()!=null)
  91.             pagerNum = alvb.getPagerNum();
  92.           if(alvb.getMobileNum()!=null)
  93.             mobileNum = alvb.getMobileNum();
  94.           if(alvb.getHomeAddress()!=null)
  95.             homeAddress = alvb.getHomeAddress();
  96.           if(alvb.getHomePC()!=null)
  97.             homePC = alvb.getHomePC();
  98.           if(alvb.getHomeTeleNum()!=null)
  99.             homeTeleNum = alvb.getHomeTeleNum();
  100.           if(alvb.getUnit()!=null)
  101.             unit = alvb.getUnit();
  102.           if(alvb.getPosition()!=null)
  103.             position = alvb.getPosition();
  104.           if(alvb.getUnitAddress()!=null)
  105.             unitAddress = alvb.getUnitAddress();
  106.           if(alvb.getUnitTeleNum()!=null)
  107.             unitTeleNum = alvb.getUnitTeleNum();
  108.           if(alvb.getUnitPC()!=null)
  109.             unitPC = alvb.getUnitPC();
  110.           if(alvb.getUnitFaxNum()!=null)
  111.             unitFaxNum = alvb.getUnitFaxNum();
  112.           if(alvb.getNotes()!=null)
  113.             notes = alvb.getNotes();
  114.         
  115.           toFile.println("""+contactName+"",""+nickName+"","+
  116.                          """+birthday+"",""+gender+"","+
  117.                          """+emailAddress+"",""+anotherEmail+"","+
  118.                          """+personalUrl+"",""+oicqNum+"","+
  119.                          """+pagerNum+"",""+mobileNum+"","+
  120.                          """+homeAddress+"",""+homePC+"","+
  121.                          """+homeTeleNum+"",""+unit+"","+
  122.                          """+position+"",""+unitAddress+"","+
  123.                          """+unitTeleNum+"",""+unitPC+"","+
  124.                          """+unitFaxNum+"",""+notes+""");
  125.           
  126.           contactName = "";
  127.           nickName = "";
  128.           birthday = "";
  129.           gender = "";
  130.           emailAddress = "";
  131.           anotherEmail = "";
  132.           personalUrl = "";
  133.           oicqNum = "";
  134.           pagerNum = "";
  135.           mobileNum = "";
  136.           homeAddress = "";
  137.           homePC = "";
  138.           homeTeleNum = "";
  139.           unit = "";
  140.           position = "";
  141.           unitAddress = "";
  142.           unitTeleNum = "";
  143.           unitPC = "";
  144.           unitFaxNum = "";
  145.           notes = "";
  146.         }
  147.       }
  148.       resultsFile.close();
  149.       
  150.     }
  151.     catch(Exception e)
  152.     {
  153.       System.out.println("e:"+e);
  154.     }
  155.   }
  156. %>
  158. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  159. <HTML>
  161. <jsp:include page="/vnex/page/FORM_HEAD.jsp" />
  163. <BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
  164. <script language="javascript" src="/vnex/validate.js" ></script>
  165. <script language="JavaScript">
  166. function exportt()
  167. {
  168.   document.myform.action = "/mainctrl/addressbook/export?export=ok";
  169.   document.myform.submit();
  170. }
  171. </script>
  172. <script language="JavaScript1.2" src="/vnex/menu/dockmenu_person.js"></script>
  173. <script language="JavaScript" src="/vnex/menu/dockmenu.js"></script>
  176. <DIV align=center>
  177. <form name="myform" method="post" action="">
  178.   <TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
  179.     <jsp:include page="/vnex/page/TTOA_TABLE_TOP.jsp" />
  180.     <TR>
  181.         <TD colSpan=3 align="center"><br>
  182.           <table width="600" border="1" cellspacing="1" bordercolor="#666666">
  183.             <tr> 
  184.               <td align="center" colspan="2" bgcolor="#FFFFFF"> 
  185.                 <table width="600" border="0" cellspacing="0" cellpadding="0">
  186.                   <tr bgcolor="#666666"> 
  187.                       <td colspan="2"><font class="strongw"><a href="/mainctrl/home/index"><font color="#ffffff">主页</font></a>&gt;&gt;<a href="/mainctrl/personal/main"><font color="#ffffff">个人办公</font></a>&gt;&gt;<a href="/mainctrl/addressbook/home"><font color="#ffffff">个人通讯录</font></a>&gt;&gt;导出</font>
  188.                       </td>
  189.                   </tr>
  190.                 </table>
  191.                 <table class=title border="0" cellpadding="2" cellspacing="1" width="600">
  192.               <tr bgcolor="#e0e0e0">
  193.                 <td width="15%"><strong>&nbsp;说明：</strong></td> 
  194.                 <td> 
  195.                 <a href="/mainctrl/addressbook/help"><font color="#0000FF">导入导出说明</font></a>
  196. <%
  197.   if( request.getParameter("export")!=null && request.getParameter("export").equals("ok") )
  198.   {
  199. %>
  200. <a href="/CSVFile/NetOffice<%= BusinessName.getEmpId()%>.csv" target="_blank"><font color="#0000FF">NetOffice.csv</font></a>
  201. <%
  202.   }
  203. %>
  204.              </td>
  205.              <tr bgcolor="#fafafa" height="30">
  206.                <td colspan="2" align="center">
  207.                  <input type="button" name="Button2" value="导出" onClick="exportt()" class="text">&nbsp;&nbsp;
  208.                  <input type="button" name="Button3" value="返回" onClick="location='/mainctrl/addressbook/home'" class="text">     
  209.                  </td>
  210.               </tr>
  211.            </table>
  212.                </td>
  213.             </tr>
  214.           </table>
  215.           <jsp:include page="/vnex/page/TTOA_HELP.jsp" />
  216.        </TD>
  217.       </TR>
  218.       <jsp:include page="/vnex/page/TTOA_TABLE_BOTTOM.jsp" />
  219.    </TABLE>
  220.     <br>
  221.   <jsp:include page="/vnex/page/TTOA_PRODUCER_LOGO.jsp" />
  222. </form></DIV>
  223. </BODY></HTML>