Gallery :: Applications by Robert Gelb :: Web Application Code Generator (2002)

Introduction

Five minutes after I turned in my second web application for a bank, a cold realization came over me: banking applications are essentially all the same. You get the data out of the database to show to the user, the user changes something, you then move these changes back to the database.

Being, generally, a person who hates repetition (particularly coding) and subscribes to the theory that lazy programmers are better, I set out to write an application that generates web applications given a set of data. People often comment that my web applications all look similar to each other. There is a reason behind it: they were all generated. And one side bonus of apps looking similar is that users who use one app feel right at home with the second one.

The idea is to generate 90% of the screens that are always the same in banking environments. This way the programmer doesn't have to worry about the user interfaces and generating views, but instead can focus on the business logic.

The Benefit

Time required to develop simple applications is down by 90% compared to the manual development method. More complicated applications are cut down on the average 30-50%

Technologies Involved
  • Language: Visual Basic 6
  • Data Access: ADO 2.5 for applicaions written in VB 6
  • RDBMS: Any
Screenshots

After connecting to the database, pick the table to work with

After connecting to the database, pick the table to work with

The Code Generator can work with existing stored procedures or generate new ones

The Code Generator can work with existing stored procedures or generate new ones

Code Generator offers detailed options for the Add, Edit and Search screens

Code Generator offers detailed options for the Add, Edit and Search screens

Set a few final options (or don't) and generate code

Set a few final options (or don't) and generate code

Code Generator automatically generates Add/Edit/List/Search screen including dropdowns based on database constraints

Code Generator automatically generates Add/Edit/List/Search screen including dropdowns based on database constraints

Code Generator automatically generates Add/Edit/List/Search screen including dropdowns based on database constraints

Code Generator automatically generates Add/Edit/List/Search screen including dropdowns based on database constraints

Code Generator automatically generates Add/Edit/List/Search screen including dropdowns based on database constraints