Welcome!

Eclipse Authors: Lacey Thoms, Carmen Gonzalez, Liz McMillan, Ken Fogel, Jayaram Krishnaswamy

Related Topics: Eclipse

Eclipse: Article

Creating Web Applications with the Eclipse Web Tools Project

Using open source to develop Web applications, EJBs, and Web services

The Web Tools Project (WTP) by the Eclipse Foundation is a set of open source tools that substantially reduce the time required for the development of Web applications, EJBs, and Web services. The WTP's current version is 0.7.1 and version 1.0 is coming later this year. The framework provides wizards and tools to create EJBs, Web components such as servlets and JSPs, and Web services using the Axis engine. It also provides source editors for HTML, JavaScript, CSS, JSP, SQL, XML, DTD, XSD, and WSDL; graphical editors for XSD, WSDL, J2EE project builders, models, and a J2EE navigator; a Web service wizard, explorer, and WS-I Test Tools; and database access, query tools, and models.

In this article I'll show you how to develop and deploy a JSP Web application with WTP in less than an hour. I'll also cover the creation and deployment of a basic servlet and editing JSP with WTP. Let's develop the WTP application together but, first, we need to install the following software:

  1. J2SE 5.0 JRE: http://java.sun.com/j2se
  2. Eclipse 3.1: www.eclipse.org
  3. WTP 0.7.1: www.eclipse.org/webtools
  4. Tomcat 5.0: http://jakarta.apache.org/tomcat/
  5. MySQL 4.0.25: www.mysql.com
  6. MySQL Connector/J Driver 3.1: www.mysql.com/products/connector/j/

Application Overview
Our application will be a basic Web application implementing the following use cases:

  • Customers need to register on the site to place orders.
  • Customers can place orders.
  • Customers can view their orders.
  • Admin can list all registered customers.

The system will be implemented using a servlet programming model and MySQL database.

Configuring MySQL Database and the Data Source
By default, when MySQL gets installed, a TEST database is available. Be sure to launch C:\Mysql\winmysqladmin.exe to specify the user name and password (the first time you launch it, it lets you do it and also starts the database server). It's necessary to copy MySQL Connector/J JDBC Driver: mysql-connector-java-3.1.10-bin.jar to the Tomcat/common/lib directory, so the Tomcat server can recognize it.

