摘要 |
PURPOSE: An automatic SQL(Structured Query Language) processing system and a method thereof are provided to develop an application by making a SQL and a user interface, thereby improving development production and enhancing the quality of the application. CONSTITUTION: In a command and data receiving step(S201), a command and data to which a UI(User Interface) common script is applied are received in a screen. In a command type analyzing step(S202), the type of a received command to which the UI common script is applied is analyzed. In a SQL sentence analyzing step(S203) about a command type, a SQL sentence about an analyzed command type is analyzed by loading a SQL map. In a data mapping step(S204) about the command type, data about the command type is mapped with an analyzed SQL sentence. In an SQL sentence and data processing step(S205), mapped SQL sentence and data are processed in a database. In a database processing result outputting step(S206), processing result data transmitted from the database is outputted. [Reference numerals] (AA) Start; (BB) End; (S201) Receive a command and data from a UI; (S202) Analyze a command type; (S203) Analyze an SQL sentence for the command; (S204) Map data for an SQL command type; (S205) Process in a DB; (S206) Output a processing result
|