KR100331626B1 - Method for processing Internet Connection Automatic database Entry OCX and computer readable record medium on which a program therefor is recorded - Google Patents

Abstract

PURPOSE: A method for automatically processing a database is provided to construct a homepage regardless of a form of the database connected to a web server, access to a wanted database, prepare a homepage, and process wanted information in a homepage by executing a drag and drop using an objected-oriented technique. CONSTITUTION: A user group(30) includes a web server, an MIS(management information system), a general user, etc. An ICADE-OCX(Internet Connection Auto DB Entry Object Control ActiveX)(40) collects and outputs data through the Internet for inputting, modifying, deleting, and inquiring various formed multi-record. An ADC(Advance Data Connection)(50) includes an ADC module, an OLE(Object Linking Embedding) database module for an opened database connection in a web client, and a VTM(Virtual Task Management) module for supporting a multi-tasking. An IIS(Internet Information server)(60) is connected to the ICADE-OCX(40) and a database(70). The IIS processes a transaction. The database(70) inputs, modifies, deletes, and inquires the transmitted data on the Internet.

Description

Method for processing Internet Connection Automatic database Entry OCX and computer readable record medium on which a program therefor is recorded}

The present invention relates to a method for automatically processing an internet connection, and in particular, to automate complex database access when constructing an internet management information system (MIS) and an e-commerce home page, and to enable a user to input and output on the internet through various tools (ICADE OCX). The present invention relates to an automatic database processing method for internet access.

In general, a web-database control program applied to Internet application programming such as Internet Management Information System (MIS), e-library and e-commerce, such as HR, salary, accounting, purchasing, materials, ordering, etc. Coded in the form of CGI (Common Gateway Interface), it connects to the desired database and executes the application.

Referring to FIG. 1, a block diagram showing a WWW-DBMS connection using a conventional CGI is shown in FIG. 1. The client 10 uses a CGI or PERL language in a web server 21 connected to a web browser 11. It performs a role of a database gateway (24) by programming and is connected to the database server engine 25 to transmit and receive data between the web browser 11 and the database 26.

However, the network environment is complicated in small and medium-sized enterprises or general enterprises that use various databases and have low capital when constructing JAVA / CGI type web-database management information system, and the modules are large between client and server, and various development tools (VB, PB) It is difficult to install without an expert between client and server because it relies on DELPHI), and it is expensive to install network and server and software implementation cost. When changing program of client side, it is necessary to download new module or set new configuration to each client. There is a problem.

An object of the present invention is to solve the above problems, regardless of the type of database connected to the web server can build a home page, access the database of the desired form to create a home page, and rely on complex tools Object-oriented technology, rather than program coding, enables users to process information they want from the homepage by installing them on the homepage, install programs developed only on the server, and provide a convenient user interface on the computer by providing a convenient web interface to the user's computer. It provides an automatic database processing method for Internet access that can visually design input / output in any web browser.

1 is a block diagram showing a WWW-DBMS connection using a conventional CGI,

2 is a block diagram showing a WWW-DBMS system using the Internet connection automatic database processing system (ICADE OCX) for applying the present invention,

3 is a block diagram showing a connection of a web-database using the ICADE-OCX of FIG. 2;

4A to 4G are flowcharts illustrating an authentication step, a design step, an input and an output step for configuring an input / output component of web data according to an embodiment of the present invention.

Explanation of symbols on the main parts of the drawings

1: Internet Explorer 2: SQL Server

5: Oracle Database 7: Message Queuing (MSMQ)

6: Microsoft Exchange

40: Internet connection automatic database processing system (ICAD-OCX)

50: Advanced Connector (ADC) 60: Internet Information Server (IIS)

70: database

ICAD-OCX: Internet Access Automatic Database Processing System

(Internet Connection Auto DB Entry OCX)

OCX: Object Control ActiveX

IIS: Internet Information Server

ADC: Advanced Data Connection

VTM: Virtual Task Management

CGI: Common Gateway Interface

