Abhijeet.docx

A REPORT OF SIX WEEKS INDUSTRIAL TRAINING (14 PT.) At [HINDUSTAN COPPER LIMITED] SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE AWARD OF THE DEGREE OF

BACHELOR OF TECHNOLOGY (INFORMATION TECHNOLOGY)

JULY-AUGUST 2018 SUBMITTED BY: NAME: ABHIJEET KUMAR ROLL NO: 15030141IT002

Under the Guidance of Dr. Rathnakar Achary In partial fulfillment of the Course- Industry Internship Programme-IIP In Semester VII of the Bachelor of Technology (2015-2019)

ACKNOWLEDGEMENT

The internship opportunity I had with HINDUSTAN COPPER LIMITED was a great chance for learning and professional development. Therefore, I consider myself as a very lucky individual as I was provided with an opportunity to be a part of it. I am also grateful for having a chance to meet so many wonderful people and professionals who led me though this internship period. Bearing in mind previous I am using this opportunity to express my deepest gratitude and special thanks to the MD of [HCL] who in spite of being extraordinarily busy with his duties, took time out to hear, guide and keep me on the correct path and allowing me to carry out my project at their esteemed organization and extending during the training. I express my deepest thanks to MR KULDEEP SINGH, Asst. Manager for taking part in useful decision & giving necessary advices and guidance and arranged all facilities to make life easier. I choose this moment to acknowledge his/her contribution gratefully. I perceive as this opportunity as a big milestone in my career development. I will strive to use gained skills and knowledge in the best possible way, and I will continue to work on their improvement, in order to attain desired career objectives. Hope to continue cooperation with all of you in the future, Sincerely, ABHIJEET KUMAR Place:GHATSILA Date: 28-08-18

CANDIDATE'S DECLARATION I “ABHIJEET KUMAR” hereby declare that I have undertaken six weeks industrial at “HINDUSTAN COPPER LIMITED” during a period from 23.07.2018 to 28.08.2018 in partial fulfillment of requirements for the award of degree of B.Tech (Information technology) at ALLIANCE COLLEGE OF ENGINEERING AND DESIGN, BANGALORE. The work which is being presented in the training report submitted to Department of Information and technology at ALLIANCE COLLEGE OF ENGINEERING, BANGALORE is an authentic record of training work.

Signature of the Student

Public Grievance System

ABSTRACT The project primarily focuses on sanitation and development of a municipal corporation. To create it attainable, the people that belong to the municipal corporation are supplied with chance of raising grievance relating to any issue that happen in their section. The problems are garbage management, water supply management and their related issues arise at any instant time, electricity management, management of transport and sewage management and other sensitive issues regarding law & order, various social problems like child laboring. This are the various issues that will be lodge on this system. A simplified answer is intended wherever the various form of complaints management system is to create complaints easier to coordinate, monitor, track and resolve, and to supply company with good tool to spot and target drawbacks areas, monitor complaints handling performance and build business enhancement. On-line grievance management could be a better management technique for assessing, analyzing and responding to client complaints. Then the updated status would be shown to the user and they may get known about the entire system. And this system mainly designed for the public use only.

TABLE OF CONTENT 1.

INTRODUCTION

1

2.1

PROJECT PROFILE

3

2.2

SYSTEM ARCHITECTURE

5

2.3

MODULES

9

3.1

COMPANY PROFILE

11

4.1

SYSTEM REQUIREMENTS

14

5.1

SYSTEM DESIGN

15

5.2

OUTPUT DESIGN

16

5.3

FEASIBILITY STUDY

17

5.4

SYSTEM IMPLEMENTATION

18

6.1

SOFTWARE DESCRIPTION

21

6.2

SAMPLE CODING

26

6.3

SCREENSHOTS

47

7.1

TESTING

59

8.1

CONCLUSION

62

9.1

REFRENCE

63

List of Figures SL NO

FIG NO

PAGE NO

1

FIGURE-2.1

5

2

FIGURE -2.2

6

3

FIGURE -2.3

7

4

FIGURE -2.4

8

5

FIGURE -6.1

47

6

FIGURE -6.2

48

7

FIGURE -6.3

49

8

FIGURE -6.4

50

9

FIGURE -6.5

51

10

FIGURE -6.6

52

11

FIGURE -6.7

53

12

FIGURE -6.8

54

13

FIGURE -6.9

55

14

FIGURE -6.10

56

15

FIGURE -6.11

57

