Design And Implementation Of Yunnan Vocational College Of Economic Management Library Management System

For a long time, people use the traditional manual management of the library daily, operational procedures more cumbersome and inefficient. To overcome these drawbacks, the book provides quick information retrieval functions, quick book lending, the return process, the maximum extent to meet the needs of managers and readers to develop a rational and effective library management system will be imminent. By the author of some of the typical library management system of inspection, from the perspective of readers and librarians, in line with library readers, the book also fast, convenient principle, the author developed a library management system, the paper intended to help system design and implementation.The library management system development environment based on prospects for the C# back-end database environment SQL Server 2005, based on C / S mode to achieve the basic realization of the following features:First, readers to borrow books, the reader to the system administrator to provide readers with books by the bar code number and the number, the system administrator according to the keyword query to the readers and the books of the relevant information and determine whether it can lend the book, you can by several, lend books, the system automatically updates records in the database.Second, readers to return books, the reader should be returned to the system administrator to provide books and readers bar code number, the system administrator according to the information to judge whether the return of overdue books and library information delete data in the table.Third, the system administrator of the library management, administrators can input information for the book, modify, or delete operation, to achieve the formulation of categories of books, books of the query and retrieval. Enter keywords can query the library books borrowed information, and books can be classified statistical reports, and books of inspection reports.Fourth, the management of the reader system administrator, the administrator can input information for the reader, modified, deleted, etc, enter the keyword readers can check the situation of readers.Fifth, security management, access to the system requires a user name and password, if not the system user may enter the system to operate, must be allowed to register under the senior system administrator account, you can login after successful registration of the system. After the log management can modify their own account and password, or cancel your account.