Comment
phani
facing problem in jdbc,
December 6, 2007 at 7:34 PM
December 6, 2007 at 7:34 PM
import java.io.*;
import java.lang.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CheckLogin extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/empdata";
Connection connection=null;
try{
String dusername;
String dpassword;
String username= request.getParameter("username");
String password = request.getParameter("password");
pw.println(username);
pw.println(password);
Class.forName("org.gjt.mm.mysql.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "admin");
Statement st = connection.createStatement();
String vsql1="select username,password from emplogin where username="+username+"and password="+password;
ResultSet rs = st.executeQuery(vsql1);
while(rs.next())
{
dusername = rs.getString("uname");
dpassword = rs.getString("pass");
System.out.println (" database username is=" + dusername);
System.out.println (" database password is=" + dpassword);
System.out.println("Checking userdata with database");
if(username.equals(dusername)&&password.equals(dpassword))
{
RequestDispatcher rd;
rd= getServletContext().getRequestDispatcher("/welcome.jsp");
System.out.print(rd);
rd.forward(request, response);
}
else
{
pw.println("<a href = \"login.jsp\"> BACK </a>");
}
st.close();
connection .close();
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
in the above if the data is matched with the html data the welcome.jsp will be calle....but forward part is not executning....only else part is executing....pls help me..
View All Comments | View Tutorial
Related Tutorial and Articles
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
