Bean generated SQL for back-end management and configuration

• US 20030229633A1
• Filed: 06/06/2002
• Published: 12/11/2003
• Est. Priority Date: 06/06/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Phillips, Brent Russel
• Granted Patent: US 6,920,449 B2
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A Configuration Application running on a server that responds to a web client is disclosed. The Configuration Application has a Bean Configuration Utility, a Program Bean and one or more SectionBeans within the Program Bean. The Configuration Application has a graphical user interface for the user to select tables, join tables, select columns, review a conditional SQL statement at the graphical user interface, and save the SQL statement. Using the graphical user interface, the user at the client computer can manipulate the Program Bean to return custom fields from the database without a change to the running application itself. The Program Bean is serializable and can be saved to a file, database, or it can be sent through a network socket (TCP/IP).

Claims

1. A method for developing structured query language statements to re-configure a web-based program while the program is running comprising the steps of:

loading a bean configuration utility in a server computer;

loading a program bean in the server computer;

connecting the server computer to a back end storage;

loading a section bean in the server computer; and

generating an SQL statement with the section bean

2. The method of claim 1 further comprising:

interrogating a back end storage for table definitions.

3. The method of claim 1 further comprising:

displaying a conditional SQL statement.

4. The method of claim 1 further comprising:

connecting the server computer to a back end storage.

5. The method of claim 4 further comprising:

determining whether the back end storage is connected.

6. The method of claim 5 further comprising:

requesting available tables; and

selecting a first table and a second table

7. The method of claim 1 further comprising:

joining the first table and the second table to create a new table; and

selecting a column from the new table.

8. The method of claim 1 further comprising:

determining whether a user selection is valid.

9. The method of claim 1 further comprising:

selecting tables.

10. The method of claim 9 further comprising:

interrogating the tables for available columns.

11. The method of claim 10 further comprising:

selecting columns.

12. The method of claim 11 further comprising:

joining tables.

13. The method of claim 1 further comprising:

serializing the section bean.

14. A programmable apparatus for developing structured query language statements to reconfigure a program while the program is running comprising:

programmable hardware comprising;

a server computer;

a client computer;

a relational data base;

a network connecting the server computer, the relational data base, and the client computer;

a first program installed on the server computer;

a second program installed on the client computer;

wherein the server computer is directed by the first program to load a Program Bean and responsive to a selection by a user, call a section bean to generate an SQL statement.

15. The programmable apparatus of claim 14 wherein the server computer is directed by the first program to provide a user table selection to the program bean.

16. The programmable apparatus of claim 15 wherein the server computer is directed to load a section bean with a table, column and join information.

17. A computer readable memory for developing structured query language statements to reconfigure a web-based program while the program is running comprising:

a server computer readable storage medium;

a computer program stored in said storage medium;

the storage medium, so configured by said computer program, responsive to receipt from a client computer of table, column and join information, causes the server computer to call a section bean from the program bean to generate a SQL statement.

18. A computer implemented process to developing structured query language statements to reconfigure a web-based program while the program is running comprising:

using a client computer, performing the following series of steps;

selecting tables;

joining tables;

selecting columns;

using a server computer, performing the following series of steps;

calling a program bean;

receiving a program bean;

interrogating a relational data base for a table information and a column information;

providing the table information and the column information to the program bean;

generating a conditional SQL statetment;

responsive to accepting the conditional SQL statetment, creating a section bean; and

serializing the section bean.

19. A computer program product on a computer-readable medium for developing structured query language statements to re-configure a web-based program while the program is running comprising:

means for loading a program bean in a server computer;

means for interrogating a relational data base for table and column information;

means for creating a section bean; and

means for adding the section bean to the program bean.