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
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