In order to achieve the above object, the present invention provides a web-database automatic database processing method, comprising: (a) an authentication step defining user license check, authority and security; (b) generating a script by setting an input / output form of the web document; (c) input and output of the web document; Including, wherein the authentication step (a) comprises: reading an environment file which is access information of a database management system (DBMS) in a web browser; Connecting a web browser and a database server; Database grid (GRID), combo box and list box, radio button (RADIO BUTTON) and picture button (PICTURE BUTTON), calender, EXCEL, ASCII, ASCII Loading a session variable defining a load of an application program variable capable of reporting various formats such as (Text) and the number of connection connections of the database management system (DBMS); Checking user authentication, retrying the process of connecting the web browser and the server if authentication is not successful, and extracting a user internet protocol (IP) address if authentication is performed; Retrying the process of connecting the web browser and the server if the number of users is equal to or greater than the license number, and checking whether the user is a registered user if the number of users is less than the license number; Checking whether the user is a registered user or retrying a process of connecting a web browser and a server, and executing the process workflow and application logic such as the grid, the combo box, and the list box if the registered user; And configuring a batch update and configuring a graphical user interface (GUI), wherein the design step (b) comprises: reading an environment file which is access information of the database management system (DBMS) in a web browser; Connecting the web browser and the database server; Loading the application program variable (Load) and session (Session) variables; Defining a database management system (DBMS) to set an environment of a database to be accessed; Checking whether there is a connection between the web browser and the database server, retrying the database configuration if a connection is not established, and checking a picture event if a connection is established; Database grids, database combos and lists, database radios and pictures, database calendars, database reporting, database reporting and database mailing Check each, executing the corresponding grid call, combo box and list box call, radio button and picture button call, calendar call, reporting call, and database mailing call, and if not checked, retry the figure event check step. ; Checking an object call and checking whether a script is generated when the object is called and retrying the drawing event checking step if the object is not called; Checking whether or not the script is generated and performing the drawing event checking step if the script is not generated, and checking that the design is an end of file (EOF) when the script is generated; Check that the design is the end of file (EOF) and if not the end of file (EOF) the database grid, the database combo box and list box, the database radio button and picture button, the database calendar, the database reporting, database Check the mailings respectively to perform the grid generation, the combo box and the list box generation, the radio button and the picture button generation, the calendar generation, the reporting generation and the database mailing generation, and the design is the file. If it is end (EOF), determining whether to print; Outputting a result when the printing is performed by checking whether the printing is performed, retrying the drawing event checking step, and checking whether or not the printing is finished; Checking whether or not the end is completed and retrying the drawing event checking step if not ending, and performing a storage presence checking if ending; Checking whether the storage is completed and ending the storage; if not, checking the storage request; And checking the presence or absence of the storage request and ending the storage request, and if the storage request is completed, storing and terminating the project and storing the program source. The input / output step (c) includes the designed contents. An input step for inputting a web document based on the input; And an output step for outputting a web document based on the designed contents. It consists of.

Hereinafter, with reference to the accompanying drawings will be described in detail a preferred embodiment of the present invention.

2 is a block diagram showing a WWW-DBMS system using the Internet connection automatic database processing system (ICADE OCX) according to the present invention.

A schematic diagram showing a WWW-DBMS system using the Internet connection automatic database processing system (ICADE OCX) includes a user group 30, an Internet connection automatic database processing system (ICADE-OCX) 40, and an advanced advance data connection. : ADC (50), Internet Information Server (IIS) 60, and database 70.

The user group 30 includes a web server, a management information system (MIS), tools such as Excel and PowerBuilder, a general user, and the like.

The automatic database processing system (ICADE-OCX) 40 is installed in the operating systems of Windows 95, Windows 98, and Windows NT, and multiple types of multiple records can be collectively inputted / modified. DB Grid OCX TOOL, which can collect and print data on the internet so that it can be deleted / retrieved, and functions to process DB Grid OCX TOOL, single line input field and help form in conjunction with DB. DB COMBO & LIST BOX OCX TOOL, DB RADIO & PICTURE OCX TOOL which can link radio button and graphic button to DB. Database calendar that provides calendar, lunar and lunar calendar, and year-end calculations. DB CALENDER OCX TOOL, Database Filler with convenience sorting and automatic sorting Ring and Classification O.C.EX TOOL, a function that can be output in accordance with the DM and various reports that you want to link with the database.Excel, ASCII, text, etc. REPORTING OCX TOOL to provide mailing, MAILING OCX TOOL to send, receive, and exchange electronic documents between Windows network users. Database buffering interface (DB BUFFERING INTERFACE), which is a buffering interface that buffers data and stores it in a database that provides stability and stability when connecting to the database in the event of a system crash or malfunction. Includes development tools for building .NET (INTERNET / INTRANET SEARCH OCX) and electronic commerce (EC).

The advanced connector (ADC) 50 is a program installed in Internet Explorer of Microsoft Corporation (MS). The advanced connector (ADC) module, O.L. (Object Linking and Embedding: OLE) Database (OLE DB) module and Virtual Task Management (VTM) module that supports multitasking.

