reg1.java

help desk for hospitals/health care systems

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

public class reg1 extends HttpServlet
{

    public reg1()
    {
    }

    public void init(ServletConfig servletconfig)
        throws ServletException
    {
        super.init(servletconfig);
        try
        {
            System.out.println("inside try");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ecare","ecare","ecare");

//Class.forName("oracle.jdbc.driver.OracleDriver");
  // con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:project","ecare","ecare");
   st=con.createStatement();
            System.out.println("statement is created");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
        String s9 = "";
        String s16 = "";
        java.io.PrintWriter printwriter = httpservletresponse.getWriter();
        HttpSession httpsession = httpservletrequest.getSession(true);
        httpservletresponse.setContentType("text/html");
        try
        {
            String s = httpservletrequest.getParameter("fname");
            System.out.println("first name is " + s);
            String s1 = httpservletrequest.getParameter("lname");
            System.out.println("lname is" + s1);
            String s2 = httpservletrequest.getParameter("address");
            System.out.println("address is " + s2);
            String s17 = httpservletrequest.getParameter("phno");
            int i = Integer.parseInt(s17);
            System.out.println("phno is" + i);
            String s3 = httpservletrequest.getParameter("city");
            System.out.println("city is " + s3);
            String s4 = httpservletrequest.getParameter("state");
            System.out.println("state is " + s4);
            String s5 = httpservletrequest.getParameter("country");
            System.out.println("country is " + s5);
            String s6 = httpservletrequest.getParameter("gender");
            System.out.println("gender is " + s6);
            String s18 = httpservletrequest.getParameter("zipcode");
            int j = Integer.parseInt(s18);
            System.out.println("zipcode is" + j);
            String s7 = httpservletrequest.getParameter("email_id");
            System.out.println("emailid is " + s7);
            String s8 = httpservletrequest.getParameter("ctype");
            System.out.println("corptype is" + s8);
            if(s8.equalsIgnoreCase("corpuser"))
            {
                System.out.println("inside if");
                String s10 = httpservletrequest.getParameter("user_id");
                System.out.println("uuuuuuserid is " + s10);
                s16 = "CU" + s10;
                System.out.println("cat is " + s16);
            } else
            if(s8.equalsIgnoreCase("corpclient"))
            {
                String s11 = httpservletrequest.getParameter("user_id");
                System.out.println("userid is " + s11);
                s16 = "CC" + s11;
                System.out.println("cat is " + s16);
                httpsession.setAttribute("uid", s16);
            }
            String s12 = httpservletrequest.getParameter("password");
            System.out.println("password is " + s12);
            String s15 = httpservletrequest.getParameter("confpwd");
            System.out.println("password is " + s15);
            String s13 = httpservletrequest.getParameter("hintquestion");
            System.out.println("hintqt is " + s13);
            String s14 = httpservletrequest.getParameter("hintsolution");
            System.out.println("hintsol is " + s14);
            System.out.println("Before inserting");
            
            int k = st.executeUpdate("insert into registration values('" + s + "','" + s1 + "','" + s2 + "'," + i + ",'" + s4 + "','" + s3 + "','" + s5 + "','" + s6 + "'," + j + ",'" + s7 + "','" + s8 + "','" + s16 + "','" + s12 + "','" + s15 + "','" + s13 + "','" + s14 + "')");
            System.out.println(k + " One row is inserted");
            System.out.println("After query");
            if(s8.equals("corpclient"))
                httpservletresponse.sendRedirect("./addcompanyinfo.html");
            else
                httpservletresponse.sendRedirect("./elogin.html");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }
Connection con;
Statement st;

    ResultSet rs;
}