Final Report BTS-1

MAJOR PROJECT
ON
BUG TRACKING SYSTEM
SUBMITTED BY:
NAME -: HARSH MODANWAL
COURSE-: B.Sc. IT
ROLL NO -: 209505
Email id: harshmodanawal@gmail.com
SUBMITTED TO:
DR. NEERAJ KUMAR TIWARI
(CO-ORDINATOR OF DIT)
DEPARTMENT OF INFORMATION TECHNOLOGY

BABASAHEB BHIMRAO AMBEDKAR UNIVERSITY
SATELLITE CAMPUS AMETHI,227413 INDIA
1
TABLE OF CONTENTS
1. Abstract 8
2. Title of the Study 9
3. Literature survey 9
4. Introduction 10
4.1 Project Overview 10
4.2 Purpose 10
4.3 Scope 10
4.4 Definition, Acronyms, Abbreviations 11
4.5 Existing System 11
4.6 Proposed System 11
5. Functional Or Specific Requirements 12
5.1 External Interface Requirements 12
5.1.1 Software Interface 12
5.1.2 Hardware Interfaces 13
5.2 Non-Functional Requirements 13
5.2.1 Security 13
5.2.2 Reliability 13
5.2.3 Portability 13
5.2.4 Performance 14
5.3 Database Requirements 14
5.4 Method to be Used 14
5.5 Hardware 15
2
5.5.1 Server 15
5.5.2 Client 15
6. Analysis And Design 16
6.1 Data Flow Diagram 16
6.1.1 DFD Symbols 16
6.1.2 DFD Level 0 16
6.1.3 DFD Level 1 17
6.1.4 Diagram which shows the working of the Site 17
7. User Interface 18-22
8. Limitation and future enhancement 23
9. Sample Code Layout 23-59
10. References 60
11. Suggested Webpages 61
3
DECLARATION
I hereby declare that the Major project work entitled “Bug Tracking System” is an
authentic record of our own work carried out as requirements of Capstone Project for
the award of BSc.IT degree in Information Technology from Babasaheb Bhimrao
Ambedkar University Satellite Centre (A Central University) under the guidance of
Dr. Neeraj Kumar Tiwari during January to June 2023. All the information furnished
in this capstone project report is based on our own intensive work and is genuine.
Signature of Student
Name – HARSH MODANWAL

Roll No – 209505
Enrollment No.- AC-023/20
Mobile No - +91-8127543191
Email Id – harshmodanawal@gmail.com
Date-
Certified that the above statement made by the student is correct to the best of our knowledge and
belief.
Signature of Supervisor Signature of Examiner
4
ACKNOWLEDGEMENT
I express my sincere thanks and indebtedness to my esteemed institution, Department

of Information Technology, Babasaheb Bhimrao Ambedkar University Satellite
Centre, Tikarmafi, Amethi which provides me with opportunity to fulfil my desire and
reach my goal. First, I would like to express my sincere appreciation and deep debt to
respected head of department Dr. Neeraj Kumar Tiwari and my internal project
supervisor and other teacher of department for their astute guidance, constant
encouragement and sincere support for this project work.
HARSH MODANWAL
5
CERTIFICATE
This is to certify that the Harsh Modanwal declaration statement of student is correct
to the best of my knowledge and belief. I have completed this Capstone Project under
my guidance and supervision. The present work is the result of their original
investigation, effort and study. No part of the work has ever been submitted for any
other degree at any University. The Capstone Project is fit for the submission and partial
fulfilment of the conditions for the award of BSc.IT degree in Bachelor of Science in
Information Technology from Babasaheb Bhimrao Ambedkar University, Satellite
Centre, Amethi.
Dr. Neeraj Kumar Tiwari

Designation
Assistant Professor (coordinator of Department)
Bachelor of Science in Information Technology
Babasaheb Bhimrao Ambedkar University
Satellite Centre, Amethi U.P. INDIA
Date – 17-05-2023
6
PREFACE
I am developing to this website to take that my good this opportunity to express my

honorable to all those people who have been to communicate directly and indirectly
with me during the completion of this project. We are paying a very great thanks to my
guide, Dr. Neeraj Kumar Tiwari who has given guidance and a light to us during this
project session. We acknowledge here out debt to those who contributed significantly
to one or more steps. We take full responsibility for any remaining sins of omission and
commission.
7
1. ABSTRACT
This project Bug Tracking System for Improving Software Quality and Reliability is to keep
track of employee skills and based on the skills assigning of the task is done to an employee.
Employee does bugs capturing. It can be done on daily basis. Various Reports are generated
by this System for an employee and as well as to a manager.
Tracking system must be in place for every infrastructure we design. Software is no exception
to this. This application which will be implemented on Java platform is designed to track the
status of bugs that are reported during Software testing.
Bug Tracking System is an ideal solution to track the bugs of a product, solution or an
application. Bug Tracking System allows individual or groups of developers to keep track of
outstanding bugs in their product effectively. This can also be called as Defect Tracking
System.
This project will be accessible to all developers and its facility allows developers to focus on
creating the database schema and while letting the application server define table based on the
fields in JSP and relationships between them.
This application software has been computed successfully and was also tested successfully by
taking “test cases”. It is user friendly, and has required options, which can be utilized by the
user to perform the desired operations.
Bug information includes the bug id, bug name, bug priority, project name, bug location, bug
type. This whole process continues until all the bugs are got fixed in the application. The
software is developed using Java as front end and Oracle as backend in Windows
environment.
8
2. TITLE OF THE STUDY
Bug Tracking System: Developing a Custom Bug Tracking System for Your Team.
3. LITERATURE SURVEY
Bug Tracking System is an ideal solution to track bugs of a product, solution or an application.
Bug Tracking System allows individual or groups of a developers to keep track the bugs of
outstanding bugs in their product effectively [2]. This can also called as Defect Tracking
System.
The Bug Tracking System can dramatically increase the productivity and accountability of
individual employee by providing a documented work flow and positive feedback for good
performance [5].
For many year, bug-tracking mechanism is employed only in some of the large software
development houses most of the other never bothered with bug tracking at all, and instead
simply relied on shared list and email to monitor the status of defect [3]. This procedure is
error prone and tends to cause those bugs judged least significant buy developers to be dropped
or ignored.
In any in any software development books are inevitable. Let it be any kind of product bugs
rise to any phase of development [1]. One has to take a great care in proper maintenance and
resolution of the bugs. in the existing system the bugs are not properly maintained and they
are simply relied on shared lists and email to monitor the bugs. In this type of system. it
becomes difficult to track a bug is overlooked then it may be cause tremendous errors in the
next phase and can improve the cost of project whatever necessary effort spent on the bug
maintenance may not be worthy. So, bug history has to be maintained properly. And there is
no efficient search technique. One has to search the whole database for the details of particular
bug which might have occurred sometime earlier [7]. it is both time consuming and error
prone. And it is very difficult to share the bug among several users as there is no proper
maintenance of the bugs.
In order to have an efficient product bugs must be maintained properly and should be resolved
in time both to reduce time and money spent on the development.
9
4. INTRODUCTION
4.1. Project Overview

Bug tracking is the process of reporting and tracking the progress of bugs from discovery through to
resolution, where a bug is defined as a deviation from requirements. Other terminology frequently
used to describe this process include:
• Problem tracking
• Change management
• Fault management
• Trouble tickets
Bug tracking systems are most commonly used in the coding and testing phases of the software
development process [7]. However, tracking systems can in fact be used for many other purposes such
as general issue tracking, simple task lists, help desk situations or contact management, where the
focus is on the tracking aspect rather than what is being tracked. Even in software development,
tracking systems are quite often not limited to simply tracking bugs, but extended to track feature
requests or enhancements as well as enquiries.
4.2. Purpose
The purpose of Bug Tracking for improving software reliability is to provide better service to the
administrator or useful for applications developed in an organization.
• To reduce the time constraint involved.
• To centralize all the data needed.
• To generate various reports as required
• To maintain the user rights.
4.3. Scope
The Bug Tracking for Improving Software Reliability is a web-based application that can be accessed
throughout the organization. This system can be used for logging bugs against an application/module,
assigning bugs to team members and tracking the bugs to resolution. There are features like email
notifications, user maintenance, user access control, report generators etc. in this system.
10
4.4. Definition, Acronyms, Abbreviations
Bug - A software bug (or just "bug") is an error, flaw, mistake, failure, or fault in a computer
program that prevents it from behaving as intended (e.g., producing an incorrect result). Most bugs
arise from mistakes and errors made by people in either a program's source code or its design, and a
few are caused by compilers producing incorrect code.
4.5. Existing System

