File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes Servlet Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Servlet Query" Watch "Servlet Query" New topic
Author

Servlet Query

Monisha Kapur
Greenhorn

Joined: Oct 30, 2005
Posts: 1
hi
I am new to servlets . My first program executed..
but the second one is having problem as all is going right but when the i submit the uid and pwd through the html i get a blank page.it shows nothing

Servlet Code:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;


public class login extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
String uid=req.getParameter("t1");
String pwd=req.getParameter("t2");

PrintWriter out=res.getWriter();

res.setContentType("text/html");

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc dbc:ms","scott","tiger");

PreparedStatement psm=con.prepareStatement("select * from reg where uid1=? and pwd=?");
psm.setString(1,uid);
psm.setString(1,pwd);
ResultSet rs=psm.executeQuery();
if(rs.next())
{
out.println("<html><head><title>WELCOME</title></head>");
out.println("<body><b><i>Hello user "+uid+"</b></i>");
out.println("</body></html>");
}
else res.sendRedirect("http://localhost:8080/login.html");
}
catch(Exception e)
{
e.printStackTrace();}
}
}

plz help me out ...
thanks .
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
I would first verify that the parameters are populated before using them in a query.

String uid=req.getParameter("t1");
String pwd=req.getParameter("t2");

if(your uid and pw fields != null && their length is > 0)
do what ever

Also, thee is a chance that no rows were returned. You need to display something if no rows were found.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12761
    
    5
You should also take the precaution of closing the output stream to force flushing of the contents. A simple out.close() will do the trick.
Bill
Eddy Lee Sin Ti
Ranch Hand

Joined: Oct 06, 2005
Posts: 135
Any stack trace output in the console?


SCJP, SCWCD, SCJWS, IBM 700,IBM 701, IBM 704, IBM 705, CA Clarity Technical<br /> <br /><a href="http://eddyleesinti.blogspot.com" target="_blank" rel="nofollow">http://eddyleesinti.blogspot.com</a>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Servlet Query
 
Similar Threads
500 Servlet Exception
Connection reset by peer:JVM_recv in socket input stream read
servlets using JDBC
Is SSI supported on tomcat
Internal service error..