E-care Help Desk System Java Project 2z55k

  • ed by: Jayaram Gowda M S
  • 0
  • 0
  • October 2019
  • PDF

This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report l4457


Overview 6h3y3j

& View E-care Help Desk System Java Project as PDF for free.

More details h6z72

  • Words: 11,656
  • Pages: 72
Each document has a head and body delimited by the and tag. The head is where you give your HTML document a title and where you indicate other parameters the browser may use when displaying the document. This includes the text for displaying the text. Tag also references special and indicates the hot spots that link your document to other documents. HTML FORMS: Creating a form usually involves two independent steps: Creating the layout for the form itself and then writing a script program on the server side to process the formation you get back from a form. To create a form, You use the
tag. Inside the opening and closing FORM tags are each of the individual form elements plus any other HTML content to create a layout for that form.

The opening tag of the FORM element usually includes the attributes: METHOD and ACTION. The METHOD attributes can be either GET or POST which determines how your form data is sent to the script to process it. The ACTION attribute is a pointer to the script that processes the form on the server side. The ACTION can be included by a relative path or by a full URL to a script on your server or somewhere else. For example, the following tag would call a script called form-name in cgi-bin directory on server www.myservser.com ……………….


METHOD ATTRIBUTE: The other required attribute for the
tag sets the methods by which the browser form’s data to the server for processing. There are two ways: the POST method and GET method. With POST method, the browser sends the data in two steps: the browser first s the form-processing server specified in the action attributes, and once is made, sends the data. The GET method in the other hand, s the form processing server and sends the form data in a single transaction step: the browser appends the data to the form’s action URL, separated by the question mark (?) character.

INTRODUCTION TO JAVA CREATION OF JAVA

Java was conceived by James Gosling, Patrick Naughton, Chris Warth, Ed Frank and Mike Sheridan at SUN Microsystems Incorporation in the year 1991.It took 18 months to develop the 1st working version. This language was initially called “OAK”, but was renamed “JAVA” in 1995, many more contributed to the design and evolution of the language. JAVA OVERVIEW Java is a powerful but lean object-oriented programming language. It has generated a lot of excitement because it makes it possible to program for Internet by creating Applets. Programs that can be embedded in web page. The context of an applet can be an animation with sound, an interactive game or a ticker tape. With constantly updated stock prices. Applets can be just little decorations to liven up web page, or they can be serious applications like Word processor or Spreadsheet. But Java is more than a programming language for writing Applets. It is being used more and more for writing standalone applications as well. It is becoming so popular that many people believe it will become standard language for both general purpose and Internet programming. There are many buzzwords associated with Java, but because of its spectacular growth in popularity, a new buzzword has appeared ubiquitous. Indeed, all indications are that it will soon be everywhere. Java builds on the strength of C++. It has taken the best features of C++ and discarded the more problematic and error prone parts. To this lean core, it has added garbage collection (automatic memory management), multithreading (the capacity for one program to do more than one thing at a time), security capabilities. This result is that Java is simple, elegant, and powerful and easy-to-use. Java is actually a platform consisting of 3 components:

1. Java Programming Language. 2. Java Library of Classes and Interfaces. 3. Java Virtual Machine The following sections will say more about these components. JAVA IS PORTABLE: One of the biggest advantages Java offers is that it is portable. An application written in Java will run on all the major platforms. Any computer with a Java-based browser can run the applications or Applets written in the Java-Programming-Language. A programmer no longer has to write one program to run on a Macintosh, another program to run on a Windows-machine still another to run on a UNIX-machine and so on. In other words, with Java developers write their programs only once. The Virtual Machine is what gives Java is cross platform capabilities. Rather being compiled into machine language, which is different for each OS’s and computer architecture, Java code is compiled into Byte codes. With other languages, the program code is compiled into a language that the computer can understand. The problem is that other computers with different machine instruction set cannot understand that language. Java code on the other hand is compiled into Byte-Code rather than a machine language. These byte codes go to the JVM, which executes them directly or translates them into the language that is understood by the machine running it. In summary, these means that with the JDBC API extending Java, a programmer writing Java code can access all the major RDBMS on any platform that s the JVM. JAVA IS OBJECT-ORIENTED