The existing system consists of entering the details in the Microsoft Excel Sheets for the storing of
the data. When a manager needs information of the employee, he searches for the specified file in the
file system. He opens the file and takes the information. Report Generation done manually by copying
the content of the different files into another file. The Manually generated report was then printed.
Limitations in Existing System

• Information retrieval is a very big process.
• Lack of organization of the files may porn to information loss due to accidental deletion of
files.
• No security because the files are visible to the users.
• Report generation will be a big task.
4.6. Proposed System
The Proposed system is a browser which is completely related to online system, which provides the
centralized database. It stores bugs data and description of the particular bug data. It can also create
Excel reports and PDF documents based on the information in its database.
Advantages over Existing System
• The performance is increased due to well-designed database.

• Security is increased
• Time saving in report generation
• Easy to update the details
11
5. FUNCTIONAL REQUIREMENT
Required software is for conducting online thesis management and provides upload and download
function. The system should satisfy the following requirements:
• Administrator Aspect
To upload thesis, documents, presentation by providing the title and description.

To approve users to access the system.
To maintain the details of members and thesis.
To view all the members and thesis.
To Upload thesis, documents, presentations
To change password.
Scheduling the work.
• Student Aspect
To view / update their profile.

To update their password.
To download thesis, documents, presentations.
To search thesis by name, title, authors etc.
• Analysis
Authenticating users based on username and password.
Keeping session track of user activity.
Only registered candidate can download thesis.
Only administrator can upload thesis.
5.1. External Interface Requirements

Software Requirements
Operating System : Windows XP/ Windows 7/8
User Interface : HTML, CSS
Client-side Scripting : JavaScript
Programming Language : Java
Web Applications : JDBC Servlets, JSP
Database : Oracle/Access
12
Hardware Requirements
Processor : Pentium IV
Hard Disk : 40GB
RAM : 256MB
Database
Oracle Server
5.2. Non-Functional Requirements
• System should be able handle multiple users.
• Database updating should follow transaction processing to avoid data inconsistency.
5.2.1. Security
• Administrator has the highest authority to edit/delete/create database
• Administrator have the authority to add/expel students
• Students can view and download thesis
5.2.2. Reliability
Data validation and verification needs to be done at every stage of activity.
• Validating user input
• Use of locking mechanism while updating database like transaction processing
• Recovering the transaction using rollback.
5.2.3. Portability
• The web application will be built using JSP which has support to run on any platform provided
the required compilers are available.
• For database SQL Server would be used, that too has extensive support over many popular
architectures and operating systems.
13
5.2.4. Performance
The system would be used by multiple users at a time and may grow as time passes; the system
would need to implement multithreading to achieve acceptable performance. Further a database
connection pool may also be required for assigning faster database connection.
5.3. Database Requirements

The overall objective in the development of the database technology has been to treat data as an
organizational resource and as an integrated whole. Database management system allows data to be
protected and organize separately from other resources. Database is an integrated collection of data.
The most significant of data as seen by the programs and data as stored on the direct storage access
storage devices.
5.4. METHOD TO BE USED

This section lists all the technologies for the web-based system.
• Core Java: Java is a set of computer software and specifications developed by Sun
Microsystems, later acquired by Oracle Corporation that provides a system for
developing application software and deploying it in a cross-platform computing
environment.
• JSP: Java Server Pages (JSP) is a technology that helps software
developers create dynamically generated web pages based on HTML, XML, or other
document types. To deploy and run Java Server Pages, a compatible web server with
a servlet container, such as Apache Tomcat or Jetty, is required.
• Servlet: Java Servlets are programs that run on a Web or Application server and act
as a middle layer between requests coming from a Web browser or other HTTP client
and databases or applications on the HTTP server.
• Eclipse IDE: Eclipse is a software development platform written in Java. The Eclipse
Platform allows applications to be developed from a set of modular software
components called modules. Applications based on the Eclipse Platform, including the
Eclipse integrated development environment (IDE), can be extended
by third development party.
• HTML: HTML is a markup language for describing web documents (web
pages). HTML stands for Hyper Text Markup Language. A markup language is a set
of markup tags. HTML documents are described by HTML tags. Each HTML tag
describes different document content.
14
• JavaScript: JavaScript is a high-level, dynamic, untyped, and interpreted
programming language.
• SQL: SQL is a fast, easy-to-use RDBMS being used for many small and big
businesses. SQL is becoming so popular because of many good reasons like SQL is
released under an open-source license. So, we have nothing to pay to use.
5.5. Hardware
The recommended hardware specified by the respective software would suffice the needs. The
memory and processing power needed would increase as the number of users increase. The
estimated hardware requirements are as specified.
5.6. Server
The minimum hardware as recommended by all of the software required on server side say web
server, operating system and development software-
• Processing speed of 1.6 GHz
• 2 GB of RAM
• Network interface
5.7. Client
The minimum hardware as recommended by all of the software required on client side say web
browser, operating system
• Minimum hardware depending on the operating system used
• True color visual display unit
• User peripherals for better interaction
15
6. ANALYSIS AND DESIGN
6.1. Data Flow Diagram
In our DFD, we give names to data flows, processes, and data stores. Although the names are
descriptive of the data, they do not give details. So the following the DFD, our interest is to
build some structured place to keep details of the contents of data flow, processes, and data
store. A data dictionary is a structured repository of data about data. It is a set of rigorous
definition of all DFD data element and data structure
6.2. DFD Symbols

In the DFD, there are five symbols,
1 A Square defines a source (originator) or destination of system data.
2 An Arrow identifies data flow- data in motion It is pipeline through which information flows.
3 A circle or a bubble or a oval bubble represents a process that transforms incoming data flow(s)
into outgoing data flow(s).
4 An Open rectangle is a data store-data at rest, or temporary repository of data.
6.3. Data Flow Diagram: Level 0
Programmer Administrator
Bug Tracking
System
Database
16
6.4. Data Flow Diagram: Level 1
BTS - TOP LEVEL DIAGRAM
User
tbl_Product_Details 1
Login
tbl_Bug_Details
6
2 3
Search
Products Bugs
Details
Results
Details
4 7
Track Admin tasks
7.1 7.3
Results User Admin Log Views
5
View 7.2
Configuration
Details
tbl_Configuration
8
Log Out
6.5. Diagram which shows the working of the Site
tbl_Authentication
Admin User
1.1 1.2
User User Details Validate
Programmer
17
7. USER INTERFACE
The interfaces of this system are as below:
• HOME PAGE
• ADMIN LOGIN
18
• ADMIN PAGE
• USER LOGIN
19
• USER PAGE
• BUGS SHOW IN USER PAGE
20
• EXPERT LOGIN
• EXPERT RESOLVE BUGS
21
• ABOUT US
• CONTACT US
22
8. Limitations and Future Enhancements
Limitations of the system:

• Only the permanent employees can access the system.
• System works with windows’98 and its compatible environments.
• Advanced techniques are not used to check the authorization.
• Once the employee is registered to a course cannot drop, without completing.
Future Enhancements:
It is not possible to develop a system that makes all the requirements of the user. User requirements
keep changing as the system is being used. Some of the future enhancements that can be done to this
system are:
• As the technology emerges, it is possible to upgrade the system and can be adaptable to desired
environment.
• Because it is based on object-oriented design, any further changes can be easily adaptable.
• Based on the future security issues, security can be improved using emerging technologies.
• Attendance module can be added.
• Sub admin module can be added.
9. SAMPLE CODE LAYOUT
• CODING OF HOME PAGE
<%@ page contentType="text/html; charset=iso-8859-1"

