?? memberxml.java
字號(hào):
} 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,"+
" 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!=49) {
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("MemberLastLogon");
xmlWriter.writeData(member[12]);
xmlWriter.endElement("MemberLastLogon");
xmlWriter.startElement("MemberOption");
xmlWriter.writeData(member[13]);
xmlWriter.endElement("MemberOption");
xmlWriter.startElement("MemberStatus");
xmlWriter.writeData(member[14]);
xmlWriter.endElement("MemberStatus");
xmlWriter.startElement("MemberActivateCode");
xmlWriter.writeData(member[15]);
xmlWriter.endElement("MemberActivateCode");
xmlWriter.startElement("MemberTempPassword");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[16]));
xmlWriter.endElement("MemberTempPassword");
xmlWriter.startElement("MemberMessageCount");
xmlWriter.writeData(member[17]);
xmlWriter.endElement("MemberMessageCount");
xmlWriter.startElement("MemberMessageOption");
xmlWriter.writeData(member[18]);
xmlWriter.endElement("MemberMessageOption");
xmlWriter.startElement("MemberPostsPerPage");
xmlWriter.writeData(member[19]);
xmlWriter.endElement("MemberPostsPerPage");
xmlWriter.startElement("MemberWarnCount");
xmlWriter.writeData(member[20]);
xmlWriter.endElement("MemberWarnCount");
xmlWriter.startElement("MemberVoteCount");
xmlWriter.writeData(member[21]);
xmlWriter.endElement("MemberVoteCount");
xmlWriter.startElement("MemberVoteTotalStars");
xmlWriter.writeData(member[22]);
xmlWriter.endElement("MemberVoteTotalStars");
xmlWriter.startElement("MemberRewardPoints");
xmlWriter.writeData(member[23]);
xmlWriter.endElement("MemberRewardPoints");
xmlWriter.startElement("MemberTitle");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[24]));
xmlWriter.endElement("MemberTitle");
xmlWriter.startElement("MemberTimeZone");
xmlWriter.writeData(member[25]);
xmlWriter.endElement("MemberTimeZone");
xmlWriter.startElement("MemberSignature");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[26]));
xmlWriter.endElement("MemberSignature");
//todo Igor: also filter memberAvatar, memberSkin
xmlWriter.startElement("MemberAvatar");
xmlWriter.writeData(member[27]);
xmlWriter.endElement("MemberAvatar");
xmlWriter.startElement("MemberSkin");
xmlWriter.writeData(member[28]);
xmlWriter.endElement("MemberSkin");
xmlWriter.startElement("MemberLanguage");
xmlWriter.writeData(member[29]);
xmlWriter.endElement("MemberLanguage");
xmlWriter.startElement("MemberFirstname");
xmlWriter.writeData(member[30]);
xmlWriter.endElement("MemberFirstname");
xmlWriter.startElement("MemberLastname");
xmlWriter.writeData(member[31]);
xmlWriter.endElement("MemberLastname");
xmlWriter.startElement("MemberGender");
xmlWriter.writeData(member[32]);
xmlWriter.endElement("MemberGender");
xmlWriter.startElement("MemberBirthday");
xmlWriter.writeData(member[33]);
xmlWriter.endElement("MemberBirthday");
xmlWriter.startElement("MemberAddress");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[34]));
xmlWriter.endElement("MemberAddress");
xmlWriter.startElement("MemberCity");
xmlWriter.writeData(member[35]);
xmlWriter.endElement("MemberCity");
xmlWriter.startElement("MemberState");
xmlWriter.writeData(member[36]);
xmlWriter.endElement("MemberState");
xmlWriter.startElement("MemberCountry");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[37]));
xmlWriter.endElement("MemberCountry");
xmlWriter.startElement("MemberPhone");
xmlWriter.writeData(member[38]);
xmlWriter.endElement("MemberPhone");
xmlWriter.startElement("MemberMobile");
xmlWriter.writeData(member[39]);
xmlWriter.endElement("MemberMobile");
xmlWriter.startElement("MemberFax");
xmlWriter.writeData(member[40]);
xmlWriter.endElement("MemberFax");
xmlWriter.startElement("MemberCareer");
xmlWriter.writeData(member[41]);
xmlWriter.endElement("MemberCareer");
xmlWriter.startElement("MemberHomepage");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[42]));
xmlWriter.endElement("MemberHomepage");
xmlWriter.startElement("MemberYahoo");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[43]));
xmlWriter.endElement("MemberYahoo");
xmlWriter.startElement("MemberAol");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[44]));
xmlWriter.endElement("MemberAol");
xmlWriter.startElement("MemberIcq");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[45]));
xmlWriter.endElement("MemberIcq");
xmlWriter.startElement("MemberMsn");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[46]));
xmlWriter.endElement("MemberMsn");
xmlWriter.startElement("MemberCoolLink1");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[47]));
xmlWriter.endElement("MemberCoolLink1");
xmlWriter.startElement("MemberCoolLink2");
xmlWriter.writeData(DisableHtmlTagFilter.filter(member[48]));
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
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -