Servlets with JDBC connection

hi,

I got a problem while making a servlet program. Please help me.

My problem is:

When i am loading mySQL driver in my servlet program, run time error "ClassNotFoundException" is coming. But when i load same driver in my simple program using main() method, it runs successfully.

Please tell me why this problem is coming with servlet program and also give me the solution.

Thanks & Regards,
Madhawi

Include MySQL driver's JAR file in your class path, that's all!!!

Originally posted by Vassili Vladimir:
Include MySQL driver's JAR file in your class path, that's all!!!

Thank you Vassili.
[/LIST]

But After loading the driver i got another problem.

I have created a html file in which two fields login and password has mentioned. when i submit the html file, the servlet page will open, the servlet page will store the login and password in database and after that it will display all content of my login table.

Problem is that, when i submitting my html file it opens a download dialog box, from that box i can open a file or save a file or can cancel the further process. when I select open, I have to choose a file type in which i can see my output, I choosed internet explorer. And it is showing the output of my sevlet file. Can it show directly without open with or save as option?

My Servlet program is as follows:

package first;
 
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
 
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class JdbcExample extends HttpServlet {
 
private static final long serialVersionUID = 1L;
 
Connection con = null;
 
PreparedStatement ps = null;
 
ResultSet rs = null;
 
/**
 * Constructor of the object.
 */
public JdbcExample() {
super();
}
 
/**
 * Destruction of the servlet. 
 */
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
System.out.print("success");
}
 
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("tex/html");
PrintWriter out = response.getWriter();
try 
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager
.getConnection("jdbc:mysql://localhost/jdbc?user=root&password=mad");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");

out.println(" Name     Password ");

ps = con.prepareStatement("Insert into login11 values(?,?)");
ps.setString(1, request.getParameter("login"));
ps.setString(2, request.getParameter("password"));
ps.executeUpdate();

rs = ps.executeQuery("select * from login11");

while (rs.next()) {
out.println(rs.getString(1) + " " + rs.getString(2));
out.print(" ");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
 
} catch (Exception e) {
e.printStackTrace();
out.print(e);
 
}

}
 
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
 
doGet(request, response);
}
 
public void init() throws ServletException {
}
 
}

[BSouther: Added UBB CODE tags]
[ October 13, 2007: Message edited by: Ben Souther ]

You have a typo in the content type; it should be "text/html".

Originally posted by Ulf Dittmer:
You have a typo in the content type; it should be "text/html".

thanks for the help to aware my mistake at content type.