Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

I am creating a CRUD app in JSP using Java Beans. I want to ask if there are any built in capabilities in IDE or any add-on to generate the CRUD functionality for a DB table automatically?

Like setter and accessor methods can be generated by the IDE. I know we can get CRUD using lot of frameworks like Spring,but for a simple app is this possible using just JSP and java beans?

share|improve this question

7 Answers 7

Telosys Tools has been designed for this job (provided as an Eclipse Plugin)

It uses an existing database to generate source code (typically CRUD screens) And it’s possible to customize the templates if necessary

The best way to try it is to follow the tutorial: https://sites.google.com/site/telosystutorial/ there’s a stack for Spring MVC / Spring Data / JPA, it can be adapted

See also : http://tools.telosys.org/ , http://marketplace.eclipse.org/content/telosys-tools

share|improve this answer

There are lots of tools for this purpose, i added 4 of them that i previously worked with them.

1-MyEclipse for Spring (ME4S), this IDE has code generation capability based on database.

2-Appfuse, Full-stack framework for building web applications on the JVM, you can create CRUD applications very fast and easy based on many web frameworks that Appfuse provide. you can see these demos and videos

3-SpringFuse, Reverse your database structure and generate a full J2EE web application stack in seconds

4-Spring Roo, Rapid Application Development tool with lots of plugins and features

share|improve this answer

Here is a detailed example for Generating a JavaServer Faces 2.0 CRUD Application from a Database

I have worked the above example with Apache Derby - DB and Tomcat 7.

Hope this will help you.

share|improve this answer

By simple jsp its not possible. You have to write your comman methods for CRUD and call that in your entire application. For every framework we should write these methods.

share|improve this answer

You could use Spring Roo, it scaffolds everything for you and doesn't create runtime dependancies.

It's really simple and useful for CRUD applications. It's more like an IDE plugin than a framework it self.

share|improve this answer

Take a look at Spring Roo. It is a tool for generating java code, and can scaffold a MVC JSP site: http://static.springsource.org/spring-roo/reference/html/base-web.html

share|improve this answer

Netbeans can actually help you generate a Swing CRUD app for a table on any supported database (by supported I mean databases for which you have the appropriate drivers). Simply click New Project --> Java --> Database Application. Follow the wizard to setup your database connection, tables you want to CRUD, etc and watch Netbeans generate the entire CRUD app (that you can then further customize). I used this (alongside MySQL workbench) to create a complete Contacts app in less than 10 minutes in a hackathon; the Netbeans community did a wonderful job on this. If for some reasons Swing may not be appropriate for your project (you really want to do web stuff), you might consider using the Grails framework (its a Groovy framework, there are YouTube videos to jumpstart you on this in less than 45 minutes). After creating your domain models (entities, analogous to database tables), the framework has a thing called UI scaffolding that can be employed in generating the CRUD web UI for those domain models; its really cool stuff. I hope this helps.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.
{"cc_re__cc_re__cc_by_sa_3_0": ["sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com?utm_source=stackoverflow.com&amp;utm_medium=site-ui&amp;utm_campaign=footerlink\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.9.15.1858\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Stack Overflow works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nos"], "copyright__copyright__copyright": [" using the Grails framework (its a Groovy framework, there are YouTube videos to jumpstart you on this in less than 45 minutes). After creating your domain models (entities, analogous to database tables), the framework has a thing called UI scaffolding that can be employed in generating the CRUD web UI for those domain models; its really cool stuff. I hope this helps.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service."]}