The Java programming language is OBJECT-ORIENTED, which makes program design focus on what you are dealing with, rather than on how your are going to do something. This makes it more useful for programming in sophisticated projects, because one can break the things into understandable components. A big benefit is that these components can then be reused. Object-Oriented Languages use the paradigm of classes. In simplest term, a class includes both the data and the functions to operate on data. You can create an instance of a class, also called an object, which will have all the data and functionality of its class. Because of this, you can think of a class as being like template, with each object being a specific instance of a particular type of class. The class paradigm allows one to encapsulate data so that specific data values are those using the data cannot see the function implementation. Encapsulation makes it possible to make the changes in code without breaking other programs that use that code. If for example, the implementation of a function is changed, the change is invisible to any programmer who invokes that function, and does not affect his/her program, except hopefully to improve it. Java includes inheritance, or the ability to derive new classes from existing classes. The derived class, is also called as Sub-Class, inherits all the data in the functions of the existing class. JAVA DEVOLPMENT EVNIRONMENT To code, edit, debug and test the java programs, one needs to have a java development environment. At the minimum this will consists of a java compiler interpreter and applet viewer where applets can be tested. Sun’s java development kit (JDK) latest version is 2.2 can be freely ed from the Internet. Java compiler is available on DOS, Win95, WIN’NT, Solaris and MAC etc.

Introduction to JavaScript JavaScript:

JavaScript is a new scripting language for WebPages. Scripts written with java script can be embedded into your HTML pages.

With java script you have many

possibilities for enhancing your HTML page with interesting elements. For example you are able to respond to -initiated events quite easily. Some effects that are now possible with java script were some time ago only possible with CGI. So you can create really sophisticated pages with the helps of java script on the Internet. Difference between java and Java Script Although the names are almost the same Java is not the same as Java Script. These are two different techniques for Internet programming. Java is programming language. JavaScript is a scripting language as the name implies. The difference is that we can create real programs with java. But java script in not real programming. Java Script is meant to be easy to understand and easy to use. JavaScript authors should not have to care too much about programming. We could say that Java Script is rather an extension to HTML than a separate computer language. Of course this is not the official definition but it makes it easier to understand the difference between java and java script. How can Java Script scripts run? The first browser to java script was the Netscape Navigator 2.0 of course the higher versions do have java script as well. You might know that java does not run on all Netscape Navigators 2.0 (or higher versions) versions. But this is not true for java script -although there are some problems with the different versions. The Mac version for example seems to have many bugs. In the near future there are going to be some other browsers, which java script. The Microsoft Internet explorer 3.0 is going to java script. JavaScript enabled browsers are going to spread soon - it is worth learning this new technique now. You might realize that is really easy to write Java Script scripts. We have to know is some basic techniques and some work-around for problems you might encounter. Of course we need a basic. Understanding HTML before reading this tutorial you can find many really good online resources about

HTML. Best you make an online search about ‘html’ at yahoo if you want to get informed about HTML. Now I want to show some small scripts so you can learn how they are implemented into HTML-documents and to show which possibilities you have with the new scripting language. The following is a very small script, which will only print a text into an HTML document. My first JavaScript
This is a normal HTML document
<script language=”JavaScript”> Document.write (“this is a java script”) Backing HTML again If you are using a java script enabled-browser at the moment then you will have the possibility to see this script working. If your browser doesn’t Java Script then this output might be some kind of strange… This is a normal HTML document This is java script! Back in HTML again.

Functions Functions are bet declared between the tag of HTML page. Functions are called by -initiated events. Seems reasonable to keep the functions between the tags.

They are loaded first before a can do anything that might call a function. Scripts can be placed between inside comment fields to ensure that older browser do not display the script itself. <script language=”JavaScript”> function pushbutton (){ alert (“Hello!”); }
If we want to test this one immediately and you are using a Java Script enabled browser then please go ahead and push the button. This script will create a button and when you press it a window will pop up saying “hello!”. In fact we have a lot of possibilities just by adding functions to our scripts. The common browsers transmit the form information by either method: here’s the complete tag including the GET transmission method attribute for the previous form Example
………


Input elements. Use the tag to define any one of a number of common form elements including text fields multiple choice lists click able images and submission buttons. There are many attributers for this tag only that types and name attributes are required for each element, each type of input element uses only a subset of the followed attributes. Additional attributes may be required based upon which type of the form element you specify. Submit button: The submit button ( ) does what its name implies, settings in motion the form’s submission to the server from the browser. We many have more than submit buttons will be added to the parameter list the browser sends along to the server. Example < Input type =”submit”> Reset button: The reset button if firm button is nearly self- explanatory; it lets the reset erase or set to some default value all elements in the form. By default the browser displays a reset button worth the label “reset”. We can change that by specifying a value attribute with tour own button label. INTRODUCTION TO JDBC JDBC (Java Database connectivity) is a front-end tool for connecting to a server to ODBC in that respect, however JDBC can connect only java client and it uses ODBC for the connectivity. JDBC is essentially a low-level API since any data manipulation, storage

and retrieval has to be done by the program itself. Some tools, which provide a higher-level abstraction, are expected shortly. The next question that needs to be answered is why we need JDBC, once we have ODBC on hand. We can use the same ODBC to connect the entire database and ODBC is a proven technology. Problem for doing this is ODBC gives a ‘c’ language API, which uses pointers extensively. Since java does not have any pointes and is object-oriented sun Microsystems, inventor of java developed to suit its needs. Requirements to use JDBC: To use JDBC you need a basic knowledge of databases and SQL.A part from this you need the jdk1.1 (Java Development Kit1.1 available javasoft’s website) or a version of Java since jdk1.1 and above come bundled with JDBC software. After that you need to have a back-end database engine for which a JDBC driver is available. When JDBC drivers are not available JDBC-ODBC bridge drivers are used to access the database through ODBC. Back-end is not needed when JDBC driver is capable of storing and retrieving the data itself, or if JDBC-ODBC Bridge and the ODBC driver can be used to store and retrieve the information.

DATABASE MODELS JDBC and accessing the database through applets and JDBC API via an intermediate server resulted server resulted in a new type of database model which is

different from the client-server model. Based on number of intermediate server through the request should go it is named as single tire, two tire and multi tire architecture Single Tier In a single tier the server and client are the same in the sense that a client program that needs information (client) and the source of this type of architecture is also possible in java, in case flat files are used to store the data. However this is useful only in case of small applications. The advantage with this is the simplicity and portability of the application developed.

Server and client

Database

Two Tier (client-server) In two tier architecture the database resides in one machine and client in different machine they are connected through the network. In this type of architecture a database

management takes control of the database and provides access to clients in a network. This software bundle is also called as the server. Software in different machines, requesting for information are called as the clients.

Server

Client

Database Client

Three Tier and N-Tier

In the three-tier architecture, any number servers can access the database that resides on server. Which in turn serve clients in a network. For example, you want to access the database using java applets, the applet running in some other machine, can send request only to the server from which it is down loaded. For this reason we will need to have a intermediate server which will accept the requests from applets and them to the actual database server. This intermediate server acts as a two-way communication channel also. This is the information or data from the database is ed on to the applet that is requesting it. This can be extended to make n tiers of servers, each server carrying to specific type of request from clients, however in practice only 3 tiers architecture is popular. JDBC Driver Types: The JDBC drivers that we are aware of at this time fit into one of four categories: 1. JDBC-ODBC BRIDGE PLUS ODBC DRIVER The java soft bridge product provides JDBC access via ODBC drivers. Note that ODBC binary code end in many cases database client code must be loaded on each client machine that uses this driver. As a result, this kind of driver is most appropriate on a corporate network where client installations are not major problem, or for application server code written in java in a 3-tier architecture. 2. NATIVE API PARTLY-JAVA DRIVER This kind of driver converts JDBC calls into calls on the client API for oracle Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine. 3. JDBC-NET ALL-JAVA DRIVER

This driver translates JDBC calls into a DBMS independent net protocol, which is then translated, to a DBMS protocol by a server. This net server middle-ware is able to connect its all java clients to many different databases. The Specific protocol used depends on the vendor. In general, this most flexible JDBC alternative. It is likely that all vendors of this solution will provide products suitable for intranet use. In order for these products to also Internet access, they must handle the additional requirements for security, access through firewalls, etc that the web imposes. Several vendors are adding JDBC drivers to their existing database middleware products. 4. NATIVE PROTOCOL ALL-JAVA DRIVER This kind of driver converts JDBC calls into the network protocol used by DBMS directory. This allows a direct call from the client machine to the DBMS server that is practical solution for intranet access. Since many of these protocols are proprietary, the database vendors themselves will be the primary source. Several database vendors have these in progress. Eventually, we expect that driver categories 3 and 4 will be the preferred way to access databases from JDBC. Driver categories one and two are interim solutions where direct all java drivers are not yet available. Category 4 is in some sense the ideal; however, there are many cases where category 3 may be preferable: eg: -where a thin DBMS-independent client is desired, or if a DBMS –independent protocol is standardized and implemented directly by many DBMS vendors. Servlets Servlets provides a Java-Based solution used to address the problems currently associated with doing server side programming, including inextensible scripting solutions, platform specific APIs, and incomplete interfaces. Servlets are objects conform to a specific interface that can be plugged into a Java-based server. Servlets are to the serverside what applets are to the client-side-object byte codes that can be dynamically loaded off the net. They differ from applets in that they are faceless objects (without graphics or a GUI component). They serve as platform independent, dynamically loadable, plug gable

