FileDocCategorySizeDatePackage
ZipcodeManager.javaAPI DocExample1295Sun Jun 18 08:59:32 BST 2006com.oreilly.ajax

ZipcodeManager

public class ZipcodeManager extends Object

Fields Summary
Constructors Summary
Methods Summary
public static LocationgetZipcode(java.lang.String zip)

        Location location = null;
        Connection con = DatabaseConnector.getConnection();
        String sqlString = "";
        location = new Location();
        location.setZipCode(zip);//put original zipcode in.
        
        try {
            sqlString = "SELECT CITY,STATE,ZIPCODE FROM ZIPCODES WHERE ZIPCODE='"+zip+"';";
            Statement select = con.createStatement();
            ResultSet result = select.executeQuery(sqlString);
            if (result.next()) { // process results one row at a time
                location.setCity(result.getString(1));
                location.setState(result.getString(2));
                location.setZipCode(result.getString(3));
               }

        } catch (Exception e) {
            System.out.println("exception in login"+e.getMessage());
        } finally {
            if (con != null) {
                try {
                    con.close();
                } catch (SQLException e) {
                }
            }
        }
        return location;