CHAPTER-1 INTRODUCTION Grievance Redressal is a management- and governance-related process used commonly in India. While the term "Grievance Redressal" primarily covers the receipt and processing of complaints from citizens and consumers, a wider definition includes actions taken on any issue raised by them to avail services more effectively. The traditional approach to Grievance Redressal, which is handled through letters and complaint forms, has very little appeal and its usage rarely reflects the actual state of customer satisfaction or lack thereof. However, new Internet-based approaches used by the government and more by private organizations, such as Public grievance redressal (pgportal) – India. Grievance Redressal mechanism is mandated in Government agencies and departments that are directly involved with serving citizens and organizations. Usually a Public Relations Officer (PRO) is designated with the role of receiving complaints and initiating corrective action, but this mechanism often fails on account of lack of authority vested in the PRO over officers of various capacities. The Government of India has made effort to systematize the nature of grievance redressal through legislation, being driven by civil society agitations under leadership of Anna Hazare and Arvind Kejriwal for enactment of the Jan Lokpal Bill into law. Whenever the public face problems with the government departments and are unable to find reasonable solution to their predicament, they may complaint into this system and the regarding officers may take the action to that process what the people .And here the admin where also there they would maintain the system and they would track the files and whoever come to the system and what files they upload and full details about the person.

EXISTING SYSTEM Whenever the public face problems with the government departments and are unable to find reasonable solution to their predicament, they have to come all the way to the Collectorate to submit their petitions to the Collector during the weekly grievance day meeting being conducted every Monday. And the official machinery will take its own time to act on the petitions and give a reply after a couple of weeks or months. So they have to go the government office and meet the higher officials and complaint the recording problem what they face daily. So after that they would take the action. Though the grievance process does provide for a structured and often fair 1

procedure to dealing with conflicts within the workplace, there are also certain disadvantages present. In some cases, employees and employers alike can see the inclusion of a third-party arbitrator as a way in which they lose specific rights or control over the situation. Another more obvious disadvantage is the use of time and money, which are both valuable resources to an organization. Often, a grievance does take a substantial amount of time to be completed, and therefore there is plenty of time used, while costs incurred during the investigation, and in particular through the inclusion of a third-party arbitrator can quickly add up. Another common disadvantage amongst employee and employer has to do with the notion of expectation. For instance, one party may prefer a quick resolution, while another may prefer to take their time and conduct a thorough investigation But the people cannot spend as much money for transport facility because poor people cannot go so and far it’s the traditional system. And there would be not proper way of answer also found there because everyone may not be in proper way so these all are in the existing process.

Disadvantages  Time Consumption  Public face health issues.  Make a conflict between the public and high authority

2

CHAPTER-2 2.1 PROJECT PROFILE Organizations define their own process flows for grievance redressal. These are rarely made known to the public in case of private businesses; governments and non-profits usually share voluntarily or by mandate the hierarchy of officers responsible for taking corrective action. Some organizations maintain a custom-developed ticketing software, while others count on SaaS Portals such as ActPlease.com. Feedback Portals such as Trip Advisor and Yelp are driven by consumers, and organizations / businesses have the option to join and participate. Depending on the desire to correct as well as level of transparency of the organization, grievance redressal flow can include the following steps:

Input acceptance Customers convey their grievance to the organization through feedback forms, letters, registered communications, emails, etc. These inputs may be submitted by mail, over the Internet, or in person.

Anonymity Customers are often reluctant to report grievances that target individual executives of the organization, especially those who may influence their future interactions or have the potential to take vengeance. Under such conditions, the organization needs to assure the customer that her identity will be hidden from executives, and preferably from everyone. This, however, opens the potential problem of deceitful negative inputs purposefully targeted against specific executives, as the people reporting are kept anonymous.

Acknowledgement & Status Tracking Customers tend to develop much greater confidence in the grievance and feedback mechanism if they are given a formal acknowledgement. The acknowledgement could be by SMS and Email, as used by ActPlease.com, or simply by publicly posting their message on the appropriate forum, such as Trip Advisor. Ticketing Systems such as os Ticket and Fresh Desk, as well as SaaS systems such as Act Please respond with acknowledgements with unique tracking numbers. These may be used by customers to check status of action taken on their complaint. 3

Advantages  Communication done in easy way.  No issues to the public

4

2.2 System Architecture

Public

Login

Complaint

CM Office

Sockets

Public Grievance cell

Pass the Complaint through the Sockets

Update the Status

Admin (Track the system)

Public would see the status

FIG 2.1

5

Flow Diagram

Public

Login

Post the Complaint

CM Office

Admin View the Complaint Values pass through the Sockets Public Grievance Cell

Update the Status

FIG 2.2

6

Sequence Diagram User (public)

CM Office

Public Grievance Cell

Admin

Register ( ) Send the complaints to Cell () Post their Complaints () Update the Status ( )

Track the cm office details

Update status of the system ()

FIG 2.3

7

Class Diagram View Complaints ( ) Register ( ) Post the complainants ( ) Send to Public cell ( ) User (Public) Cm Office

View the request () Update the process () () Public system

Track the files of full system () Monitor the system ()

Admin

FIG 2.4

8

2.3 MODULES User (Public)  Register  Login  Upload their file CM Office  Login  View the Complaint  Send the request to Public system Public system  Login  View the request  Update the status Admin track  Monitor Module Description User (Public) Register In this new user can register into the system to access the system and here it would access their personal details and everything and then they would generate the Id to the user to access the system. Login Here the user can login through what id given and by using their password and they may get into the system and now the system fully read to use for them.

9

Upload their file Here the user can upload their problem file and with the time and date and submit to the system. CM Office Login The Cm office also have to login into the system by using their username and password View the Complaint Here the CM Office login into the system and can see the who all are given the complaint and everything. Send the Request to Public system Cm office here performs the main role and they send the requests to the public system cell for taking action. Public System Cell Login They public system person also need to login into the system to access the system they also login through their username and password. View The request They can view the request send from the cm office and they can cam to known what are the problems faced by the people and they would came to known about all details. Update the Status Then if they take the steps about the problem they would update the status or otherwise they would also update not action take something like that. Admin Track Here the admin is main part of the system they watch who all are coming into the system and who all were accessing the system in which time and on what date everything would note by them.

10

CHAPTER-3 3.1 COMPANY PROFILE Hindustan Copper Limited (HCL), a public sector undertaking under the administrative control of the Ministry of Mines, was incorporated on 9th November 1967. It has the distinction of being the nation’s only vertically integrated copper producing company as it manufactures copper right from the stage of mining to beneficiation, smelting, refining and casting of refined copper metal into downstream saleable products.

The Company markets copper cathodes, copper wire bar, continuous cast copper rod and byproducts, such as anode slime (containing gold, silver, etc.), copper sulphate and sulphuric acid. In normal practice, more than 90% of the sales revenue is generated from cathode and continuous cast copper rods. In concluded financial year 2016-17, as per provisional estimates, the Company has earned a net profit of Rs 61.94 crore against a sales turnover of Rs 1216.94 crore. HCL’s mines and plants are spread across five operating Units, one each in the States of Rajasthan, Madhya Pradesh, Jharkhand, Maharashtra and Gujarat as named below:

Khetri Copper Complex (KCC) at Khetrinagar, Rajasthan Indian Copper Complex (ICC) at Ghatsila, Jharkhand Malanjkhand Copper Project (MCP) at Malanjkhand, Madhya Pradesh Taloja Copper Project (TCP) at Taloja, Maharashtra Gujarat Copper Project (GCP) at Jhagadia, Gujarat

Services HCL also produces gold silver, nickel sulphate, selenium, tellurium and fertiliser as by products. It is the first Indian Copper Producer to be accredited with ISO 9002 certification for Continuous Cast Rod Manufacturer at its Taloja Plant and for manufacture of cathode at its refineries both at Indian Copper Complex, Ghatsila, Jharkhand and Khetri Copper Complex, Khetri, Rajasthan 11

Hindustan Copper Limited is engaged in mining and smelting of copper, having its production facilities and offices at various locations across the country. On 29 June 2012, CMD of the company said that construction of a smelting refinery at Visakhapatnam with an annual capacity of 600,000 tonne at a cost of ₹20 billion is under consideration.

Units Khetri Copper Complex (KCC) Located in the state of Rajasthan, 180 km (110 mi) from Delhi Capacity - 31,000 tpa copper cathode(the smelter and acid plant at KCC are under shutdown since late 2008 due to the slump in global commodity prices witnessed in 2008 and old machinery.Currently, only Concentrator for production of copper concentrate is working in addition to associated mines.) By-products- sulphuric acid Mines - Khetri and Kolihan (producing 9,500 mt metal in concentrate / annum) Reserve Khetri 34.56 million tonnes @ 1.13% cu Kolihan 22.45 million tonnes @ 1.33% cu Banwas 24.97 million tonnes @ 1.69% cu Indian Copper Complex (ICC) Located in the state of Jharkhand Capacity 16,500 tpa copper cathode By products Sulfuric acid, gold, silver, palladium, selenium, tellurium, nickel sulphate Mines - Surda Reserve

12

Surda 19.30 million tonnes @1.17% cu

Malanjkhand Copper Project (MCP) Located in Madhya Pradesh 200 km (120 mi) from Jabalpur, 170 km (110 mi) from Raipur Capacity open cast mine with a capacity of 2 million tonnes with matching concentrator Mines - Malanjkhand Open-pit mining Reserve 208.030 million tonnes @1.3% cu Features of the open pit mine Length 2600 meter Width 700 meter Planned depth: 240 meter below average ground level The open pit mine has reached ultimate pit depth and further it's not economically viable to exploit the mineral with open pit mining, Hence the mine is being converted to underground mines with enhanced capacity of 5 million tonnes with an investment to the tune of 2000 crores.

Taloja Copper Project (TCP) Located in the state of Maharashtra, district-Raigad, 60 km (37 mi) from Mumbai Capacity 60,000 tpa continuous cast copper rod (CCR) - hindcop rods. Technology plant is based on the latest 'southwire technology' Product range 8 mm, 11 mm, 12.5 mm, 16 mm and 19 mm cc rod

13

CHAPTER -4 4.1 SYSTEM REQUIREMENTS HARDWARE REQUIREMENTS:  System

Intel core

 Hard Disk

160 GB

 Monitor

15 VGA color

 Mouse

Logitech.

 Keyboard

110 keys enhanced

 Ram

2GB

SOFTWARE REQUIREMENTS:  O/S

Windows 7

 Language

Java

 IDE

Net Beans 8.2

 Data Base

MySQL

14

CHAPTER-5 5.1 SYSTEM DESIGN Introduction: System design is the process or art of defining the architecture, components, modules, interfaces and data for a system to satisfy specified requirements. One could see it as the application of systems theory to product development. Design is the first phase in development phase for any engineer’s product system. Design is the creative process. It deals with the creative ability of the programmer. A good design is the key to effective system. The term “Design” is defined as “The process of applying various techniques and principles for the purpose of defining a process or a system in sufficient details to permit its physical realization”.

Input design The user interface design is very important for any application. The interface design describes how the software communicated within itself, to system that interpreted with it and with humans who use it. The interface is a packing for computer software if the interface is easy to learn, simple to use. If the interface design is very good, the user will fall into an interactive software application. The input design is the process of converting the user-oriented inputs into the computer-based format. Errors entered by data entry operations can be controlled by input design. The data is fed into the system using simple interactive forms. The forms have been supplied with messages so that user can enter data without facing any difficulty. The data is validated wherever it requires in the project. This ensures that only the correct data have been incorporated into the system. The goal for designing input data is to make data entry as easy, logical and free from errors. The objectives of input design are: 

To produce a cost effective method of input



To make the input forms understandable to the user

To ensure the validation of data input To achieve the highest position level of accuracy 15

The various activities to be performed for the overall input processors are: Data recording at its source. Data transfer to input form. Data conversation to computer acceptable mode. Data validation. Data flow control. Data correction if necessary.

5.2 Output Design The system output is the most important and direct source of information to the user. So intelligible output design improves the relationship with the user and helps in decision-making. Outputs from the computer systems are required primarily to communicate the results of processing to users. They are also used to provide a permanent copy of these results for later consultation.

A major form of output is a hard copy obtained from the printer. These printouts are designed to include the exact requirements of the user. The outputs required by the end-user are defined during the logical design stages. Two phases of the output design are: Output definition. Output specification Computer outputs are the most important and direct source of information to the user. A quality output is one which meets the requirements of the end user and which presents information in a way which is clear, easy to read and visually attractive. The screens are designed in such a way that the outputs are provided to the user in an understandable form. The objectives of output design are: Design output to serve the indented purpose. Provide output on time. Assume that output is where it is needed. Design output to fit the user

16

5.3 FEASIBILITY STUDY The feasibility study is carried out to test whether the proposed system is worth being implemented. The proposed system will be selected if it is best enough in meeting the performance requirements. The feasibility carried out mainly in three sections namely. • Economic Feasibility • Technical Feasibility • Behavioral Feasibility

Economic Feasibility Economic analysis is the most frequently used method for evaluating effectiveness of the proposed system. More commonly known as cost benefit analysis. This procedure determines the benefits and saving that are expected from the system of the proposed system. The hardware in system department if sufficient for system development.

Technical Feasibility This study center around the system’s department hardware, software and to what extend it can support the proposed system department is having the required hardware and software there is no question of increasing the cost of implementing the proposed system.

The criteria, the

proposed system is technically feasible and the proposed system can be developed with the existing facility.

Behavioral Feasibility People are inherently resistant to change and need sufficient amount of training, which would result in lot of expenditure for the organization. The proposed system can generate reports with day-to-day information immediately at the user’s request, instead of getting a report, which doesn’t contain much detail.

17

5.4 System Implementation: Implementation of software refers to the final installation of the package in its real environment, to the satisfaction of the intended users and the operation of the system. The people are not sure that the software is meant to make their job easier. 

The active user must be aware of the benefits of using the system



Their confidence in the software built up



Proper guidance is impaired to the user so that he is comfortable in using the application

Before going ahead and viewing the system, the user must know that for viewing the result, the server program should be running in the server. If the server object is not running on the server, the actual processes will not take place.

User Training: To achieve the objectives and benefits expected from the proposed system it is essential for the people who will be involved to be confident of their role in the new system.

As system becomes more complex, the need for education and training is more and more important. Education is complementary to training. It brings life to formal training by explaining the background to the resources for them. Education involves creating the right atmosphere and motivating user staff. Education information can make training more interesting and more understandable.

Training on the Application Software: After providing the necessary basic training on the computer awareness, the users will have to be trained on the new application software. This will give the underlying philosophy of the use of the 18

new system such as the screen flow, screen design, type of help on the screen, type of errors while entering the data, the corresponding validation check at each entry and the ways to correct the data entered. This training may be different across different user groups and across different levels of hierarchy.

Operational Documentation: Once the implementation plan is decided, it is essential that the user of the system is made familiar and comfortable with the environment. A documentation providing the whole operations of the system is being developed. Useful tips and guidance is given inside the application itself to the user. The system is developed user friendly so that the user can work the system from the tips given in the application itself.

System Maintenance: The maintenance phase of the software cycle is the time in which software performs useful work. After a system is successfully implemented, it should be maintained in a proper manner. System maintenance is an important aspect in the software development life cycle. The need for system maintenance is to make adaptable to the changes in the system environment. There may be social, technical and other environmental changes, which affect a system which is being implemented. Software product enhancements may involve providing new functional capabilities, improving user displays and mode of interaction, upgrading the performance characteristics of the system. So only thru proper system maintenance procedures, the system can be adapted to cope up with these changes. Software maintenance is of course, far more than “finding mistakes”.

Corrective Maintenance: The first maintenance activity occurs because it is unreasonable to assume that software testing will uncover all latent errors in a large software system. During the use of any large program, errors will occur and be reported to the developer. The process that includes the diagnosis and correction of one or more errors is called Corrective Maintenance.

Adaptive Maintenance: 19

The second activity that contributes to a definition of maintenance occurs because of the rapid change that is encountered in every aspect of computing. Therefore Adaptive maintenance termed as an activity that modifies software to properly interfere with a changing environment is both necessary and commonplace

Perceptive Maintenance: The third activity that may be applied to a definition of maintenance occurs when a software package is successful. As the software is used, recommendations for new capabilities, modifications to existing functions, and general enhancement are received from users. To satisfy requests in this category, Perceptive maintenance is performed. This activity accounts for the majority of all efforts expended on software maintenance.

Preventive Maintenance: The fourth maintenance activity occurs when software is changed to improve future maintainability or reliability, or to provide a better basis for future enhancements. Often called preventive maintenance, this activity is characterized by reverse engineering and re-engineering techniques.

20

