• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Servlets with JDBC and MYSQL

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
so how did you plan to map your servlet without web.xml?
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ankita,
Since this question is about web.xml, I am moving it to our Servlets forum.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic