With the rapid development of computer and technology, computers are becoming more and more popular all over the world, and today's society is rapidly moving towards an information society, and the role of information automation is becoming more and more important. Let's free ourselves from complicated affairs and improve work efficiency.

University library plays a vital role in the school's education, teaching and scientific research activities. Service is the essential attribute of a library. The basic function of university library is to meet the borrowing needs of teachers and students. With the application of information technology, teachers and students have higher and higher expectations for library services. They hope to obtain and use information scientifically, comprehensively, quickly and accurately. As a bridge of information transmission, the traditional "closed shelf" and "stack" lending management methods of university libraries can no longer meet the information needs of teachers and students, and even hinder the sustainable development of libraries. For librarians, facing more and more readers, manual operation is too heavy and easy to make mistakes. Therefore, the use of computer management is a trend and necessity.

I am a fresh undergraduate majoring in computer science, and I am interested in contributing to library management. And using the knowledge and skills I learned with the hard education and help of teachers in the past four years, I designed a lending management system of university library. I hope I can help university libraries to reform management, and at the same time I am willing to test my ability in practice, listen to teachers' opinions sincerely, and constantly improve and perfect the design.

Thoughts on developing library lending management system with 1

1. 1 Advantages of open-shelf lending mode

1. 1. 1 open-shelf lending is the inevitable trend of the open management of libraries today.

/kloc-in the 0/7th century, Gabrielle Nodi, a French scholar known as the "originator of library science", pointed out that "libraries should be open to the public". Under the guidance of some library development theories, after several generations of Chinese and foreign library scholars' vigorous advocacy and practice, the open-shelf service of libraries has become an important basis for the open management of libraries today. Libraries in western developed countries have already realized open-shelf lending by virtue of their strong economic and technical strength. Some advanced libraries in China and a few qualified university libraries have also adopted this method. This way has built a basic platform for the modernization of the library and ensured the sustainable development of the library. On the contrary, the "closed shelf" and "stack-style" management methods restrict the development of university libraries. Therefore, it is imperative for university libraries to implement open-shelf lending.

1. 1.2 open-shelf lending is a win-win management mode, which has obvious advantages for readers and managers.

Open-shelf lending not only simplifies the procedures, facilitates readers, ensures the integrity and accuracy of information, but also greatly improves the utilization rate of books and information and saves a lot of time. Changing the service mode from "Tibet-oriented" to "use-oriented" fully reflects the administrator's ability to actively serve.

This is a service model that both readers and administrators are satisfied with.

To sum up, the open-shelf lending model is an advanced lending model, so the management system I designed is based on the open-shelf theory.

1.2 Advantages of Full-frame Lending Book Management System

Compared with the "closed shelf" and "stack room" management systems, the open shelf lending management system shows its unique advantages, provides a satisfactory operating platform for readers and managers, and gives full play to their respective thematic functions.

1.2. 1 embodies the advanced management concept of "people-oriented"

"People-oriented" management is people-centered management. Its characteristics are: respecting people's value, adapting to and meeting people's needs, and attaching importance to emotional and cultural factors in the management process. The function is to stimulate people's enthusiasm, initiative and creativity. The concept of "people-oriented" library service is mainly embodied in readers and librarians. The design of management system is guided by the "people-centered" management thought, which enhances the self-service significance of readers and managers and repeatedly embodies their humanistic values.

1.2.2 Meet the readers' willingness of self-service and promote the development and utilization of storage resources.

With the change of readers' information demand in university libraries, "intermediary" information has been diluted, users' willingness to serve themselves has been enhanced, and their ability has been continuously improved. Users are more willing, and it is also possible to retrieve the required information by themselves, and pay more attention to the retrieval results, the integrity and accuracy of information. In view of the above changes, the design of the management system embodies the following advantages:

● Readers have the initiative, autonomy and right to know information.

The most obvious advantage of open-shelf lending management system is that readers have "three rights" The administrator's "intermediary" retrieval service is weakened, which makes the reader change from a bystander to an operator, walk on the operating platform by himself, use the query function freely, and query easily and quickly. And in the query, you can freely choose according to the relevant information and change the borrowing object according to the situation. If the information shows that the book you want to borrow has been lent, you can immediately switch to other borrowing objects. Furthermore, readers can determine the borrowing method according to the specific situation. For example, a reference book is a special kind of book. Generally speaking, it mainly provides inquiry rather than reading, and some complete sets of books are large, heavy and expensive. Once the relevant materials are found inconvenient to borrow, they can be consulted on the spot.

