Online Software Educational Training - IT Tutorials - Online Education Training for Computer Software

Home

JAVA JDBC

A Complex Query

Here is a sample code to execute a complex query

import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
public class check extends HttpServlet
{
        Connection com;
        String str,uid,pwd,stq;
        ResultSet rs;
        Statement st;
        boolean fnd;
public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
{
        try
        {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(ClassNotFoundException e){}
        try
        {
                PrintWriter pw = response.getWriter();
                response.setContentType("text/html");
                com=DriverManager.getConnection("jdbc:odbc:yahoo");
                uid= request.getParameter("txtname");
                pwd= request.getParameter("txtpassword");
                st = com.createStatement();
                stq="select *from userinfo";
                rs = st.executeQuery(stq);
                while(rs.next())
                {
                        if(rs.getString("name").equals(uid))
                        if(rs.getString("password").equals(pwd))
                        {
                                fnd=true;
                                break;
                        }
                        else
                        {
                                fnd=false;
                        }

}
                        if(fnd)
                        {
                                pw.println("<font color=gold><h2> You are Welcome </h2></font>");
                        }
                        else
                        {
                                pw.println("<font color=red><h2> Invalid user name or password </h2></font>");
                        }
                        st.close();
                        com.close();
                        pw.close();
         }
        catch(SQLException se)
        {
                System.out.println(se);
        }
    }
}


Previous		Next