Homework 10

Dynamic queries to access remote data

Analysts access financial data constantly. This homework will give you practice with (a) dynamic SQL queries, and (b) combo boxes.

SmallBankDB contains a table called StockMarket, which contains six months of closing prices for a basket of a dozen stocks. Create an app that

  • Connects at startup with the database, and fills up two combo boxes with distinct dates and distinct tickers.
  • At the press of a button, it shows either all the available stocks for a given date, or all the available prices (i.e., dates) for a given stock

A vLab is provided. The vLab is a partial solution.