Everyone at Mark's company knew about the Resource Allocation system. To say the least, it was a mess of a Java servlets held together with batch files, spreadsheets, and chewing gum, all developed by programmers who have long since been promoted to Lead Architect and Management roles. A slight change of winds was all that was needed to start a chain reactions of bugs: a while back, an edit to the configuration file to change the notification email address caused the system to bring down the email servers with a loop that became infinite when the config-file value didn't match the hard-coded value.
When word came down that the business would switch to ISO-3166 country codes throughout the enterprise, Mark knew this would have a devastating impact on the RA system. He bravely updated the COUNTRY_CODES table and prepared himself to battle a swarm of bugs. After it all was over, he was kind enough to share one of the more memorable finds from the DatabaseCache class ...
public String getCountry(String countryCode) { StringBuffer countryString = new StringBuffer(5000); countryString.append("<OPTION value=\"\">Please select country"); if(countryCode.equals("US")) countryString.append("<OPTION value=US selected>United States"); else countryString.append("<OPTION value=US>United States"); if(countryCode.equals("AF")) countryString.append("<OPTION value=AF selected>Afghanistan"); else countryString.append("<OPTION value=AF >Afghanistan"); if(countryCode.equals("AL")) countryString.append("<OPTION value=AL selected>Albania"); else countryString.append("<OPTION value=AL>Albania"); if(countryCode.equals("AG")) countryString.append("<OPTION value=AG selected>Algeria"); else countryString.append("<OPTION value=AG >Algeria"); if(countryCode.equals("AN")) countryString.append("<OPTION value=AN selected>Andorra"); else countryString.append("<OPTION value=AN>Andorra"); if(countryCode.equals("AO")) countryString.append("<OPTION value=AO selected>Angola"); else countryString.append("<OPTION value=AO>Angola"); if(countryCode.equals("AV")) countryString.append("<OPTION value=AV selected>Anguilla"); else countryString.append("<OPTION value=AV>Anguilla"); if(countryCode.equals("AC")) countryString.append("<OPTION value=AC selected>Antigua and Barbuda"); else countryString.append("<OPTION value=AC>Antigua and Barbuda"); if(countryCode.equals("AR")) countryString.append("<OPTION value=AR selected>Argentina"); else countryString.append("<OPTION value=AR >Argentina"); if(countryCode.equals("AM")) countryString.append("<OPTION value=AM selected>Armenia"); else countryString.append("<OPTION value=AM >Armenia"); if(countryCode.equals("AA")) countryString.append("<OPTION value=AA selected>Aruba"); else countryString.append("<OPTION value=AA >Aruba"); if(countryCode.equals("AT")) countryString.append("<OPTION value=AT selected>Ashmore and Cartier Islands"); else countryString.append("<OPTION value=AT >Ashmore and Cartier Islands"); if(countryCode.equals("AS")) countryString.append("<OPTION value=AS selected>Australia"); else countryString.append("<OPTION value=AS >Australia"); if(countryCode.equals("AU")) countryString.append("<OPTION value=AU selected>Austria"); else countryString.append("<OPTION value=AU >Austria"); if(countryCode.equals("AJ")) countryString.append("<OPTION value=AJ selected>Azerbaijan"); else countryString.append("<OPTION value=AJ >Azerbaijan"); if(countryCode.equals("BF")) countryString.append("<OPTION value=BF selected>Bahamas"); else countryString.append("<OPTION value=BF >Bahamas"); if(countryCode.equals("BA")) countryString.append("<OPTION value=BA selected>Bahrain"); else countryString.append("<OPTION value=BA >Bahrain"); if(countryCode.equals("BG")) countryString.append("<OPTION value=BG selected>Bangladesh"); else countryString.append("<OPTION value=BG >Bangladesh"); if(countryCode.equals("BB")) countryString.append("<OPTION value=BB selected>Barbados"); else countryString.append("<OPTION value=BB >Barbados"); if(countryCode.equals("BS")) countryString.append("<OPTION value=BS selected>Bassas Da India"); else countryString.append("<OPTION value=BS >Bassas Da India"); if(countryCode.equals("BO")) countryString.append("<OPTION value=BO selected>Belarus"); else countryString.append("<OPTION value=BO >Belarus"); if(countryCode.equals("BE")) countryString.append("<OPTION value=BE selected>Belgium"); else countryString.append("<OPTION value=BO >Belarus"); if(countryCode.equals("BH")) countryString.append("<OPTION value=BH selected>Belize"); else countryString.append("<OPTION value=BH >Belize"); if(countryCode.equals("BN")) countryString.append("<OPTION value=BN selected>Benin"); else countryString.append("<OPTION value=BN >Benin"); if(countryCode.equals("BD")) countryString.append("<OPTION value=BD selected>Bermuda"); else countryString.append("<OPTION value=BD >Bermuda"); if(countryCode.equals("BT")) countryString.append("<OPTION value=BT selected>Bhutan"); else countryString.append("<OPTION value=BT >Bhutan"); if(countryCode.equals("BL")) countryString.append("<OPTION value=BL selected>Bolivia"); else countryString.append("<OPTION value=BL >Bolivia"); if(countryCode.equals("BK")) countryString.append("<OPTION value=BK selected>Bosnia and Herzegovina"); else countryString.append("<OPTION value=BK >Bosnia and Herzegovina"); if(countryCode.equals("BV")) countryString.append("<OPTION value=BV selected>Bouvet Island"); else countryString.append("<OPTION value=BV >Bouvet Island"); if(countryCode.equals("BR")) countryString.append("<OPTION value=BR selected>Brazil"); else countryString.append("<OPTION value=BR >Brazil"); ... sniped a whole bunch of countries ... if(countryCode.equals("TX")) countryString.append("<OPTION value=TX selected>Turkmenistan"); else countryString.append("<OPTION value=TX >Turkmenistan"); if(countryCode.equals("TK")) countryString.append("<OPTION value=TK selected>Turks and Caicos Islands"); else countryString.append("<OPTION value=TK >Turks and Caicos Islands"); if(countryCode.equals("TV")) countryString.append("<OPTION value=TV selected>Tuvalu"); else countryString.append("<OPTION value=TV >Tuvalu"); if(countryCode.equals("UG")) countryString.append("<OPTION value=UG selected>Uganda"); else countryString.append("<OPTION value=UG >Uganda"); if(countryCode.equals("UP")) countryString.append("<OPTION value=UP selected>Ukraine"); else countryString.append("<OPTION value=UP >Ukraine"); if(countryCode.equals("AE")) countryString.append("<OPTION value=AE selected>United Arab Emirates"); else countryString.append("<OPTION value=AE >United Arab Emirates"); if(countryCode.equals("UK")) countryString.append("<OPTION value=UK selected>United Kingdom"); else countryString.append("<OPTION value=UK >United Kingdom"); if(countryCode.equals("UY")) countryString.append("<OPTION value=UY selected>Uruguay"); else countryString.append("<OPTION value=UY >Uruguay"); if(countryCode.equals("UZ")) countryString.append("<OPTION value=UZ selected>Uzbekistan"); else countryString.append("<OPTION value=UZ >Uzbekistan"); if(countryCode.equals("NH")) countryString.append("<OPTION value=NH selected>Vanuatu"); else countryString.append("<OPTION value=NH >Vanuatu"); if(countryCode.equals("VT")) countryString.append("<OPTION value=VT selected>Vatican City"); else countryString.append("<OPTION value=VT >Vatican City"); if(countryCode.equals("VE")) countryString.append("<OPTION value=VE selected>Venezuela"); else countryString.append("<OPTION value=VE >Venezuela"); if(countryCode.equals("VM")) countryString.append("<OPTION value=VM selected>Vietnam"); else countryString.append("<OPTION value=VM >Vietnam"); if(countryCode.equals("VQ")) countryString.append("<OPTION value=VQ selected>Virgin Islands"); else countryString.append("<OPTION value=VQ >Virgin Islands"); if(countryCode.equals("WF")) countryString.append("<OPTION value=WF selected>Wallis and Futuna"); else countryString.append("<OPTION value=WF >Wallis and Futuna"); if(countryCode.equals("WE")) countryString.append("<OPTION value=WE selected>West Bank"); else countryString.append("<OPTION value=WE >West Bank"); if(countryCode.equals("WI")) countryString.append("<OPTION value=WI selected>Western Sahara"); else countryString.append("<OPTION value=WI >Western Sahara"); if(countryCode.equals("YM")) countryString.append("<OPTION value=YM selected>Yemen"); else countryString.append("<OPTION value=YM >Yemen"); if(countryCode.equals("ZA")) countryString.append("<OPTION value=ZA selected>Zambia"); else countryString.append("<OPTION value=ZA >Zambia"); if(countryCode.equals("ZI")) countryString.append("<OPTION value=ZI selected>Zimbabwe"); else countryString.append("<OPTION value=ZI >Zimbabwe"); countryString.append("</OPTION>"); //ED: Yes, contryOptions is a class-level field countryOptions = countryString.toString(); return countryOptions; }
