rdbms
Class Sw410HW3

java.lang.Object
  rdbms.Sw410HW3

public class Sw410HW3
extends java.lang.Object

Douglas Lyon, DocJava, Inc. User: dlyon Date: Oct 9, 2007 Time: 9:10:12 PM

Constructor Summary

Sw410HW3()

Method Summary

static void

main(java.lang.String[] args) SW410 for next week download ftp://ftp.sec.gov/edgar/full-index/2006/QTR4/master.idx from the sec web page.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Sw410HW3

public Sw410HW3()

Method Detail

main

public static void main(java.lang.String[] args)
                 throws java.io.IOException,
                        java.lang.ClassNotFoundException,
                        java.sql.SQLException

SW410 for next week download ftp://ftp.sec.gov/edgar/full-index/2006/QTR4/master.idx from the sec web page. and insert them into your RDBMS of choice. use the ftp protocol by creating a new URL and get a connection that allows you to process the stream as it comes in... use a bufferedReader with a reasonable buffer. Insert the row into a table that has fields consistent with the master index records. For example: CIK|Company Name|Form Type|Date Filed|Filename Remotely create a table and populate it with your data. Use JDBC in Java to accomplish this task. Hint: see: CreateTableTest

Throws:

java.io.IOException

java.lang.ClassNotFoundException

java.sql.SQLException