root/trunk/myweb/src/zip/Model.java

package zip;

import java.util.*;
import java.sql.*;

public class Model {
  private String zip;
  private List<String[]> results;

  public List<String[]> getResults() {
    return results;
  }
  public void setZip(String zip) {
    this.zip = zip.replace("-","");
  }
  public void execute() {
    Connection conn=null;
    try {
      javax.naming.Context ctx=new javax.naming.InitialContext();
      javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookupLink("java:comp/env/jdbc/mydb");
      conn= ds.getConnection();

      PreparedStatement stmt=conn.prepareStatement("SELECT * FROM zips WHERE zip LIKE ?");
      stmt.setString(1,zip+"%");
      stmt.setMaxRows(100);
      ResultSet rs=stmt.executeQuery();

      results=new LinkedList<String[]>();
      while (rs.next()) {
        String result[]={rs.getString("zip"),
            rs.getString("addr1")
            +rs.getString("addr2")
            +rs.getString("addr3")
            +rs.getString("addr4")
            +rs.getString("establishment")};
        results.add(result);
      }
    } catch (Exception e) {
      System.out.println("in Model.execute, "+e.getMessage());
    } finally {
      if (conn!=null) {
        try {
          conn.close();
        } catch (SQLException e) {}
      }
    }
  }
}