The Internet information server (IIS) 60 is connected to a web server, the automatic internet access database processing system 40, and the database 70 to perform a function of processing a transaction.

The database 70 is an SQL server, an Oracle database, or the like, and performs a database function of input / modification / deletion / inquiry of data transmitted and received through the Internet.

Meanwhile, using Data Wizard OCX from Sheridan Soft of the US Sheridan Group, Microsoft Visual Basic and Microsoft's Active-X control can be used to create the database and database. Connect and run the application.

FIG. 3 is a block diagram illustrating a web-database connection using the ICADE-OCX of FIG. 2. The block diagram of the web-database includes Internet Explorer (1), other web browsers (2), Internet Information Server (60), Component Internet Access Automatic Database Processing System (ICADE-OCX) 40, It consists of SQL Server (4), Oracle (5), Microsoft Exchange (6), and Message Queuing (MSMQ) (7).

The Internet Information Server 60 and the Visual Basic script and Java script by the Hypertext Transfer Protocol (HTTP) in the Internet Explorer (1) and other web browsers (2). Is connected to the Component Internet Access Automatic Database Processing System (ICADE OCX) 40 via an Active Server Page (ASP), which is more advanced than Hypertext Markup Language (HTML). .

The component Internet connection automatic database processing system (ICADE OCX) 40 is a Microsoft Transaction Server using a Microsoft Distributed Component Object Model (DCOM) between the Internet information server (60). MTS) handles transactions. The object control ActiveX (OCX) is a product of the concept of combining object-oriented language (Object Linking & Embedding: OLE) and Microsoft's Active-X, the SQL server (4), It is connected to an Oracle 5 database, the Microsoft Exchange 6 and the MessageMQ 7 to process transactions between Internet clients and the database.

4A is a flowchart illustrating an authentication step (S100), a design step (S200), an input and an output step (S300) for configuring an input / output component of web data according to an embodiment of the present invention. It demonstrates in detail over 4g.

Referring to FIG. 4B, the authentication step includes reading an environment file which is access information of a database management system (DBMS) in a web browser (S1), connecting a web browser and a database server (S2), and a database grid GRID. , COMBO BOX & LIST BOX, RADIO BUTTON & PICTUREBUTTON, CALENDER, EXCEL, ASCII, TEXT etc. Loading a session variable defining an application variable load capable of reporting a format and the number of connection connections of the database management system (DBMS) (S3), and checking user authentication If not, retry the process of connecting the web browser and the server (S5), and if authentication, extracting the user's Internet Protocol (IP) address (S6), and if the number of users is greater than or equal to the number of licenses, the web Retry the process of connecting the browser and the server (S7), and if the number of users is less than the license (License) step of checking whether the user is a registered user (S8), by checking whether the user is a registered user or the web browser Retrying the process of connecting the server to the server, and if the user is a registered user, executing the process workflow and application logic such as the grid, the combo box, the list box, and the like (S9) and configuring the batch update and the graphical user interface (GUI). It consists of S10.

4C to 4E, the designing step includes reading an environment file which is access information of the database management system (DBMS) in the web browser (S21), connecting the web browser and a database server (S22), Loading the application variable (S23) and the session (Session) variable (S24), defining the database management system (DBMS) to set the environment of the database to be connected (S25), the web browser Checking the connection between the server and the database server, if the connection is not retried (S26), and if it is connected to check the picture event (S27), the database grid (DB Grid) (S28) , Database list box (S30), database radio button (S32) and picture button (S34), database calendar (DB CALENDER) (S36), database list Check the DB REPORTING (S38) and the DB MAILING (S40) respectively, and call the corresponding grid (S29), list box (S31), radio button and picture button (S33, S35). To execute the calendar call (S37), the reporting (REPORTING) call (S39), and the database mailing call (S41), or retry the checking of the picture event, and check the call to call the object. If it is checked whether the script is generated or not, and if the object is not called, retrying the picture event check step (S42), if the script is not generated by checking whether the script is generated, the picture event check step (S43) is performed. If a script is generated, checking that the design is an end of file (EOF) (S44), and checking that the design is the end of file (EOF), if not the file end (EOF), the database grid (S45) , Check the database list box (S45), the database radio button (S49) and the picture button (S51), the database calendar (S53), the database reporting (S55), and the database mailing (S57), respectively. Generation (S46), the list box generation (S48), the radio button (S50) generation and picture button generation (S52), the calendar generation (S54), the reporting generation (S56) and the database mailing generation (S58) And if the design is the end of the file (EOF), determining whether to print or not, checking whether or not the printing is performed, outputting the result and retrying the drawing event checking step (S59). If not check step (S60), the end of the check whether the end, if not the end of the picture event check step and if the end step of performing a storage check ( S61), if the storage is checked and stored, the process is terminated and if it is not stored, the storage request is checked (S62). S63) and storing (S64) and ending the program source.

