A Method and System for Employing Drag & Drop Technique While Developing Database Applications (17-Dec-2009)

A Method and System for Employing Drag & Drop Technique While Developing Database Applications

Disclosed is a method and system for employing drag and drop technique for inter-connecting one or more disparate artifacts while developing database applications. Drag and Drop techniques as disclosed herein are easy to use and promotes speedy database application development process.

Various dialog boxes and/or wizards are

dynamically pre-populated as a result of a drop action with the information fetched from a corresponding drag sources.

Consider an example where following SQL select statement is dragged and dropped onto a Java project. The drop action creates a bean, database access layer and a sample application to return the results of the bean.

SELECT ACTNO,

The following bean generation dialog as shown in Fig. 1 is pre-populated with information from the drop source related to the Java project source folder.

Figure 1

Information about the proposed bean fields is pre-populated from the SQL model of the result set of the SQL statement as shown in Fig. 2

1

ACTKWD,

ACTDESC FROM SSURANGE.

ACT

Figure 2

Consider another example,

where an SQL select statement from a Java project

dragged and dropped onto a Web service project. The Fig. 3 shows all SQL statements from the Java source code of an application. One of more SQL statements are dragged and dropped on the Web service project.

Figure 3

Dropping the one or more SQL statements onto the Web Services folder triggers creation of a New Web Service dialog while dropping it onto an existing Web service project would add the dropped SQL statements as operations to the Web service project as shown in Fig. 4.

2

Figure 4

In response to dropping the one or SQL statements, Web services initialized with respective SQL statement are created; one such Web service is shown in Fig. 5

Figure 5

where a physical data model representation is dragged

and dropped onto a Java project. This will result in database access code to be generated with create, insert, update, delete statements and a sample app...