2012 Fourth International Conference on Multimedia Information Networking and Security

Design and Implementation of a Library Management System

Based on the Web Service

Yujun Li , Hao Zheng , Tengfei Yang Zhiqiang Liu

Department of Computer Technology and Applications Department of Computer Technology and Applications
Qinghai University Qinghai University
Xining, Qinghai, China Xining , Qinghai , China
e-mail:1345649626@qq.com e-mail:2577972@qq.com

Abstract—At present, the level of library management way in system install and maintain[2].In contrast, the three-layer
most universities is still a manual operation. For the problem of architecture of the C/S model not only simplifies the client,but
the traditional manual operation is time-consuming and also simplifies the development and maintenance of the
inconvenience, this paper proposes a library management system system. In addition, because the core of modern library
is designed and implemented based on the web service . In this management system has a workflow of adopting, editing,
system, the three-layer architecture is employed , applying model flowing and inspection, so that it can construct with the
building language that UML carries on needs analysis and administrators and readers as the object of the three-layers of
design, using the JSP technique to build the system front structure model,and put the core workflow in the business
interface, and using SQL Server 2005 technology to build the
logic layer to centralism processing, such lavatory is benifit for
back-end database. In order to timely feedback of relevant
information for the use of the reader, we add the Guest Book
system development and deployment, and improve the
submodule to the system in implementation process. Finally, to efficiency of the information resources.
improve the operating efficiency of the database, we use the use-case analysis
stored procedures and triggers technology to optimize the The most important part of the analysis phase is the
database performance.By actual test, we correct the system bug, establishment of the use case diagram. The use case diagram
and further improve the system performance. stresses the function which users want to get and through
which the external users of participants have been able to look
Keywords-library manegement system; use case Analysis; into the system function model figure.Through the user view,
database optimization ;performance test users are clear to what task in the system design stage should
be done.The whole software implementation is focus on the
I. INTRODUCTION use-cases of the requirements phase.Through the analysis of
the system,it can determine two kinds of system roles and
The biggest characteristics of the department library is a system related use-cases.The reader can inquiry , borrow and
highly professional books collection that provides a convenient return the books.As well as the system administrator can
conditions for teachers and students to access information.But manage the information of books and readers,Lend and
with largely increasing number of the library's books, the return.According to the above analysis, figure1 shows the
traditional manual operation management is very low system overall use case diagram.
efficiency.Therefore, it is necessary for teachers and students
of the university to use the modern managemental technical of
books,and also is an important part of the school of information
construction.The development of computer technology not
only provide reliable basis for the books management
automation, but also greatly improve the quality of the service
for readers so that the reader can find their needed books
conveniently[1].
Based on the above mentioned, the system employs the
three-layer architecture,chooses the UML to establish the
system demand model, and applies JSP technique to build
system front desk interface. The backend database uses SQL
Server 2005 and Log4j log.In addition, for the convenience of
the users feedback the information as soon as possible, the Figure 1. Library Management System use-case diagram
system attaches to the message board Sub-module. system design
System Architecture
II. RESEARCH STATUS Software system structure is software super-structure, and
At present, the library management system is usually based good software architecture has the leading role in the whole
on two-layer architecture of the client/server mode, namely the life cycle of the software.The different software architecture in
C/S structure, it has the disadvantage of long development the different levels of the application,has different effects of
cycle, taking up the clients more resources, and is difficult to operation.Therefore, different levels of the software application

978-0-7695-4852-4 2012 430

