FileDocCategorySizeDatePackage
RicoZipCodesServlet.javaAPI DocExample2968Wed Apr 05 20:05:26 BST 2006com.oreilly.ajax.servlet

RicoZipCodesServlet

public class RicoZipCodesServlet extends HttpServlet

Fields Summary
private static final long
serialVersionUID
Constructors Summary
Methods Summary
public voiddoGet(javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res)


	     
			   
		String responseString = null;
		String type = req.getParameter("type");
		if(type==null)
			type = "0";
		String zipCode = req.getParameter("zip");
		if (zipCode != null) {
			HashMap location = getCityState(zipCode);
			if (location==null || location.size()==0){
				location = new HashMap();
				location.put("city"," ");
				location.put("state"," ");
				type = "1";
			}
			if (type.equals("1")){
				String message = "Zip code: "+zipCode+" is not in the database. Please enter your City and State";
				responseString = RicoUtil.buildRicoXML(location,"<input>",message);
			}
			else
				responseString = RicoUtil.buildRicoXML(location,"");		
		}
		if (responseString != null) {
			System.out.println(responseString);
			res.setContentType("text/xml");
			res.setHeader("Cache-Control", "no-cache");
			res.getWriter().write(responseString);
		} else {
			// If key comes back as a null, return a question mark.
			res.setContentType("text/xml");
			res.setHeader("Cache-Control", "no-cache");
			res.getWriter().write("?");
		}
private java.util.HashMapgetCityState(java.lang.String zipCode)

		Connection con = DatabaseConnector.getConnection();
		HashMap cityStateMap = new HashMap();
		String queryString = "";
		try {
			queryString = "SELECT CITY, STATE FROM ZIPCODES where ZIPCODE='"
					+ zipCode + "';";
			Statement select = con.createStatement();
			ResultSet result = select.executeQuery(queryString);

			while (result.next()) { // process results one row at a time
				String city;
				String state;

				city = result.getString("CITY");
				if (result.wasNull()) {
					city = "";
				}
				cityStateMap.put("city", city);
				state = result.getString("state");
				if (result.wasNull()) {
					state = "";
				}
				cityStateMap.put("state", state);
			}
		} catch (Exception e) {
			System.out.println("exception caught getting city/state:"
					+ queryString + " " + e.getMessage());
		} finally {
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
				}
			}
		}
		return cityStateMap;