With the maturity of computer science and technology and its wide application in various fields of human society, its powerful function saves a lot of labor time for people, thus improving the work efficiency of human beings unprecedentedly. Using computer to manage book information has incomparable advantages compared with manual management. For example: fast retrieval, convenient search, high reliability, large storage capacity, good confidentiality, long service life and low cost. These advantages can greatly improve the efficiency of book management. At the same time, the application of information technology in management is more and more extensive, and the implementation of management information system is gradually mature in technology. Management information system is a new and developing discipline. This paper introduces the process of developing management information system with the strategy of "top-down overall planning and bottom-up application development" in vb environment. By analyzing the shortcomings of traditional manual management library, this paper puts forward an effective scheme of computer management library. The system analysis part of the book management information system includes feasibility analysis, organizational structure analysis, management function analysis, business process analysis, data process analysis, data dictionary, process description and so on. The system design part mainly introduces the system function design and database design; The system implementation part lists several main program block diagrams, with some main windows and programs attached.
The system has friendly interface, simple operation and strong practicability.
Keywords management information system, book management, vb application.
catalogue
1. Overview 1
1. 1 Introduction 1
1.2 development background 1
1.3 II feasibility analysis
1.4 system functions2
1.5 Work done in this paper 3
2. Development tools and related technologies 4
2. Introduction to1VB 4
3. The overall design of the book management system
3. 1 system target design 7
3.2 System Function Analysis 7
3.3 Data Flow Figure 8
3.3. 1 business flow chart 8
Data flow chart 9
3.4 module implementation 1 1
3.5 Overall Interface Design 15
3.5. 1 writing purpose 15
3.5.2 Interface design idea 16
3.5.3 Interface design principles 16
3.5.4 Interface design style 17
3.5.5 Common prompt information styles 17
3.5.6 Common prompt information styles 17
3.6 Create a database 18
4. The design of book lending information management module 19.
4. 1 "Book Lending Information Management" Form Implementation 19
4. 1. 1 object naming convention 19
4. 1.2 naming convention for constants and variables 20
4. 1.3 Structured coding convention21
4. 1.4 data source convention21
4. 1.5 database access convention21
4. 1.6 Other protocols 2 1
4.2 Loading of "Borrowing Information" Table 22
4.3 Unload "Borrowing Information" Table 22
4.4 "book lending information management" form function realization 22
4.4 1 "book borrowing information query" function design table 22
4.5 "Book Return Information" Form Implementation 23
4.6 Loading of "Return Form" 24
4.7 "book return information management" form function realization 24
4.7. 1 Function Design of "Query Book Return Information" Module 24
4.7.2 Design of "Add Return Information" and "Modify Return Information" Module 25
5. Operation and maintenance of the system 26
5. 1 system login 26
5.2 System Testing 27
5.3 System Maintenance 28
Conclusion 29
thank you
Reference 3 1
1 overview
1. 1 Introduction
This system is based on the application system of the school library, written in VISUAL BASIC language and developed on VISUAL BASIC 6.0 language +ACCESS database. The system has good operation interface and complete functions. Can complete most of the work of library management system, from reader registration, borrowing and returning books to new book storage. , users can not only successfully complete all the work, but also complete information query and statistics in various ways as needed, and also add administrators and administrators to add and edit books and library cards. This system takes four basic operations of the database (adding records, deleting records, modifying records and querying records) as the basic operations, and completes all the functions required by users. At the same time, the system also has the characteristics of good reliability, simple operation, friendly interface and easy maintenance and expansion.
1.2 development background
Today's era is a rapidly developing information age. All walks of life are inseparable from information processing, which is the environment in which computers are widely used in information management systems. The biggest advantage of a computer is that it can manage information. Using computer control information not only improves work efficiency, but also greatly improves its safety.
Especially for complex information management, computers can give full play to their advantages. Computer information management is closely related to the development of information management system, which is the premise of system management.
In normal operation, modern libraries are always faced with a large number of reader information, book information and book borrowing information and book return information generated by their interaction. Faced with tens of thousands of books, complicated readers' information and frequently changed books' borrowing and returning information, the traditional direct way not only causes loopholes in management, but also causes losses.
Therefore, it is very important to have an intelligent, systematic and informative book management system. Making full use of the functions of computers to realize the automatic control of reader management, book management and lending management will greatly weaken the work of libraries. Convenient and friendly graphical interface, simple operation and perfect database management. It will make the library system apply to modern book management to the maximum extent.
As a distribution center of information resources, the library has a large number of books and user borrowing materials, including a large number of information data management. At present, many libraries are initially used, and even computers have not been used for information management.
In the past, their main information management method was manual processing based on paper media such as text and tables. The statistics and verification of book borrowing (such as borrowing days and over-limit days) are often carried out by manually checking the library card, and manually calculating and copying the borrower's borrowing authority and borrowing days. Data information processing has a large workload and is prone to errors; Because of the large amount of data, it is easy to lose and difficult to find.
Generally speaking, there is a lack of systematic and standardized information management means. Although some libraries have computers, they are not used for information management and their resources are idle, which is the basic environment for the development of management information systems.
Feasibility analysis of 1.3
This topic is to improve the efficiency of book lending information management with the expansion of the scale of the college's book reference room, which is helpful to maintain the normal teaching order of the college and meet the standardization, rationalization and scientificity of the book lending management of the college. Through this topic, we can improve the function of book lending information management, improve the efficiency of book lending work conveniently and quickly, and reduce the management cost. It requires that the system not only can successfully complete the daily work of the library, but also has the characteristics of simple operation, good reliability, strong fault tolerance, friendly interface, easy maintenance and easy expansion. Therefore, according to the above requirements, we have compiled this system.
1.4 system functions
Campus library system is the best assistant for librarians. Its functions are as follows:
A. It is convenient for students and teachers to borrow, return, find, export and count books.
B. You can customize the book category and reader category, which is convenient for adding books, managing books, adding readers and managing readers.
C. It provides perfect lending and returning operation and has a completely independent database system, which ensures the data security of the library. Data management provides librarians with: book management and reader management.
D. Data query provides you with: borrowing situation, stacks query and readers query.
E it is also a safe database backup scheme, which is simple and easy to use.
1.5 the work done in this paper
The first chapter mainly introduces the development background of the book management system, and the important functions and feasibility analysis of the book management system.
The second chapter introduces the development tool (VB), the characteristics of VB and the brief introduction of VB. Using VB to develop. And the SQL database used. This paper briefly introduces the database.
The third chapter is the overall design of the book management system, and draws the functional hierarchy diagram of the system. Basic work to be done before designing a library management system.
The fourth chapter is how to realize the function of "borrowing information management module" that I have completed. In this chapter, there are the design of the form and the realization of the function of the form. This chapter is also the focus of this article.
Chapter V System Operation and Maintenance.
2 development tools and related technologies
In order to facilitate the query, application and maintenance of librarians. When developing the school library management system, I compared the developed software, including their application and maintenance, and the response speed. I think VB is suitable for developing this system, because the biggest feature of VB is "what you see is what you get". It is convenient for librarians to use.
2. Introduction to1VB
199 1 year, Microsoft Corporation of the United States launched Visual Basic (VB), and the current version is 6.0 Chinese version.
Visual Basic has three versions: learning version, professional version and enterprise version, which meet different development needs.
The learning version is suitable for ordinary learners and most people who use Visual Basic to develop general Windows applications. The professional edition is suitable for computer professional developers, including all the content functions of the learning edition and advanced functions such as Internet control development tools. In addition to all the contents of the professional edition, the enterprise edition also has tools such as automatic component manager, which allows professional programmers to develop powerful distributed applications in groups.
VB is a visual, object-oriented and event-driven structured high-level programming language, which can be used to develop various applications in the Windows environment. It is easy to learn, efficient and powerful, and can be compared with the professional development tool SDK of Windows.
In the Visual Basic environment, by using the event-driven programming mechanism, the novel and easy-to-use visual design tools, the rich functions of application program interface (SPI) in Windows, and the technologies of dynamic link library (DLL), object linking and embedding (OLE) and open data connection (ODBC), the application software system with powerful functions and rich graphical interfaces can be developed efficiently and quickly. Its characteristics are as follows:
A. visual programming:
When designing programs with traditional programming languages, the user interface is always designed by writing program codes. In the design process, you can't see the actual display effect of the interface, so you can only observe the program after compilation.
Visual Basic provides a visual design tool to "encapsulate" the complexity of Windows interface design, so that developers don't have to write a lot of program code for interface design. We only need to draw various "components" on the screen according to the screen layout required by the design and use the tools provided by the system, that is, graphical objects, and set the properties of these graphical objects.
Visual Basic automatically generates interface design code, and programmers only need to write the part of the code that realizes the program function, which can greatly improve the efficiency of program design. Can better design practical software.
B. Object-oriented programming
Visual Basic supports object-oriented programming, but it is not exactly the same as the general object-oriented programming language (C++). In the general object-oriented programming language, the object is composed of program code and data, which is an abstract concept. Visual Basic, on the other hand, applies the object-oriented programming method (OOP), which encapsulates the program and data into an object, and endows each object with appropriate attributes to make the object become a real thing. When designing objects, you don't have to write the program code to establish and describe each object, but draw it on the interface with tools, and Visual Basic automatically generates the program code of the object and encapsulates it. Each object is displayed graphically on the interface and is visible.
C. Structured programming language
Visual BASIC is developed on the basis of BASIC language, which has the sentence structure of high-level programming language and is close to natural language and human logical thinking mode. Visual Basic statements are easy to understand, its editor supports color codes, can automatically check grammar errors, and has a powerful and flexible debugger and compiler.
Visual Basic is an explanatory language. While inputting the code, the interpretation system decomposes the high-level language into machine instructions that the computer can recognize, and judges the grammatical errors of each sentence. In the process of designing Visual Basic program, you can run the program at any time, but after the whole program design is completed, you can compile and generate an executable file. Exe) and run directly in Windows environment, without Visual Basic environment.
Visual Basic provides an open data connection, that is, ODBC function, which can use and operate large-scale network databases, such as SQL Server and Oracle, in the background through direct access or connection. In the application program, SQL data standard of structured query language can be used to directly access the database on the server, and simple object-oriented library operation instructions, locking mechanism of multi-user database access and SQL programming technology of network database can be provided to provide SQL network interface for the database running on a single computer, thus realizing the client/server scheme in distributed environment quickly and effectively. It is convenient for users and meets their needs.
D. dynamic data exchange
Using dynamic data exchange technology, the data in one application can be dynamically linked to another application, so that two completely different applications can establish dynamic data links. Linked data can be updated automatically when the original data changes. Visual Basic provides the programming technology of dynamic data exchange, which can establish dynamic data exchange with other Windows applications and realize communication between different applications.
E. dynamic link library (DLL)
Visual Basic is a high-level programming language, which does not have the function of a low-level language, and it is not easy to access the machine hardware. However, it can add programs written in C/C++ or assembly language to Visual Basic applications through dynamic link library technology, and can call functions written in other languages just like calling internal functions. In addition, through the dynamic link library, you can also call the Windows application programming interface (API) function to realize the functions of SDK.
3 the overall design of the book management system
If you want to complete a complete book management system, you need a lot of relevant information. Due to various conditions and considering the development cost, this system can only achieve basic management functions. Please forgive my shortcomings.
3. 1 system target design
The overall goal of system development is to realize the systematization, standardization and automation of internal book lending management. You can register books, that is, the basic information of books (such as title, author, price, etc. ) is pre-stored in the database for later retrieval. Be able to register borrowers. Users who use the management system can be managed, and different functional authorizations can be provided according to different job functions.
Provide convenient query methods. For example, information such as book title, author, publishing house and publication time can be used to retrieve books and reflect the borrowing situation of books; Retrieve the borrower information through the borrower number; Inquire about the contact information of the publishing house by its name. Provide perfect error control and friendly user interface to avoid misoperation as much as possible.
3.2 System Function Analysis
According to the above functions, the data of the book management system is divided into:
Data input part: mainly includes the input of basic information of books and basic information of borrowers.
Enter basic user information.
Data output part: mainly various statistical queries, including: according to book information (such as book title,
, publishing house, etc. ) Consult books and their borrowing information.
Data processing part: mainly involves the processing of borrowing and returning. For example, after lending a book, it must be returned.
According to the database, mark the book as lent to prevent the situation that there are books in the database but there are no books in the library.
After the book is returned, it must be marked as returned in the database for borrowing again.
3.3 data flow chart
3.3 1 business flow chart
Figure 3.2 Business Flow Chart
The business process is:
A. the reader consults the index card in the catalogue hall;
B. The reader writes down the classification number and species number of the borrowed books, gives them to the librarian, and shows his library card;
C. The librarian looks for books in the stacks according to their classification numbers and species numbers;
D. Give the book to the reader, and the reader will fill in the library card.
E. The librarian puts the library card in his pocket with the reader's library card number written on it.
data flowchart
1) Registration/modification of basic information of books
Figure 3.3 Flowchart of Basic Information of Books
Note: After manual input, the publishing house information is stored in the information base to facilitate the input of book information and the query of publishing house information in the future. The classification information is customized by the library and stored in the book classification information base for the classification management of books. When registering a new book, when it comes to filling in the publishing house and classification, you only need to make corresponding choices and store them in the library information base.
2) Registration and modification of the borrower's basic information
Figure 3.4 Borrower Information Map
Description: Enter the basic information of the borrower and store it in the borrower information base.
3) Book query
Figure 3.5 Book Query Flowchart
Description: After entering the query conditions, search the library information database to reflect the query results.
4) Book borrowing