helper byte code objects on the server side that can be used to dynamically extend serverside functionality. For example, an HTTP servlet can be used to generate dynamic HTML content. When you use servlets to do dynamic content you get the following advantages: 1.They’re faster and cleaner than CGI scripts. 2.They use a standard API (the Servlet API) 3.They provide all the advantages of Java (run on a variety of servers without needing to be rewritten) The attractions of Servlets There are many features of servlets that make them easy and attractive to use. These include: Easily configured using the GUI-based Tool. Can be loaded and invoked from a local disk or remotely across the network. Can be linked together, or chained, so that one servlet can call another servlets, or several servlets in sequence. Can be called dynamically from within HTML pages, using server-side include tags Invoking the servlet To invoke a servlet you call it by creating a URL with “/servlet/” pretended to the servlet name. Then enter this URL in your favorite browser to see the output of the Servlet. Example: After installing according to the directions above, access the HelloServlet by entering the following URL in your favorite browser:

http://server-host-name:8080/servlet/hell Internal Servlets The Java Server servlet architecture is very flexible and the server takes advantage of this by dividing up its work among several internal servlets. They are 1.File Servlet 2.Invoker Servlet 3.Server side include servlet 4. Servlet 5.CGI Servlet 6.Image map servlet

File Servlet The file servlet provides the standard document serving capabilities of java server. This servlet includes a caching mechanism to speed up response times of frequently accesses files. In addition it recognizes files that are to be parsed for server side includes and es them on to the SSInclude Servlet. Servlets are an effective substitute for CGI scripts and provide a faster and cleaner way to generate dynamic documents. The java server is both flexible and extensible. Using the java server APIs you can write your own servlet and incorporate it into the server. To do this follows these three steps 1. Write the servlet 2. Configure the servlet 3. Invoke the servlet

Writing the Servlet Unless they are used with the http protocol, servlets subclass the servlet. GenericServlet class and override the service (Servlet Request, ServletResponse) method. Servlets use with the HTTP protocol should subclass the javax.servlet.HttpServlet class override one or both of the doGet (HttpServletRequest, HttpServletResponse) and doPost (HttpServletRequest, HttpServletResponse) methods Servlets class may choose to override the default implementations of the servlet “lifecycle” servlet methods, init (ServletConfig) and destroy ().

Configuring the Server: The real beauty of the java server is that it is extensible. But, before you can use a Servlet to add an extended functionality to the JavaServer.You have to use the Java Server istration applet to install the Servlet and specify the default parameters and arguments. Display the istration Applet by connecting to: http://server_Host_Name:9090/index.html Are secure-even when ing across the network, the servlets security model and the Servlet sandbox to protect your system from unfriendly behavior. The advantage of the Servlet API One of the great advantages of the Servlet API is protocol independence. It assumes nothing about: The protocol being used to transmit on the net. How it is loaded. The server environment it will be running in. These qualities are important, because it allows the Servlet API to be embedded in many different kinds of Servers. There are other advantages to the servlet API as well. Servlet Features

The Java Server provides several important Servlet features. These include: Loading & Invoking Servlets. Servlets can be loaded both locally and remotely. Filters and Servlets change. The Java Server uses MIME types to call Servlets sequentially. Server size includes: Servlets can be invoked from dynamic HTML documents using Server side include tags. Replacing the CGI Scripts.

ORACLE INTRODUCTION:

Oracle is a relational database management system, which organizes data in the form of tables. Oracle is one of many database servers based on RDBMS model, which manages a seer of data that attends three specific things-data structures, data integrity and data manipulation. With oracle cooperative server technology we can realize the benefits of open, relational systems for all the applications. Oracle makes efficient use of all systems resources, on all hardware architecture; to deliver unmatched performance, price performance and scalability. Any DBMS to be called as RDBMS has to satisfy Dr.E.F.Codd’s rules.

DISTINCT FEATURES OF ORACLE: •

ORACLE IS PORTABLE: The Oracle RDBMS is available on wide range of platforms ranging from PCs to super computers and as a multi loadable module for Novel NetWare, if you develop application on system you can run the same application on other systems without any modifications.



ORACLE IS COMPATIBLE: Oracle commands can be used for communicating with IBM DB2 mainframe RDBMS that is different from Oracle, that is Oracle compatible with DB2. Oracle RDBMS is a high performance fault tolerant DBMS, which is specially designed for online transaction processing and for handling large database applications.



MULTITHREADED SERVER ARCHITECTURE:

Oracle adaptable multithreaded server architecture delivers scalable high performance for very large number of s on all hardware architecture including symmetric multiprocessors (sumps) and loosely coupled multiprocessors. Performance is achieved by eliminating U, I/O, memory and operating system bottlenecks and by optimizing the Oracle DBMS server code to eliminate all internal bottlenecks. FEATURES OF ORACLE: Most popular RDBMS in the market because of its ease of use •

