Java Reference
In-Depth Information
LISTING 18.2
Continued
10: ticker = inTicker;
11: }
12:
13: private String retrieveQuote() {
14: StringBuffer buf = new StringBuffer();
15: try {
16: URL page = new URL(“http://quote.yahoo.com/d/quotes.csv?s=” +
17: ticker + “&f=sl1d1t1c1ohgv&e=.csv”);
18: String line;
19: URLConnection conn = page.openConnection();
20: conn.connect();
21: InputStreamReader in= new InputStreamReader(
22: conn.getInputStream());
23: BufferedReader data = new BufferedReader(in);
24: while ((line = data.readLine()) != null) {
25: buf.append(line + “\n”);
26: }
27: } catch (MalformedURLException mue) {
28: System.out.println(“Bad URL: “ + mue.getMessage());
29: } catch (IOException ioe) {
30: System.out.println(“IO Error:” + ioe.getMessage());
31: }
32: return buf.toString();
33: }
34:
35: private void storeQuote(String data) {
36: StringTokenizer tokens = new StringTokenizer(data, “,”);
37: String[] fields = new String[9];
38: for (int i = 0; i < fields.length; i++) {
39: fields[i] = stripQuotes(tokens.nextToken());
40: }
41: String datasource = “jdbc:odbc:QuoteData”;
42: try {
43: Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
44: Connection conn = DriverManager.getConnection(
45: datasource, “”, “”);
46: PreparedStatement prep2 = conn.prepareStatement(
47: “INSERT INTO “ +
48: “Stocks(ticker, price, quoteDate, change, open, “ +
49: “high, low, volume) “ +
50: “VALUES(?, ?, ?, ?, ?, ?, ?, ?)”);
51: prep2.setString(1, fields[0]);
52: prep2.setString(2, fields[1]);
53: prep2.setString(3, fields[2]);
54: prep2.setString(4, fields[4]);
55: prep2.setString(5, fields[5]);
56: prep2.setString(6, fields[6]);
57: prep2.setString(7, fields[7]);
58: prep2.setString(8, fields[8]);
18