Referring to FIG. 4F, the input step includes reading an environment file which is access information of the database management system (DBMS) in the web browser (S65), connecting the web browser and the database server (S66), and Loading an application variable and loading a session variable (S66 and S67), defining the database management system (DBMS) and setting an environment of a database to be accessed (S68), and connecting to the database to be accessed. When (S70) check whether the form (Report Form) of the web browser is loaded (S71) by loading the data into the database server connected from the web browser when loaded (S72), if not loaded checks the presence of errors In step S73, the web browser checks whether a request is made to the connected database server (S73). In the checking step, when the web browser makes a query request to the connected database server, data buffering is performed (S74), and the corresponding data is committed to the connected database. (S75) and if there is an error (S76), if there is an error, roll back (ROLL BACK) and retry the form loading process of the web browser (S77), if there is no error, the corresponding data in the connected database It is configured to store the step (S78).

Referring to FIG. 4G, the outputting step includes reading an environment file which is access information of the database management system (DBMS) in the web browser (S79), connecting the web browser and the database server (S80), and Loading an application variable and loading a session variable (S81, S82), defining a database management system (DBMS) to set an environment of a database to be accessed (S83), and connecting with the database to be connected. (S84) Check whether the Report Form is Loaded and Loaded. Check if there is a query request from the web browser to the connected database server (S85), and if not, check for an error. In step S86, the web browser checks whether there is a query request to the connected database server, and if the query request is made, data buffering is performed. ta buffering (S87), if the query request is not made, checking whether there is an error, performing data buffering, and fetching data from the connected database server to a web browser. Performing etching (S88) and checking the presence of the error after performing the data fetching (S89), and outputting a report (S90) if no error exists.

As described above, the automatic Internet access processing method according to the present invention is a server (Server) environment in Unix and NT operating system, Oracle database, Escule server, Sybase database, TCP / IP, X.25, modem and ISDN Netscape or Internet Explorer (IIS), Advanced Connection Control (ADC, AdvanceData Object (ADO)) and Internet Data Access Control (ICAD-OCX) server modules on your network Explorer to build Active Server Pages (ASP) and HTML-based tasks on the server's system, and the client environment uses the Windows 95/98 (Win95 / Win98) operating system for TCP / IP, Netscape or Internet Explorer (E) using the Internet Data Access Control (ICAD-OCX) client module in X.25, modem and ISDN network environments. Using xplorer), e-commerce and internet management information system can be constructed at low cost without additional development cost or equipment, and maintenance is convenient.

Therefore, the Internet management information system (MIS) and electronic commerce (EC) have been developed by the domestic small and medium-sized enterprises incorporating Internet information technology in the age of infinite competition of internationalization by developing the Internet and intranet DB interlocking engine using the automatic method of internet access database processing. Exporting each module of ICADE-OCX, the Internet access automatic database processing system that can erase technology, increase exports by receiving and ordering through the Internet, and sell it as an integrated tool for e-commerce, allowing domestic companies to easily operate the intranet. It has the effect of increasing exports, and reduces the foreign currency by converting the imports of various development tools and languages into its own technology, and has the effect of import debt by reducing the foreign currency by unifying various foreign equipment.

The automatic Internet access database processing method according to the present invention uses its own O.C. OCX (OCX) to process business management information of a general enterprise or a small and medium enterprise without a computer room in an internet application system of a web-database. It has the effect of replacing the computer room, and if you install the program only on the server and only the web browser on the developer or user's computer, you can design the input / output form you want in the graphic user interface (GUI) environment. It can be used regardless of the type, and the data buffering enables automatic data restoration function and data encryption function through data transaction to handle data security. Income that saves foreign currency by overcoming with our own technology There is a replacement effect and an increase in export of each module of ICADE-OCX.

Although the above has been described with reference to a preferred embodiment of the present invention, those skilled in the art will be able to variously modify and change the present invention without departing from the spirit and scope of the invention as set forth in the claims below. It will be appreciated.

Claims (7)

