Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Servlets with JDBC and MYSQL

 
ankita balaji
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
so how did you plan to map your servlet without web.xml?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ankita,
Since this question is about web.xml, I am moving it to our Servlets forum.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.

Mark
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
sidharth nayak
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Go to the following link http://www.javaranch.com/drive/jdbc/index.jsp
to know how to read MySql database using java.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic