memberxml.java

解觖java技术中后台无法上传数给的情况

                  DAOFactory.getMemberDAO().getMemberIDFromMemberName(memberName));
        } catch (ObjectNotFoundException e) {
            throw new ForeignKeyNotFoundException("Can't find member with name \""+memberName+"\".");
        }
    }

    public static void exportMember(XMLWriter xmlWriter, int memberID)
    throws IOException, DatabaseException, ExportException {
        Collection member1=ExportWebHelper.execSqlQuery(
                   "SELECT MemberName, MemberPassword, MemberFirstEmail, MemberEmail,"+
                   " MemberEmailVisible, MemberNameVisible, MemberFirstIP, MemberLastIP,"+
                   " MemberViewCount, MemberPostCount, MemberCreationDate, MemberModifiedDate, MemberExpireDate, "+
                   " MemberLastLogon, MemberOption, MemberStatus, MemberActivateCode,"+
                   " MemberTempPassword, MemberMessageCount, MemberMessageOption, MemberPostsPerPage,"+
                   " MemberWarnCount, MemberVoteCount, MemberVoteTotalStars, MemberRewardPoints,"+
                   " MemberTitle, MemberTimeZone, MemberSignature, MemberAvatar,"+
                   " MemberSkin, MemberLanguage, MemberFirstname, MemberLastname,"+
                   " MemberGender, MemberBirthday, MemberAddress, MemberCity,"+
                   " MemberState, MemberCountry, MemberPhone, MemberMobile,"+
                   " MemberFax, MemberCareer, MemberHomepage, MemberYahoo,"+
                   " MemberAol, MemberIcq, MemberMsn, MemberCoolLink1,"+
                   " MemberCoolLink2 FROM "+
                   MemberDAO.TABLE_NAME+
                   " WHERE MemberID="+Integer.toString(memberID));
        Iterator iter=member1.iterator();
        String[] member=null;
        //try {
            try {
                if ( (member=(String[])iter.next()) ==null) {
                    throw new ExportException("Can't find data for memberID=="+memberID);
                }
                if (member.length!=50) {
                    throw new ExportException("Error while retrieving data about member with memberID=="+memberID);
                }
            } catch (NoSuchElementException e) {
                throw new ExportException("Can't find data for memberID=="+memberID);
            }

            //if I am here, that means I now have correct object member
            if (memberID==MVNForumConstant.MEMBER_ID_OF_GUEST) {
                xmlWriter.startElement("Member", new String[]{"class", "Guest"});
            } else if (memberID==MVNForumConstant.MEMBER_ID_OF_ADMIN) {
                xmlWriter.startElement("Member", new String[]{"class", "Admin"});
            } else {
                xmlWriter.startElement("Member");
            }

            xmlWriter.startElement("MemberName");
            xmlWriter.writeData(member[0]);
            xmlWriter.endElement("MemberName");
            xmlWriter.startElement("MemberPassword");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[1]));
            xmlWriter.endElement("MemberPassword");
            xmlWriter.startElement("MemberFirstEmail");
            xmlWriter.writeData(member[2]);
            xmlWriter.endElement("MemberFirstEmail");
            xmlWriter.startElement("MemberEmail");
            xmlWriter.writeData(member[3]);
            xmlWriter.endElement("MemberEmail");
            xmlWriter.startElement("MemberEmailVisible");
            xmlWriter.writeData(member[4]);
            xmlWriter.endElement("MemberEmailVisible");
            xmlWriter.startElement("MemberNameVisible");
            xmlWriter.writeData(member[5]);
            xmlWriter.endElement("MemberNameVisible");
            xmlWriter.startElement("MemberFirstIP");
            xmlWriter.writeData(member[6]);
            xmlWriter.endElement("MemberFirstIP");
            xmlWriter.startElement("MemberLastIP");
            xmlWriter.writeData(member[7]);
            xmlWriter.endElement("MemberLastIP");
            xmlWriter.startElement("MemberViewCount");
            xmlWriter.writeData(member[8]);
            xmlWriter.endElement("MemberViewCount");
            xmlWriter.startElement("MemberPostCount");
            xmlWriter.writeData(member[9]);
            xmlWriter.endElement("MemberPostCount");

            xmlWriter.startElement("MemberCreationDate");
            xmlWriter.writeData(member[10]);
            xmlWriter.endElement("MemberCreationDate");
            xmlWriter.startElement("MemberModifiedDate");
            xmlWriter.writeData(member[11]);
            xmlWriter.endElement("MemberModifiedDate");
            xmlWriter.startElement("MemberExpireDate");
            xmlWriter.writeData(member[12]);
            xmlWriter.endElement("MemberExpireDate");
            xmlWriter.startElement("MemberLastLogon");
            xmlWriter.writeData(member[13]);
            xmlWriter.endElement("MemberLastLogon");
            xmlWriter.startElement("MemberOption");
            xmlWriter.writeData(member[14]);
            xmlWriter.endElement("MemberOption");
            xmlWriter.startElement("MemberStatus");
            xmlWriter.writeData(member[15]);
            xmlWriter.endElement("MemberStatus");
            xmlWriter.startElement("MemberActivateCode");
            xmlWriter.writeData(member[16]);
            xmlWriter.endElement("MemberActivateCode");
            xmlWriter.startElement("MemberTempPassword");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[17]));
            xmlWriter.endElement("MemberTempPassword");
            xmlWriter.startElement("MemberMessageCount");
            xmlWriter.writeData(member[18]);
            xmlWriter.endElement("MemberMessageCount");
            xmlWriter.startElement("MemberMessageOption");
            xmlWriter.writeData(member[19]);
            xmlWriter.endElement("MemberMessageOption");
            xmlWriter.startElement("MemberPostsPerPage");
            xmlWriter.writeData(member[20]);
            xmlWriter.endElement("MemberPostsPerPage");

            xmlWriter.startElement("MemberWarnCount");
            xmlWriter.writeData(member[21]);
            xmlWriter.endElement("MemberWarnCount");
            xmlWriter.startElement("MemberVoteCount");
            xmlWriter.writeData(member[22]);
            xmlWriter.endElement("MemberVoteCount");
            xmlWriter.startElement("MemberVoteTotalStars");
            xmlWriter.writeData(member[23]);
            xmlWriter.endElement("MemberVoteTotalStars");
            xmlWriter.startElement("MemberRewardPoints");
            xmlWriter.writeData(member[24]);
            xmlWriter.endElement("MemberRewardPoints");
            xmlWriter.startElement("MemberTitle");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[25]));
            xmlWriter.endElement("MemberTitle");
            xmlWriter.startElement("MemberTimeZone");
            xmlWriter.writeData(member[26]);
            xmlWriter.endElement("MemberTimeZone");
            xmlWriter.startElement("MemberSignature");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[27]));
            xmlWriter.endElement("MemberSignature");
            //todo Igor: also filter memberAvatar, memberSkin
            xmlWriter.startElement("MemberAvatar");
            xmlWriter.writeData(member[28]);
            xmlWriter.endElement("MemberAvatar");
            xmlWriter.startElement("MemberSkin");
            xmlWriter.writeData(member[29]);
            xmlWriter.endElement("MemberSkin");
            xmlWriter.startElement("MemberLanguage");
            xmlWriter.writeData(member[30]);
            xmlWriter.endElement("MemberLanguage");

            xmlWriter.startElement("MemberFirstname");
            xmlWriter.writeData(member[31]);
            xmlWriter.endElement("MemberFirstname");
            xmlWriter.startElement("MemberLastname");
            xmlWriter.writeData(member[32]);
            xmlWriter.endElement("MemberLastname");
            xmlWriter.startElement("MemberGender");
            xmlWriter.writeData(member[33]);
            xmlWriter.endElement("MemberGender");
            xmlWriter.startElement("MemberBirthday");
            xmlWriter.writeData(member[34]);
            xmlWriter.endElement("MemberBirthday");
            xmlWriter.startElement("MemberAddress");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[35]));
            xmlWriter.endElement("MemberAddress");
            xmlWriter.startElement("MemberCity");
            xmlWriter.writeData(member[36]);
            xmlWriter.endElement("MemberCity");
            xmlWriter.startElement("MemberState");
            xmlWriter.writeData(member[37]);
            xmlWriter.endElement("MemberState");
            xmlWriter.startElement("MemberCountry");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[38]));
            xmlWriter.endElement("MemberCountry");
            xmlWriter.startElement("MemberPhone");
            xmlWriter.writeData(member[39]);
            xmlWriter.endElement("MemberPhone");
            xmlWriter.startElement("MemberMobile");
            xmlWriter.writeData(member[40]);
            xmlWriter.endElement("MemberMobile");

            xmlWriter.startElement("MemberFax");
            xmlWriter.writeData(member[41]);
            xmlWriter.endElement("MemberFax");
            xmlWriter.startElement("MemberCareer");
            xmlWriter.writeData(member[42]);
            xmlWriter.endElement("MemberCareer");
            xmlWriter.startElement("MemberHomepage");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[43]));
            xmlWriter.endElement("MemberHomepage");
            xmlWriter.startElement("MemberYahoo");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[44]));
            xmlWriter.endElement("MemberYahoo");
            xmlWriter.startElement("MemberAol");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[45]));
            xmlWriter.endElement("MemberAol");
            xmlWriter.startElement("MemberIcq");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[46]));
            xmlWriter.endElement("MemberIcq");
            xmlWriter.startElement("MemberMsn");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[47]));
            xmlWriter.endElement("MemberMsn");
            xmlWriter.startElement("MemberCoolLink1");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[48]));
            xmlWriter.endElement("MemberCoolLink1");
            xmlWriter.startElement("MemberCoolLink2");
            xmlWriter.writeData(DisableHtmlTagFilter.filter(member[49]));
            xmlWriter.endElement("MemberCoolLink2");

            exportGlobalPermissionsForMember(xmlWriter, memberID);
            exportMessageFoldersForMember(xmlWriter, memberID);
            exportGlobalWatchesForMember(xmlWriter, memberID);
            xmlWriter.endElement("Member");
        //} catch throw exportexception
    }

    public static void exportMemberList(XMLWriter xmlWriter)
    throws IOException, DatabaseException, ExportException {
        Collection memberIDs=ExportWebHelper.execSqlQuery(
                   "SELECT MemberID"+
                   " FROM "+MemberDAO.TABLE_NAME);
        Iterator iter=memberIDs.iterator();
        String[] memberID=null;
        //try {
            xmlWriter.startElement("MemberList");
            /* First, I'll export guest and root admin. If they don't exist, just continue. */
            if (MVNForumConstant.MEMBER_ID_OF_GUEST < MVNForumConstant.MEMBER_ID_OF_ADMIN) {
                try { exportMember(xmlWriter, MVNForumConstant.MEMBER_ID_OF_GUEST); }
                catch (Exception e) { /* doesn't exist => ignore */ }
                try { exportMember(xmlWriter, MVNForumConstant.MEMBER_ID_OF_ADMIN); }
                catch (Exception e) { /* doesn't exist => ignore */ }
            } else {
                try { exportMember(xmlWriter, MVNForumConstant.MEMBER_ID_OF_ADMIN); }
                catch (Exception e) { /* doesn't exist => ignore */ }
                try { exportMember(xmlWriter, MVNForumConstant.MEMBER_ID_OF_GUEST); }
                catch (Exception e) { /* doesn't exist => ignore */ }
            }
            try {
                while ( (memberID=(String[])iter.next()) !=null) {
                    if (memberID.length!=1) {
                        throw new ExportException("Error while retrieving list of members.");
                    }
                    try {
                        int i=Integer.parseInt(memberID[0]);
                        if ((i!=MVNForumConstant.MEMBER_ID_OF_GUEST) && (i!=MVNForumConstant.MEMBER_ID_OF_ADMIN)) {
                            exportMember(xmlWriter, i);
                        }
                    } catch (NumberFormatException e) {
                        throw new ExportException("Error while retrieving list of members.");
                    }
                }
            } catch (NoSuchElementException e) {
                //no more database records
            }
            xmlWriter.endElement("MemberList");
         //} catch throw exportexception
    }



}