sqlquery.jsp

国外的一套开源CRM

<%@ page import="org.ofbiz.entity.*" %>
<%@ page import="org.ofbiz.entity.model.*" %>
<%@ page import="com.sourcetap.sfa.security.*" %>
<%@ page import="com.sourcetap.sfa.report.*" %>
<%@ page import="com.sourcetap.sfa.sql.*" %>

<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>

<%@ include file="/includes/header.jsp" %>

<table width="100%" class="tabularSectionDisplayTable" ><tr><td>Results</td></tr></table>
<%String sql = request.getParameter("sql");%>
<%  
  out.write( "SQL: " + sql );
  HashMap specCellMap = new HashMap();
  specCellMap.put("6", "<td align=\"right\"> ");

  Report oppReport = new Report();
  oppReport.setTableString("<table class=\"tabularSectionDisplayTable\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n");
  oppReport.setCellHeaderString("<td class=\"tabularSectionBlankLabel\">");
  oppReport.setSpecificCellBodyString(specCellMap);
  oppReport.setTableBodyString("<tbody>\n ");
  Vector colsToSum = new Vector();
  colsToSum.add(new Integer(6));
  oppReport.setColumnsToSum(colsToSum);
  out.write( ReportBuilder.getReportTableHTML(sql, oppReport, delegator ));

%>