433
U.S. Government Work Not Protected by U.S. Copyright
DOI 10.1109/MINES.2012.94
system choosing the appropriate software system structure has III. THE TECHNOLOGY & CORE CODE
important meaning to improve the efficiency of software
development, reduce the software costs, increase the software A. The Optimization of the Database
maintainability[3]. 1) The design of the database stored procedures:
This paper introduces the library management system using To facilitate the operation of the database, we define a set
the B/S structure of design patterns. In this system, the user of stored procedures, which can implement to easily query,
sends service in the client browser,and after the server receives add, update and delete information in the table.And a set of
requests to connect the database and identities stored procedures relating to borrowing are as follows:
verification.Then the server sents data processing applications
to the database, the database calls data or files of the database a) The bookList of stored procedures:
information in terms of the user's request of and submits the The process returns all books’ information to users.
data processing of the results to the web server. Then the server
sends again the page to the client using the HTTP protocol. In b) The BookmaxBidget of stored procedures:
this system, the web server layer uses JSP to generate page,the Through this stored procedures, it can get the largest
database layer using SQL SERVE 2005.
system Book ID in the book table of the system , so that it can
A. System Function Module Design determine the value that the next adding books should be given
During the structural design of the system, it uses the top- , namely the ID value + 1. The advantage of this way is that we
down,from the abstract to the concrete specification method
[5],which divides the complex system into each simple stand- can easily control table ID. In the stored procedures, it is
alone module by the function.Shown in Figure 1,the following needed to specify the output of the parameters ( @ maxBID is
system module, as follows:
the output parameters),and the system identifies it with output-
parameters. The core codes are as follows:
CREATE PROCEDURE BookMaxBIDGet
@maxBID int OUTPUT
AS
Select @maxBID=max(BID) from book
c) A group of stored procedures faced the librarian:
BookModify storaged procedures: the process updates the
list of the books;
BookAdd storaged procedures: the process is responsible
for inserting the new books' information into the book’s table ;
Figure 1. System Architecture Design Book_NotinLib_Check storaged procedures: this process
Each module of the system are described below: will return the book registration,which is responsible for
1) The user management module: inspecting and controling whether the books' Id is input
the user of the library management system is divided into correctly.If the books' Id is existing in the table of BookInform
three categories, First it is the average consumer who need not and the book of statement information is not in the library, we
to verify to access the system by the client browser. Second it think the book is out of circulation, that is to say the books'
is special users who can use the system to borrow books. Third return operation can be performed. In other words, it means
it is the system administrator who has the permission to release that registration is allowed to be operated, and there is no
information, manage the system privileges,and also add users, mistake. The core codes are as follows:
examine,verify,and set up permissions[2].
CREATE PROCDURE Book_NOTINLib_Check
2) The column management module:
The module is used to update the books' information on the @ IBID INT
web page and a variety of column content.Users can also AS SELECT * FROM [dbo].[BorrowInform]
browse the content according to their own needs.
3) The basic information management module: WHERE BorrowInform.IBID=@IBID AND IState=0
it mainly refers to update the basic information of the web d) ReaderBorrowHis stored procedures:
page, such as links,etc. This process is responsible to provide readers with his
return of all books.The rule is that users of borrowing
4) Back-stage management module:
information sheet are the current users,and the status of users'
The module can manage users' information,update books'
information,and restore the feedback messages by background books is returned.
administrator. 2) The design of database Triggers:
a) The realization of login module trigger’s main codes
are as follows:

434
431
 ...... End;
Begin ......
Close; d) Automatic update the database specific features main
SQL.Clear; code is as follows:
SQL.Add('select * from LoginIfo where(UserName=:a)and ......
(PassWord=:b) and (UserType=:c)'); Begin
adoquery2.Active:=false;
Parameters.ParamByName('a').Value:=Trim(edit1.Text); adoquery2.Active:=ture;
adoquery1.Clone(adoquery2,ltunspecified);
Parameters.ParamByName('b').Value:=Trim(edit2.Text); End;
Parameters.ParamByName('c').Value:=Trim(Combobo ......
x1.Text); IV. PERFORMANCE TEST
Open;
A. Function test
End;
According to the functions and procedures of library
...... management system, we adopt the Black-box testing" to
b) The main codes of determining borrowing books’trigger achieve the functional test, including the system registry, books
are as follows: management,library registration,the return of the books
registration, book evaluation, feedback,the system maintenance
......
and other functions. In the testing process, we improve where
Begin the record does not meet the functional , and make it more in
adocommandl.commandtext:='SET line with the actual needs of the library management system.
IDENTITY_INSERT BookBorrowing on';
B. Structure test
adocommandl.execute; For the structure of the programs and codes,we do a
For i:=1 to 12 do detailed test through The White-Box testing,which is based on
if stringgridl.Cells[0,i]='NewReader' then the Java standard coding structure to write.Then, we adjust the
code redundancy and correct where the testing code is not neat
Begin and the level of detail of comments. By testing, we find many
adocommandl.CommandText:='insertintoBookBorrowing([Bo problems further more, such as the messy and not standardized
rrowingId] ， [BookId] ， [ReaderId] ， [BorrowingTime] ， code writing and so on. Then we correct those mistake through
the structure test and make the program more reasonable and
[ReturnTime],[Statement]) clear.
value("'+inttostr(maxnum)+"',"'+stringgridl.Cell[l,i])+"',
"'+usernum+"',"'+stringgridl.Cells[3,i]+"','"+stringgridl.cells[4 V. SUMMARY

,i]+ "',"0","NonReturn")'; University faculty library information technology and

