FusionCharts 拼装 xml

public String getStrXML(String begin, String end) {

        FusionChartsHelper mch = new FusionChartsHelper();

        //String begindate = null;

        //String enddate = null;


        Connection conn = getConnection();
        Map<Integer, String> pms = new HashMap<Integer, String>();
        ResultSet rs = null;
        ResultSet rs2 = null;
        PreparedStatement pstmt = null;
        PreparedStatement pstmt2 = null;

        /*if(begin == null || end == null || "".equals(begin) || "".equals(end)){
            begindate = getBeginDate();
            enddate = getEndDate();
        }else{
            begindate = begin + " 00:00:00";
            enddate = end + " 23:59:59";
        }*/

        String[] types = new String[] { "CORPORATE", "MEET", "PEEP", "RR"};

        StringBuffer strXML = new StringBuffer();
        strXML.append("");
        strXML.append("");

        try {
            pstmt = conn.prepareStatement(getpm);

            rs = pstmt.executeQuery();

            //set the category xml

            while (rs.next()) {
                int pmid = rs.getInt(1);
                String pmname = rs.getString(2);
                pms.put(pmid, pmname);
            }

            Set<Integer> pmset0 = pms.keySet();
            Iterator<Integer> is0 = pmset0.iterator();

            while(is0.hasNext()){
                Integer pmid = is0.next();
                String pmname = pms.get(pmid);
                String category = "";
                strXML.append(category);
            }

            strXML.append("");

            Set<Integer> pmset = pms.keySet();
            Iterator<Integer> is = pmset.iterator();

            int pmcount = pms.size();
            int pmvalue[][] = new int[pmcount][types.length];

            int loopi = 0;

            while (is.hasNext() && loopi < pmcount) {
                int loopj = 0;
                int pmid = is.next();
                pstmt2 = conn.prepareStatement(getdata);
                pstmt2.setString(1, Integer.toString(pmid));
                pstmt2.setString(2, begin);
                pstmt2.setString(3, end);
                pstmt2.setString(4, Integer.toString(pmid));
                pstmt2.setString(5, begin);
                pstmt2.setString(6, end);
                pstmt2.setString(7, Integer.toString(pmid));
                pstmt2.setString(8, begin);
                pstmt2.setString(9, end);
                pstmt2.setString(10, Integer.toString(pmid));
                pstmt2.setString(11, begin);
                pstmt2.setString(12, end);

                rs2 = pstmt2.executeQuery();
                while (rs2.next() && loopj < types.length) {
                    pmvalue[loopi][loopj++] = rs2.getInt(1);
                }
                loopi++;
            }

            for (int i = 0; i < types.length; i++) {
                String dataset = "";
                strXML.append(dataset);

                for (int k = 0; k < pmcount; k++) {
                    strXML.append("");
                }
                strXML.append("");
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            closeResultSet(rs);
            closeResultSet(rs2);
            closeStatement(pstmt);
            closeStatement(pstmt);
            returnConnection(conn);
        }

        strXML.append("");
        return strXML.toString();
    }