HI..
I want to create an webpage such that when user will enter their username and password,the data will be stored in a database(I am using MySQL).I have the code.But when i am trying to run the servlet,its showing following error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
I have set the classpath of the driver

C:\apache-tomcat-4.1.36\common\lib\servlet.jar;C:\mysql-connector-java-5.0.8\mysql-connector-java-5.0.8-bin.jar
I think its ok as if i run any jdbc program without using servlet, it is working properly.
So i cant understand what to do..
Please help as soon as possible.
This is servlet code:

import java.io.*;
import java.lang.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ServletInsertingDataUsingHtml extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DATABASE_URL = "jdbc:mysql://localhost/sweta_db";

Connection connection;
try{
Class.forName( JDBC_DRIVER );
connection = DriverManager.getConnection( DATABASE_URL, "jhtp6", "jhtp6" );
String username = request.getParameter("username");
String password = request.getParameter("password");
pw.println(username);
pw.println(password);



PreparedStatement pst = connection.prepareStatement("insert into User values(?,?)");
pst.setString(1,username);
pst.setString(2,password);
int i = pst.executeUpdate();
if(i!=0){
pw.println("<br>Record has been inserted");
}
else{
pw.println("failed to insert the data");
}
}
catch (Exception e){
pw.println(e);
}
}
}

You have to set classpath in apache configuration file.

I have set apache servlet.jar file in CLASSPATH alreadi
C:\apache-tomcat-4.1.36\common\lib\servlet.jar in CLASSPATh
but then also code not working
Please tell whats the problem