Welcome!

Weblogic Authors: Yeshim Deniz, Elizabeth White, Michael Meiner, Michael Bushong, Avi Rosenthal

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
SYS-CON Events announced today that Avere Systems, a leading provider of hybrid cloud enablement solutions, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere Systems was created by file systems experts determined to reinvent storage by changing the way enterprises thought about and bought storage resources. With decades of experience behind the company’s founders, Avere got its ...
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, will discuss how by using...
In this strange new world where more and more power is drawn from business technology, companies are effectively straddling two paths on the road to innovation and transformation into digital enterprises. The first path is the heritage trail – with “legacy” technology forming the background. Here, extant technologies are transformed by core IT teams to provide more API-driven approaches. Legacy systems can restrict companies that are transitioning into digital enterprises. To truly become a lead...
SYS-CON Events announced today that CAST Software will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CAST was founded more than 25 years ago to make the invisible visible. Built around the idea that even the best analytics on the market still leave blind spots for technical teams looking to deliver better software and prevent outages, CAST provides the software intelligence that matter ...
SYS-CON Events announced today that Daiya Industry will exhibit at the Japanese Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Ruby Development Inc. builds new services in short period of time and provides a continuous support of those services based on Ruby on Rails. For more information, please visit https://github.com/RubyDevInc.
As businesses evolve, they need technology that is simple to help them succeed today and flexible enough to help them build for tomorrow. Chrome is fit for the workplace of the future — providing a secure, consistent user experience across a range of devices that can be used anywhere. In her session at 21st Cloud Expo, Vidya Nagarajan, a Senior Product Manager at Google, will take a look at various options as to how ChromeOS can be leveraged to interact with people on the devices, and formats th...
SYS-CON Events announced today that Yuasa System will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Yuasa System is introducing a multi-purpose endurance testing system for flexible displays, OLED devices, flexible substrates, flat cables, and films in smartphones, wearables, automobiles, and healthcare.
SYS-CON Events announced today that Taica will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Taica manufacturers Alpha-GEL brand silicone components and materials, which maintain outstanding performance over a wide temperature range -40C to +200C. For more information, visit http://www.taica.co.jp/english/.
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities – ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups. As a result, many firms employ new business models that place enormous impor...
SYS-CON Events announced today that SourceForge has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. SourceForge is the largest, most trusted destination for Open Source Software development, collaboration, discovery and download on the web serving over 32 million viewers, 150 million downloads and over 460,000 active development projects each and every month.
SYS-CON Events announced today that Dasher Technologies will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Dasher Technologies, Inc. ® is a premier IT solution provider that delivers expert technical resources along with trusted account executives to architect and deliver complete IT solutions and services to help our clients execute their goals, plans and objectives. Since 1999, we'v...
As popularity of the smart home is growing and continues to go mainstream, technological factors play a greater role. The IoT protocol houses the interoperability battery consumption, security, and configuration of a smart home device, and it can be difficult for companies to choose the right kind for their product. For both DIY and professionally installed smart homes, developers need to consider each of these elements for their product to be successful in the market and current smart homes.
SYS-CON Events announced today that MIRAI Inc. will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MIRAI Inc. are IT consultants from the public sector whose mission is to solve social issues by technology and innovation and to create a meaningful future for people.
SYS-CON Events announced today that Massive Networks, that helps your business operate seamlessly with fast, reliable, and secure internet and network solutions, has been named "Exhibitor" of SYS-CON's 21st International Cloud Expo ®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. As a premier telecommunications provider, Massive Networks is headquartered out of Louisville, Colorado. With years of experience under their belt, their team of...
SYS-CON Events announced today that TidalScale, a leading provider of systems and services, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. TidalScale has been involved in shaping the computing landscape. They've designed, developed and deployed some of the most important and successful systems and services in the history of the computing industry - internet, Ethernet, operating s...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicate or sell. In their Day 3 Keynote at 21st Cloud Expo, Greg Chambers, Global Group Director, Digital Innovation, Coca-Cola, and Vidya Nagarajan, a Senior Product Manager at Google, will discuss how from store operations...
In a recent survey, Sumo Logic surveyed 1,500 customers who employ cloud services such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). According to the survey, a quarter of the respondents have already deployed Docker containers and nearly as many (23 percent) are employing the AWS Lambda serverless computing framework. It’s clear: serverless is here to stay. The adoption does come with some needed changes, within both application development and operations. Tha...
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, will lead you through the exciting evolution of the cloud. He'll look at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering ...