Java Code to Create Simple Tables

Completed Posted May 19, 2014 Paid on delivery
Completed Paid on delivery

I am attaching two mySQL tables and two input files [url removed, login to view] and [url removed, login to view]

The program flow follows. See attached Field Definition documentation

Program Flow

1. Read file "[url removed, login to view]"

2. If first time, load SourceIPaddress, DestinationIPaddress, SourcePort, DestinationPort into Configuration. Create new unique Identifier. CommonName should be Kame.net. That is, take the name of the file without the "SYN".

3. Create array with items ID, SourceIPaddress, DestinationIPaddress, SourcePort, DestinationPort, SYNPacket, SYNDate, SYNHour, SYNMinutes, SYNSeconds, SYNMilliseconds, SYNMicroseconds,

SYNNanoseconds

4. Read all packets. Load into array.

5. Read file "[url removed, login to view]"

6. For each line in [url removed, login to view], check to see if it matches an item in the array. A match is considered:

SourceIPAddress in array = DestinationIPAddress from [url removed, login to view]

SourcePort in array = DestinationPort from [url removed, login to view]

DestinationIPAddress in array = SourceIPAddress from [url removed, login to view]

DestinationPort in array = SourcePort from [url removed, login to view]

SYNPacket in array < ResponsePacket from [url removed, login to view]

7. There may be multiple matches in [url removed, login to view] for an entry in the array. Take the one with the highest packet number (ResponsePacket).

8. When you get a match, calculate the difference in time from the SYNPacket to the RSPPacket then write out a record in the table HTTPResponse.

9. If at the end, there are unmatched entries in the array, write those to HTTPResponse leaving the "RSP" fields empty.

I will pay at most $50 for this project.

Java MySQL Software Architecture

Project ID: #5963572

About the project

7 proposals Remote project Active May 19, 2014

Awarded to:

AlbertWang

I have 15 years development experience in C++/Java in company Motorola/NSN and Logicmonitor. I also have lots of project on relation database such as MySQL. From this month, I quit and began a SOHO developer, and tryin More

$50 USD in 3 days
(0 Reviews)
0.0

7 freelancers are bidding on average $88 for this job

nittilegupta

Hi, I have worked for 5-6 different projects in Java. See my portfolio. And , the feedback too. I have read the details, and I am confident to get it done. I would like to be invited. Looking forward for your More

$168 USD in 8 days
(8 Reviews)
5.1
alphasoftuk

Hi, I can do this easily, but please don't feel pressed to accept this bid. Choose what's best for you. Though it's a small job, the 5 days in my bid is based on my current commitments. Thanks.

$55 USD in 5 days
(23 Reviews)
3.8
cungthehung

Hi. Certainly i can do it for you with that price. I did completed 100% projects for all my employers and they are very satisfied with my result. You can check it in my profile. Hope we have a deal. Thank you!

$88 USD in 2 days
(10 Reviews)
3.4
joseluiselp

I think i can do this, please let me know so we can talk. .

$50 USD in 3 days
(6 Reviews)
3.4
iphonedev311

Hello! I am WEB expert and a project manager of excellent WEB(PHP,.NET,ASP,CMS,...) development team and have also professional experiences of Java Application, J2EE, EJB, spring, Hibernate, Vaddin, Maven... I had More

$45 USD in 3 days
(0 Reviews)
0.0