reportbuilder.java

国外的一套开源CRM

                                } else {
                                    doubleSumValue = doubleSumValue + 0.0;
                                }

                                sumList.add(i,
                                    Double.valueOf(String.valueOf(
                                            doubleSumValue)));
                            }

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                DecimalFormat frmt = (DecimalFormat) specificCellBodyFormat.get(String.valueOf(
                                            i));
                                returnString.append(frmt.format(
                                        resultSet.getDouble(i)));
                            } else {
                                returnString.append(String.valueOf(
                                        resultSet.getDouble(i)));
                            }

                            break;

                        case Types.DATE:

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                DateFormat frmt = (DateFormat) specificCellBodyFormat.get(String.valueOf(
                                            i));
                                returnString.append(frmt.format(
                                        resultSet.getDate(i)));
                            } else {
                                returnString.append(String.valueOf(
                                        resultSet.getDate(i)));
                            }

                            break;

                        case Types.DECIMAL:

                            if ((sumColumns != null) &&
                                    sumColumns.contains(Integer.valueOf(
                                            String.valueOf(i)))) {
                                doubleSumValue = resultSet.getDouble(i);

                                if (String.valueOf(sumList.get(i)).trim()
                                              .length() >= 1) {
                                    doubleSumValue = doubleSumValue +
                                        Double.valueOf(String.valueOf(
                                                sumList.get(i))).doubleValue();
                                } else {
                                    doubleSumValue = doubleSumValue + 0.0;
                                }

                                sumList.add(i,
                                    Double.valueOf(String.valueOf(
                                            doubleSumValue)));
                            }

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                returnString.append(((Format) specificCellBodyFormat.get(
                                        String.valueOf(i))).format(
                                        resultSet.getString(i)));
                            } else {
                                returnString.append(resultSet.getString(i));
                            }

                            break;

                        case Types.LONGVARCHAR:

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                returnString.append(((Format) specificCellBodyFormat.get(
                                        String.valueOf(i))).format(
                                        resultSet.getString(i)));
                            } else {
                                returnString.append(resultSet.getString(i));
                            }

                            break;

                        case Types.NULL:
                            returnString.append(" ");

                            break;

                        case Types.NUMERIC:

                            if ((sumColumns != null) &&
                                    sumColumns.contains(Integer.valueOf(
                                            String.valueOf(i)))) {
                                doubleSumValue = resultSet.getDouble(i);

                                if (String.valueOf(sumList.get(i)).trim()
                                              .length() >= 1) {
                                    doubleSumValue = doubleSumValue +
                                        Double.valueOf(String.valueOf(
                                                sumList.get(i))).doubleValue();
                                } else {
                                    doubleSumValue = doubleSumValue + 0.0;
                                }

                                sumList.add(i,
                                    Double.valueOf(String.valueOf(
                                            doubleSumValue)));
                            }

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                returnString.append(((Format) specificCellBodyFormat.get(
                                        String.valueOf(i))).format(
                                        resultSet.getString(i)));
                            } else {
                                returnString.append(resultSet.getString(i));
                            }

                            break;

                        case Types.TIMESTAMP:

                            if ((specificCellBodyFormat != null) &&
                                    specificCellBodyFormat.containsKey(
                                        String.valueOf(i))) {
                                returnString.append(((Format) specificCellBodyFormat.get(
                                        String.valueOf(i))).format(
                                        resultSet.getString(i)));
                            } else {
                                returnString.append((resultSet.getString(i)));
                            }

                            break;

                        default:
                            returnString.append(resultSet.getString(i));

                            break;
                        }
                    } else {
                        returnString.append(" ");
                    }

                    returnString.append("</td>\n");
                }

                returnString.append("</tr>\n");
            }

            //prepare sum row
            if (sumList != null) {
                returnString.append(r.getRowBodyString());

                for (i = 1; i <= rptCols; i++) {
                    if ((specificCellBodyString != null) &&
                            specificCellBodyString.containsKey(String.valueOf(i))) {
                        returnString.append(specificCellBodyString.get(
                                String.valueOf(i)));
                    } else {
                        returnString.append(r.getCellBodyString());
                    }

                    if ((sumList.get(i) != null) ||
                            (String.valueOf(sumList.get(i)).trim().length() >= 1)) {
                        returnString.append(String.valueOf(sumList.get(i)));
                    } else {
                        returnString.append("&nbsp;");
                    }

                    returnString.append("</td>");
                }

                returnString.append("</tr>");
            }

            returnString.append("</tbody>\n");
            returnString.append("</table>\n");
        } catch (SQLException e) {
            Debug.logError(e.getMessage(), module);

            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            e.printStackTrace(new PrintWriter(baos));
            Debug.logError(new String(baos.toByteArray()), module);
        } catch (Exception e) {
            e.printStackTrace();
            Debug.logError(e.getMessage(), module);

            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            e.printStackTrace(new PrintWriter(baos));
            Debug.logError(new String(baos.toByteArray()), module);
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }

                if (preparedStatement != null) {
                    preparedStatement.close();
                }

                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                Debug.logError(e.getMessage(), module);

                ByteArrayOutputStream baos = new ByteArrayOutputStream();
                e.printStackTrace(new PrintWriter(baos));
                Debug.logError(new String(baos.toByteArray()), module);
            }
        }

        return returnString.toString();
    }

    /**
     * DOCUMENT ME!
     *
     * @param wholeString 
     * @param token 
     * @param replaceString 
     *
     * @return 
     */
    private static String replace(String wholeString, String token,
        String replaceString) {
        StringBuffer sb = new StringBuffer(wholeString);

        if (wholeString.indexOf(token) >= 1) {
            sb.replace(wholeString.indexOf(token),
                (wholeString.indexOf(token) + token.length()), replaceString);

            return sb.toString();
        } else {
            return wholeString;
        }
    }
}