Determining Category and Project types using Netbeans 6.1 for a project

[HASSAN Kamrul]

Could you help me determine which best and simple approach [File->New
Project->Choose Project->Categories & Projects [Web or Enterprise]
I should take to develop my Web application using Netbeans 6.1
in Java EE 5

My project description:
I am trying to develop a report Metrics [for ticketing system Database]
Web portal with on-demand fields (drop-down list, button controls etc).
Data source is Oracle 9i and I am only doing "Select" query (retrieve
only).
Based on the on-demand fields value a result should be displayed [as
table or data grid] with list of all tickets then user should be able to
* create [from result] csv or Excel file or send email this
result
* click any row to open a window with certain fields of the ticket
where user should be able to put comments which will be submitted
[will go to an API updating the Ticketing Database]
* Based on some on-demand fields user will generate number metrics
[ticketing pattern behavior] then user should be able to
create Chart and user should be able to click on a chart bar
which will bring result data grid
[ex. Critical chart bar, Major 2 chart bar then clicking
Critical chart bar should display all Critical tickets in data grid]

Thank you

kam

[jyeary]

That is a very tall order if you have not done a web project before.

Add drivers to NetBeans for database under the services tab --> database.
Create a link to the Oracle database and connect
I would create a web based project using Visual JSF.
Use binding capabilities in NetBeans to bind the database to the appropriate tables, and drop downs.
Crating an csv file from the data is easy Tor Norbye has an example on his blog.
There are some free charting libraries (frameworks) that you can use to create charts.

The majority of what you are trying to accomplish can be found on the NetBeans site under tutorials, the tutorial divas ( http://blogs.sun.com/divas ), http://woodstock.dev.java.net , and my blog http://javaevangelist.blogspot.com

John

On Wed, Nov 5, 2008 at 1:40 PM, HASSAN Kamrul <address-removed ([email]address-removed[/email])> wrote:

[kb9agt]

Use web and then use a framework like hibernate and JPA(persistence)

On 11/5/08, HASSAN Kamrul <address-removed> wrote: