Updating and retrieving data from java servlet to sql database


The page should process the submission, and you should see your comments appear in the table.Check the database table using the table editor; you should find that the comments have been saved there.Creating database-driven web applications in Java has traditionally involved a steep learning curve.Even if you already know how to write Java programs, and have a basic understanding of web applications, the Java Enterprise Edition (Java EE) stack is daunting.In this article, I will demonstrate how the combination of Eclipse Web Tools Platform, Eclipse Data Tools Platform, Tomcat, and Derby help to "lower the bar" by virtually eliminating the server administration issues, allowing developers to focus on the task at hand: building the web application.

You will need the following software to build the project: If you're using an application server other than Tomcat 6.0, and you don't know how to configure a Data Source, you can embed the connection attributes directly in the JSP page.

You won't get connection pooling, but you can at least get the sample working by replacing line with the following lines: After entering this code, save the changes. You should see a form appear: Try entering some comments and clicking Submit.

When you are ready to deploy the application to a production Tomcat application server, you must copy the Derby database data folders to the application server computer.

You then have a couple of options for accessing the Derby database from your deployed application.


The Eclipse Web Tools and Data Tools Projects deliver a feature-rich environment for developing Java EE database-driven web applications.This tutorial walks you through the process of creating a simple database web application using Eclipse WTP/DTP, Tomcat, and the Derby database engine.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>