Chapter 1 ORGANIZATION OVERVIEW
“Aptech Computer Education is a premier IT education Institute. Established in 1986, Aptech is a pioneer in IT software & hardware training.” OVERVIEW Aptech Computer Education is a premier ITeducation Institute. Established in 1986, Aptech is apioneer in IT software & hardware training. The Institute has successfully trained more than 65lakh (6.5 million) students through its wide network of education centres located in over 40 countries.
The Academy offers:
World class quality of education
A wide range of courses Benefits
through alliances with international companies like Microsoft, Red Hat & Oracle Job placement assistance after successful completion of career courses . According to a NASSCOM* report, the Indian IT- BPO industry is expected to grow at a rate of 1215% this year. The industry is predicted to cross revenues of USD 100 billion during 2012-13, thus creating a demand for 28 lakh qualified IT professionals. Aptech Computer Education prepares students to be a part of this growing industry.
1
Quality education: Aptech gives great importance to providing high-quality education to students. By ing an IT career course with Aptech, you get: A wide variety of career, professional, short-term & certification courses designed for the learning & career needs of students, working professionals & others Alliances with industry leaders like Java, Oracle, Microsoft & Red Hat which helps students obtain global certifications Workshops, Events & other activities to encourage student-industry interaction, prepare them for their job interviews & make them industry-ready
Business Partners: Technology has influenced every part of our life & IT skills are a must for every company today. Therefore, IT training & education has great business potential & starting your own training institute is a profitable & secure business opportunity. Aptech's reputation as a leader in IT training over the past 26 years & a wide network of centers all over India make it a sound investment for starting your own business. Aptech Ltd is the pioneer in IT
2
education franchising with many industry awards for its expertise & experience in the Franchisee business model. Aptech Ltd boasts of over 20 years of experience in training students in various sectors like animation, hardware & networking all over the world.
Course offered by aptech:
Professional courses
Smart Professional- Java
Smart Professional- .NET
Smart Professional- MIS
IT Booster - .NET
IT Booster – Java
Aptech Certified Web Designer (ACWD)
Smart ant
Certification Courses
Microsoft .NET
Red Hat Certification
Oracle
Java
Short-term courses
Cloud Computing
C in practice – Examinable
Programming Languages
Database
Foundation Courses
3
Chapter 2 INTRODUCTION TO PROJECT The project ”web based library” has many features of saving records of new books, magazines. And view them. This project reduces the manual work to much extent and stores the data and retrieves the data for further use. This project really helps the and saves his/ her time and increase efficiency. With the development of this software the organization would get faster up gradation of records of the books & magazines and would retrieve faster than manual system.This Library Management Project is best suited to manage a Library. It can retain records for future references. can view the old records as well as current records. This project has very much capacity to retaining records. It can be accessed or manipulate according to our need. Records can be retained for future use.This project can be further upgraded to handle other operation,if introduced in future,in library center
4
Project Inititation Note Client
: Aptech Computer Education
Project Name
: Web Based Library
Duration
: 6 Weeks
Quality Reviewer: Mr. Prashant Kumar Internal Auditor : Mr. Akhilesh Kumar Team
: Abhishek Kr. Bharati Indrajeet Kumar
Initiated by
: Mr. Akhilesh Kumar
Date: 12 July 2012
5
Tool and Platform Operating System
Windows XP SP2
Front End JAVA
Back End SQL Server2000
Hardware Requirements: Pentium IV Processor 512 MB RAM 80 GB Hard Disk Software Requirements: jdk1.5.0 Internet Explorer 8 SQL Server2000 Ms-office
6
Chapter 3 INTRODUCTION TO JAVA Java is a programming language originally developed by James Gosling at Sun Microsystems (which is now a subsidiary of Oracle Corporation) and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities. Java applications are typically compiled to bytecode (class file) that can run on any Java Virtual Machine (JVM) regardless of computer architecture. Java is a general-purpose, concurrent, class-based, object-oriented language that is specifically designed to have as few implementation dependencies as possible. It is intended to let application developers "write once, run anywhere". Java is currently one of the most popular programming languages in use, and is widely used from application software to web applications. The original and reference implementation Java compilers, virtual machines, and class libraries were developed by Sun from 1995. As of May 2007, in compliance with the specifications of the Java Community Process, Sun relicensed most of its Java technologies under the GNU General Public License. Others have also developed alternative implementations of these Sun technologies, such as the GNU Compiler for Java and GNU Classpath.
Java Technology
Java Technology Java Enterprise Edition (Java EE) Java Mobile Edition ( Java ME)
7
Versions
1. Product Version a. 1.0 b. 1.1 c. 1.2 d. 1.3 e. 1.4 f. 5.0 g.6.0
2. Developer Version (JDK & JRE) a. 1.0 b. 1.1 c. 1.2 d. 1.3 e. 1.4 f. 1.5 g. 1.6
8
Tools 1. Java Development Kit (1.5 & 1.6) 2. Java Runtime Environment (1.5 & 1.6)
Editor or IDE 1. Notepad 2. Kawa 3. Net Beans 4. Eclipse 5. IntelliJ 6. IBM Visual Age 7. Oracle JDeveloper Etc.
JDK Javac.exe, JAVAP.EXE, JAR.EXE etc. JRE Java Virtual Machine + Garbage Collector JVM Code Verifier + JIT (Just-In-Time) compiler
9
HISTORY OF JAVA James Gosling and Patrick Naughton initiated the Java language project in June 1991 for use in one of his many set-top box projects. Java was originally designed for interactive television, but it was too advanced. The language was initially called Oak after an oak tree that stood outside Gosling's office; it went by the name Green later, and was later renamed Java, from a list of random words. Gosling aimed to implement a virtual machine and a language that had a familiar C/C++ style of notation. Sun Microsystems released the first public implementation as Java 1.0 in 1995. It promised "Write Once, Run Anywhere " (WORA), providing no-cost run-times on popular platforms. Fairly secure and featuring configurable security, it allowed network- and file-access restrictions. Major web browsers soon incorporated the ability to run Java applets within web pages, and Java quickly became popular. With the advent of Java 2 (released initially as J2SE 1.2 in December 1998–1999), new versions had multiple configurations built for different types of platforms. For example, J2EE targeted enterprise applications and the greatly stripped-down version J2ME for mobile applications (Mobile Java). J2SE designated the Standard Edition. In 2006, for marketing purposes, Sun renamed new J2 versions as Java EE, Java ME, and Java SE, respectively. In 1997, Sun Microsystems approached the ISO/IEC JTC1 standards body and later the Ecma International to formalize Java, but it soon withdrew from the process. Java remains a de facto standard, controlled through the Java Community Process. At one time, Sun made most of its Java implementations available without charge, despite their proprietary software status. Sun generated revenue from Java through the selling of licenses for specialized products such as the Java Enterprise System. Sun distinguishes between its Software Development Kit (SDK) and Runtime Environment (JRE) (a subset of the SDK); the primary distinction involves the JRE's lack of the compiler, utility programs, and header files. On November 13, 2006, Sun released much of Java as open source software under the of the GNU General Public License (GPL). On May 8, 2007, Sun finished the process, making all of Java's core code available under free software/open-source distribution , aside from a small portion of code to which Sun did not hold the copyright. Sun's vice-president Rich Green has said that Sun's ideal role with regards to Java is as an "evangelist. 10
Chapter 4 INTRODUCTION TO JDBC JDBC provides a standard library for accessing relational databases – API standardizes • Way to establish connection to database • Approach to initiating queries • Method to create stored (parameterized) queries • The data structure of query result (table) – Determining the number of columns – Looking up metadata, etc. – API does not standardize SQL syntax • JDBC is not embedded SQL – JDBC classes are in the java.sql package
Basic Steps inUsing JDBC 1. Load the driver – Not required in Java 6, so Java 6 needs only 6 steps. 2. Define the Connection URL 3. Establish the Connection 4. Create a Statement object 5. Execute a query 6. Process the results 7. Close the connection
JDBC Step 1: Load the Driver • Not required in Java 6 – In Java SE 6.0 and later (JDBC 4.0 and later), the driver is loaded automatically. • Java 5 and earlier 11
– Load the driver class only. The class has a static initialization block that makes an instance and s it with the DriverManager. try { Class.forName("com.mysql.jdbc.Driver"); Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException cnfe) { System.out.println("Error loading driver: " cnfe); } 14 JDBC Step 2: Define the Connection URL • Remote databases – Format is “jdbc:vendorName:…” • Address contains hostname, port, and database name • Exact details given by supplier of JDBC driver • Embedded Derby database – The “Java DB” (i.e., Apache Derby) is bundled with Java 6 and can be used for a database embedded in the same Java VM that runs the app server. – Format is “jdbc:derby:databaseName” • Examples String host = "dbhost.yourcompany.com"; String dbName = "someName"; int port = 1234; String mySqlUrl = "jdbc:mysql//" + host + ":" + port + "/" + dbName; String embeddedDerbyUrl = "jdbc:derby" + dbName; 15 JDBC Step 3: Establish the Connection • Get the main connection Properties Info = new Properties(); Info.put("", "jay_debesee"); Info.put("", "secret"); 12
Connection connection = DriverManager.getConnection(mySqlUrl, Info); • Optionally, look up info about the database DatabaseMetaData dbMetaData = connection.getMetaData(); String productName = dbMetaData.getDatabaseProductName(); System.out.println("Database: " + productName); String productVersion = dbMetaData.getDatabaseProductVersion(); System.out.println("Version: " + productVersion); 16 JDBC Step 4: Make a Statement • Idea – A Statement is used to send queries or commands • Statement types – Statement, PreparedStatement, CallableStatement • Details on other types given later • Example Statement statement = connection.createStatement(); 17 JDBC Step 5: Execute a Query • Idea – statement.executeQuery("SELECT … FROM …"); • This version returns a ResultSet – statement.executeUpdate("UPDATE …"); – statement.executeUpdate("INSERT …"); – statement.executeUpdate("DELETE…"); – statement.execute("CREATE TABLE…"); – statement.execute("DROP TABLE …"); • Example String query = "SELECT col1, col2, col3 FROM sometable"; ResultSet resultSet = statement.executeQuery(query); 13
18 JDBC Step 6: Process the Result • Important ResultSet methods – resultSet.next() • Goes to the next row. Returns false if no next row. – resultSet.getString("columnName") • Returns value of column with designated name in current row, as a String. Also getInt, getDouble, getBlob, etc. – resultSet.getString(columnIndex) • Returns value of designated column. First index is 1 (ala SQL), not 0 (ala Java). – resultSet.beforeFirst() • Moves cursor before first row, as it was initially. Also first – resultSet.absolute(rowNum) • Moves cursor to given row (starting with 1). Also last and afterLast. 19 JDBC Step 6: Process the Result • Assumption – Query was “SELECT first, last, address FROM…” • Using column names while(resultSet.next()) { System.out.printf( "First name: %s, last name: %s, address: %s%n", resultSet.getString("first"), resultSet.getString("last"), resultSet.getString("address")); } • Using column indices while(resultSet.next()) { System.out.printf( "First name: %s, last name: %s, address: %s%n", resultSet.getString(1), resultSet.getString(2), 14
20 resultSet.getString(3)); } JDBC Step 7: Close the Connection • Idea – When totally done, close the database connection. However, opening a new connection is typically much more expensive than sending queries on existing connections, so postpone this step as long as possible. – Many JDBC drivers do automatic connection pooling – There are also many explicit connection pool utilities • Example connection.close();
15
Software requirement analysis
2jdk1.5.0 Notepad & Net beans 6.5.1 Internet Explorer 8 SQL Server2000 Ms-office Operating system(window 7/window vista)
16
Chapter 5 DATA FLOW DIAGRAM The DFD is an excellent communication tool for analysts to model processes and functional requirements. Used effectively, it is a useful and easy to understand modeling tool. It has broad application and usability across most software development projects. The data flow diagram shows how data flows form one point to another point in the current physical system. The processes through which the transformation of the data takes place normally create the data and used it. The four basic symbols are used to construct the data flow diagram. These are the symbols which represents data source, data flow, data transformation, and data storage. The point at which data transformed are represented by enclosed figure, usually circles, which are called nodes.
Level-0
Data
Data
Authentication
Unit Of Operation
17
list
Level-1.1
Member Detail
Member
Member List
Member Entry
Level-1.2
Book Return
Stock
Stock Entry
18
Book Detail
Stock Details
Level-1.3
Member Id
Issue Book
Book code
Member Id
Book Details
Level-1.4
Member Id
Return Book
Book code
19
Member Id
Book Details
E-R DIAGRAM
Web Based Library
View Stock
View Defaulter list Create Member
Name
Mo. No.
Address Email ID
Create Member
Name
Issue Book
Stock Entry
Address
Return Book
No Of Book
Book Code Publication
M-ID
Name Of Book Category Email ID
Mob-No.
Move To Next Page
20
Issue Book
Return Book
Fine
Book Code
Schedule Return Date
Book Code
Actual Return Date
Member ID
Member Id
Schedule Return Date
Issue Date
21
DATA STRUCTURES
Table: Authentication Field
Data
Size
Name
Type
U_Name
Varchar2
15
Pwd
Varchar2
10
Field
Data
Size
Name
Type
Name
Varchar
20
Address
Varchar
30
M_ID
Varchar
10
varchar
20
Email_Id
Varchar
30
Mob_No.
Int
Table: Member
Table: Stock:Field Name
Data
Size
Type B_Code
Varchar
20
Name
Char
20
22
_of_Book Caregory
Varchar
20
Publication
Varchar
20
No_of_Book
Int
Table: Issue_Book Field Name
Data
Size
Type Book_Code
Varchar
10
Member ID
Varchar
30
Issue Date
Date
ScheduleReturnDate
Date
Table: ReturnBook Field Name
Data
Size
Type B_Code
Varchar
20
M_ID
Varchar
20
ScheduleReturnDate
Date
ActualReturnDate
Date
Fine
Int
23
MODULE DESCRIPTION There are various Modules in the project:-
Authentication:This module is gives the permission to to use the library because it holds Id & also hold the Id and .
Member:`
This module store the many types of Id and details.
Stock:This module stores the book details which are available or not.
Issue Book:This module maintain the records of books which is issue to s.
Return Book:This module manage the returnig date of book and also calculate the fine which is generated by delay time of returning date.
24
COST ESTIMATION OF THE PROJECT In case of this software, it is a live project for the submission of BSC(IT) paper. Hence, this software is of cost free. But as far as the cost estimation is concerned, it is a technique by which a S/W Development company can prepare Cost Analysis Report. This will help the company to prepare product price including their profit.
PERT CHART Some of the advantages of pert chart It forces the manager to plan.
It shows the interrelationships among the task in the project.
It clearly identifies critical path of the project.
It exposes all possible parallelism in the activities and thus helps in allocating resources.
It allows scheduling and simulation of alternative schedules.
It enables the manager to monitor and control the project.
0
beginning Prototype
2 2 1
Beginning Of Needs
3
5
2 Problem
13
Final Documentation
Understanding
Acceptance Testing 6
2
92
7 3 Problem Listing 12
Unit Testing 25
8 2 9
10
86
14
Testing
Problem 4
Interviewing 11
3
12 5
40
Coding
76
Evaluation of
15
Installation
Existing system
3
15 Analysis of Alternate candidate 6
Detail Design 10
8
Specification
36
Details execution 3
18
Delivery
of Project
7
9
General Specification
6
4
8
16
28
22 Data collection
26
GANTT CHART Gantt charts (developed by Henry L. Gantt) are a project control technique that can be used for several purposes including scheduling, budgeting and resource planning. A Gantt chart is a bar chart with each bar representing an activity. The bars are drawn against a time line. The length of each bar is proportional to the length of time planned for the activity. Gantt chart can take different phase depending on their intended use. The Gantt chart of WEB BASED LIBRARY is drawn for the time management.
Gantt chart is drawn below.
Gantt Chart for Web Based Library YEAR 2010 16Dec
24Dec
Start
Analysis
Design Database (Back End)
Design of LMS diffenent form (Front End) Part
Code data base part
Code Part of LMS Report Generation
Write Manual
Integration & Testing
27 Finish
Chapter 6 Project Legacy FUTURE SCOPE This application can be easily implemented under various situations. We can add new features as and when we require. Reusability is possible as and when require in this application. There is flexibility in all the modules. Reusability is possible as and when require in this application. We can update it next version. Reusable software reduces design, coding and testing cost by amortizing effort over several designs. Reducing the amount of code also simplifies understanding, which increases the likelihood that the code is correct. We follow up both types of reusability: Sharing of newly written code within a project and reuse of previously written code on new projects.
The different areas where we can use this application are: Any educational institute can make use of it for providing information about author content of the available books. It can be used in offices and modifications can be easily done according to requirements. It also saves our time in this chalanging world. Because it runs on the Web browser and connect to many peoples through internet who interested in web based library. It will be the simpler way to access libraries.
28
Chapter 7 Source code Html:Library.Html:-