Client/server architecture.



Data independence.



Ensuring data integrity and data security.



Managing data concurrency.



Parallel processing for speed up data entry and online transaction processing used for applications.



DB procedures, functions and packages.

Dr.E.F.CODD’s RULES These rules are used for valuating a product to be called as relational database management systems. Out of 12 rules, a RDBMS product should satisfy at least 8 rules +rule called rule 0 that must be satisfied. RULE 0: FOUNDATION RULE: For any system that is to be d as, or claimed to be relational DBMS. That system should manage database with in it self, with out using an external language.

RULE 1.INFORMATION RULE

All information in relational database is represented at logical level in only one way as values in tables. RULE 2.GUARANTEED ACCESS: Each and every data in a relational database is guaranteed to be logically accessibility by using to a combination of table name, primary key value and column name RULE 3.SYSTEMATIC TREATMENT OF NULL VALUES Null values are ed for representing missing information and inapplicable information. They must be handled in systematic way, independent of data types. RULE 4 DYNAMIC ONLINE CATALOG BASED RELATION MODEL: The database description is represented at the logical level in the same way as ordinary data so that authorized s can apply the same relational language to its interrogation as they do to the regular data. RULE 5: COMPRHENSIVE DATA SUB LANGUAGE A relational system may several languages and various models of terminal use. However there must be one language whose statement can express all of the following: Data Definitions, View Definitions, Data Manipulations, Integrity, Constraints, Authorization and transaction boundaries. RULE 6.VIEW UPDATING Any view that is theoretical can be updatable if changes can be made to the tables that effect the desired changes in the view. RULE 7.HIGH LEVEL UPDATE, INSERT and DELETE The capability of handling a base relational or derived relational as a single operand applies not only retrieval of data also to its insertion, updating, and deletion. RULE 8.PHYSICAL DATA INDEPENDENCE

Application program and terminal activities remain logically unimpaired whenever any changes are made in either storage representation or access method. RULE 9.LOGICAL DATA INDEPENDENCE Application programs and terminal activities remain logically unimpaired whenever any changes are made in either storage representation or access methods. RULE 10: INTEGRITY INDEPENDENCE: Integrity constraints specific to particular database must be definable in the relational data stored in the catalog, not in application program. RULE 11: DISTRIBUTED INDEPENDENCE: Whether or not a system database distribution, it must have a data sublanguage that can distributed databases without changing the application program. RULE 12: NON SUB-VERSION: If a relational system has low level language, that low language cannot use to subversion or by the integrity rules and constraints expressed in the higher level relational language. ORACLE S THE FOLLOWING CODD’S RULES: Rule 1: Information Rule (Representation of information)-YES. Rule 2: Guaranteed Access-YES. Rule 3: Systematic treatment of Null values-YES. Rule 4: Dynamic on-line catalog-based Relational Model-YES. Rule 5: Comprehensive data sub language-YES. Rule 6: View Updating-PARTIAL. Rule 7: High-level Update, Insert and Delete-YES. Rule 8: Physical data Independence-PARTIAL. Rule 9: Logical data Independence-PARTIAL. Rule 10: Integrity Independence-PARTIAL. Rule 11: Distributed Independence-YES. Rule 12: Non-subversion-YES. CONCLUSION

The result of the E-care is that it s many corporate clients and the individual s or the end-s with unique interface, through which the HD problems are solved within given time and it shows efficiency in the internal messaging system and results in accurate task scheduling system and this E-care can be run with the minimal istration.

SCREENS

Related Documents 543cg

E-care Help Desk System Java Project 2z55k
October 2019 69
Manual Help Desk 1 2q503m
December 2019 38
Cuestionario Help Desk 5b1x6b
February 2021 0
Siebel Help Desk 30ro
December 2019 39
Help Desk Presentation.ppt 364y1g
December 2019 33
Politicas Help Desk 5k2nz
September 2020 0

More Documents from "Jayaram Gowda M S" 1se6j

E-care Help Desk System Java Project 2z55k
October 2019 69
5. Calendar Call 6v2m44
October 2022 0
A Seminar On Under Water Windmill-ppt Full _ Mechanical Engineering World _ Project Ideas _ Seminar Topics _ E-books (pdf) _ New Trends.pdf 3471a
January 2022 0
Standard Dwg For Box Cell Culvert 6o3y5p
October 2019 99
10cvl 37 Survey Lab Manual u283
December 2019 30
M3 Vtu Notes v6h2a
November 2019 60