memberxml.java

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

                          String memberViewCount, String memberPostCount,
                          String memberCreationDate, String memberModifiedDate, String memberExpireDate,
                          String memberLastLogon,
                          String memberOption, String memberStatus,
                          String memberActivateCode, String memberTempPassword,
                          String memberMessageCount, String memberMessageOption,
                          String memberPostsPerPage,
                          String memberWarnCount,
                          String memberVoteCount, String memberVoteTotalStars,
                          String memberRewardPoints,
                          String memberTitle, String memberTimeZone,
                          String memberSignature, String memberAvatar,
                          String memberSkin, String memberLanguage,
                          String memberFirstname, String memberLastname,
                          String memberGender, String memberBirthday,
                          String memberAddress, String memberCity,
                          String memberState, String memberCountry,
                          String memberPhone, String memberMobile,
                          String memberFax, String memberCareer,
                          String memberHomepage, String memberYahoo,
                          String memberAol, String memberIcq, String memberMsn,
                          String memberCoolLink1, String memberCoolLink2)
    throws CreateException, DuplicateKeyException, ObjectNotFoundException, DatabaseException {
        if ((memberName==null) || (memberName.equals("")) ||
            (memberPassword==null) || (memberPassword.equals("")) ||
            (memberFirstEmail==null) || (memberFirstEmail.equals("")) ||
            (memberEmail==null) || (memberEmail.equals("")) ||
            (memberFirstname==null) || //first and last name can be empty
            (memberLastname==null)) {
            throw new CreateException("Not enough data to create a member. Check for name, email and password.");
        } else {
            int memberEmailVisible1;
            int memberNameVisible1;
            int memberViewCount1;
            int memberPostCount1;
            java.sql.Timestamp memberCreationDate1;
            java.sql.Timestamp memberModifiedDate1;
            java.sql.Timestamp memberExpireDate1;
            java.sql.Timestamp memberLastLogon1;
            int memberOption1;
            int memberStatus1;
            int memberMessageCount1;
            int memberMessageOption1;
            int memberPostsPerPage1;
            int memberWarnCount1;
            int memberVoteCount1;
            int memberVoteTotalStars1;
            int memberRewardPoints1;
            int memberTimeZone1;
            int memberGender1;
            java.sql.Date memberBirthday1;

            try {
                memberEmailVisible1= (XMLUtil.stringToBooleanDef(memberEmailVisible, false)?1:0);
                memberNameVisible1= (XMLUtil.stringToBooleanDef(memberNameVisible, false)?1:0);
                if (memberFirstIP==null) memberFirstIP="0.0.0.0";
                if (memberLastIP==null) memberLastIP="0.0.0.0";
                memberViewCount1= XMLUtil.stringToIntDef(memberViewCount, 0);
                memberPostCount1= XMLUtil.stringToIntDef(memberPostCount, 0);
                memberCreationDate1= XMLUtil.stringToSqlTimestampDefNow(memberCreationDate);
                memberModifiedDate1= XMLUtil.stringToSqlTimestampDefNull(memberModifiedDate);
                memberExpireDate1= XMLUtil.stringToSqlTimestampDefNow(memberExpireDate);
                memberLastLogon1= XMLUtil.stringToSqlTimestampDefNull(memberLastLogon);
                memberOption1= XMLUtil.stringToIntDef(memberOption, 0);
                memberStatus1= XMLUtil.stringToIntDef(memberStatus, 0);
                if (memberActivateCode==null) memberActivateCode="";
                if (memberTempPassword==null) memberTempPassword="";
                memberMessageCount1= XMLUtil.stringToIntDef(memberMessageCount, 0);
                memberMessageOption1= XMLUtil.stringToIntDef(memberMessageOption, 0);
                memberPostsPerPage1= XMLUtil.stringToIntDef(memberPostsPerPage, 10);
                memberWarnCount1= XMLUtil.stringToIntDef(memberWarnCount, 0);
                memberVoteCount1= XMLUtil.stringToIntDef(memberVoteCount, 0);
                memberVoteTotalStars1= XMLUtil.stringToIntDef(memberVoteTotalStars, 0);
                memberRewardPoints1= XMLUtil.stringToIntDef(memberRewardPoints, 0);
                if (memberTitle==null) memberTitle="";
                memberTimeZone1= XMLUtil.stringToIntDef(memberTimeZone, 0);
                if (memberSignature==null) memberSignature="";
                if (memberAvatar==null) memberAvatar="";
                if (memberSkin==null) memberSkin="";
                if (memberLanguage==null) memberLanguage="";
                memberGender1= XMLUtil.stringToGenderDef(memberGender, 1/*Male*/);
                memberBirthday1= XMLUtil.stringToSqlDateDefNull(memberBirthday);
                if (memberAddress==null) memberAddress="";
                if (memberCity==null) memberCity="";
                if (memberState==null) memberState="";
                if (memberCountry==null) memberCountry="";
                if (memberPhone==null) memberPhone="";
                if (memberMobile==null) memberMobile="";
                if (memberFax==null) memberFax="";
                if (memberCareer==null) memberCareer="";
                if (memberHomepage==null) memberHomepage="";
                if (memberYahoo==null) memberYahoo="";
                if (memberAol==null) memberAol="";
                if (memberIcq==null) memberIcq="";
                if (memberMsn==null) memberMsn="";
                if (memberCoolLink1==null) memberCoolLink1="";
                if (memberCoolLink2==null) memberCoolLink2="";
            } catch (NumberFormatException e) {
                throw new CreateException("Invalid data for a member. Expected a number.");
            }

            //now ensure that strMemberID is valid number, or null
            if ( (strMemberID!=null) && (!strMemberID.equals("")) ) {
                try {
                    if (Integer.parseInt(strMemberID)<0) strMemberID=null;
                } catch (NumberFormatException e) {
                    strMemberID=null;
                }
            } else strMemberID=null;

            memberPassword=EnableHtmlTagFilter.filter(memberPassword);
            memberTempPassword=EnableHtmlTagFilter.filter(memberTempPassword);
            memberTitle=EnableHtmlTagFilter.filter(memberTitle);
            memberSignature=EnableHtmlTagFilter.filter(memberSignature);
            //todo Igor: also filter memberAvatar, memberSkin
            memberAddress=EnableHtmlTagFilter.filter(memberAddress);
            memberCountry=EnableHtmlTagFilter.filter(memberCountry);
            memberHomepage=EnableHtmlTagFilter.filter(memberHomepage);
            memberYahoo=EnableHtmlTagFilter.filter(memberYahoo);
            memberAol=EnableHtmlTagFilter.filter(memberAol);
            memberIcq=EnableHtmlTagFilter.filter(memberIcq);
            memberMsn=EnableHtmlTagFilter.filter(memberMsn);
            memberCoolLink1=EnableHtmlTagFilter.filter(memberCoolLink1);
            memberCoolLink2=EnableHtmlTagFilter.filter(memberCoolLink2);

            if (strMemberID==null) {
                DAOFactory.getMemberDAO().create(
                   memberName, memberPassword, memberFirstEmail,
                   memberEmail, memberEmailVisible1, memberNameVisible1,
                   memberFirstIP, memberLastIP, memberViewCount1, memberPostCount1,
                   memberCreationDate1, memberModifiedDate1, memberExpireDate1, memberLastLogon1,
                   memberOption1, memberStatus1, memberActivateCode, memberTempPassword,
                   memberMessageCount1, memberMessageOption1, memberPostsPerPage1,
                   memberWarnCount1, memberVoteCount1, memberVoteTotalStars1,
                   memberRewardPoints1, memberTitle, memberTimeZone1, memberSignature,
                   memberAvatar, memberSkin, memberLanguage,
                   memberFirstname, memberLastname, memberGender1,
                   memberBirthday1, memberAddress, memberCity,
                   memberState, memberCountry, memberPhone,
                   memberMobile, memberFax, memberCareer,
                   memberHomepage, memberYahoo, memberAol,
                   memberIcq, memberMsn, memberCoolLink1, memberCoolLink2);
            } else {
                //I must change all possible nulls into "", so I don't get "'null'" in sql query
                String memberEmailVisible2 = (XMLUtil.stringToBooleanDef(memberEmailVisible, false)?"1":"0");
                String memberNameVisible2 = (XMLUtil.stringToBooleanDef(memberNameVisible, false)?"1":"0");
                String memberModifiedDate2= XMLUtil.sqlTimestampToStringDefEmpty(memberModifiedDate1);
                String memberLastLogon2= XMLUtil.sqlTimestampToStringDefEmpty(memberLastLogon1);
                String memberBirthday2= XMLUtil.sqlDateToStringDefEmpty(memberBirthday1);

                String query="INSERT INTO "+ MemberDAO.TABLE_NAME +
                    " (MemberID, 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)" +
                    " VALUES (" +strMemberID+ ", '"+memberName +"', '" +memberPassword+ "', '" +memberFirstEmail+
                    "', '" +memberEmail+ "', " +memberEmailVisible2+ ", " +memberNameVisible2+
                    ", '" +memberFirstIP+ "', '" +memberLastIP+ "', " +memberViewCount1+
                    ", " +memberPostCount1+ ", '" +memberCreationDate1+ "', '" +memberModifiedDate2+ "', '" + memberExpireDate +
                    "', '" +memberLastLogon2+ "', " +memberOption1+ ", " +memberStatus1+
                    ", '" +memberActivateCode+ "', '" +memberTempPassword+ "', " +memberMessageCount1+
                    ", " +memberMessageOption1+ ", " +memberPostsPerPage1+ ", " +memberWarnCount1+
                    ", " +memberVoteCount1+ ", " +memberVoteTotalStars1+ ", " +memberRewardPoints1+
                    ", '" +memberTitle+ "', " +memberTimeZone1+ ", '" +memberSignature+
                    "', '" +memberAvatar+ "', '" +memberSkin+ "', '" +memberLanguage+
                    "', '" +memberFirstname+ "', '" +memberLastname+ "', " +memberGender1+
                    ", '" +memberBirthday2+ "', '" +memberAddress+ "', '" +memberCity+
                    "', '" +memberState+ "', '" +memberCountry+ "', '" +memberPhone+
                    "', '" +memberMobile+ "', '" +memberFax+ "', '" +memberCareer+
                    "', '" +memberHomepage+ "', '" +memberYahoo+ "', '" +memberAol+
                    "', '" +memberIcq+ "', '" +memberMsn+
                    "', '" +memberCoolLink1+ "', '" +memberCoolLink2+ "')";
                if (ImportWebHelper.execUpdateQuery(query) !=1) {
                  throw new CreateException("Error adding member into table '"+
                            MemberDAO.TABLE_NAME +"'.");
                }
            }
            this.memberID=DAOFactory.getMemberDAO().getMemberIDFromMemberName(memberName);
        }
    }

    /**
     * Adds a permission to this member. In order to know which member we are
     * reffering to, this method is supposed to be called after {@link #setMemberID(String)},
     * {@link #addMember(String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String)}
     * or {@link #addMember(String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String, String)}
     * have been called. Otherwise, this permission will be simply ignored.
     *
     * @param permission Permission to be added.
     *
     * @throws CreateException
     * @throws DatabaseException
     * @throws ForeignKeyNotFoundException
     */
    public void addMemberPermission(String permission)
    throws CreateException, DatabaseException, ForeignKeyNotFoundException {
        if (memberID<0) {
            throw new CreateException("Found member permission that is not assigned to any known member.");
        }
        int permission1;
        try {
            permission1=XMLUtil.stringToIntDef(permission, MVNForumPermission.PERMISSION_NO_PERMISSIONS);
        } catch (NumberFormatException e) {
            throw new CreateException("Invalid data for a member permission. Expected a number.");
        }
        try {
            DAOFactory.getMemberPermissionDAO().create(memberID, permission1);
        } catch (DuplicateKeyException e) {
            //ignore if already had that permission
        }
    }

    public static void addGuestMemberPermission(String permission)
    throws CreateException, DatabaseException, ForeignKeyNotFoundException {
        int permission1;
        try {
            permission1=XMLUtil.stringToIntDef(permission, MVNForumPermission.PERMISSION_NO_PERMISSIONS);
        } catch (NumberFormatException e) {
            throw new CreateException("Invalid data for a guest member permission. Expected a number.");
        }
        try {
            DAOFactory.getMemberPermissionDAO().create(MVNForumConstant.MEMBER_ID_OF_GUEST, permission1);
        } catch (DuplicateKeyException e) {
            //ignore if already had that permission
        }
    }

    public static void addAdminMemberPermission(String permission)
    throws CreateException, DatabaseException, ForeignKeyNotFoundException {
        int permission1;
        try {
            permission1=XMLUtil.stringToIntDef(permission, MVNForumPermission.PERMISSION_NO_PERMISSIONS);
        } catch (NumberFormatException e) {
            throw new CreateException("Invalid data for a guest member permission. Expected a number.");
        }
        try {
            DAOFactory.getMemberPermissionDAO().create(MVNForumConstant.MEMBER_ID_OF_ADMIN, permission1);
        } catch (DuplicateKeyException e) {
            //ignore if already had that permission
        }
    }

    public static void addMemberPermission(String memberName, String permission)
    throws CreateException, DatabaseException, ForeignKeyNotFoundException,
    ObjectNotFoundException {
        int permission1;
        try {