In Progress

Java Applet - Read from SQL, User Edits the List, Generates CSV file

Application will:

- Read a list of orders from a Microsoft SQL database using a stored procedure which returns a table (I have already written the stored procedure; it supplies order #'s and various details about the order)

- Display the results in a table. All of the columns being displayed are text and will be read-only, except for one which needs to be a drop-down list

- The options in the drop-down are different for each order (the options are provided in columns in the original SQL table, although during development we can decide if it makes more sense for these options to come from a second table)

- The user will scroll through the list and may decide to change the selected option in the drop-down list for various orders. You need to track which orders are modified, so that only the modifications are picked up in the next step.

- When the user is done, they will click a button which triggers the application to go through each order that was modified. For each order that was modified, you need to get additional data from the SQL database using another stored procedure which returns two tables (or two stored procedures that return their own tables, whichever is easier.) The parameters for this stored procedure is the order # and code # based on the selection in the drop-down list for that order.

- The application will then generate two CSVs file to a predetermined folder and file names (the user is not allowed to change these, but we should be able to change it in some sort of configuration file/interface.) The contents the CSV file are simply the results from the tables in the second stored procedure

At that point the program is complete. The user will take that CSV and import it to our ERP system.

Skills: Java, Software Architecture, Software Testing, SQL

See more: sql list csv java, sql java, options java, database microsoft sql, java selection sort, erp system architecture, drop list database, sql different, data interface java, sense configuration, erp software code, software development java, java erp architecture, java configuration, read details, java display file, sort contents, table csv, sort list, java import file, stored procedure list, selection sort program, csv table, Microsoft erp, java file list

About the Employer:
( 1 review ) Hamilton, Canada

Project ID: #5015823

Awarded to:


Previously done many projects in Java Applet and MS SQL database. Your requirements are simple and easy to understand. We can start immediately on this project. Done 500+ project in java in last couple of years. Thanks

$368 CAD in 5 days
(404 Reviews)

31 freelancers are bidding on average $488 for this job


Hello Sir, I am Bing from China, I am a senior Java developer with 11 years experience. I also have applet experience,I can complete your project very quickly,please consider my serious bid Thanks Bing

$550 CAD in 5 days
(104 Reviews)

Hi Sir, I am ready to work for you.I have 8 years of experience in C/C++/java and SQL/MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time More

$515 CAD in 7 days
(132 Reviews)

Hi, I am expert at Java and SQL, I have gone through the description and very much interested in this project, Looking forward to hear from you. Thank You

$421 CAD in 5 days
(243 Reviews)

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$515 CAD in 10 days
(37 Reviews)

hi JasonHITG, I'm an expert software engineer with more than 7 years of experience in PHP and Java ... I'm SCJP certified ... Looking forward to work with you and waiting for your reply ...

$744 CAD in 7 days
(127 Reviews)

let me help you. I checked your requirements. I'm very good at Java. This is my expert field. I can send you one demo if you want

$250 CAD in 3 days
(48 Reviews)

I have 6 years experience in JAVA, J2EE and ready to work on your project. I can start work on your project immediately.

$333 CAD in 7 days
(42 Reviews)

Hi, Please see my previous projects done in Java. I'm fully familiar with Java Applet, how to work with Microsoft SQL Server in Java and how to deal with csv files. Please open a chat session so we can discuss m More

$300 CAD in 6 days
(85 Reviews)

Can help... I am an Expert... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...

$1250 CAD in 21 days
(15 Reviews)

Hello sir, I'm an experienced Java, J2EE application developer, I'm very happy to get this project done for you. thanks.

$618 CAD in 5 days
(12 Reviews)

Hi, Please focus here,:-), I can do these , and I am interested in your [url removed, login to view], I am a full-time freelancer with 12 years experience in soft development. I have rich experience in Java/J2EE, Android, JSP More

$452 CAD in 8 days
(4 Reviews)

I am a expert in java programming, I have completed many java project works, Recently I completed some java projects which one creating a .csv file from a excel file, another one creating .midi file from lyrics file an More

$421 CAD in 10 days
(9 Reviews)

Hi, I'm very interested helping you creating your Java applet, I have years of experience in Java, SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is som More

$631 CAD in 15 days
(14 Reviews)

Dear Customer, I have 6 years of experience in Software Development. I am Oracle Certified Professional. I have experience in developing software using SQL Server, Oracle, JSP, Spring, Java Swing/Applet etc. I can do More

$255 CAD in 10 days
(13 Reviews)

Hi Jason, I've been developing java web and standalone applications for the past 7 years and as such I've gained a lot of experience in developing the kinds of applications that you require. I am adept with creating da More

$250 CAD in 10 days
(8 Reviews)

Hey I am Software Engineer and have very good experience in JAVA Applets and Stored procedures , MySQL. Contact me, I have questions regarding your project. I can do your project. Regards Junaid

$395 CAD in 6 days
(10 Reviews)

Hi I am experienced java developer and I have worked with such applications... Applet is not suggested approached now a days. We can use use flex. more user friendly then applets. or any java script frame work(visit my More

$444 CAD in 3 days
(3 Reviews)

Hi! I've been reading your requirements and I've realized I have the skills to implement your project properly and on time. I'm very experienced with Java and databases. I can either implement the GUI with Swing or wi More

$500 CAD in 12 days
(2 Reviews)

Hi, I understood your high level requirement. I am interested to work on this project. I have 5+ years experience in software development and customization using wide range of Microsoft technologies (C#, ASP.NET, MV More

$555 CAD in 7 days
(4 Reviews)

Hi, We are interested. We have more than 13+ years of experience in delivering Java/J2EE based solutions to busienesses. We did quiet a few website designing too. We are well versed in HTML, Flash, JSP and jav More

$288 CAD in 3 days
(5 Reviews)