• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How i can connect my servlet to mysql database

 
Rashmi Pant
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Will anybody please tell me how i can connect my servlet to mysql database.
i am using jdk1.5,tomcat5 & mysql4.0.18.The installation directory for thes are as:
C:\Program Files\Java\jdk1.5.0_12
C:\Tomcat5.0
C:\mysql\
I am putting all my servlet file inside testpackage,package so the folder sequence is like :
C:\Tomcat5.0\webapps\servlets-examples\WEB-INF\classes\testpackage
i have created student database and it is in C:\mysql\data directory
this database contains a simple table name detail with column like roll,name,address.
Now i want to connect this table with servlet and want to display the data from this table to my browser.
Please tell me where i should place the database,what change i should make in web.xma(if it is required).
For example say if i want to connect displatRecord servlet(means diplayRecord.java, this will be inside testpackage, package) to detail table and want to display the records in browser then what should i do.
I know java connectivity with access database but i do not knoe how this can be done with servlet when i am using a local server.
Thanks to all
Rashmi
 
sudhir nim
Ranch Hand
Posts: 212
Eclipse IDE Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You dont connect servlet to database but use jdbc for database access.
Look at this tutorial Servlet tutorial
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This page shows how to set up Tomcat's internal database connection pool.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic