Dynamic generation of web forms for editing data

I'm looking for a way to get web forms for data edition created automatically based upon a database model plus some additional parameters.

The forms should be used to add or modify data records on a database table.

The forms source data should come from a sql query, its fields may be textboxes, text areas but also with some additional parameters they could be dropdowns or radio buttons.

The goal of what I'm looking for is that whenever there is a change in the database model (ie, there is a new field in a table) the forms should change dinamically to reflect the modified table structure.

All this should be complemented with the possibility to include custom code in events such as before insert, after update, etc.

Does anybody know any tool or framework that could help me achieve this? My goal is to have dinamically generated web pages to edit data in databases without worrying about changes in the tables structure

Hi Nicolas,

Welcome to Javaranch.

I suggest you have a look at Ruby on Rails. It is a framework based on Ruby programming language, and is creating quite a buzz with its ease of development.

In Java world, there is Trails, and a new entrant Sails. But both of these are probably still experimental. I would not consider these for any real development yet.

Disclaimer - Haven't use any of these in real world, so do your research.

HTH

Sonny