I've been tasked with writing a web application. I have access to a mySQL database and an apache server.
This application will allow users to submit reports containing multiple text fields, radio boxs, and check boxs. These reports can later be retrieved or compared against one another by other users.
My thoughts were using CGI to do this and having a java program do the SQL stuff. Would this be the right way of doing a simple application like this, or does java provide something more high level for web development?
Also, this site needs to be accessible by phones, so I can't use applets.
i want an .exe
You want Instant.EXE. It features the Instant.EXE Script Editor,
?Instant.EXE Dialog Editor, Instant.EXE Menu Editor, 50 Powerful Commands and Over 200 System Variables!
Instant.EXE, because real men make their own tools.
The only interesting parts of this project are the representation you use for reports and the method you use to allow users to input reports.
If the reports need to be input by users and run without necessarily being sanity-checked, it's probably best to simply provide views that users can base reports on and a list of reasonable stored procedures that can be used to perform calculations on fields.
The only other things that you would need are selection criteria and possibly grouping, totals and subtotals.