modern management plays an important role in the
adocommand.Execute; construction of homes and the department of resource sharing
End; platform.Students can not only easily access to the rich
End; resource of expertise in the profession,but also play a very
important role to keep abreast of the professional
...... developments. However, due to the university hospital, lacking
c) Books return its main codes is as follows: of staff development, maintenance and management, the
...... library can not be fully utilized, and also limit the role of
library.
Begin
If(date+time-returndate)>0 then Thus, in this paper we design a Library Management
System based on Web services , using the three-tier dynamic
Begin website production technology,and database optimization
Money:=0.1*(date-returndate); techniques to maximize the performance of the system.The
system has the functions of adding , deleting, modifying books
fine:=InputBox('BookExpired ， PayFine'' Fines
and readers; remote access to book an appointment, queries
Amount '，'floattostr(money)'); loan period, renewals and password change functionality. After
End; the initial test,it is basically reached the desired results.

435
432
 ACKNOWLEDGMENT [6] Lin,Yan. The library management information system[D].Electronic and
Science and Technology University, 2008
This topic is supported by the Department of Computer [7] Gong,ChangLi.Design and Implementation of the Library Management
Technology and Applications Qinghai University- "Tsinghua System[D].Shandong University, 2009
Talent Public Welfare Innovation Fund" (Project No. [8] Application of Rough Sets in Intelligent Control[A]. Proceedings of 4th
201107115). Thanks very much for supplying a good International Symposium on Test and Measurement(Volume 1)[C], 2007
experimental environment by the Laboratory of Department of [9] The Method of the Intelligent Decision Based on the Rough Set[A].
Computer Technology and Applications Qinghai University Proceedings of 4th International Symposium on Test and
and thanks for my guiding teacher liu's help. Measurement(Volume 1)[C], 2001
[10] Xu Qing,Qing xin,Li Xing-fang.The Key Technology Studying of the
dynamic Library Management System[J].Computer Knowledge and
REFERENCES Technology,2010,6(12):8-12
[11] Liu Tao,Li Zhenxing,Tang Weiqing,.etc. Library management Platform
[1] RONG Mei,ZHANG Guang-Quan,LIU Yan.Design and Implement of Using J2EE and XML[J].Journal of Computer-Aided Design &
Library System Based on Software Architecture and UML[J]. Computer Computer Graphics,2003,15(6)
Science,2007，32(06)：224-227 [12] Xiao Min.J2EE Application Development Based on Library
[2] QIAN Xiao-hua,Geng Cai-feng.The Building of Library Management ManagememtSystem[J].ComputerandTelecommunication,2009,(1):56
System in B/S Structure Based on J2EE[J].Journal of LiaoNing [13] DUAN Shu-min,XU Zi-li,WANG Yong,etc.Design and Implementation
University Natural Science Edition,2009,34(4):12-15 of Library Management System[J].Journal of Henan University(Natural
[3] Zong Wei.Research for Modeling the High School Library Management Science),2006,36(4):87-90
System Based on UML[J].Computer Science, 2011,20(12):9-13 [14] DENG Fu-e.The Development and Application of Book Management
[4] Song Bo.Java Web Application and development of the System in Reference Rooms[J].Journal of Hubei University of
tutorial[M].Beijing: TsingHua University Press，2006：112-208 Technology(Natural Science),2007,20(3):180-185
[15] LIU Ming-hui.Research and Design on Library Management System
[5] Li Zhong-wei,Liu Jian.JSP Dynamic Deb Design Technology Based on Struts and Hibernate Framework[J].Journal of Anhui
Tutorial[M].Beijing: science publishing house,2009：33-89 University Natural Science Edition,2009,33(3):36-40

436
433