To configure MySQL database access in Tomcat, we have to add a separate file called Listing 1: DBTest.xml; the file follows a convention of "application_name.xml" under $TOMCAT\conf\catalina\localhost directory. The only problem with this file is that it may get deleted when the application is undeployed, so if you undeploy and redeploy the application, you have to place this file into the same folder again (so it's a good idea to save it somewhere else). Looking inside the DBTest.xml file, please note that in our case we are using "ODBC" for the username and don't provide any password.

Building Our Web Application Using Web Tools and a Database
Before we can start working on the Web project, we must configure Tomcat 5.0 in Eclipse to be our default server. When Web Tools are installed in Eclipse, new perspectives and options are added, such as a J2EE perspective where you can create J2EE projects, Web projects, and Web services. New options are available under the Window-Preferences menu for configuring Tomcat servers with Eclipse. Go to Window - Preferences menu, under Server select - Installed Runtimes, click Add, and then specify Tomcat 5.0 server with the installed JRE and a path to the Tomcat installation directory (see Figure 1). Now create a Dynamic Web Project using the Web Tools wizard by selecting File-New-Other, then expanding Web-Dynamic Web Project.

We'll name the project DBTest, which will also become its context root. The Web module will be targeted to our default server: Tomcat. Click Finish and the DBTest Web project gets created. This project will contain all of our Web resources, such as HTML and JSP files, and servlets, and you'll be able to export it into a standard WAR file later, if needed.

Creating Supporting Domain Classes and Tables
Before creating servlets, let's create supporting classes to represent a customer and an order. The class diagram in Figure 2 depicts the Customer and Order relationship.

Note that when creating Customer and Order classes, we define corresponding fields as their public instance variables and then can automatically generate getters and setters from those fields. This can be easily done by going to Outline view (appears after you double-click on an existing class name or create a new class), selecting a class, and selecting "Source - Generate Getters and Setters..." from the right-button menu (see Figure 3).

Along with the classes, we'd have to create corresponding database tables in a MySQL database:


CREATE TABLE CUSTOMER (
ID INT PRIMARY KEY,
FIRST_NAME VARCHAR(50),
LAST_NAME VARCHAR(50),
ADDRESS VARCHAR(150));

CREATE TABLE ORDERS (
ID INT PRIMARY KEY,
CUST_ID INT REFERENCES CUSTOMER,
DATE_PLACED DATE,
AMOUNT INT);

Creating Database Command Classes
We'll create a special package with classes that implement a Command design pattern to perform necessary database updates. The Command pattern allows the classes to implement the common interface executing some particular command. Examples of the Command pattern in Java would be classes that implement the ActionListener interface with the actionPerformed() method. Our Command pattern interface for database integration is presented in Listing 2.

Classes implementing this command will be performing the actual database operations for reading and inserting rows into customer and order tables. The following use cases will be addressed:

  • Customers want to register on the site in order to place orders (a new row is created in the customer table)
  • Customers can place the order (the order gets created in the database for a particular customer)
  • Customers can view the orders they have placed
  • Admin can list all the customers

Based on these use cases, the following classes have implemented the DatabaseCommand interface (see Listings 3-6):

public class CreateCustomer implements DatabaseCommand
public class CreateOrder implements DatabaseCommand
public class ListCustomers implements DatabaseCommand
public class ListCustomerOrders implements DatabaseCommand

Finally, in order to execute our command classes, we will need to create a class that would access the database datasource, obtain a SQL connection, and then execute a particular database command. This class will implement a Singleton design pattern, which we'll call CommandExecutor:

Object o = CommandExecutor.getInstance().executeDatabaseCommand
(<<instance of the particular database command class goes here>>).

The CommandExecutor class will perform the datasource lookup as follows:

InitialContext ctx = new InitialContext();
Context envCtx = (Context) ctx.lookup("java:comp/env");
ds = (DataSource) envCtx.lookup("jdbc/TestDB");

This finds the reference to the data-source we have defined in DBTest.xml by resolving its reference in a Web deployment descriptor (web.xml), which we'll define in a section below. Listing 7 has the complete code of the Command Executor class.

More Stories By Boris Minkin

Boris Minkin is a Senior Technical Architect of a major financial corporation. He has more than 15 years of experience working in various areas of information technology and financial services. Boris is currently pursuing his Masters degree at Stevens Institute of Technology, New Jersey. His professional interests are in the Internet technology, service-oriented architecture, enterprise application architecture, multi-platform distributed applications, and relational database design. You can contact Boris at [email protected]

Comments (15) View Comments

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


Most Recent Comments
Mintara 12/26/07 04:11:21 PM EST

Hello Sir,
Could you please elaborate (for e.g the classes ..I could not find the source code)what you have explained.
Thank you.

Serge Cambour 09/25/07 06:38:15 AM EDT

It would be really a very good article or a tutorial if the author had tested it himself before posting it. I don't even talk of missing details, classes, code mistakes, ets. that make you loose any wish to continue.

Keith Freeman 07/15/06 10:32:01 PM EDT

Well, this seems like a fantastic tutorial, until suddenly the "CreateCustomerServlet" description morphs into a "ListCustomersServlet". We're left to figure out how to finish the servlets ourselves (still in progress for me), since as others point out here a bunch of code is missing from the zip file download. VERY disappointing after such a strong start.

David Paules 05/24/06 04:04:22 PM EDT

Good introduction article. Unfortunately, it's not clear where the database connection file DBTest.xml should reside when running Tomcat under Eclipse. Where does this file or it's content go in the Dynamic Web project tree? Because of this, I get an error message at debug time:

javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'

Chuck Ferrick 05/20/06 09:24:58 PM EDT

I was very interesting article, but most of the listings where not posted. I was hoping to gain some insight on how you configure Hibernate. Your article stated to look at listing 9, but listing 9 was know where to be found. I was also frustrated when I could not find the DBTest.war file on java.sys-con web site.

Good furture article and maybe next time JDJ will include all of the necesasry file listings.

Achille Komla 02/05/06 10:57:41 PM EST

Very well done. It will be good to see how the application works with hibernate.

Daniel Hillebrand 12/15/05 04:35:56 AM EST

Hi Boris,

thank you for your great tutorial! Maybe you could add a note to your article regarding running Tomcat in eclipse:

You have to put the content of DBTest.xml in the (new) file context.xml in "WebContent/META-INF". The path strings are not needed, except the "path" string.

regards, Daniel

Bill Gercken 12/09/05 09:02:38 AM EST

Soource code: For those who did not find it: the link to the source is at the top of listing 1. View link: http://res.sys-con.com/story/nov05/152270/source.html

km 12/07/05 03:41:46 PM EST

could you provide the link for the source code

Paul Mischler 12/05/05 04:39:16 PM EST

Did anyone notice that listings 3-10 aren't included in the dead-tree edition?

Corrections to the article:

For the code to work "out of the box", the Customer and Order classes need to be created in a package called "domain"

Figure 2 shows "cust_id" as a member of the Order class. However, the image of Figure 3 (and the CreateOrder class sample code) utilize "custId".

A helpful reminder that a user with permissions to access the database tables would have been helpful.

CS Cassell 12/02/05 10:01:30 AM EST

Several of the links are broken. This could be a really good article but ones needs the various links to work correctly.

José D´Andrade 12/01/05 09:11:56 AM EST

Please, think Linux. Think about Linux users when writing articles about developing whatever using:

Eclipse
Apache
Tomcat
MySQL

It is confusing to read about things that perhaps only apply to MS Windows (¨be sure to launch C:\Mysql\winmysqladmin.exe ¨) when the tools are mostly used by Linux people. And, this is not religion.

At least, write referencing both OSs.

José D´Andrade 12/01/05 09:10:40 AM EST

Please, think Linux. Think about Linux users when writing articles about developing whatever using:

Eclipse
Apache
Tomcat
MySQL

It is confusing to read about things that perhaps only apply to MS Windows (¨be sure to launch C:\Mysql\winmysqladmin.exe ¨) when the tools are mostly used by Linux people. And, this is not religion.

At least, write referencing both OSs.

Bill Dornbush 11/29/05 03:16:26 PM EST

Where is the source code for the article? I can't find any for this issue of the magazine at java.sys-con.com

@ThingsExpo Stories
Software AG helps organizations transform into Digital Enterprises, so they can differentiate from competitors and better engage customers, partners and employees. Using the Software AG Suite, companies can close the gap between business and IT to create digital systems of differentiation that drive front-line agility. We offer four on-ramps to the Digital Enterprise: alignment through collaborative process analysis; transformation through portfolio management; agility through process automation and integration; and visibility through intelligent business operations and big data.
There will be 50 billion Internet connected devices by 2020. Today, every manufacturer has a propriety protocol and an app. How do we securely integrate these "things" into our lives and businesses in a way that we can easily control and manage? Even better, how do we integrate these "things" so that they control and manage each other so our lives become more convenient or our businesses become more profitable and/or safe? We have heard that the best interface is no interface. In his session at Internet of @ThingsExpo, Chris Matthieu, Co-Founder & CTO at Octoblu, Inc., will discuss how these devices generate enough data to learn our behaviors and simplify/improve our lives. What if we could connect everything to everything? I'm not only talking about connecting things to things but also systems, cloud services, and people. Add in a little machine learning and artificial intelligence and now we have something interesting...
Last week, while in San Francisco, I used the Uber app and service four times. All four experiences were great, although one of the drivers stopped for 30 seconds and then left as I was walking up to the car. He must have realized I was a blogger. None the less, the next car was just a minute away and I suffered no pain. In this article, my colleague, Ved Sen, Global Head, Advisory Services Social, Mobile and Sensors at Cognizant shares his experiences and insights.
We are reaching the end of the beginning with WebRTC and real systems using this technology have begun to appear. One challenge that faces every WebRTC deployment (in some form or another) is identity management. For example, if you have an existing service – possibly built on a variety of different PaaS/SaaS offerings – and you want to add real-time communications you are faced with a challenge relating to user management, authentication, authorization, and validation. Service providers will want to use their existing identities, but these will have credentials already that are (hopefully) irreversibly encoded. In his session at Internet of @ThingsExpo, Peter Dunkley, Technical Director at Acision, will look at how this identity problem can be solved and discuss ways to use existing web identities for real-time communication.
Can call centers hang up the phones for good? Intuitive Solutions did. WebRTC enabled this contact center provider to eliminate antiquated telephony and desktop phone infrastructure with a pure web-based solution, allowing them to expand beyond brick-and-mortar confines to a home-based agent model. It also ensured scalability and better service for customers, including MUY! Companies, one of the country's largest franchise restaurant companies with 232 Pizza Hut locations. This is one example of WebRTC adoption today, but the potential is limitless when powered by IoT. Attendees will learn real-world benefits of WebRTC and explore future possibilities, as WebRTC and IoT intersect to improve customer service.
From telemedicine to smart cars, digital homes and industrial monitoring, the explosive growth of IoT has created exciting new business opportunities for real time calls and messaging. In his session at Internet of @ThingsExpo, Ivelin Ivanov, CEO and Co-Founder of Telestax, will share some of the new revenue sources that IoT created for Restcomm – the open source telephony platform from Telestax. Ivelin Ivanov is a technology entrepreneur who founded Mobicents, an Open Source VoIP Platform, to help create, deploy, and manage applications integrating voice, video and data. He is the co-founder of TeleStax, an Open Source Cloud Communications company that helps the shift from legacy IN/SS7 telco networks to IP-based cloud comms. An early investor in multiple start-ups, he still finds time to code for his companies and contribute to open source projects.
The Internet of Things (IoT) promises to create new business models as significant as those that were inspired by the Internet and the smartphone 20 and 10 years ago. What business, social and practical implications will this phenomenon bring? That's the subject of "Monetizing the Internet of Things: Perspectives from the Front Lines," an e-book released today and available free of charge from Aria Systems, the leading innovator in recurring revenue management.
The Internet of Things will put IT to its ultimate test by creating infinite new opportunities to digitize products and services, generate and analyze new data to improve customer satisfaction, and discover new ways to gain a competitive advantage across nearly every industry. In order to help corporate business units to capitalize on the rapidly evolving IoT opportunities, IT must stand up to a new set of challenges.
There’s Big Data, then there’s really Big Data from the Internet of Things. IoT is evolving to include many data possibilities like new types of event, log and network data. The volumes are enormous, generating tens of billions of logs per day, which raise data challenges. Early IoT deployments are relying heavily on both the cloud and managed service providers to navigate these challenges. In her session at 6th Big Data Expo®, Hannah Smalltree, Director at Treasure Data, to discuss how IoT, Big Data and deployments are processing massive data volumes from wearables, utilities and other machines.
All major researchers estimate there will be tens of billions devices – computers, smartphones, tablets, and sensors – connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades. With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo in Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be!
P2P RTC will impact the landscape of communications, shifting from traditional telephony style communications models to OTT (Over-The-Top) cloud assisted & PaaS (Platform as a Service) communication services. The P2P shift will impact many areas of our lives, from mobile communication, human interactive web services, RTC and telephony infrastructure, user federation, security and privacy implications, business costs, and scalability. In his session at Internet of @ThingsExpo, Erik Lagerway, Co-founder of Hookflash, will walk through the shifting landscape of traditional telephone and voice services to the modern P2P RTC era of OTT cloud assisted services.
While great strides have been made relative to the video aspects of remote collaboration, audio technology has basically stagnated. Typically all audio is mixed to a single monaural stream and emanates from a single point, such as a speakerphone or a speaker associated with a video monitor. This leads to confusion and lack of understanding among participants especially regarding who is actually speaking. Spatial teleconferencing introduces the concept of acoustic spatial separation between conference participants in three dimensional space. This has been shown to significantly improve comprehension and conference efficiency.
The Internet of Things is tied together with a thin strand that is known as time. Coincidentally, at the core of nearly all data analytics is a timestamp. When working with time series data there are a few core principles that everyone should consider, especially across datasets where time is the common boundary. In his session at Internet of @ThingsExpo, Jim Scott, Director of Enterprise Strategy & Architecture at MapR Technologies, will discuss single-value, geo-spatial, and log time series data. By focusing on enterprise applications and the data center, he will use OpenTSDB as an example to explain some of these concepts including when to use different storage models.
SYS-CON Events announced today that Gridstore™, the leader in software-defined storage (SDS) purpose-built for Windows Servers and Hyper-V, will exhibit at SYS-CON's 15th International Cloud Expo®, which will take place on November 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA. Gridstore™ is the leader in software-defined storage purpose built for virtualization that is designed to accelerate applications in virtualized environments. Using its patented Server-Side Virtual Controller™ Technology (SVCT) to eliminate the I/O blender effect and accelerate applications Gridstore delivers vmOptimized™ Storage that self-optimizes to each application or VM across both virtual and physical environments. Leveraging a grid architecture, Gridstore delivers the first end-to-end storage QoS to ensure the most important App or VM performance is never compromised. The storage grid, that uses Gridstore’s performance optimized nodes or capacity optimized nodes, starts with as few a...
The Transparent Cloud-computing Consortium (abbreviation: T-Cloud Consortium) will conduct research activities into changes in the computing model as a result of collaboration between "device" and "cloud" and the creation of new value and markets through organic data processing High speed and high quality networks, and dramatic improvements in computer processing capabilities, have greatly changed the nature of applications and made the storing and processing of data on the network commonplace. These technological reforms have not only changed computers and smartphones, but are also changing the data processing model for all information devices. In particular, in the area known as M2M (Machine-To-Machine), there are great expectations that information with a new type of value can be produced using a variety of devices and sensors saving/sharing data via the network and through large-scale cloud-type data processing. This consortium believes that attaching a huge number of devic...
Innodisk is a service-driven provider of industrial embedded flash and DRAM storage products and technologies, with a focus on the enterprise, industrial, aerospace, and defense industries. Innodisk is dedicated to serving their customers and business partners. Quality is vitally important when it comes to industrial embedded flash and DRAM storage products. That’s why Innodisk manufactures all of their products in their own purpose-built memory production facility. In fact, they designed and built their production center to maximize manufacturing efficiency and guarantee the highest quality of our products.
All major researchers estimate there will be tens of billions devices - computers, smartphones, tablets, and sensors - connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades. Over the summer Gartner released its much anticipated annual Hype Cycle report and the big news is that Internet of Things has now replaced Big Data as the most hyped technology. Indeed, we're hearing more and more about this fascinating new technological paradigm. Every other IT news item seems to be about IoT and its implications on the future of digital business.
Can call centers hang up the phones for good? Intuitive Solutions did. WebRTC enabled this contact center provider to eliminate antiquated telephony and desktop phone infrastructure with a pure web-based solution, allowing them to expand beyond brick-and-mortar confines to a home-based agent model. Download Slide Deck: ▸ Here
BSQUARE is a global leader of embedded software solutions. We enable smart connected systems at the device level and beyond that millions use every day and provide actionable data solutions for the growing Internet of Things (IoT) market. We empower our world-class customers with our products, services and solutions to achieve innovation and success. For more information, visit www.bsquare.com.
With the iCloud scandal seemingly in its past, Apple announced new iPhones, updates to iPad and MacBook as well as news on OSX Yosemite. Although consumers will have to wait to get their hands on some of that new stuff, what they can get is the latest release of iOS 8 that Apple made available for most in-market iPhones and iPads. Originally announced at WWDC (Apple’s annual developers conference) in June, iOS 8 seems to spearhead Apple’s newfound focus upon greater integration of their products into everyday tasks, cross-platform mobility and self-monitoring. Before you update your device, here is a look at some of the new features and things you may want to consider from a mobile security perspective.