Requirment: To fetch records depends on the scenario from database and display on webpages in a grid format with paging.
Bind the table data corresponding to combo box selection.
IDE : NetBeans 6.7
Web Server : Apache Tomcat 5.5
Database Server: FireBird
Without any framework : I am able to manage to fetch records from database using Java Beans in an Arraylist and display it on Web (JSP )Page using table.
Need of Famework:
1 ) If records are too many, it wud b difficult to manage them in a single table so need to go for paging soln.
2) Not able to bind the dropdownlist to a table data , i.e table data shuld be dependent on combo box selection.
3) Edition , Deletion in table rows.
Due to above mentioned issues , I was looking for some framework or plugin.
Now I started working with Visual Web JSF framework since it is providing some drag n drop components and also solved binding components issue.
But now I got some Configuration Issue, i.e. I need to deploy multiple sites using this project for each client attach to different sql databases.
Earlier when I was not using any framework,I was like changing the database string in web.xml file of the project and deploying it with different name for each client on server by copying the war file in Tomcat/Webapps folder and restart the server.
Problem: Since I am using Visual JSF Framwork ,I needed to register the database connection URL for making connection in NetBeans IDE in Server(Services)only to bind the components and not in web.xml file .So how wud I deploy multiple sites for each client having different databases by this project ????
Infact,the database connection string which i have specified currently in IDE is of database at my local machine .Then how will I make it point to any other datbase on server ???
I wud need some guidance :How should I configure my Visual Web JSF project to different databases. ??
If this framework is not good enough , then what should I use ???
If u need any clarifications then let me know .