language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-
8859-1" />
<title>Welcome - BugTracker.com/Home</title>
<link href="mystyle.css" rel="stylesheet" type="text/css" />
</head>
<body background="images/background2.jpg">
<table align="center" width="1000" height="779" bgcolor="#07b9e6">
<tr>
<td height="70" colspan="2"><jsp:include
page="header.jsp"/></td>
23
</tr>
<tr style="background-color: rgb(255, 128, 0); height: 60px">
<td colspan="2">
<jsp:include page="menu.jsp"/>
<p style="background-color: rgb(192, 183,
116);"> </p>
</td>
</tr>
<tr>
<td>
<div style="height: 150px; width: 200px;
background-image: url('images/img.jpg'); background-repeat: no-
repeat;"><br /><div align="left"><font color="red"><marquee
direction="up"><ul><li>This is bugtracking.com<br
/><br/></li><li>We provide imidiate solution<br /><br/></li/><li>We
are Lealing Service provider<br /><br/></li><li>we have various
type of product<br /><br/></li><li>Let's go ahead........<br
/><br/></li></ul></marquee></font></div></div>
<div style="height: 150px; width:
200px"><img src="images/Cosmology.gif" width="199"
height="169"/><br /><br /><ul><li><font color="#ff0000"><a
href="help.jsp">Bug tracking helps you to</a></font></li><li><font
color="#ff0000"> <a href="useme.jsp">use the product in well
and efficient manner</a></font></li></ul></div>
200px"><img src="images/bike.gif" width="199" height="169"/><br
/><br /><br /><br /></div>
</td>
<td height="470" valign="middle" align="left">
<table width="350">
<tr>
<td><marquee dir="up"><img
src="images/butterfly.gif" alt="fly" width="140"
hight="140"/></marquee></td>
</tr>
<tr>
<td height="80" align="center"><img
src="images/buggg-removebg-preview.png" alt="bug" width="134"
height="80" align="middle"/></td>
</tr>
<tr>
<td height="30"><strong><b>Help Us in
Tracking Bugs. Report Immediately!</b></strong><hr color="#008ACC"
/></td>
</tr>
<tr>
<td align="left"><ul><li><font
color="#e8210b">
<b>Bug Tracking system is web based
general purpose issue tracking
application.</b></font></li></ul><ul><li><font
color="#e8210b"><b>It is in daily use by thousands of development,
customer support, and help desk teams around the
world.</b></font></li></ul><ul><li><font color="#e8210b"><b>Highly
24
configurable. you can configure it to use as a simple bug tracking
system for a small team, or configure it with a workflow,
permissions for a larger organization. works great as a helpdesk
system, a customer support ticket system.</b></font><br
/></li></ul>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"><div align="center" class="greysmall"
style="height: 10%"><h6><br /></h6><hr />
<h3></h3><font color="black">All Rights are
reserved with ABC Softwares Pvt. Ltd.</font></h3></div>
</td>
</tr>
</table>
</body></html>
• CODING OF HEADER SECTION

language="java" import="java.sql.*, java.util.*, java.text.* "
errorPage="" %>
<div align="left" style="background-color:#66FF99 ">

