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