● Concentrate on the use of information resources to increase the amount of information for readers.

Readers can fully understand the information provided, wander among them, and truly appreciate the pleasure of traveling in the ocean of knowledge.

● Convenient and quick access function.

Readers can find the books they need directly in the perfect query function, which saves time and improves the effectiveness of borrowing.

1.3 facilitates managers and promotes comprehensive service for readers.

1.3. 1 Provide comprehensive, scientific and effective information services.

Information literacy education for college students by university libraries is an important supplementary form of classroom education, which has irreplaceable advantages. With the advent of the economic era, scientific research projects in colleges and universities also need a lot of information resources. Open-shelf information management system can store a large number of books, materials and information, and can be added and modified at any time, thus providing comprehensive, scientific and effective comprehensive information services.

1.3.2 has perfect management functions.

Make the administrator operate quickly and accurately. At the same time, due to the dilution of "intermediary" information service, it can save management manpower and time.

1.3.3 Managing security and reliability

Because there is a login password program, it is absolutely safe and reliable, even though it is fully open-shelf management.

1.4 laid the foundation of library automation management.

The development of open-shelf lending management system is not only the beginning of modern library management, but also the basis of its automatic management. If this management system is connected with the network, once it is connected with the national library network, it will become an important part of the future information superhighway.

2 system analysis and design

2. 1 demand analysis

The number of books in a library or library must have a certain scale, and the readers who borrow books from a library or library are not just a few specific readers. To manage these books, students' materials and students' borrowing situation, it is very heavy to operate by hand, and it is difficult to achieve optimal management. Therefore, the book lending management system I developed is mainly aimed at the management of administrators.

2. 1. 1 Overall framework of management system

Design a lending management software of university library to manage the books and users of the school. It can query books and users through different conditions, and handle books borrowed and returned by users, book certificates and other functions. The administrator can log in to the system after entering the correct account and password in the "System Login" form, and the Logo form will pop up. Click "Enter" button in this interface to enter the system form. The system mainly consists of two pages: student information and book information. In these two pages, you can add, modify, delete, query and print student materials and books respectively. At the same time, the "Borrow and Return Books" button is set in the "Student Information" page box, and students can borrow and return books through this button.

2.2 module analysis

2.2. 1 function module diagram

The functional module diagram is as follows:

Figure 2.2. 1. 1 system function module diagram

Modular analysis

● "Books and materials management" module

The "Book Management" module includes the functions of browsing, adding, modifying, deleting, querying and printing books and materials. In the "Book Information" page box of the form, you can view the detailed information of all books in the system through the "Mobile Record Toolbar", including name, category, author, publisher, purchase date, etc. Click the button in the command button toolbar to operate the records in the page box of books and materials.

● "Student Data Management" module

"Student Data Management" module includes the functions of browsing, adding, modifying, deleting, querying and printing student data. In the "Student Information" page box of the form, you can view the detailed information of all students in the system through the "Mobile Record Toolbar", including student name, gender, department, class and so on. Click the button in the command button toolbar to operate the records in the page box of student information.

● "Book borrowing and returning operation" module

The "borrowing and returning books operation" module includes the functions of checking readers' borrowing and returning books, reading overdue books and printing.

The reader's borrowing record viewing function can view all borrowing records, or only those that have not been returned. Click the "Borrowing Books" button in the "Reader Borrowing Records" table. In the Input form that opens, enter the book number of the book you want to borrow. If the books are in the library and readers can borrow books, then borrowing books is successful.

Click the Return Book button in the Reader's Book Borrowing Record form, and enter the book number of the book to be returned in the Open Input form. If the book is borrowed by the current reader, the book is returned successfully.

When the list of books that the reader has not returned is displayed in the form, double-click the "Book Number" column of the book to be returned in the table listing the book borrowing records to return the book.

Click the "Expired" button in the "Reader's Borrowing Records" form to view the borrowing records of books that have not been returned by the return date in the system.

Click the "Rank" button in the "Reader's Borrowing Record" form to view the list of all books in the system whose borrowing times are before 10. ............

............

The paper shows that the paper includes functional module diagram, interface demonstration diagram, complete program and code (need to be debugged by yourself), Powerpiont answer draft, Word format, file size of 3M, 9000 words, written according to the format requirements of computer graduation thesis, suitable for all computer majors!