In Progress

Java Get URL Content. No Duplicates

i need a java program to get asin from this sql.

mysql> select asinId,item_no,asin from ASIN;

+--------+---------+------------+

| asinId | item_no | asin |

+--------+---------+------------+

| 6 | 46475 | B003L9QE0C |

| 10 | 41126 | B004O9C1GO |

| 11 | 41141 | B004FRKMCK |

| 12 | 41141 | B004OQU1KA |

| 13 | 41141 | B004FRJDC |

| 14 | 41127 | B004O957UQ |

| 15 | 41619 | B004O967VO |

| 16 | 41619 | B00455MKLS |

| 17 | 41622 | B00455MKE0 |

+--------+---------+------------+

10 rows in set ([url removed, login to view] sec)

mysql>

2)

for each asin get the url

http://www.amazon.com/gp/offer-listing/B002VZSQ08/ref=dp_olp_new_mbc?ie=UTF8&condition=new

replace B002VSQ08 with he new asin

i need the price, shipping price, store id of all merchants under new

if it says free shipping put [url removed, login to view]

the store id is from the url <a href= under Seller Information column

for example http://www.amazon.com/shops/A10KOAR5YA65RL/ref=olp_merch_name_1

the store id is A10KOAR5YA65RL

the data must go in this table

create table asinPriceTrack (

id int auto_increment primary key,

dateFound datetime not null,

storeID varchar(100) not null,

asin varchar(50) not null,

item_no int not null,

price double not null,

shipPrice double not null

);

Skills: Java

See more: java url content, amazon asin url java, asin java, java url, sql get duplicates, sql create table price, get java, url, sql java, sql duplicates, null, java sql, java free, get merchants, free java, amazon get, mysql content, datetime, amazon store set, asin amazon url, url information, asin price, java url information, content amazon, create store amazon

About the Employer:
( 197 reviews ) Hacienda Heights, United States

Project ID: #1099865

Awarded to:

aoefmpes

pl check PM

$100 USD in 2 days
(32 Reviews)
4.8

5 freelancers are bidding on average $84 for this job

eperfections

JAVA + MySQL expert! I an develop this ! Please check PMB for details. Thanks ePerfections

$125 USD in 3 days
(292 Reviews)
6.8
techsoft1

hello, i had just gone through your requirement and i am interested in your project to do.I will provide best solution so for

$100 USD in 1 day
(0 Reviews)
0.0
miteshjadia1990

please check pm

$50 USD in 2 days
(0 Reviews)
0.0
S14S

Ready to work on this project

$45 USD in 2 days
(0 Reviews)
0.0