Devam Ediyor

GeniusCoder Stock Project

java program format is

java stockReader [directory of csv files]

File format

[Market]_[date].csv

Inside [url removed, login to view] the first line is

AACC 9-Jan-09 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 55400

you will write into stockSymbols

Market = NASDAQ

Symbol = AACC

if NASDAQ + AACC exists you will not write it. there is a unique key (Market,Symbol)

get the StockId

then write the Date, Open, High, Low, Close, Volume to dailyStockPrices

Table format is

create table stockSymbols

(

StockId int auto_increment primary key,

Market text not null,

Symbol text not null

);

create table dailyStockPrices

(

StockId int not null,

StockDate date not null,

StockOpen decimal(20,2) not null,

StockHigh decimal(20,2) not null,

StockLow decimal(20,2) not null,

StockClose decimal(20,2) not null,

StockVolume int not null

);

Beceriler: Java, JSP

Daha fazlasını görün: java stock project, null, int, market stock project java, create java project, java stock market project, stock project java, java project market, project stock java, market csv, key project, stock symbol, project write file, jsp text, project key, primary key, program stock, write file java, java table project, java program project, csv jsp, open text file java, line stock, jsp csv, open file java

İşveren Hakkında:
( 197 değerlendirme ) Hacienda Heights, United States

Proje NO: #700045

Seçilen:

GeniusCoder001

Asdiscussed

3 gün içinde 150$ USD
(17 Değerlendirme)
5.3