📄 statcomcertservlet.java
字号:
// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name: StatComCertServlet.java
package personaladmin.statistic;
import common.*;
import java.io.*;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.*;
// Referenced classes of package personaladmin.statistic:
// StatComCertDBBean
public class StatComCertServlet extends ParentServlet
{
public StatComCertServlet()
{
}
public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
{
try
{
StatComCertDBBean statcomcertdbbean = new StatComCertDBBean();
ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
DateTimeBean datetimebean = new DateTimeBean();
String s = httpservletrequest.getParameter("inputString");
Vector vector = parseinputstringbean.parseCommonFormatIS(s);
String s1 = (String)vector.elementAt(0);
Vector vector1 = (Vector)getServletContext().getAttribute("Para");
statcomcertdbbean.setUserID((String)vector1.elementAt(0));
statcomcertdbbean.setPassword((String)vector1.elementAt(1));
statcomcertdbbean.setURL((String)vector1.elementAt(2));
statcomcertdbbean.setDriver((String)vector1.elementAt(3));
statcomcertdbbean.setDataSourceName((String)vector1.elementAt(4));
statcomcertdbbean.setDelFlag("0");
try
{
statcomcertdbbean.initialize();
}
catch(Exception exception1)
{
throw exception1;
}
statcomcertdbbean.setCertName(s1);
statcomcertdbbean.setTableName("certinfo");
statcomcertdbbean.setSelectSQL02("SELECT NUMBER,CERTNAME,PRINCIPAL,ISSUEDATE,ISSUEDEPT,ISSUEADRESS,LINKTEL,LINKMAN,BEGINDATE,ENDDATE,REMARK FROM " + statcomcertdbbean.getTableName() + " WHERE CERTNAME = ? AND DELFLAG = ? order by number desc");
try
{
statcomcertdbbean.select02();
statcomcertdbbean.getDataFromResult02();
statcomcertdbbean.setOpcontent("统计公司证照台账");
HttpSession httpsession = httpservletrequest.getSession(false);
statcomcertdbbean.setOperator((String)httpsession.getValue("persname"));
statcomcertdbbean.setOpdate(datetimebean.getDate());
statcomcertdbbean.setOptime(datetimebean.getTime());
statcomcertdbbean.insertLog();
statcomcertdbbean.commitToDB();
}
catch(Exception exception3)
{
throw new Exception(exception3.getMessage());
}
finally
{
statcomcertdbbean.releaseConnection();
}
String s2 = getServletConfig().getServletContext().getRealPath("/personaladmin/statistic/");
String s3 = s2 + "StatComCertResults.html";
PrintWriter printwriter = new PrintWriter(new FileWriter(s3));
printwriter.println("<html>");
printwriter.println("<head>");
printwriter.println("<title>");
printwriter.println("光大花园物业管理系统人事行政");
printwriter.println("</title>");
printwriter.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">");
printwriter.println("</head>");
printwriter.println("<body>");
printwriter.println("<table>");
printwriter.println("<tr><td>公司各类证件台账</td></tr>");
printwriter.println("<tr><td>证照名称:" + s1 + "</td><td></td><td></td><td></td><td></td><td></td><td></td><td>统计时间:" + datetimebean.getDate() + " " + datetimebean.getTime() + "</td></tr>");
printwriter.println("<td>年审负责人</td>");
printwriter.println("<td>发证日期</td>");
printwriter.println("<td>发证部门</td>");
printwriter.println("<td>发证部门地址</td>");
printwriter.println("<td>联系电话</td>");
printwriter.println("<td>联系人</td>");
printwriter.println("<td>有效期</td>");
printwriter.println("<td>备注</td>");
printwriter.println("</tr>");
for(int i = 0; i < statcomcertdbbean.vprincipal.size(); i++)
{
printwriter.println("<tr>");
printwriter.println("<td>" + (String)statcomcertdbbean.vprincipal.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vissuedate.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vissuedept.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vissueadress.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vlinktel.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vlinkman.elementAt(i) + "</TD>");
printwriter.println("<td>自" + (String)statcomcertdbbean.vbdate.elementAt(i) + "到" + (String)statcomcertdbbean.vedate.elementAt(i) + "</TD>");
printwriter.println("<td>" + (String)statcomcertdbbean.vremark.elementAt(i) + "</TD>");
printwriter.println("<td></TD>");
printwriter.println("</tr>");
}
printwriter.println("</table>");
printwriter.println("</body>");
printwriter.println("</html>");
printwriter.flush();
printwriter.close();
RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/personaladmin/statistic/StatComCertResults.exe");
requestdispatcher1.forward(httpservletrequest, httpservletresponse);
}
catch(Throwable _ex)
{
try
{
RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
requestdispatcher.forward(httpservletrequest, httpservletresponse);
}
catch(Exception exception)
{
System.out.println(exception.getMessage());
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -