This is my first post here and I'm a begginer in this field.
My question sounds like this: let's say you have a database in Oracle and you want to create a JSP app that will run over Tomcat Apache or Weblogic Server(in JDev), consisting on multiple webpages for: displaying data from tables/joins of tables, update tables, running queries, etc.

How should I do?
My idea is to create a javabean with methods for adding, deleting, updating tables. After that, create the JSP's files which invocates those methods implememnted in javabean, right? What are your recommendations?

Also, is there any way to generate the jsp scripts with drag and drop tables from db, or one should code them explicitely?

Thank you in advance.