CHAPTER-6 6.1 SOFTWARE DESCRIPTION Java Java is a programming language originally developed by James Gosling at Sun Microsystems (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 byte code (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, particularly for client-server web applications.

Java Platform: One characteristic of Java is portability, which means that computer programs written in the Java language must run similarly on any hardware/operating-system platform. This is achieved by compiling the Java language code to an intermediate representation called Java byte code, instead of directly to platform-specific machine code. Java byte code instructions are analogous to machine code, but are intended to be interpreted by a virtual machine (VM) written specifically for the host hardware. End-users commonly use a Java Runtime Environment (JRE) installed on their own machine for standalone Java applications, or in a Web browser for Java applets. Standardized libraries provide a generic way to access host-specific features such as graphics, threading, and networking. A major benefit of using byte code is porting. However, the overhead of interpretation means that interpreted programs almost always run more slowly than programs compiled to native executables would. Just-in-Time compilers were introduced from an early stage that compiles byte codes to machine code during runtime.

21

Just as application servers such as Glass Fish provide lifecycle services to web applications, the Net Beans runtime container provides them to Swing applications. All new shortcuts should be registered in "Key maps/Net Beans" folder. Shortcuts installed INS Shortcuts folder will be added to all key maps, if there is no conflict. It means that if the same shortcut is mapped to different actions in Shortcut folder and current key map folder (like Key map/Net Beans), the Shortcuts folder mapping will be ignored. * Database Explorer Layer API in Database Explorer * Loaders-text-dB schema-Actions in Database Explorer * Loaders-text-sq.-Actions in Database Explorer * Plug-in Registration in Java EE Server Registry The keyword public denotes that a method can be called from code in other classes, or that a class may be used by classes outside the class hierarchy. The class hierarchy is related to the name of the directory in which the .java file is located. The keyword static in front of a method indicates a static method, which is associated only with the class and not with any specific instance of that class. Only static methods can be invoked without a reference to an object. Static methods cannot access any class members that are not also static. The keyword void indicates that the main method does not return any value to the caller. If a Java program is to exit with an error code, it must call System. Exit () explicitly. The method name "main" is not a keyword in the Java language. It is simply the name of the method the Java launcher calls to pass control to the program. Java classes that run in managed environments such as applets and Enterprise JavaBeans do not use or need a main () method. A Java program may contain multiple classes that have main methods, which means that the VM needs to be explicitly told which class to launch from. The Java launcher launches Java by loading a given class (specified on the command line or as an attribute in a JAR) and starting its public static void main(String[]) method. Stand-alone programs must declare this method explicitly. The String [] rags parameter is an array of String objects containing any arguments passed to the class. The parameters to main are often passed by means of a command line.

22

Java a High-level Language: A high-level programming language developed by Sun Microsystems. Java was originally called OAK, and was designed for handheld devices and set-top boxes. Oak was unsuccessful so in 1995 Sun changed the name to Java and modified the language to take advantage of the burgeoning World Wide Web. Java source code files (files with a .java extension) are compiled into a format called byte code (files with a .class extension), which can then be executed by a Java interpreter. Compiled Java code can run on most computers because Java interpreters and runtime environments, known as Java Virtual Machines (VMs). Byte code can also be converted directly into machine language instructions by a just-in-time compiler (JIT). Java is a general purpose programming language with a number of features that make the language well suited for use on the World Wide Web. Small Java applications are called Java applets and can be downloaded from a Web server and run on your computer by a Javacompatible Web browser, such as Netscape Navigator or Microsoft Internet Explorer. Object-Oriented Software Development using Java: Principles, Patterns, and Frameworks contain a much applied focus that develops skills in designing software-particularly in writing well-designed, medium-sized object-oriented programs. It provides a broad and coherent coverage of object-oriented technology, including object-oriented modeling using the Unified Modeling Language (UML) object-oriented design using Design Patterns, and object-oriented programming using Java.

Net Beans The Net Beans Platform is a reusable framework for simplifying the development of Java Swing desktop applications. The Net Beans IDE bundle for Java SE contains what is needed to start developing Net Beans plug-in and Net Beans Platform based applications; no additional SDK is required. Applications can install modules dynamically. Any application can include the Update Centre module to allow users of the application to download digitally-signed upgrades and new features directly into the running application.

23

The platform offers reusable services common to desktop applications, allowing developers to focus on the logic specific to their application. Among the features of the platform are: 

User interface management (e.g. menus and toolbars)



User settings management



Storage management (saving and loading any kind of data)



Window management



Wizard framework (supports step-by-step dialogs)



Net Beans Visual Library



Integrated Development Tools

J2EE A Java EE application or a Java Platform, Enterprise Edition application is any deployable unit of Java EE functionality. This can be a single Java EE module or a group of modules packaged into an EAR file along with a Java EE application deployment descriptor. Enterprise applications can consist of the following: 

EJB modules (packaged in JAR files);



Web modules (packaged in WAR files);



connector modules or resource adapters (packaged in RAR files);



Session Initiation Protocol (SIP) modules (packaged in SAR files);



application client modules



Additional JAR files containing dependent classes or other components

required by the application; Wamp Server

24

WAMPs are packages of independently-created programs installed on computers that use a Microsoft Windows operating system. Apache is a web server. MySQL is an open-source database. PHP is a scripting language that can manipulate information held in a database and generate web pages dynamically each time content is requested by a browser. Other programs may also be included in a package, such as phpMyAdmin which provides a graphical user interface for the MySQL database manager, or the alternative scripting languages Python or Perl. MySQL The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. Free-software-open source projects that require a full-featured database management system often use MySQL. Applications which use MySQL databases include: TYPO3, Joomla, WordPress, hob, Drupal and other software built on the LAMP software stack.

Platforms and interfaces Many programming languages with language-specific APIs include libraries for accessing MySQL databases. These include MySQL Connector/Net for integration with Microsoft's Visual Studio (languages such as C# and VB are most commonly used) and the JDBC driver for Java. In addition, an ODBC interface called Modoc allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.

25

6.2 SAMPLE CODING: ADMIN CODE /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package grievance;

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import net.proteanit.sql.DbUtils;

/** * * @author EGC */ public class admintrack extends javax.swing.JFrame { Connection conn; 26

Statement stmt; PreparedStatement pst; ResultSet rs; /** * Creates new form admintrack */ public admintrack() { initComponents(); try { String url = "jdbc:mysql://localhost:3306/"; String driver = "com.mysql.jdbc.Driver";

conn = DriverManager.getConnection(url +"publicsystem","root", ""); stmt = conn.createStatement();

} catch(Exception e) { e.printStackTrace(); } }

27

/** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() {

jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jPanel1.setBackground(new java.awt.Color(153, 204, 255));

jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N jLabel1.setText("Admin panel Tracking files"); 28

jButton1.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jButton1.setText("Complainer "); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } });

jButton2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jButton2.setText("CM Office"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } });

jButton3.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jButton3.setText("Public Grievance "); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } 29

});

jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] {

}, new String [] {

} )); jScrollPane1.setViewportView(jTable1);

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(107, 107, 107) .addComponent(jButton1) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(149, 149, 149) .addComponent(jLabel1)) 30

.addGroup(jPanel1Layout.createSequentialGroup() .addGap(109, 109, 109) .addComponent(jButton2) .addGap(109, 109, 109) .addComponent(jButton3))) .addContainerGap(111, Short.MAX_VALUE)) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(140, 140, 140) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 493, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 0, Short.MAX_VALUE)) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(20, 20, 20) .addComponent(jLabel1) .addGap(46, 46, 46) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton1) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE ) .addComponent(jButton3) .addComponent(jButton2))) 31

.addGap(64, 64, 64) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 202, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(73, Short.MAX_VALUE)) );

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) );

pack(); }//

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: 32

try { rs=stmt.executeQuery("SELECT * FROM upload"); ResultSetMetaData metadata=rs.getMetaData();

jTable1.setModel(DbUtils.resultSetToTableModel(rs)); } catch(Exception e) { e.printStackTrace(); } } private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { rs=stmt.executeQuery("SELECT * FROM cm"); ResultSetMetaData metadata=rs.getMetaData(); jTable1.setModel(DbUtils.resultSetToTableModel(rs)); } catch(Exception e) { e.printStackTrace(); 33

} } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { rs=stmt.executeQuery("SELECT * FROM update1"); ResultSetMetaData metadata=rs.getMetaData(); jTable1.setModel(DbUtils.resultSetToTableModel(rs)); } catch(Exception e) { e.printStackTrace(); } } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 34

*/ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(admintrack.class.getName()).log(java.util.logging.Level.SEV ERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(admintrack.class.getName()).log(java.util.logging.Level.SEV ERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(admintrack.class.getName()).log(java.util.logging.Level.SEV ERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(admintrack.class.getName()).log(java.util.logging.Level.SEV ERE, null, ex); } //

35

/* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new admintrack().setVisible(true); } }); }

// Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JPanel jPanel1; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; // End of variables declaration } Upload file: /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. 36

*/ package grievance;

import java.io.File; import java.io.FileReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Calendar; import javax.swing.JFileChooser; import javax.swing.JOptionPane;

/** * * @author EGC */ public class fileupload extends javax.swing.JFrame { Connection conn; Statement stmt; public static String tf; public static String tf1;

37

File ff; FileReader k=null; /** * Creates new form fileupload */ public fileupload() { try { String url = "jdbc:mysql://localhost:3306/"; String driver = "com.mysql.jdbc.Driver";

conn = DriverManager.getConnection(url +"publicsystem","root", ""); stmt = conn.createStatement(); } catch(Exception e) { e.printStackTrace(); } initComponents(); jLabel5.setText(register.name);

} 38

/** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() {

jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jTextField2 = new javax.swing.JTextField(); jScrollPane1 = new javax.swing.JScrollPane(); jTextArea1 = new javax.swing.JTextArea(); jButton2 = new javax.swing.JButton(); jLabel4 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); 39

jTextField3 = new javax.swing.JTextField(); jTextField4 = new javax.swing.JTextField();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jPanel1.setBackground(new java.awt.Color(153, 204, 255));

jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N jLabel1.setText("Upload the Complaint file");

jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel2.setText("User Id"); jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel3.setText("Name"); jButton1.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jButton1.setText("Upload File"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } });

jTextArea1.setColumns(20); 40

jTextArea1.setRows(5); jScrollPane1.setViewportView(jTextArea1); jButton2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jButton2.setText("Submit"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel4.setText("Date"); jLabel4.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel4MouseClicked(evt); } }); jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel6.setText("Time"); jLabel6.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel6MouseClicked(evt); } }); 41

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel1) .addGap(254, 254, 254)) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(81, 81, 81) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 351, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup() .addComponent(jButton1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 203, javax.swing.GroupLayout.PREFERRED_SIZE))

42

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup() .addGap(16, 16, 16) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel3) .addComponent(jLabel4) .addComponent(jLabel6)) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(67, 67, 67) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 141, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup() .addGap(71, 71, 71) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField3) .addComponent(jTextField4, javax.swing.GroupLayout.DEFAULT_SIZE, 137, Short.MAX_VALUE)))))) 43

.addGap(29, 29, 29) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(199, Short.MAX_VALUE)) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(23, 23, 23) .addComponent(jLabel1) .addGap(39, 39, 39) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(jPanel1Layout.createSequentialGroup() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE ) .addComponent(jLabel2) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(33, 33, 33) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(jLabel3)) .addGap(30, 30, 30)

44

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE ) .addComponent(jLabel4) .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 24, Short.MAX_VALUE) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE ) .addComponent(jLabel6) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(24, 24, 24) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE ) .addComponent(jButton1) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton2)) .addGap(31, 31, 31) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(39, 39, 39)) );

45

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) );

pack(); }//

46

6.3 SCREENSHOTS

FIG 6.1

47

FIG 6.2

48

FIG 6.3

49

FIG 6.4

50

FIG 6.5

51

FIG 6.6

52

FIG 6.7

53

FIG 6.8

54

FIG 6.9 55

FIG 6.10

56

FIG 6.11 57

FIG 6.12

58

CHAPTER-7 7.1 TESTING System testing is the stage of implementation, which aimed at ensuring that system works accurately and efficiently before the live operation commence. Testing is the process of executing a program with the intent of finding an error. A good test case is one that has a high probability of finding an error. A successful test is one that answers a yet undiscovered error. Testing is vital to the success of the system. System testing makes a logical assumption that if all parts of the system are correct, the goal will be successfully achieved. The candidate system is subject to variety of tests-on-line response, Volume Street, recovery and security and usability test. A series of tests are performed before the system is ready for the user acceptance testing. Any engineered product can be tested in one of the following ways. Knowing the specified function that a product has been designed to from, test can be conducted to demonstrate each function is fully operational. Knowing the internal working of a product, tests can be conducted to ensure that “al gears mesh”, that is the internal operation of the product performs according to the specification and all internal components have been adequately exercised. Unit Testing: Unit testing is the testing of each module and the integration of the overall system is done. Unit testing becomes verification efforts on the smallest unit of software design in the module. This is also known as ‘module testing’. The modules of the system are tested separately. This testing is carried out during the programming itself. In this testing step, each model is found to be working satisfactorily as regard to the expected output from the module. There are some validation checks for the fields. For example, the validation check is done for verifying the data given by the user where both format and validity of the data entered is included. It is very easy to find error and debug the system.

59

Integration Testing: Data can be lost across an interface, one module can have an adverse effect on the other sub function, when combined, may not produce the desired major function. Integrated testing is systematic testing that can be done with sample data. The need for the integrated test is to find the overall system performance. There are two types of integration testing. They are: i)

Top-down integration testing.

ii)

Bottom-up integration testing.

White box Testing: White Box testing is a test case design method that uses the control structure of the procedural design to drive cases. Using the white box testing methods, we derived test cases that guarantee that all independent paths within a module have been exercised at least once.

Black box Testing: 

Black box testing is done to find incorrect or missing function



Interface error



Errors in external database access



Performance errors



Initialization and termination errors

In ‘functional testing’, is performed to validate an application conforms to its specifications of correctly performs all its required functions. So this testing is also called ‘black box testing’. It tests the external behavior of the system. Here the engineered product can be tested knowing the specified function that a product has been designed to perform, tests can be conducted to demonstrate that each function is fully operational.

Validation Testing: After the culmination of black box testing, software is completed assembly as a package, interfacing errors have been uncovered and corrected and final series of software validation tests

60

begin validation testing can be defined as many, but a single definition is that validation succeeds when the software functions in a manner that can be reasonably expected by the customer.

User acceptance Testing: User acceptance of the system is the key factor for the success of the system. The system under consideration is tested for user acceptance by constantly keeping in touch with prospective system at the time of developing changes whenever required.

Output Testing: After performing the validation testing, the next step is output asking the user about the format required testing of the proposed system, since no system could be useful if it does not produce the required output in the specific format. The output displayed or generated by the system under consideration. Here the output format is considered in two ways. One is screen and the other is printed format. The output format on the screen is found to be correct as the format was designed in the system phase according to the user needs. For the hard copy also output comes out as the specified requirements by the user. Hence the output testing does not result in any connection in the system.

61

8 CONCLUSION In this application, it's explained concerning the operating procedure of the system, the roles concerned within the system and therefore the activities and responsibilities those users. This paper presents the summary of the analysis and development of the grievance management system of Municipal Corporation. The Grievance cell system has been developed to beat the issues with ancient system. The system was tested with sample knowledge and was found to be a lot of quicker, reliable and user friendly than the prevailing system So this system would be more useful to the public people and cm office and the public government authority too so this would make their work more simple and make them more free too.

62

9 REFERENCES Websites [1 https://www.tutorialspoint.com/java/ [2] https://www.javatpoint.com/java-tutorial [3] https://www.w3schools.com/java/default.asp [4] https://www.journaldev.com/9191/java-web-services-tutorial [5] https://netbeans.org/kb/articles/learn-java.html [6] https://netbeans.org/kb/docs/java/quickstart.html [7] https://www.homeandlearn.co.uk/php/php1p3.html [8] http://www.icynets.com/set-wampserver-computer/

Video link [1]file:///C:/Users/Robin/Desktop/SCRIPTING%20ASSIGNMENT/SCRIPTING%20ASSIGN MENT/EXERCISE%202/hotel.xml [2] https://www.youtube.com/watch?v=oTzNRv6X51o [3]https://www.youtube.com/watch?v=B8gMEV8GKbg&list=PLyRiRUsTyUXhUXoOPEdMZWhGpGeSQFZg [4] https://www.youtube.com/watch?v=Hl-zzrqQoSE&list=PLFE2CE09D83EE3E2

63

64