In the web-database automatic database processing method, (a) an authentication step defining user license checks, rights and security; (b) a design step of generating a script by setting an input / output form of a web document; (c) an input / output step for inputting / outputting a web document based on contents designed in the authentication step and the design step; The authentication step (a), Reading an environment file which is access information of a database management system in a web browser; Connecting a web browser and a database server; Loading session variables defining application program variables capable of reporting various formats and connection connection times of a database management system; Checking user authentication and extracting a user internet protocol address if the user is authenticated; Checking whether the user is a registered user and executing process workflow and application logic if the user is a registered user; And Including deploying deployments and configuring a graphical user interface, Step (b) of generating a script by setting the input and output form of the web document, Reading an environment file which is access information of a database management system in a web browser; Connecting a web browser and a database server; Loading the application variable and session variable; Defining the database management system to set an environment of a database to be accessed; Checking a picture event in the web browser; Executing and checking an object call in the web browser; Generating a script by checking whether a script is generated in the web browser; And Checking that the design is at the end of the file in the web browser. The method of claim 1, The authentication step (a), Checking user authentication and retrying the process of connecting the web browser and the server if the user is not authenticated; Retrying the process of connecting the web browser and the server if the number of users is equal to or greater than the license number, and checking whether the user is a registered user if the number of users is less than the license number; And Checking whether the user is a registered user and retrying a process of connecting the web browser and the server if the user is not a registered user; Internet access automatic database processing method further comprising. The method of claim 1, Step (b) of generating a script by setting the input and output form of the web document, After checking that the design is at the end of the file in the web browser, Determining whether to print; Outputting a result when the printing is performed by checking whether the printing is performed, retrying the drawing event checking step, and checking whether or not the printing is finished; Checking whether or not the end is completed and retrying the drawing event checking step if not ending, and performing a storage presence checking if ending; Checking whether the storage is completed and ending the storage; if not, checking the storage request; And Checking whether or not the storage request is terminated if not a storage request, and if the storage request is completed, storing and terminating the project and program source. The method of claim 1, The input and output step (c), (c-1) an input step for inputting a web document based on the designed content; And (c-2) an Internet connection automatic database processing method, comprising: an output step for outputting a web document based on the designed contents. The method of claim 4, wherein The input step (c-1) may include reading an environment file which is access information of the database management system in the web browser; Connecting the web browser and the database server; Loading the application variable and session variable; Defining the database management system and setting an environment of a database to be accessed; Checking whether a form of a web browser is loaded when connected to the database to be accessed, inputting data from a web browser to a connected database server if loaded, and checking whether there is an error if not loaded; Checking whether there is a query request from the web browser to the connected database server, and if not, checking whether there is an error; Performing data buffering when a query request is made to the connected database server from the web browser, and committing the corresponding data to the connected database; And Checking whether there is an error, and if there is an error, rolls back to retry the form loading process of the web browser, and if there is no error, automatically stores the data in the connected database. Treatment method. The method of claim 4, wherein The output step (c-2) may include reading an environment file which is access information of the database management system in a web browser; Connecting the web browser and the database server; Loading the application variable and session variable; Defining the database management system and setting an environment of a database to be accessed; Checking whether a report form is loaded when connected to the database to be accessed, and checking whether there is a query request from a web browser to a connected database server if loaded, and checking whether there is an error if not loaded; Checking whether there is a query request from the web browser to the connected database server to perform data buffering when the query request is made, and checking whether there is an error if the query request is not made; Performing data fetching after the data buffering and importing data from the connected database server to a web browser; And And after the data fetching, checking whether there is an error and outputting a report if there is no error. For automatic database processing of internet access of web-database, (A) authentication functions defining user license checks, rights and security; (B) a design function for generating a script by setting an input / output form of a web document; (C) an input / output function for inputting / outputting a web document based on contents designed in the authentication step and the design step; The authentication function (A), A function of reading an environment file which is access information of a database management system in a web browser; Connecting a web browser and a database server; Loading session variables defining application program variables capable of reporting various formats and the number of connection connections of a database management system; Verifying user authentication and extracting a user internet protocol address if the user is authenticated; Checking whether the user is a registered user and executing process workflow and application logic if the user is a registered user; And Includes the ability to configure deployment updates and graphical user interfaces, Function (B) for generating a script by setting the input and output form of the web document, A function of reading an environment file which is access information of a database management system in a web browser; Connecting a web browser and a database server; Loading the application variable and session variable; Defining an environment of a database to be connected by defining the database management system; Checking a picture event in the web browser; Executing and checking an object call in the web browser; Generating a script by checking whether a script is generated in the web browser; And Checking that the design is at the end of the file in the web browser; A recording medium having recorded thereon a computer readable program for executing the program.