Completed

Write a program in java interacting with MYSQL database

Your program will obtain the following information from the keyboard in the following order: - The starting date for the period to summarize - The ending date for the period to summarize

- The name of the file for the output All dates will be in a YYYY-MM-DD format.

Your program will send all of its output to the specified file.

The data that you extract will be in 3 categories: 1. Customer information a. Report the customer name, address, number of orders in the period, and total order value 2. Product information a. Report, for each product category, the category name and for each product in the category report the name, supplier, units sold, and value of product sold 3. Supplier information a. Report the supplier name, address, number of products that we sold, and the total value of a business that we sold from this supplier’s products. In all of the reporting, do not report any customers, products, or suppliers who have not had any interaction over the reporting period.

Skills: Database Programming, Java, MySQL, Software Architecture

See more: how to connect mysql database in java using netbeans, java sql tutorial, how to connect mysql database in java using eclipse, java standalone application with database example, java mysql tutorial, how to connect database in java using eclipse, how to create jdbc connection in java, java database tutorial, write program java graphical user interface, write program java deposit money, write program java tube, write program java calculate payment amount mortgage loans, write program java read text files randomly, java callback mysql database, write program java convert xml file sql database, write program java calculating mortgage payments

About the Employer:
( 1 review ) Halifax, India

Project ID: #18950963

Awarded to:

anish424

Hi, Its a very easy task and I can surely do this. I have 8 yrs of exp in java and related technologies All my previous projects had 5/5 ratings so you can be sure of quality and timely delivery. Looking foward t More

$30 CAD in 2 days
(39 Reviews)
4.8

17 freelancers are bidding on average $61 for this job

wbslivera

Hello, I am oracle certified professional programmer and work as oracle ERP techno functional consultant. I have developed many similar applications. I would like to clarify few things before confirming. Thanks

$60 CAD in 1 day
(255 Reviews)
6.4
paulprabhakarand

Hi, This is Paul Devanesn has done [login to view URL] and [login to view URL] from IIT Madras. I am a tech savvy person, more than a decade I am developing and delivering applications on Android app and Java based technologies. I am a certif More

$70 CAD in 2 days
(31 Reviews)
5.4
BeshoyMousaKhair

easy task, easy task, easy task, easy task, easy task, easy task, easy task, easy task, easy task, easy task,

$50 CAD in 1 day
(36 Reviews)
4.4
ownmyserver

Hello Friend, I have read your project requirements. We are familiar with all required technologies and we have expertise resource to start with your project. We have 4+ year experience in design and development More

$25 CAD in 1 day
(39 Reviews)
4.7
nlhdung

Hi, I have 7+ years experience in Java/Android/iOS application development with a lot of applications on Store. You can review my recent applications from my PORTFOLIO or at App Store link: https://www.freelancer.com More

$150 CAD in 1 day
(4 Reviews)
4.2
farhadakram

Hi, I have read the project details and attached document very carefully and I understand that I have to implement some advanced queries on north wind food chain database via Java and XML and output the report data fr More

$100 CAD in 2 days
(19 Reviews)
3.8
TeamDPS

Hi sir I read your requirements and ready to do that for you. I have 5 years of experience in software development as well as in Java technology and JavaFX with jasper report. Please contact me via messages for further More

$30 CAD in 2 days
(3 Reviews)
2.2
Mulayamsoft98

Hello Dear Employer, it's very easy task , I can develope this application for you. I have 6 years of experience in professional software development. Let's discuss in chat for more details. Thank you

$105 CAD in 3 days
(4 Reviews)
2.0
lira1992

Hi friend. I have more than 5 years programming in the programming languages ​​c, c ++, java and php. I can help you in your work. If you agree, I would like to have more details. I have been working for this page More

$30 CAD in 7 days
(3 Reviews)
2.0
toutoudiaf

Hi ! I can do that job in a short time and with any modifications you need . I am waiting forward for your response !

$50 CAD in 1 day
(1 Review)
0.7
amalaljarousha93

Hi there, I have carefully gone through your application. I can help to redesign your app as per your need. Please contact me for further discussion over chat. Regards

$166 CAD in 7 days
(0 Reviews)
0.0
mohamedkhomsi

im here for you im here for you im here for you im here for you im here for you im here for you im here for you im here for you

$35 CAD in 1 day
(0 Reviews)
0.0
CitachiTech

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data More

$65 CAD in 1 day
(0 Reviews)
0.0
phanmai92

I can do ut Relevant Skills and Experience Hello man

$25 CAD in 1 day
(1 Review)
0.0
anuyazhi

Thanks Relevant Skills and Experience Have core Java experience

$25 CAD in 1 day
(0 Reviews)
0.0
shivangigupta94

Dear Sir/Madam I can make the required project as per your requirement. I have a good hold on sql and java. I am professionally working in java technology. Find my complete profile at : [login to view URL] More

$20 CAD in 7 days
(0 Reviews)
0.0