Developing browser-based document database management software with ASP

Source: Internet
Author: User
Tags query client access
Browser | data | database | Browser Document database is an important part of internet/intranet application. With manual maintenance site documents and links, the administrator should have a little web technology background to be competent, with the expansion of the site, the need to maintain more and more documents, it is inevitable that there is no sense of inadequacy. Using a document database has a significantly different effect, and administrators can easily handle the maintenance and management of thousands of documents, and users to publish, query, browse documents is also more convenient and quick.

Using Microsoft's ASP technology (Active Server page, a server-side Dynamic Web page that can replace CGI), the author has developed a browser-based document database management software ("Document Database", hereafter). The "Document database" structure is simple, easy to use and maintain, suitable for small and medium-sized enterprises Intranet solutions and primary and secondary school campus network and other fields. Its operating environment is:

Server-side: Operating system MS Windows NT4.0
Web server MS IIS4.0 (Internet information Server4.0)
Database SQL Server (Access 97 is also available for small web sites)
Client: windows95/98+ie4.0 above version

Development environment:
MS Visual InterDev and Frontpage98 (making ASP pages)
MS Visual Basic (developing ActiveX controls)
MS Vbscript (Compose ASP page scripting language)

The following is a brief introduction to the functional and technical essentials of the document database.

First, the user management mode
The document database is tiered and hierarchical for users, divided into four tiers, two management, and two user tiers, as shown in Figure 1.


Network administrator: The highest level of users, the use of network administrator components, responsible for the establishment and revocation of the Web site, maintenance site administrator and registered user information, etc., generally do not participate in the management of specific sites.

Site administrator: A site of the webmaster (moderator), the use of site administrator components, responsible for the site permissions, column (document classification) management, manuscript review, document maintenance and so on.

Registered users: generally limited to the staff of the Unit. Register the user with the identity code and password, and implement a rating (default 9 levels, up to 98 levels). When a registered user attempts to enter a site, the "document database" will verify its identity code, password, level, and meet the requirements of the site to be released. In addition, when a registered user publishes a document to a site, its identity code and password can also be used as a "digital signature" to ensure the authenticity of the identity of the publisher. Registered user database by the network administrator responsible for maintenance, run-time users in the network home page once login, by the ASP's session object for the entire maintenance, do not need to enter a site each to show the user code and password.

Non-registered users: generally limited to social users, such as remote logins to browse the public information part of the user.
Two, can redefine the modular layout component
There are more than 70 ASP pages in the document database. Divided into network administrators, site administrators, site users three components, the last two components are customizable modular layout components, by a specific ASP property page parameters (existing site name, URL, Database DSN, page style, etc. 11 parameters) redefined, Multiple sites of different uses and styles can be generated on one or more Web servers.
To simplify the site operation, the document database has 50 built-in parameters, and in most cases the network administrator can put the site into use with a single "naming" operation on a preset site. To close a site, cancel the site "name" is OK.

Third, the site structure
Each site consists of a network administrator component, a site user component, a database (including 2 tables), and a document folder.
Databases maintain document titles, columns, authors, dates, review flags, file names, and so on, and when users browse, query, and publish documents, send the SOL command to the database (using ODBC Connectors and ASP's ADO Database components), through the database's "filename" The actual document for the field and document folder is hyperlinked.

To prevent the document from having the same name, the hyperlink is not positioned properly, and the document is renamed after it is published to the site.

Iv. Site Management
By using the site administrator component to manage a site, the component's main feature Pack expands:
1, set the site permissions

User browsing rights: Specify which category (site administrator, registered user, all users), which level of users can access the site browse query.

User publishing rights: Specify which category (site administrator, registered user, all users), which level of users can enter the site to publish documents.

Document forward filtering: Allows users to publish all types to this site or only allow certain types of documents to be published.

Document Reverse filtering: Users are not allowed to publish specific types of documents to this site.

Document size: Limits the documents that users publish to this site no more than xx KB.

Document review: Documents published by the user will not be published until they are reviewed by the site administrator.

2, column Management

The column is the document category, for example, in a "campus news" site, you can set up school news, school announcements, school publications and other columns.

Column management includes adding columns, deleting columns, merging columns and other operations, site managers can be flexible use, so that the site content rich and colorful.

3, single or bulk delete expired documents.

4. Review the manuscripts of users.

5, the site notices the release and the administrator mailbox.

6, not subject to site permissions restrictions on document browsing and publishing.

V. Browsing, querying, and publishing documents
Document browsing, querying, and publishing are available in Site administrators and site user components, and are limited by site permissions (document size, type, user level) in site user components.
Users can find documents based on column, date, document title matching, author name matching, using the Index server of IIS, and Full-text search of all documents in the site, Full-text search currently supports commonly used format documents (txt,doc,rtf,htm, etc.), but the system overhead is large, Recommended for use only on important sites.

Document Publishing is a wizard-style application that provides three ways to publish:

1, form submission method: Through the form text box to compose the document and publish.

2, Single document publishing mode: Import any type of single document.

3, multiple Document publishing methods: similar to the site release. This is the way to publish multiple documents that have links to each other, and users first select multiple documents to publish, and then specify the starting document to run first in multiple documents.

Vi. Summary
ASP, as a server-side Dynamic Web page, is used in conjunction with client script and ActiveX to develop almost all browser-based, database-driven Web applications.
Although there are some deficiencies in the current function of ASP, the practical value of it is quite high as a rapid development tool. Additionally, the ASP runs on the server side, and its scripts and objects are not visible from the client browser, so security is also better.

This "document Database" is a typical intranet software developed by ASP, from the structure to the functional design all through the principle of simple and easy to use, the hardware environment requirements are also very low. For the need of Intranet for information publishing and document management, but lack of funds and talent of small and medium-sized enterprises and educational units have a certain use and reference value.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.