xlogin.java

help desk for hospitals/health care systems

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class xlogin extends HttpServlet
{

    public xlogin()
    {
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
        boolean flag = true;
        httpservletresponse.setContentType("text/html");
        PrintWriter printwriter = httpservletresponse.getWriter();
        String s = httpservletrequest.getParameter("logtxt");
        String s1 = httpservletrequest.getParameter("pwd");
        printwriter.println("in the welcome page");
        try
        {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection con=DriverManager.getConnection("jdbc:odbc:ecare","ecare","ecare");

//            Class.forName("oracle.jdbc.driver.OracleDriver");
  //Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","ecare","ecare");
  Statement st=con.createStatement();
            ResultSet resultset;
            for(resultset = st.executeQuery("select * from login"); resultset.next();)
                if(s.equals(resultset.getString(1)) && s1.equals(resultset.getString(2)))
                {
                    System.out.println("authorised user");
                    flag = false;
                }

            if(flag)
                System.out.println("not authorised user");
            resultset.close();
            st.close();
            con.close();
        }
        catch(Exception exception)
        {
            System.out.println("some problem with databse" + exception);
        }
    }
}