Thanks for telling us about your problem. But what you didn't tell us however, was the error message.
Anyway, make sure you have the driver installed before you can use it. But if you think you have it installed but still not able to run your code, it might help by posting the error message you received. Good luck -- Evans http://www.javawug.org ----- Original Message ----- From: Kiran Kumar To: java-ee-j2ee-programming-with-passion@googlegroups.com ; kiran. b333 Sent: Tuesday, March 17, 2009 5:30 PM Subject: [java ee programming] please tell the solution urgently hi, i have created jsp login page and servlet(with database connection) in netbeans 6.5. in servlet file i specified Class.forname(com.mysql.jdbc.Driver). whenever i click submit button, this servlet has to be executed. but the above command is not executed. unless it executes, i cannot work with database. so please find out the error in it. DUE TO THIS ERROR MY ACADAMIC PROJECT WAS STOPPED.PLEASE HELP ME. THANK U IN ADVANCE JSP FILE <%...@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body><form action="servlet2" method="get" > <center> <label for="name"> user name: </label> <input type="text" value="" name="username"> <br> <label for="PASSWORD"> password: </label> <input type="text" value="" name="password"> <br> <input type="submit" value="submit" > </center> </form> </body> </html> SERVLET import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class servlet2 extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ String str1=request.getParameter("username"); String str2=request.getParameter("password"); PrintWriter pw=response.getWriter(); response.setContentType("text/html"); pw.println("enter try"); try{ pw.println("entered try"); Class.forName("com.mysql.jdbc.Driver"); pw.println("enter for name"); pw.print("url"); String durl="jdbc:mysql://localhost:3306/mydb?"; String userid="root"; String pass="root"; Connection con=DriverManager.getConnection(durl, userid, pass); pw.print("con complete"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from mydb.login;"); pw.println("<html>"); pw.print("<body >"); pw.print("<br>"+"output stopped"+"<br>"); pw.print("<br>"+"user name is "+str1+"<br>"); pw.println("password is"+str2+"<br>"); pw.println("<br>"+"this is servlet output"); pw.print("this is database"); while(rs.next()) { pw.print(rs.getString(1)+"<br>"); pw.print(rs.getString(2)+"<br>"); } pw.println(" </body >"); pw.println("</html>"); } catch(Exception e) { System.out.print("error occured"); } } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //processRequest(request, response); } @Override public String getServletInfo() { return "Short description"; }// </editor-fold> } --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en -~----------~----~----~----~------~----~------~--~---
