Bean generated SQL for back-end management and configuration
AssigneeInternational Business Machines Corporation
InventorBrent Russel Phillips
Life of this patent
Estimating the term…
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).
Claims19
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
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.
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.
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.
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.
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.
Dependencies are inferred from the claim text.