reportmanager.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.report;

import java.sql.*;
import java.util.*;
import com.sxit.wap.common.*;
import com.sxit.wap.exception.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.sxit.wap.pdf.*;

public class ReportManager {
    public ReportManager() {
    }
	public void makeReport(HttpServletRequest request, HttpServletResponse response){

		//权限验证
		//manager.makeReport(request,response);
		java.sql.Statement statement = null;
		java.sql.Connection conn = null;
		try {
			conn = com.sxit.wap.common.Database.getConnection();
			statement = conn.createStatement ();
			Report report = null;
			java.sql.ResultSet result = null;

			if (  "cpStatReport".equals(( ( String ) request.getParameter ( "reportType" ) ))  ) {
				System.out.println ( "Start report....cpStatReport" );
				report = new CpStatReport ();

				System.out.println ( request.getAttribute ( "date" ) );
				System.out.println ( request.getAttribute ( "cpid" ) );
				System.out.println ( request.getAttribute ( "mdn" ) );
				result = ( ( CpStatReport ) report ).getResult ( statement,
					DateUtil.getTimestamp ( request.getParameter ( "startDate" ) ),
                    DateUtil.getTimestamp ( request.getParameter ( "endDate" ) ),
					( Integer.parseInt ( request.getParameter ( "cpid" ) ) ),
					request.getParameter ( "mdn" ) );
			} else if ( "cpAccoutReport".equals ( ( ( String ) request.getParameter ( "reportType" ) ) ) ) {
				System.out.println("Start report....cpAccoutReport");
				report = new CpAccoutReport ();
				result = ((CpAccoutReport)report).getResult(statement,
					DateUtil.getTimestamp (request.getParameter("startDate")),DateUtil.getTimestamp (request.getParameter("endDate")) )  ;

			}else if ( "cpAccoutDetailReport".equals(( ( String ) request.getParameter ( "reportType" ) )) ){
				System.out.println("Start report....cpAccoutDetailReport");
				report = new CpAccoutDetailReport ();
				result = ((CpAccoutDetailReport)report).getResult(statement,
					DateUtil.getTimestamp (request.getParameter("startDate")) ,
                    DateUtil.getTimestamp (request.getParameter("endDate")) ,
					( Integer.parseInt ( request.getParameter ( "cpid" ) ) ) );
			} else if ( "myCdrReport".equals ( ( ( String ) request.getParameter ( "reportType" ) ) ) ) {
				System.out.println ( "Start report....MyCdrReport" );
				report = new MyCdrReport ();
				result = ( ( MyCdrReport ) report ).getResult ( statement,
					 DateUtil.getTimestamp( request.getParameter("startDate") ),
					DateUtil.getTimestamp( request.getParameter("endDate") ),
					 ( ( String) request.getParameter("mdn") ));
			} else {
				System.out.println ( "Start report...null." );
				return;
			}

			Output output = new Output ();
			String[] head = report.getReportHeader();
			System.out.println("Start report....1");
			DBResultSet dbResult = new DBResultSet ( result, head );
			System.out.println("Start report....2");
			dbResult.setTitle(report.getReportTitle());
			output.toPdf ( response, dbResult );
		} catch ( Exception ex ) {
			ex.printStackTrace();
		} finally {
			try {
				statement.close ();
			} catch ( Exception e1 ) {
			}
			try {
				conn.close ();
			} catch ( Exception e2) {
			}

		}

	}
}