File searching system and method based on SQL database

Abstract

The invention discloses a file searching system and method based on an SQL database. The file searching system comprises file names, summary information, a file uploading module, an appending line, anThe invention discloses a file searching system and method based on an SQL database. The file searching system comprises file names, summary information, a file uploading module, an appending line, anSQL data processing module, the SQL database and a searching module, wherein the file names and the summary information obtain and record a plurality of bottom files, the file uploading module is use SQL data processing module, the SQL database and a searching module, wherein the file names and the summary information obtain and record a plurality of bottom files, the file uploading module is used for Excel indexed files of an Excel form, and the appending line extracts the hyperlink of each bottom file of the Excel indexed files and relatively stores the hyperlink to the Excel indexed files;d for Excel indexed files of an Excel form, and the appending line extracts the hyperlink of each bottom file of the Excel indexed files and relatively stores the hyperlink to the Excel indexed files;the SQL data processing module relatively processes each Excel indexed file as an SQL data list file, the SQL database stores the SQL data list file of each Excel indexed file, and the searching modu the SQL data processing module relatively processes each Excel indexed file as an SQL data list file, the SQL database stores the SQL data list file of each Excel indexed file, and the searching module provides user input searching conditions, searches the SQL database according to user input searching conditions and displays the searching result to users. The file searching system uniformly tranle provides user input searching conditions, searches the SQL database according to user input searching conditions and displays the searching result to users. The file searching system uniformly transforms each Excel indexed file to the SQL database for management, thereby having simple operation and rapid search and enhancing the managing and searching efficiency of files.sforms each Excel indexed file to the SQL database for management, thereby having simple operation and rapid search and enhancing the managing and searching efficiency of files.

Description

technical field [0001] The invention relates to an information retrieval system, in particular to a file retrieval system and method based on an SQL database. Background technique [0002] Large and medium-sized enterprises have many subdivided departments. Each department generally uses Microsoft Office Excel software to generate Excel files to record the work progress, sales status and other information of the department, and cooperates with the internal LAN of the company to share and retrieve files on the Internet. For reference, all kinds of Excel files linked to the Internet are used as databases to provide reference services. [0003] Generally speaking, the file structure of an enterprise is generally divided into 3 layers: the first layer is the underlying file, which is the original issued file, which is stored in two forms: original and electronic files, and the format of the electronic file can be any format , and the file name conforms to the unified naming rul...

AI Technical Summary

Problems solved by technology

[0009] The present invention proposes a file retrieval system and method based on an SQL database. By uniformly converting each Excel index file to an SQL database for retrieval management, the current Excel file-based retrieval system has multiple Excel files that cannot be retrieved at the same time. The technical problem of defects such as less information and slow retrieval speed caused by the limitation of the number of rows

Images