Development system providing HTML database control object

• US 6,714,928 B1
• Filed: 03/17/2000
• Issued: 03/30/2004
• Est. Priority Date: 03/19/1999
• Status: Expired due to Term

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Calow, Thomas Jeffrey
• Primary Examiner(s): Le, Uyen
• Assistant Examiner(s): Chen, Te Y
• Application Number:
  US09/527,983
• Time in Patent Office: 1,474 Days
• Field of Search: 345/326, 345/333, 345/349-473, 707/501-513, 707/2, 707/4, 715/509, 715/513, 715/514
• US Class Current: 1/1
• 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/99934 Query formulation, input preparation, or translation

Abstract

A Database Development System is described that provides methodologies for creating an HTML or Web database control object (the “HTML DataWindow”) for use in a Client/Server Database System The HTML DataWindow serves as a thin-client DataWindow implementation for Web applications that provides most of the data manipulation, presentation, and scripting capabilities of the PowerBuilder DataWindow, without requiring any runtime DLLs (e.g., PowerBuilder runtime dynamic link libraries) on the client. DataWindow validation rules, formatting, and edit styles are automatically converted by the system into equivalent HTML and JavaScript, without coding by the user. HTML is generated that is suitable for the target browser. A plurality of functions and events are implemented by the generation of JavaScript which is downloaded to the client. In this manner, the Web or HTML DataWindow Design-Time Dontrol supports generation of a runtime DataWindow object in HTML.

Claims

1. A method for providing a Web-based database control object, the method comprising:

at design time, creating a definition of a Web-based database control object based on input of a developer user for visually dropping a data window design time control object corresponding to said Web-based database control object onto an HTML editing surface and using said data window design time control object for receiving input of the developer user for modifying properties of said Web-based database control object as appropriate for data access;

receiving at a Web server a request from an end user'"'"'s Web browser for a particular Web page;

passing the request to a page server;

at the page server, locating a Web page template for the requested Web page, said Web page template including a definition of the Web-based database control object;

executing server-side scripts in said Web page template, said server-side scripts establishing a connection to a server component and passing to the server component information about said Web-based database control object;

at the server component, performing substeps of;

establishing a connection with a database,

retrieving data required for said Web-based database control object from the database,

based on said definition of said Web-based database control object, generating hypertext markup language and script commands for rendering said Web-based database control object at the end user'"'"'s browser, and

returning said generated hypertext markup language and script commands to the page server;

at the page server replacing the server-side script in the requested Web page with the generated hypertext markup language and script commands; and

returning the page to the end user'"'"'s Web browser, said page rendering said Web-based database control object with data from said database, such that rendering said Web-based database control object in the end user'"'"'s Web browser occurs without requiring a runtime library at the end user'"'"'s Web browser.

2. The method of claim 1, wherein said hypertext markup language comprise HTML.

3. The method of claim 1, wherein said script commands comprise JavaScript.

4. The method of claim 1, wherein said definition of said Web-based data control object includes information specifying data and a state for said Web-based database control object.

5. The method of claim 1, wherein said database comprises an SQL database.

6. The method of claim 5, wherein specifying said data includes specifying an SQL query for fetching data from said database.

7. The method of claim 1, further comprising:

receiving end user input for interacting with said Web-based database control object.

8. The method of claim 7, wherein said end user input includes end user input for manipulating said data.

9. The method of claim 8, wherein said manipulating said data includes updating said data.

10. The method of claim 1, further comprising:

receiving another request from the end user'"'"'s Web browser for a new Web page; and

repeating said method for the new Web page.

11. The method of claim 1, wherein said script commands include client-side validation rules defined for the Web-based database control object.

12. The method of claim 1, wherein said database comprises a set of database tables residing on a server.

13. The method of claim 12, wherein said data being retrieved comprises database rows selected from said set of database tables.

14. The method of claim 1, wherein rendering of said Web-based database control object includes displaying a graphical user interface for the object.

15. The method of claim 1, wherein said step of generating hypertext markup language and script commands for rendering said Web-based database control object at the end user'"'"'s browser is performed automatically without coding by the developer user.

16. A development system providing a Web based database control object that allows an end user to manipulate, from an HTML browser, data that resides in a database, said development system comprising:

program logic for defining at design time a Web-based database control object definition, said definition based at least in part on a developer visually dropping a data window design time control object corresponding to said Web-based database control object onto an HTML editing surface and based in part on a developer using said data window design time control object to set properties of said Web-based database control object, said definition including specification of retrieval of information from the database;

program logic for generating at runtime, based on said Web-based database control object definition, HTML and script commands for rendering a user interface for displaying said information specified by said Web-based database control object in an HTML browser, including generating said user interface in accordance with a presentation style specified in said Web-based database control object and displaying said information from said database in said user interface;

wherein said HTML and script commands provide, at least in part, runtime program logic that allows the end user to make modifications to said information displayed in said user interface by said Web-based database control object;

wherein said HTML and script commands provide, at least in part, runtime program logic that allows the end user to apply said modifications to said database; and

wherein displaying said information specified by said Web-based database control object in the HTML browser occurs without requiring a runtime library at the HTML browser.

17. The system of claim 16, wherein said script commands comprise JavaScript.

18. The system of claim 16, wherein said definition of said control object includes information specifying data and a state for said control object.

19. The system of claim 16, wherein said database comprises an SQL database.

20. The system of claim 19, wherein specification of data for said control object includes specification of an SQL query for fetching data from said database.

21. The system of claim 16, further comprising:

user input means for interacting with said control object.

22. The system of claim 21, wherein said user input means includes user input means for manipulating said data.

23. The system of claim 22, wherein said user input means for manipulating said data allows updating of said data.

24. The system of claim 16, wherein said script commands include client-side validation rules defined for the control object.

25. The system of claim 16, wherein said database comprises a set of database tables residing on a server.

26. The system of claim 25, wherein said information being retrieved comprises database rows selected from said set of database tables.

27. The system of claim 16, wherein program logic for generating hypertext, markup language and script commands for rendering the control object at the end user'"'"'s browser operates automatically without coding by the developer user.