<%
DateFormat df=new SimpleDateFormat("EEEE, dd MMMM, yyyy");
String date=df.format(new java.util.Date());
out.print("| "+date+" | ");
String login = (String)session.getAttribute("login");
if("yes".equals(login))
out.print((String)session.getAttribute("user")+" | <a
href=logout.jsp>Logout</a> |</font>");
%></div>
<table background="images/banner1.jpg" align="center" width="400"
height="102" background-repeat: no-repeat;>
<tr><td height="70">
<div align="center" class="head"></div></td></tr></table>
• CODING OF LOGIN PAGE

language="java" import="java.sql.*, javax.servlet.*" errorPage=""
%>
<%
String login = (String)session.getAttribute("login");
if("yes".equals(login)){
RequestDispatcher rd=null;
if("Admin".equals((String)request.getParameter("type")) &&
"Admin".equals((String)session.getAttribute("type")))
rd=request.getRequestDispatcher("admin.jsp");
25
else if("Expert".equals((String)request.getParameter("type"))
&& "Expert".equals((String)session.getAttribute("type")))
rd=request.getRequestDispatcher("expert.jsp");
else if("User".equals((String)request.getParameter("type")) &&
"User".equals((String)session.getAttribute("type")))
rd=request.getRequestDispatcher("user.jsp");
else
rd=request.getRequestDispatcher("loginerror.jsp");
rd.forward(request, response);
}
else{
%>
<head>
8859-1" />
<title>Welcome - BugTracker.com/Login</title>
</head>
<table align="center" width="700" bgcolor="#f2efb7" height="779">
<tr><td height="70"><jsp:include page="header.jsp"/></td></tr>

<tr style="background-color: rgb(255, 128, 0); height: 60px"><td>
</td></tr>
<tr><td height="470" valign="top">
<table width="690" height="467">
<tr>
<td align="center" bgcolor="" width="40%" >
<table width="200" cellspacing="5" align="center"
bgcolor="#99FFCC">
<%
if("Admin".equals((String)request.getParameter("type"))){
out.println("<tr><td bgcolor=#F2F2F2 height=25>Sign in as
Administrator</td></tr>");
out.println("<tr><td><p align=justify>An Administrator can
assign various reported bugs to different Technical Experts and
update the status of bugs.</td></tr>");
out.println("<tr><td bgcolor=#F2F2F2
height=25> </td></tr>");
}
else
if("Expert".equals((String)request.getParameter("type"))){
out.println("<tr><td bgcolor=#F2F2F2 height=25>Sign in as
Technical Expert</td></tr>");
out.println("<tr><td><p align=justify>A Technical Expert can
give comments on the Reported Bugs and try to fix
them.</td></tr>");
out.println("<tr><td bgcolor=#F2F2F2
height=25> </td></tr>");
}
else if("User".equals((String)request.getParameter("type"))){
26
out.println("<tr><td bgcolor=#F2F2F2 height=25>Sign in
Reporting Bugs</td></tr>");
out.println("<tr><td><p align=justify>A Normal User can sign
in for Reporting Bugs to the Sofware Management Team.</td></tr>");
out.println("<tr><td bgcolor=#F2F2F2 height=25>New User Please
<a href=signup.jsp><b>Signup</b></a></td></tr>");
}
%>
</table> </td>
<td align="center"><form id="form" name="form" method="post"
action="Login"><br /><br />
<%
if("loginerror".equals((String)request.getParameter("msg")))
out.println("<div class=errortext align=center>Invalid
Login ID or Password.</div>");
%>
<table width="200" bgcolor="" cellpadding="3" align="center">
<tr>
<td colspan="2" align="center" bgcolor="#0063C6"
height="20" class="whitehead">Login</td>
</tr>
<tr>
<td>Login ID</td>
<td><input type="text" name="loginid"
class="inputtext"/></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password"
</tr>
<tr>
<td colspan="2" > </td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="Submit" value="Submit"
class="inputtext" />
<input type="reset" name="Reset" value="Reset"
</tr>
</table>
</form>
<p> </p> </td>
</tr>
<tr>
<td valign="middle" align="center"> </td>
<td><div align="center"><img src="images/BEETLE1.-removebg-
preview.png" width="134" height="74" /></div></td>
</tr>
</table>
</td>
</tr>
27
<tr><td colspan="2"><div align="center" class="greysmall" ><h6><br
/></h6><hr />
<font color="black">All Rights are
</td></tr>
</table>
</body>
</html>
<%}%>
• CODING OF ADMIN PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Administrator</title>
</head>
<body background="images/waterbackground4.jpg">
<table align="center" width="700" bgcolor="#99CCFF" height="779">

<tr><td>
</td></tr>
<table width="100%">
<tr>
<td width="200" valign="top">
<p> </p><p><br /></p><p><br /></p>
<table width=150>
<tr>
<td bgcolor="#F2F2F2" height="25" align="center"><a
href="bugsadmin.jsp">View Bugs</a></td>
</tr>
<tr>
href="configexp.jsp">Configure Experts</a></td>
</tr>
<tr>
href="addexpert.jsp">Add Expert</a></td>
</tr>
<tr>
href="">Logout</a></td>
</tr>
<tr>
<td bgcolor="#F2F2F2" height="25"> </td>
</tr>
</table></td>
28
<td><p style="color: rgb(255, 120, 0);">As an Administrator you
can</p>
<ul>
<li style="color: rgb(255, 0, 0);">View all reported bugs,
assign bugs to different Technical Experts to fix it.
</li></ul><ul>
<li style="color: rgb(255, 0, 0);">Configure different
Technical Experts for different Teams for a particular Software
Product. </li>
</ul></td>
</tr>
<tr>
<td valign="top"> </td>
<td><div align="center"><img src="images/bug.jpg" alt="bug"
width="134" height="74" /></div></td>
</tr>
</table>
</td></tr>
<tr><td ><div align="center" class="greysmall"><hr /><font
color="#ff0000">
All Rights are reserved with Dcuat India Pvt.
Ltd.</font></div></td></tr>
</table>
</body>
</html>
• CODING OF ADD EXPERT PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Adding Expert!</title>
</head>
<body>
<table align="center" width="700" bgcolor="#FFFFFF">

</td></tr>
<tr><td height="300" align="center" valign="top"><p> </p>
<%
if("blank".equals((String)request.getParameter("msg")))
out.println("<div class=errortext>Field Blank | Password and Re-
Enter Password mismatch.</div>");
else if("error".equals((String)request.getParameter("msg")))
out.println("<div class=errortext>Login Already exists.</div>");
%>
<form id="form1" name="form1" method="post" action="SignUp">
<table width="300">
29
<tr>
<td colspan="2" bgcolor="#5050A0"height="20"
class="whitehead">Adding Expert</td>
</tr>
<tr>
<td align="left">Login ID </td>
<td><input type="text" name="loginid" size="20"
</tr>
<tr>
<td align="left">Password</td>
<td><input type="password" name="password" size="20"
</tr>
<tr>
<td align="left">Re-Enter Password </td>
<td><input type="password" name="repassword" size="20"
</tr>
<tr>
<td align="left">Name</td>
<td><input type="text" name="name" size="20"
</tr>
<tr>
<td align="left">E-Mail</td>
<td><input type="text" name="email" size="20"
</tr>
<tr>
<td> </td>
<td><input type="hidden" name="type"
value="Expert"/></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Submit" class="inputtext"
/>
<input type="reset" value="Reset" class="inputtext"/>
</td>
</tr>
</table>
</form>
</td></tr>
<tr><td ><div align="center" class="greysmall"><hr />
All Rights are reserved with ABC Softwares Pvt.
Ltd.</div></td></tr>
</table>
</body>
</html>
• CODING OF EXPERT PAGE
30
language="java" import="java.sql.*,connect.*" errorPage="" %>
<head>
8859-1" />
<title>Welcome - BugTracker.com/Expert</title>
</head>
<body>

</td></tr>
<ul>
<li><font color="#c24974">This is List of all Reported Bugs
assigned to you.
</font></li></ul><ul><li><li><font color="#c24974">Find out the
possibel causes, try to fix it and provide satisfactory
comments.</font></li></li></ul>
<table align="center" cellpadding="2" width="100%">
<tr bgcolor="#0054A8" class="whitetext" align="center" >
<td>Bug ID</td>
<td>Product</td>
<td>Env.</td>
<td>Type</td>
<td>Synopsis</td>
<td>Status</td>
<td> </td>
</tr>
<%
try{
Connection con=ConnectionProvider.getConnection();
Statement stmt = con.createStatement();
String query = "select * from bug where
assign_to='"+(String)session.getAttribute("loginid")+"'";
ResultSet rs = stmt.executeQuery(query);
int i=2;
while(rs.next()){
if(i%2==0)
out.println("<tr bgcolor=#CEE7FF>");
else
out.println("<tr bgcolor=#E8F3FF >");
i++;
out.print("<td
class=smalltext>"+rs.getString("bugid")+"</td>");
out.print("<td
class=smalltext>"+rs.getString("prodname")+"</td>");
out.print("<td class=smalltext>"+rs.getString("env")+"</td>");
out.print("<td
class=smalltext>"+rs.getString("type")+"</td>");
31
out.print("<td class=smalltext>");
String des=rs.getString("description");
if(des.length()>40)
des=des.substring(0,40)+". . .";
out.println(des);
out.print("</td>");
out.print("<td
class=smalltext>"+rs.getString("status")+"</td>");
out.print("<td class=smalltext><a
href='bugcomment.jsp?bugid="+rs.getString("bugid")+"'>Comment</a></
td>");
out.println("</tr>");
}
out.println("</table>");
out.print("<div align=left> Total Bugs: "+(i-2)+"</div>");
}catch(Exception e){
System.out.print(e);
}
%>
</td></tr>
</table>
</body>
</html>
• CODING OF USER PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Reporting Bugs</title>
</head>
<body>
<table align="center" width="700" bgcolor="#FFFFFF" height="779">

<tr style="background-color: rgb(255, 128, 0); height: 60px" ><td>
</td></tr>
<table width="690" height="291">
<tr>
<p> </p>
<table width=150>
<tr>
href="reportbug.jsp">Report A New Bug</a></td>
32
</tr>
<tr>
href="viewbugs.jsp">View Status</a></td>
</tr>
<tr>
href="logout.jsp">Logout</a></td>
</tr>
<tr>
</tr>
<tr>
</tr>
</table></td>
<td><p><font color="#800080">Report a Bug:</font></p>
<ul>
<li><font color="#ff0000">Select Product, Environment and
Type for the Bug being reported by you.</font></li></ul><ul>
<li><font color="#ff0000">Try to describe your bug
precisely and write the steps to reproduce the bug
again.</font></li></ul><ul>
<li><font color="#ff0000">Also specify some erroneous
behaviour of the program when bug appears. </font></li>
</ul></td>
</tr>
<tr>
<td><div align="right"><img src="images/bug.jpg" width="134"
height="74" /></div></td>
</tr>
</table>
</td></tr>
color="#ff0000">
</table>
</body>
</html>
• CODING OF LOGIN ERROR

<head>
8859-1" />
<title>Welcome - BugTracker.com/Authentication Error!</title>
</head>
<body>
33
<tr><td height="70"> </td></tr>
<tr><td>
</td></tr>
<tr><td height="300" align="center" valign="top"><p> </p>
<div align="center">
<div class="errortext">You are not authrized to view this
page.</div><br/>
Your have been logged as some other type of User. <br /> Re-Login
after <a href="logout.jsp">Logout</a></div>
<p><img src="images/bug.jpg" width="134" height="74"
/></p></td></tr>
</table>
</body>
</html>
• CODING OF LOGOUT FUNCTION

<%
session.invalidate();
RequestDispatcher rd=request.getRequestDispatcher("default.jsp");
%>
• CODING OF SIGNUP PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Sign Up!</title>
</head>
<body>

<tr><td>
</td></tr>
<tr><td height="300" align="center" valign="top"><p
style="background-color: rgb(192, 183, 116);"> </p>
<%
if("blank".equals((String)request.getParameter("msg")))
34
out.println("<div class=errortext>Field Blank | Password and Re-
Enter Password mismatch.</div>");
else if("error".equals((String)request.getParameter("msg")))
out.println("<div class=errortext>Login Already exists.</div>");
%>
<form id="form1" name="form1" method="post" action="SignUp">
<table width="300">
<tr>
<td colspan="2" bgcolor="#0063C6" height="20"
class="whitehead">Sign Up Form</td>
</tr>
<tr>
<td align="left">Login ID </td>
<td><input type="text" name="loginid" size="20"
</tr>
<tr>
<td align="left">Password</td>
<td><input type="password" name="password" size="20"
</tr>
<tr>
<td align="left">Re-Enter Password </td>
<td><input type="password" name="repassword" size="20"
</tr>
<tr>
<td align="left">Name</td>
<td><input type="text" name="name" size="20"
</tr>
<tr>
<td align="left">E-Mail</td>
<td><input type="text" name="email" size="20"
</tr>
<tr>
<td> </td>
<td><input type="hidden" name="type" value="User"/></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Submit" class="inputtext"
/>
</td>
</tr>
</table>
</form>
</td></tr>
</table>
</body>
</html>
35
• CODING OF NAV BAR
<table align="center" width="800">

<tr align="center" height="25">
<td width="150" bgcolor="#F2F2F2"><a
href="default.jsp">Home</a></td>
href="login.jsp?type=Admin">Administrator</a></td>
href="login.jsp?type=Expert">Technical Expert</a></td>
href="login.jsp?type=User">User Login</a></td>
<td width="150" bgcolor="#F2F2F2"><a href="aboutus.jsp">About
us</a></td>
<td width="150" bgcolor="#F2F2F2"><a href="contactus.jsp">Contact
us</a></td>
</tr></table>
• CODING OF BUG DETAILS PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Bug Detail</title>
</head>
<body>

</td></tr>
<br />
<table align="center" cellpadding="2" width="600" cellspacing="4">
<tr bgcolor="#0054A8" class="whitetext" align="center">
<td colspan="4">Your Bug Detail</td></tr>
<%
try{
bugid="+(String)request.getParameter("bugid");
while(rs.next()){
36
out.print("<tr><td bgcolor=#F2F2F2>Bug
ID</td><td>"+rs.getString("bugid")+"</td><td
bgcolor=#F2F2F2>Author</td><td>"+rs.getString("author")+"</td></tr>
");
out.print("<tr><td bgcolor=#F2F2F2>Product Name</td><td
colspan=3>"+rs.getString("prodname")+"</td></tr>");
out.print("<tr><td
bgcolor=#F2F2F2>Environment</td><td>"+rs.getString("env")+"</td><td
bgcolor=#F2F2F2>Type</td><td>"+rs.getString("type")+"</td></tr>");
out.print("<tr><td colspan=4
bgcolor=#F2F2F2>Description</td></tr>");
>"+rs.getString("description")+"</td></tr>");
out.print("<tr><td bgcolor=#F2F2F2>Priority</td><td
colspan=3>"+rs.getString("priority")+"</td></tr>");
out.print("<tr><td
bgcolor=#F2F2F2>Status</td><td>"+rs.getString("status")+"</td><td
bgcolor=#F2F2F2>Responsible</td><td>"+rs.getString("assign_to")+"</
td></tr>");
}
rs.close();
stmt.close();
con.close();
}
%>
</table>

<tr><td colspan="2" bgcolor="#0054A8" class="whitetext">Audit
Trail</td></tr>
<tr bgcolor=#F2F2F2><td class="smalltext"
width="150">Expert</td><td class="smalltext">Comments</td></tr>
<%
try{
String query = "select * from solutions where
while(rs.next()){
out.print("<tr>");
out.print("<td
class=smalltext>"+rs.getString("expert")+"</td>");
out.print("<td
class=smalltext>"+rs.getString("soln")+"</td>");
out.print("</tr>");
}
rs.close();
stmt.close();
con.close();
37
}
%>
</table>
<div align="center"><hr width="100" /><a
href="viewbugs.jsp">Back</a><hr width="100" /></div>
</td></tr>
color="#ff0000">
</table>
</body>
</html>

<head>
8859-1" />
<title>Welcome - BugTracker.com/Bug Detail</title>
</head>
<body>
</td></tr>
<p> </p>
<%
try{
while(rs.next()){
");
out.print("<tr><td
38
out.print("<tr><td
td></tr>");
}
rs.close();
stmt.close();
con.close();
}
%>
</table>

Trail</td></tr>
<%
try{
while(rs.next()){
out.print("<tr>");
out.print("<td
out.print("<td
out.print("</tr>");
}
rs.close();
stmt.close();
con.close();
}
%>
</table>
href="bugsadmin.jsp">Back</a><hr width="100" /></div>
</td></tr>
39
</table>
</body>
</html>
• CODING OF BUG COMMENT PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Expert/Comments</title>
</head>
<body>

<tr><td>
</td></tr>
<p> </p>
<%
try{

while(rs.next()){
");
out.print("<tr><td
40
out.print("<tr><td
td></tr>");
}
rs.close();
stmt.close();
}
%>
<tr><td colspan="4">Expert Comments/Solutions</td></tr>
<tr><td colspan="4">
<form name="form" method="post" action="addcomment.jsp">
<textarea cols="60" rows="4" class="inputtext"
name="sol"></textarea>
<input type="hidden" name="bugid"
value="<%=(String)request.getParameter("bugid")%>" />
<input type="hidden" name="expertid"
value="<%=session.getAttribute("loginid")%>" />
<input type="hidden" name="expert"
value="<%=session.getAttribute("user")%>" /><br /><br />
<div align="center"><input type="submit" value="Add Your Comment"
/></div>
</form>
</td></tr>
</table>

Trail</td></tr>
<%
try{

while(rs.next()){
out.print("<tr>");
out.print("<td
out.print("<td
out.print("</tr>");
}
rs.close();
stmt.close();
con.close();
41
}
%>
</table>
href="expert.jsp">Back</a><hr width="100" /></div>
</td></tr>
</table>
</body>
</html>
• CODING OF ADD COMMENT PAGE

language="java" import="java.sql.*, java.util.*,connect.*"
errorPage="" %>
<%
String bugid=(String)request.getParameter("bugid");
String expertid=(String)request.getParameter("expertid");
String expert=(String)request.getParameter("expert");
String sol=(String)request.getParameter("sol");
try{
String insertquery = "insert into solutions

values(?,?,?,?,?)" ;
PreparedStatement prestmt =
con.prepareStatement(insertquery);
prestmt.setString(1,bugid);
prestmt.setString(2,expertid);
prestmt.setString(3,expert);
prestmt.setString(4,sol);
Calendar cal = new GregorianCalendar();

int year = cal.get(Calendar.YEAR);
int mm = cal.get(Calendar.MONTH);
int dd = cal.get(Calendar.DAY_OF_MONTH);
java.sql.Date date=new java.sql.Date(year,mm,dd);
System.out.println(date);
prestmt.setDate(5,date);
prestmt.executeUpdate();
prestmt.close();
con.close();
RequestDispatcher
rd=request.getRequestDispatcher("bugcomment.jsp?bugid="+bugid);
}catch(Exception e){System.out.println(e);
42
RequestDispatcher
rd=request.getRequestDispatcher("bugcomment.jsp?bugid="+bugid);
}
%>
• CODING OF BUG LIST

<head>
8859-1" />
<title>Welcome - BugTracker.com/Bugs List</title>
</head>
<body>
</td></tr>
<table align="center" cellpadding="2" width="100%">
<tr bgcolor="#0054A8" class="whitetext" align="center" >
<td>Bug ID</td>
<td>Product</td>
<td>Env.</td>
<td>Type</td>
<td>Synopsis</td>
<td>Status</td>
</tr>
<%
try{
String query = "select * from bug order by bugid desc";
int i=2;
while(rs.next()){
if(i%2==0)
else
i++;
out.print("<td
out.print("<td
43
out.print("<td
if(des.length()>40)
out.println(des);
out.print("</td>");
out.print("<td
out.print("<tr><td colspan=5>");
%>
<div class="smalltext">|
<a
href="updatebug.jsp?bugid=<%=rs.getString("bugid")%>">Update
Bug</a> |
<a href="del.jsp?bugid=<%=rs.getString("bugid")%>">Delete</a>
|
<a
href="bugdetail1.jsp?bugid=<%=rs.getString("bugid")%>">Detail</a>
|</div>
<%
out.print("</td></tr>");
}
}
%>

href="admin.jsp">Back</a><hr width="100" /></div>
</td></tr>
Ltd.</div></td></tr></table></body></html>
• CODING OF VIEW BUGS

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitionasl//EN"
<head>
8859-1" />
<title>Welcome - BugTracker.com/List of Bugs</title>
</head>
<body>
44
</td></tr>
<tr><td height="300" valign="top"><br />

<table align="center" cellpadding="2" width="691">
<td>Bug ID</td>
<td>Product</td>
<td>Env.</td>
<td>Type</td>
<td>Synopsis</td>
<td>Status</td>
<td> </td>
</tr>
<%
try{
String u=(String)session.getAttribute("loginid");
System.out.println(u);
String query = "select * from bug where AUTHORID='"+u+"' order
by bugid asc";
int i=2;
while(rs.next()){
if(i%2==0)
else
i++;
out.print("<td
out.print("<td
out.print("<td
if(des.length()>40)
out.println(des);
out.print("</td>");
out.print("<td
out.print("<td class=smalltext><a
href='bugdetails.jsp?bugid="+rs.getString("bugid")+"'>Detail</a></t
d>");
}
45
}
%>

href="user.jsp">Back</a><hr width="100" /></div>
</td></tr>
color="#ff0000">
</table>
</body>
</html>
• CODING OF UPDATE BUGS FUNCTION

<%
String bugid=(String)request.getParameter("bugid");
String priority=(String)request.getParameter("priority");
String status=(String)request.getParameter("status");
String assign_to=(String)request.getParameter("assign_to");
System.out.print(bugid+" "+priority+" "+status+" "+assign_to);
try{
String query = "Update bug set priority='"+priority+"',
status='"+status+"', assign_to='"+assign_to+"' where bugid="+bugid;
stmt.executeUpdate(query);
RequestDispatcher
rd=request.getRequestDispatcher("updatebug.jsp?bugid="+bugid);
RequestDispatcher
rd=request.getRequestDispatcher("updatebug.jsp?bugid="+bugid);
}
%>

<head>
8859-1" />
<title>Welcome - BugTracker.com/Updating Bug</title>
</head>
<body>
<tr><td height="70"> </td></tr>
46
<tr><td>
</td></tr>
<tr><td height="300" valign="top"><div align="center">
You can update Priority, Status and Responsible Expert for this
Bug.</div>
<form name="form" method="post" action="updatebug1.jsp">
<input type="hidden" name="bugid"
value="<%=(String)request.getParameter("bugid")%>" />
<td colspan="4">Bug Detail</td></tr>
<%
try{
while(rs.next()){
");
out.print("<tr><td
out.print("<tr bgcolor=#F2F2F2><td> </td><td>Current
Stage</td><td>New Stage</td><td> </td></tr>");
out.print("<tr><td
bgcolor=#F2F2F2>Priority</td><td>"+rs.getString("priority")+"</td>"
);
out.print("<td>");
out.print("<select name=priority class=inputtext>");
out.print("<option value='Low'>Low</option><option
value='Medium'>Medium</option><option value='High'>High</option>");
out.print("</select>");
out.print("</td><td> </td></tr>");
out.print("<tr><td
bgcolor=#F2F2F2>Status</td><td>"+rs.getString("status")+"</td>");
out.print("<td>");
out.print("<select name=status class=inputtext>");
out.print("<option value='New'>New</option><option
value='Assigned'>Assigned</option><option
value='Fixed'>Fixed</option><option
value='Closed'>Closed</option>");
47
out.print("<tr><td
td>");
out.print("<td>");
out.print("<select name=assign_to class=inputtext>");
query = "select loginid, name from login where loginid in

(select expertid from experts where
prodid='"+rs.getString("prodid")+"')";
System.out.print(query);
ResultSet rs1 = stmt.executeQuery(query);
while(rs1.next()){
out.print("<option
value="+rs1.getString(1)+">"+rs1.getString(2)+"</option>");
}
rs1.close();
}
rs.close();
stmt.close();
con.close();
}
%>
<td colspan="4" align="center"><input type="submit" name="update"
value="Update"/></td></tr>
</table>
</form>
Trail</td></tr>
<%
try{
while(rs.next()){
out.print("<tr>");
out.print("<td
out.print("<td
out.print("</tr>");
}
rs.close();
stmt.close();
con.close();
48
}
%>
</table>
href="bugsadmin.jsp">Back</a><hr width="100" /></div>
</td></tr>
</table>
</body>
</html>
• CODING OF CONFIGURING EXPERT PAGE

<head>
8859-1" />
<title>Welcome - BugTracker.com/Administrator/Configuring
Experts.</title>
</head>
<body>

<tr><td>
</td></tr>
<table width="100%">
<tr>
<p> </p>
<table width=150>
<tr>
href="bugsadmin.jsp">View Bugs</a></td>
</tr>
<tr>
href="configexp.jsp">Configure Experts</a></td>
</tr>
<tr>
href="addexpert.jsp">Add Expert</a></td>
</tr>
49
<tr>
</tr>
<tr>
</tr>
</table></td>
<td valign="top">
<p> </p>
<form name="form1" method="post" action="configexp1.jsp">
<table width="400" >
<%
if("success".equals((String)request.getParameter("msg"))){
out.print("<tr><td colspan=2 bgcolor=#FFD7AE class=smalltext
align=center height=25><font color=blue>Expert Configured
Successfully!</font></td></tr>");
}else if("error".equals((String)request.getParameter("msg"))){
out.print("<tr><td colspan=2 bgcolor=#FFD7AE
class=smalltext align=center height=25><font color=red>Expert
already configured for this Product.</font></td></tr>");
}
%>
<tr>
<td colspan="2" bgcolor="#F2F2F2" height="25">Configuring
Experts for Software Teams. </td>
</tr>
<tr>
<td>Product</td>
<td>
<select name="prodid" class="inputtext">
<%
String query = "select * from products";
while(rs.next()){
out.print("<option
value="+rs.getString("prodid")+">"+rs.getString("prodname")+"-
"+rs.getString("version")+"</option>");
}
rs.close();
%>
</select> </td>
</tr>
<tr>
<td>Technical Expert </td>
<td>
<select name="expertid" class="inputtext">
<%
query = "select * from login where type='Expert'";
rs = stmt.executeQuery(query);
while(rs.next()){
50
out.print("<option
value="+rs.getString("loginid")+">"+rs.getString("name")+"</option>
");
}
rs.close();
con.close();
%>
</select> </td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#F2F2F2"
height="25"><input type="submit" name="Submit" value="Submit"
</tr>
</table>
</form> </td>
</tr>
<tr>
<td valign="top"><div align="right"><img src="images/bug.jpg"
width="134" height="74" /></div></td>
</tr>
</table>
</td></tr>
</table>
</body>
</html>

<%
String prodid=(String)request.getParameter("prodid");
String expertid=(String)request.getParameter("expertid");
try{

String query = "insert into experts
values('"+expertid+"','"+prodid+"')";
String query1="update bug set assign_to='"+expertid+"' where
PRODID='"+prodid+"'";
System.out.println("query1 :"+query1);
con.setAutoCommit(false);
int y=stmt.executeUpdate(query1);
int x=stmt.executeUpdate(query);
con.commit();
if(x >0 && y > 0)
{
RequestDispatcher
rd=request.getRequestDispatcher("configexp.jsp?msg=success");
51
}
con.rollback();
RequestDispatcher
rd=request.getRequestDispatcher("configexp.jsp?msg=error");
}
%>
• CODING OF REPORTING BUG

<head>
8859-1" />
<title>Welcome - BugTracker.com/Reporting Bugs</title>
</head>
<body>

</td></tr>
<table width="100%" align="center">
<tr>
<table width=150 align="center">

<%
if("error".equals((String)request.getParameter("msg")))
out.print("<div align=center class=errortext>Field Blank or
Some Database Error!</div>");
%>
<tr>
href="reportbug.jsp">Report A New Bug</a></td>
</tr>
<tr>
href="viewbugs.jsp">View Status</a></td>
</tr>
<tr>
href="logout.jsp">Logout</a></td>
</tr>
<tr>
</tr>
</table>
52
</td>
<td><form id="form1" name="form1" method="post"
action="ReportBug">
<table width="400" cellpadding="3" align="center">
<tr>
<td colspan="2" class="whitehead" bgcolor="#0063C6"
height="20" align="center">Reporting Bug</td>
</tr>
<tr>
<td>Product</td>
<td><select name="prodid" class="inputtext">
<%
try{
String query = "select * from products";
while(rs.next())
{
out.print("<option value=");
out.print(rs.getString("prodid")+">");
out.print(rs.getString("prodname")+" -
"+rs.getString("version"));
out.print("</option>");
}
}
%></select></td>
</tr>
<tr>
<td>Environment</td>
<td>
<select name="env" class="inputtext">
<option value="Windows 7">Windows 7</option>
<option value="Windows 2000">Windows 2000</option>
<option value="Solaris">Solaris</option>
<option value="Linux">Linux</option>
</select> </td>
</tr>
<tr>
<td>Type</td>
<td>
<select name="type" class="inputtext">
<option value="GUI">GUI</option>
<option value="Server">Server</option>
<option value="Database">Database</option>
<option value="Network">Network</option>
</select> </td>
</tr>
<tr>
<td valign="top">Bug Description </td>
<td><textarea cols="40" rows="8" class="inputtext"
name="description"></textarea></td>
</tr>
53
<tr>
<td colspan="2">
<input type="hidden" name="authorid"
value="<%=(String)session.getAttribute("loginid")%>" />
<input type="hidden" name="author"
value="<%=(String)session.getAttribute("user")%>" />
</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit"
value="Submit" class="inputtext" />
</td></tr></table></form>
</td>
</tr>
</table>
</td></tr>
</table>
</body>
</html>
• CODING OF ABOUT US PAGE
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
8859-1">
</head>
<table width="700" height="779" bgcolor="#CCFFCC"
align="center">
<tr height="70">
<td colspan="2"><jsp:include
</tr>
<tr style="background-color: rgb(255, 128, 0);

height: 60px">
page="menu.jsp"/></td>
</tr>
<tr>
<td>
repeat;"><br /><div align="left"><font color="#FF0000"><marquee
54
/><br /><br /><br /></div>
</td>
<td align="center">
<table width="500">
<tr>
<td>
<font color="red"; font size="5px";><strong>
About Our Project
</strong></font><br><br><div align="left"><b><font
color="voilet">
Our development process includes the following
stages:</font></b><br><br><b>
Planning and Requirements Gathering<br>

Design and Architecture<br>
Development and Testing<br>
Deployment and Maintenance<br>
Technical Details<br><br></b>
<font color="voilet"><b>Our bug tracking system is built using the

following technologies:</b></font><br><br><b color=red;>
Operating System : Windows XP/ Windows

7/8<br>
User Interface : HTML, CSS<br>
Client-side Scripting : JavaScript<br>
Programming Language : Java<br>
Web Applications : JDBC Servlets, JSP<br>
Database :
Oracle/Access<br></b><br>
<font color="red"; font size="5px";><b>Future

Plans</b></font><br><br>
<font color="royal blue";>
<b>The Bug Tracking for Improving Software Reliability is a web-

based application that can be accessed throughout the organization.
This system can be used for logging bugs against an
application/module, assigning bugs to team members and tracking the
bugs to resolution. There are features like email notifications,
user maintenance, user access control, report generators etc. in
this system
</b></font></div></td>
</tr>
55
</table>
</td>
</tr>
<tr>
<td colspan="2"><div align="center"
class="greysmall" ><h6><br /></h6><hr />
</td>
</tr>
</table>
</body>
</html>
• CODING OF CONTACT US PAGE
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
8859-1">
S <style type="text/css">
table.curvedEdges
{
border:5px solid RoyalBlue;-webkit-border-
radius:13px;-moz-border-radius:13px;-ms-border-radius:13px;-o-
border-radius:13px;border-radius:13px;display: inline-
block;padding: 9px 15px 7px 15px
}
table.curvedEdges td, table.curvedEdges th
{
border-bottom:1px solid green;padding:5px;
}
</style>
</head>
<body>
<table width="700" height="779" bgcolor="#CCFFCC"
align="center">
<tr height="70">
</tr>
<tr style="background-color: rgb(255, 128, 0);

height: 60px">
56
page="menu.jsp"/></td>
</tr>
<tr>
<td>
repeat;"><br /><div align="left"><font color="#FF0000"><marquee
/><br /><br /><br /></div>
</td>
<td align="center">
<table bgcolor="#FFFFCC"
class="curvedEdges" border="2">
<tr>
<td><font
color="red";><b>
We are testers- in
other words,Bug Finders<br>
Defect/Bug/Issue/Fault/Failure/Incident -<br>
Whatever we choose
to call. Our primary motive<br>
revolves around
finding,recording,reporting,<br>
managing and
tracking these.</b></font><br><br><h3>Get In Touch</h3>
<svg
xmlns="http://www.w3.org/2000/svg" width="16" height="16"
fill="currentColor" class="bi bi-geo-alt-fill" viewBox="0 0 16 16">
<path d="M8 16s6-5.686 6-10A6 6
0 0 0 2 6c0 4.314 6 10 6 10zm0-7a3 3 0 1 1 0-6 3 3 0 0 1 0
6z"/></svg> Noida, Uttar pradesh
<br><br><svg
fill="currentColor" class="bi bi-telephone" viewBox="0 0 16 16">
<path d="M3.654 1.328a.678.678
0 0 0-1.015-.063L1.605 2.3c-.483.484-.661 1.169-.45 1.77a17.568
17.568 0 0 0 4.168 6.608 17.569 17.569 0 0 0 6.608 4.168c.601.211
1.286.033 1.77-.45l1.034-1.034a.678.678 0 0 0-.063-1.015l-2.307-
1.794a.678.678 0 0 0-.58-.122l-2.19.547a1.745 1.745 0 0 1-1.657-
.459L5.482 8.062a1.745 1.745 0 0 1-.46-1.657l.548-2.19a.678.678 0 0
57
0-.122-.58L3.654 1.328zM1.884.511a1.745 1.745 0 0 1 2.612.163L6.29
2.98c.329.423.445.974.315 1.494l-.547 2.19a.678.678 0 0 0
.178.643l2.457 2.457a.678.678 0 0 0 .644.178l2.189-.547a1.745 1.745
0 0 1 1.494.315l2.306 1.794c.829.645.905 1.87.163 2.611l-1.034
1.034c-.74.74-1.846 1.065-2.877.702a18.634 18.634 0 0 1-7.01-4.42
18.634 18.634 0 0 1-4.42-7.009c-.362-1.03-.037-2.137.703-
2.877L1.885.511z"/>
</svg> +91-
8127543191<br><br>
<svg
fill="currentColor" class="bi bi-envelope" viewBox="0 0 16 16">
<path d="M0 4a2 2 0
0 1 2-2h12a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V4Zm2-1a1 1
0 0 0-1 1v.217l7 4.2 7-4.2V4a1 1 0 0 0-1-1H2Zm13 2.383-4.708
2.825L15 11.105V5.383Zm-.034 6.876-5.64-3.471L8 9.583l-1.326-.795-
5.64 3.47A1 1 0 0 0 2 13h12a1 1 0 0 0 .966-.741ZM1 11.105l4.708-
2.897L1 5.383v5.722Z"/>
</svg> digitalsociety9@gmail.com
</td>
</table>
</td>
</tr>
<tr>
<td colspan="2"><div align="center" class="greysmall"
><hr />
</td>
</tr>
</table>
</body>
</html>
• CSS FILE (mystyle.css)
body {
font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-
size:12px; background-color:#E8E8E8;
}
td {
font-family: Verdana, Geneva, Arial, helvetica, sans-serif;
font-size:12px;
}
th {
font-family: Verdana, Geneva, Arial, helvetica, sans-serif;
font-size:12px;
}
a:link {
color:#004284; text-decoration:none;
}
58
a:active {
}
a:visited {
}
a:hover{ text-decoration:underline;}
.head{ font-size: 36px; font:"Book Antiqua"; color:#0063C6;}

.greysmall{ font-size:10px; color:#999999;}
.whitehead{ color:#FFFFFF; font-weight:bold}
.inputtext{ font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:12px;}
.errortext{ color:#C60000; font-size:10px}
.smalltext{ font-size:11px;}
.whitetext{ color:#FFFFFF;}
strong{font-size:20px; color=""}
• CODE OF TABLE
CREATE TABLE LOGIN(
LOGINID VARCHAR2(10),
PASSWORD VARCHAR2(10),
NAME VARCHAR2(20),
EMAIL VARCHAR2(30),
TYPE VARCHAR2(10),
PRIMARY KEY(LOGINID))
/
insert into login values('admin', 'admin', 'Harsh Modanwal', 'Harsh@gmail.com', 'Admin')
/
CREATE TABLE PRODUCTS(
PRODID VARCHAR2(10),
PRODNAME VARCHAR2(15),
VERSION VARCHAR2(10),
PRIMARY KEY(PRODID))
/
insert into products values('101', 'JavaEdit', '1.01')
/
insert into products values('102', 'SoundRX', '2.0.2')
/
insert into products values('103', 'WordSolution', '3.0.2')
/
CREATE TABLE EXPERTS(
EXPERTID VARCHAR2(10),
PRIMARY KEY(EXPERTID))
/
CREATE TABLE BUG(
BUGID VARCHAR2(10),
AUTHORID VARCHAR2(10),
AUTHOR VARCHAR2(20),
PRODNAME VARCHAR2(25),
ENV VARCHAR2(15),
TYPE VARCHAR2(15),
DESCRIPTION VARCHAR2(100),
REP_DATE DATE,
PRIORITY VARCHAR2(10),
STATUS VARCHAR2(15),
ASSIGN_TO VARCHAR2(10),
PRIMARY KEY(BUGID))
/
CREATE TABLE SOLUTIONS(
BUGID VARCHAR2(10),
EXPERTID VARCHAR2(10),
EXPERT VARCHAR2(20),
SOLN VARCHAR2(200),
SOLN_DATE DATE,
PRIMARY KEY(BUGID, EXPERTID)
59
10. REFERENCES
[1] Schildt, H. (2006) Java the complete reference, Seventh edition, Google Books. Available at:
https://books.google.com/books/about/Java_The_Complete_Reference_Seventh_Edit.html?id
=C_l2R8ZSPMoC (Accessed: 10 February 2023).
[2] Zimmermann, T. et al. (2009) ‘Improving Bug Tracking Systems’, 2009 31st International
Conference on Software Engineering - Companion Volume [Preprint]. doi:10.1109/icse-
companion.2009.5070993.
[3] Vasumathi, K., Selvakani, S. and Sridhar, P. (2022) ‘Bug tracker: Comprehensive bug
tracking and modification system’, Asian Journal of Electrical Sciences, 11(2), pp. 24–29.
doi:10.51983/ajes-2022.11.2.3545.
[4] J. Anvik, L. Hiew, and G. C. Murphy. Who should fix this bug? In ICSE’06: Proceedings of
the 28th International Conference on Software engineering, pages 361–370, 2006.
[5] N. Bettenburg, S. Just, A. Schroter, C. Weiss, R. Premraj, and ¨ T. Zimmermann. What

makes a good bug report? In FSE’08: Proceedings of the 16th International Symposium on
Foundations of Software Engineering, pages 308–318, November 2008.
[6] S. Artzi, S. Kim, and M. D. Ernst. Recrash: Making software failures reproducible by
preserving object states. In ECOOP’08: Proceedings of the 22nd European Object-Oriented
Programming Conference, pages 542–565, 2008.
[7] N. Bettenburg, R. Premraj, T. Zimmermann, and S. Kim. Duplicate bug reports considered
harmful ... really? In ICSM’08: Proceedings of the 24th IEEE International Conference on
Software Maintenance, pages 337–345, 2008.
[8] S. Breu, J. Sillito, R. Premraj, and T. Zimmermann. Frequently asked questions in bug
reports. Technical report, University of Calgary, March 2009.
[9] P. Fritzson, T. Gyimothy, M. Kamkar, and N. Shahmehri. Generalized algorithmic debugging

and testing. In PLDI’91: Proceedings of the ACM SIGPLAN Conference on Programming
Language Design and Implementation, pages 317–326, 19.
[10] S. Just, R. Premraj, and T. Zimmermann. Towards the next generation of bug tracking
systems. In VL/HCC’08: Proceedings of the 2008 IEEE Symposium on Visual Languages
and Human-Centric Computing, pages 82–85, September 2008.
60
11. SUGGESTED WEBPAGES
[11] JavaScript tutorial (2023) GeeksforGeeks. Available at:
https://www.geeksforgeeks.org/javascript/ (Accessed: 20 January 2023).
[12] Learn servlet tutorial – javatpoint Available at: https://www.javatpoint.com/servlet-tutorial

(Accessed: 23 February 2023).
[13] WampServer, La Plate-forme de developpement web sous windows - apache, MySQL, PHP
(no date) WampServer. Available at: https://www.wampserver.com/en/ (Accessed: 10 April
2023).
[14] JSP tutorial Tutorial Point. Available at: https://www.tutorialspoint.com/jsp/index.htm

(Accessed: 2023).
[15] MySQL Tutorial MySQL tutorial. Available at: https://www.w3schools.com/MySQL/default.asp

(Accessed: 2023).
[16] Learn HTML Codecademy. Available at: https://www.codecademy.com/learn/learn-html

(Accessed: 05 January 2023).
[17] HTML & CSS courses tutorials Codecademy. Available at:

https://www.codecademy.com/catalog/language/html-css (Accessed: 2023).
61

Final Report BTS-1

Uploaded by

Copyright:

Available Formats

Final Report BTS-1

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Final Report BTS-1

Uploaded by

Copyright:

Available Formats

MAJOR PROJECT

DEPARTMENT OF INFORMATION TECHNOLOGY

2. Title of the Study 9

4.1 Project Overview 10

4.4 Definition, Acronyms, Abbreviations 11

4.5 Existing System 11

4.6 Proposed System 11

5. Functional Or Specific Requirements 12

5.1 External Interface Requirements 12

5.1.1 Software Interface 12

5.1.2 Hardware Interfaces 13

5.2 Non-Functional Requirements 13

5.3 Database Requirements 14

5.4 Method to be Used 14

6. Analysis And Design 16

6.1 Data Flow Diagram 16

6.1.1 DFD Symbols 16

6.1.2 DFD Level 0 16

6.1.3 DFD Level 1 17

6.1.4 Diagram which shows the working of the Site 17

7. User Interface 18-22

8. Limitation and future enhancement 23

9. Sample Code Layout 23-59

11. Suggested Webpages 61

Name – HARSH MODANWAL

Signature of Supervisor Signature of Examiner

I express my sincere thanks and indebtedness to my esteemed institution, Department

Dr. Neeraj Kumar Tiwari

I am developing to this website to take that my good this opportunity to express my

4.1. Project Overview

• To reduce the time constraint involved.

• To centralize all the data needed.

• To generate various reports as required

• To maintain the user rights.

4.5. Existing System

Limitations in Existing System

4.6. Proposed System

Advantages over Existing System

• The performance is increased due to well-designed database.

To upload thesis, documents, presentation by providing the title and description.

To view / update their profile.

5.1. External Interface Requirements

5.2. Non-Functional Requirements

• System should be able handle multiple users.

• Database updating should follow transaction processing to avoid data inconsistency.

• Administrator has the highest authority to edit/delete/create database

• Administrator have the authority to add/expel students

• Students can view and download thesis

• Validating user input

• Use of locking mechanism while updating database like transaction processing

• Recovering the transaction using rollback.

5.3. Database Requirements

5.4. METHOD TO BE USED

• Processing speed of 1.6 GHz

• Minimum hardware depending on the operating system used

• True color visual display unit

• User peripherals for better interaction

6.2. DFD Symbols

6.3. Data Flow Diagram: Level 0

BTS - TOP LEVEL DIAGRAM