File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes Servlets with JDBC and MYSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Servlets with JDBC and MYSQL" Watch "Servlets with JDBC and MYSQL" New topic

Servlets with JDBC and MYSQL

ankita balaji

Joined: Aug 19, 2004
Posts: 11
Hai Everyone,
Good Evening.Iam new to servlets and Mysql.Iam using Mysql as my backend and servlets as my frontend for the project of storing a group pf users in a particular company.Can i know if a new user enters into company,he must register in a register page and how does his details get automatically enetered into the database table without using any Web.xml file.Can anyone plz drop me a example in this case.Thank you
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
so how did you plan to map your servlet without web.xml?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33098

Since this question is about web.xml, I am moving it to our Servlets forum.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

"Web.xml" is used with Servlets, you don't have Servlets running unless you have your web.xml file, so you can't have one without the other.

This sounds to me like a classwork assignment.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

ankita balaji

For a new comer to Servlets and JDBC, there is not a simple answer to your question. Nor will posting some random code help you out.

How familiar are you with JDBC right now? How familiar with Servlets? Technically, this is a 2 part question..

1. How do I use Servlets without using the web.xml file
2. How do I insert information from a web page into a MySQL database.

As far as #1 goes, Mark said it best in this thread.

using Tomcat's invoker mapping (no longer a default in Tomcat) you can get to a servlet by /servlet/packagename.classname (Works in Resin too).

It's useful for testing, but I wouldn't want to use it in production use.

For #2 getting information from the submitted form is as simple as doing a request.getParameter("formElementName"). Then it's just a matter of doing a little JDBC. However, JDBC is better suited for the JDBC Forum.

What I would recommend is that you begin by getting your servlets running. If you choose not to use the web.xml file, you'll probably have to hunt down some information on the relivent servlet containers (Tomcat, Resin, etc) documentation to find out exactly how they suggest doing it. After you have some basic Servlet work down and you are comfortable with gathering data from a web form, move on to entering that information in a Database and ask those JDBC specific questions in the JDBC forum.

Hope that helps.

GenRocket - Experts at Building Test Data
sidharth nayak

Joined: Aug 29, 2004
Posts: 6
hi ankita

u should try jdbc for entering the data into the database
use prepared statment clause instead of execute statement
it ll be helpful

try it

Hussam Bamatraf

Joined: Aug 25, 2003
Posts: 14
Go to the following link
to know how to read MySql database using java.

SCJP 90%<br />FileNet Certified Professional: Content Management Developer 92%<br />FileNet Certified Professional: Business Process Management Developer 92%
I agree. Here's the link:
subject: Servlets with JDBC and MYSQL
jQuery in Action, 3rd edition