DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep
DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONS
USING JAVA IN PUBLIC ELEMENTARY SCHOOLS
Volume 3 Issue 2 (August 2.
e-ISSN 2722-6395 doi: 10.
30997/ijar.
ARTICLE INFO
Article history:
Received: 31-07-2022 Revised version received: 03-08-2022 Accepted: 25-08-2022 Available online: 31-08-2022 Keywords:
Program Planning Library Program.
How to Cite:
Encep.
DESIGN OF
DESKTOP-BASED LIBRARY
APPLICATIONSUSING JAVA IN PUBLIC
ELEMENTARY SCHOOLS.
Indonesian Journal of Applied Research (IJAR), 3.
, 115-130.
https://doi.
org/10.
30997/ijar.
Corresponding Author:
Muhammad Encep ahmadpoac@unida.
Muhammad Encep1 1 Computer Science.
Universitas Djuanda.
Bogor.
Indonesia
ABSTRACT
The library is a place that provides a vast collection of books, which are financed and operated by a city or institution, and used by people who, on average, cannot afford to buy many books at their own expense.
The research was carried out in a library in a Bogor City State Elementary School, which was closed.
The library visitors consisted of teachers, staff, and public elementary school students.
Borrowing books is usually on the instructions of teaching teachers to do school assignments concerning books that can be borrowed in the library.
Library management is still done manually in processing library data, so they often experience difficulties in managing books and membership data, collecting data on the borrowing process, and returning and making reports.
In addition, library operations have not yet run optimally.
The research method used is Research and Development with several stages, namely Planning and Needs Analysis.
Analysis by conducting Literature Studies, interviews and observations.
Design.
Implementation.
Testing and Integration, and Maintenance.
The study results are in the form of a computerized system that facilitates library activities to run well, especially in presenting fast, precise, accurate, and safe information that can overcome various existing Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022
DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep
INTRODUCTION
Facing the era of globalization, education is a significant and fundamental need for everyone because education is the root of a nation's civilization.
Education can be obtained in many ways, including through formal and non-formal education.
One of the efforts to bring education through non-formal channels can be made by utilizing library facilities.
The use of libraries has received government attention through the Law of the Republic of Indonesia Number 20 of 2003 concerning the national education system.
In article 45, it is stated that "every formal and non-formal education unit provides facilities and infrastructure that meet educational needs by the growth and development of physical potential, intellectual,social, emotional, and psychological intelligence of students.
According to RI Law Number 43 of 2007 concerning Libraries article 23 paragraph .
states, "Every school/madrasah organizes a library that meets the national library standards by taking into account the national education " A library is a room, part of a building, or the building itself that is used to store books and other publications, which are usually held according to a particular arrangement for the use of readers, not for sale (Qalyubi.
, 2.
Academic libraries are excellent sources of information and knowledge to provide a wide range of services to meet user needs (Iqbal et al.
, 2.
In line with the critical role of libraries, library information system applications are now Many libraries have used library information system applications as an essential part of improving the performance of library staff and library organizations.
Technological developments make people think to be able to work more effectively and efficiently.
One of them is to create a conventional system into a computerized system (Yahya, 2.
computerized system can assist the librarian in processing library data and printing reports (Panjaitan et al.
, 2.
Website-based library applications make it easier to find the desired information and build a more structured library information system (Maimunah et al.
,2.
Digital libraries will improve the quality of services and the transmission rate of digitallibrary information (Shi & Zhu, 2.
Library Information System provides convenience andspeed in processing library data to improve library services (Nurhayati, 2.
Digital Library application development in the future will be a solution to the problems that exist in the application (Mayasari & Irawan et al.
, 2.
Android-based library applications increase children's literacy interest and are easily accessible to the public (Ramadhani & Saputro.
Information systems that can manage library management more effectively and efficiently canuse intelligent libraries (Andriyani et al.
, 2.
From this background, the author researched a public elementary school in one of the cities of Bogor, a government-owned educational institution under the auspices of the Education Office.
At the school, library facilities are widely used by the students and the teachers and staff as auxiliary facilities in the teaching and learning process.
Based on several previous research references related to the creation of a computerized system for libraries that have been found by several researchers above, the results of the research show that an automated system can facilitate work to be more effective and efficient, processing library data and reports more efficiently, realizing a more comprehensive library information system.
Structured, improved service quality and digital transformation are easily accessible to the public and support the intelligent library concept.
So far, library management is still done In processing the data, in the form of book data, membership data, borrowing, returning, and preparing the necessary reports, they have not been managed properly.
Hence, they often experience difficulties managing library books, membership data, collecting data on the borrowing and returning process, and makinga report as a form of responsibility for the performance of library staff and library organizations.
In addition, the operation of the library until now has not run optimally.
Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep With these problems, making library information system applications is expected to help in library management, and it is hoped that in the future, library operations at the school can run optimally because library applications can make it easier for librarian officers to do work and can work effectively with existing systems (Loi et al.
, 2.
Purpose and objectives The aims and objectives of this research are:
Creation and development of a computerized system for processing library data at SD Negeri Bogor City, from a manual system to an automated system, to facilitate activities in the school library so that the information obtained is faster, more precise, and accurate.
Helping the management of the library in one of the public elementary schools in the city of Bogor so that it can be better managed, and it is hoped that in the future, library operations can run optimally.
Scope In the scope of this study, the authors provide a limitation of the problem, namely by discussing the problem of borrowing, returning, and reporting transactions at the library in one of the State Elementary Schools in Bogor City, which starts from processing user data, then processing book data, then processing membership data, then processing borrowing and Closed with the process of making several reports, including book data reports, membership reports, loan reports, and return reports.
METHODS
One of the important factors in the development/development of information systems is to understand the existing system and its problems (Sutabri, 2.
This study uses the Research and Development research method with several stages carried out, namely as follows:
Planning and Needs Analysis Analysis by conducting literature studies.
Interview, and Observation.
Literature Study Covers the collection of theoretical data and information by studying books, references, and other literature related to the research title.
The interview process was carried out with the person in charge and the school librarian regarding library management, including processing book data, membership data, borrowing, and returning books and reports, which will be used for library program design.
Observations were made by direct observation in the school library, including book data recording, membership registration, borrowing, and returning books and reports made.
Design by making a system design that is poured into a business process model equipped with HIPO (Hierarchy Input Process Outpu.
Program Specifications, flowcharts, and User Interface Design.
Implementation where the system is built using tools and applies concepts as needed.
Testing and Integration with UAT (User Acceptance Testin.
ensures the system follows the needs.
Maintenance by evaluating to see if the system developed is following the initial design, how successful the implementation is, and the benefits of using the system.
Maintenance, and Long-Term Planning.
Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022
DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep
RESULTS AND DISCUSSION
The library in one of the public elementary schools in Bogor City is a closed library type, where the use of library facilities is used by internal school parties, consisting of students, teachers, and staff as support in the teaching and learning process.
School library management is still done manually, both in processing data, in the form of book data, membership data, borrowing, returning, and making reports, so they often experience difficulties in managing library books, membership data, collecting data on the borrowing process and returns and reporting as a form of responsibility for the performance of library staff and library organizations.
In addition, the operation of the library until now has not run With these problems, making library information system applications is expected to help in library management, and it is hoped that in the future, school library operations can run optimally.
File Normalization A file consisting of several groups of elements that repeatedly need to be reorganized.
The process of organizing files to eliminate repetitive groups of elements is called normalization (Jogiyanto, 2.
Normalization can be understood as stages, each of which is related to the standard form.
The typical format is a relational state generated by applying simple rules regarding the concept of functional dependence on the relation in question (Nugroho, 2.
Making normalization is used as a reference for making files or databases that will be used in the application to be made.
Un Normalized Form and 1NF/First Normal Form Figure 1 Un Normalized Form Figure 2 1NF/First Normal Form Figure 1 is a collection of data to be recorded, and there is no need to follow a specific The data may be incomplete or duplicated.
The data are grouped as is according to their arrival.
Meanwhile.
Figure 2 the first standard form is met if a table does not have manyvalued attributes or more than one attribute with the same value domain.
Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep 2NF/Second Normal Form and 3NF/Third Normal Form Figure 3 2NF/Second Normal Form Figure 4 3NF/Third Normal Form Figure 3 is the second standard form is met if the data has met the criteria of the first standard form, and every non-key attribute must be functionally dependent on the primary Figure 4 has the condition that the relation must be in the second standard form, and all non-primary attributes have no transitive relationship.
File Specification In designing library programs.
The database that the author uses is MySQL.
The database file is created with the following file specifications:
File User and Member Files Table 1 User File Specification Specification Table 2 Member File Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Book Files and Loan Files Table 3 Book File Specification Table 4 Loan File Specification Loan Details File and Return Files Table 5 Loan Details File Specification Table 6 Return File Specification Code Structure Member Code Example:
Information: 327101170 : NIS/NIP Book Code Example :
Information:
: Book Type AoPembelajaranAo MAT : Book title AoMatematikaAo 3 : Book Reference AoKelas 3Ao Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Loan Number Code Return Transaction Number Code Example:
Example:
Information:
: Borrowing date 01 : Loan Serial Number Information:
010512: Date of return : Return Sequence Number Data Security Plan In designing this program, the author makes a data security design through a login form where everyone using this program must enter a user name and password.
It is intended that not just anyone can apply to this program.
The author makes a data security design with two access rights, namely:
Admin Is access that has the right .
to perform all activities in the application program that the author has made.
User It is accessible with limited rights for certain activities such as managing book data, membership data, borrowing, returning, and searching.
Meanwhile, officers' data management, login updates, and reports are not given access and authority.
HIPO (Hierarchy Input Process Outpu.
Program Specifications The program specifications that the author made are a more accurate description of the HIPO (Hierarchy Input Process Outpu.
diagram to make it easier for users to find out the HIPO form of the Pamoyanan 3 Elementary School library application, which the author has made, as for the HIPO form, namely:
Figure 5 HIPO (Hierarchy Input Process Outpu.
Diagram Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Program Flowchart Flowcharts are used in describing an algorithm.
The function of making a program flowchart is:
So that the program made can be more easily understood.
To make the relationship between procedures and instructions clearer.
Login.
Connection and Main Menu (Admi.
Program Flowchart Figure 6 Login and Connection ProgramFlowchart Figure 7 Main Menu (Admi.
Program Flowchart Main Menu (Use.
and Update Login Program Flowchart Figure 8 Main Menu (Use.
ProgramFlowchart Figure 9 Update Login ProgramFlowchart Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Searching and Officer Data Program Flowchart Figure 10 Flowchart Program Searching Figure 11 Officer Data Program Flowchart Member Data.
Book Data and Data Lending Transaction Program Flowchart Figure 12 Member Data and Book Data Program Flowchart Figure 13 Lending Transaction Program Flowchart Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Return Transaction and Member Report Program Flowchart Figure 15 Member Report ProgramFlowchart Figure 14 Return Transaction ProgramFlowchart Book Report and Transaction Report Program Flowchart Figure 16 Book Report Program Flowchart Figure 17 Transaction Report ProgramFlowchart Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Application.
Programmer and Program Help Program Flowchart Figure 18 Application Program Flowchart Program Help Figure 19 Programmer and User Interface The following is a user interface of the library application that has been created:
Login Form and Main Menu Form Figure 21 Main Menu Form Figure 20 Login Form Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Update Login Form and Search Form Figure 23 Search Form Figure 22 Update Login Form User Form and Member Form Figure 24 User Form Figure 25 Member Form Book Form and Loan Form Figure 26 Book Form Figure 27 Loan Form Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Return Form and Transaction Report Form Figure 28 Return Form Figure 29 Transaction Report Form Application Form and Help Form Figure 31 Help Form Figure 30 Application Form Program Support Facilities To support the data processing needs, a computer is needed as a tool because the speed of data processing is one of the advantages of computers.
In its use, computers require appropriate application programs to process data to produce faster, more precise, and accurate information, as well as human resources that run computers and their programs.
Thus, a sound information system must be supported by the following components:
Hardware is equipment from a computer system that can be physically seen and .
Software is a program that contains commands to process data.
Brainware is a human who plays a role inoperating and managing computer systems.
These three elements must be interconnected and form a single unit.
Hardware without Software will not function as expected, and hardware supported by Software will not work if there is no brainwave to operate it.
Taking this into account, supporting facilities are needed in implementing a computerized system so that the automated system that has been created can work as expected.
Hardware The application of a computerized system is closely related to the specifications of the hardware that will be used to run software or application programs.
The proper hardware specifications must be selected so the computer system's performance can run well.
Computer system users can feel that ease and comfort.
The hardware consists of three main parts.
CPU (Central Processing Uni.
Input Device Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep Output Device With the above considerations, the authors provide hardware specifications that will be used in the computerization process, including:
Proccesor
: Pentium Core i5
Memory (RAM) : 4 GB atau lebih Monitor
: SVGA 15Ay Harddisk
: SSD 500 GB
Disk
: CD ROM
Keyboard : 102 Keys Mouse : PS/2 Optical/Standard Printer : Ink jet The authors refer to these specifications considering the rapid development of technology in the computer field so that the computer specifications can still show good performance results for the next few years.
Software The use of a computerized system will not be separated from the problem of software .
that will be used to run the application program.
The required software specifications are JDK 8.
Apache NetBeans 14, and MySQL.
Java NetBeans programming and data storage in the MySQL database can provide the library's smooth processing of information systems (Yulianti, 2.
Software is functionally divided into operating systems and program packages:
Operating system The operating system used is a Windows-based operating system, which is one of the operating systems that support theapplication program that the author makes because the programming that the author makes uses the Java programming language, which has the advantage of multi-platform, which can be run on various operating systems in which there are Java DevelopmentKit (JDK), which contains the JRE (Java Runtime Environmen.
Program Packages The program packages that the author uses in making this final project are:
Operating System: Microsoft Windows10 .
Program Packages: JDK 8 and Java SEDevelopment Kit 8 .
Apache NetBeans IDE 14 .
Database: MySQL (Xampp Version3.
CONCLUSION
The conclusion that can be formulated after the author completes this research is that this library program helps the performance of library staff and library organizations to implement library operations effectively and efficiently.
This library system can provide fast, precise, accurate, and safe information.
The author tries to provide suggestions, especially on several matters relating to application programs that have been developed, including:
The initial stage of using a computerized system should be training Library Staff and Library Organizations in the use of the program, anticipating errors that mayarise when Indonesian Journal of Applied Research (IJAR), volume 3 issue 2 Ae August 2022 DESIGN OF DESKTOP-BASED LIBRARY APPLICATIONSUSING JAVA IN PUBLIC ELEMENTARY SCHOOLS Ae Encep using it later, and producing the desired output.
And socialize this new computerized system to all teachers,staff, and students.
In using the application program, it is better to determine the parties who can access the program by providing a user name and password to maintain data security and access.
The use of computers is beneficial in completing a job, but that does not mean its use without risk.
The risk that often arises in the use of computers is the loss of data on the hard disk or data exposed to viruses.
For this reason, the user mustback up any data used regularly to avoidthis risk.
Regular upgrades and program revisionsare needed.
So that the applicationprogram that has been created alwaysruns as expected and keeps up with technological developments that continue to grow.
ACKNOWLEDGMENT
The author realizes that the completion of this writing is also thanks to the guidance and encouragement from all parties.
Therefore, the author would like to express his gratitude to Mrs.
Hj.
Oneng Harsiti.
MPd As the Principal.
Parents, and beloved family, who have helped morally and materially.
All parties cannot be mentioned one by one who has helped in completing this writing.
Finally, the author realizes that this writing is not perfect.
Therefore, he asks for constructive criticism and suggestions for the perfection of writing in the future.
Hopefully, this writing can be helpful, especially for writers and readers.
REFERENCES