addemployee1.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 addemployee1 extends HttpServlet
{

    public addemployee1()
    {}
        public void init(ServletConfig servletconfig)
        throws ServletException
    {
        super.init(servletconfig);
        try
        {
        	//PreparedStatement ps;
            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();
            //PreparedStatement pstm = new PrepareStatement("insert into hdemp1 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" );
           // ps =con.prepareStatement("insert into hdemp1 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)")   
            System.out.println("statement is created");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
    	
    	try{
      /*  String s = "";
        String s2 = "";
        String s4 = "";
        String s6 = "";
        String s8 = "";
        String s10 = "";
        String s12 = "";
        String s14 = "";
        String s16 = "";
        String s18 = "";
        String s20 = "";
        String s22 = "";
        String s24 = "";
        String s26 = "";
        String s28 = "";*/
        java.io.PrintWriter printWriter = httpservletresponse.getWriter();
    	
           httpservletresponse.setContentType("text/html");
            String s1 = httpservletrequest.getParameter("levelname");
           //ps.setString(1,);
             System.out.println("name is " + s1);
            String s17 = httpservletrequest.getParameter("categoryid");
           // ps.setString(2,s17);
            System.out.println("catid is " + s17);
            String s19 = httpservletrequest.getParameter("moduleid");
            System.out.println("modid is " + s19);
            String s11 = httpservletrequest.getParameter("supportid");
            System.out.println("supid is " + s11);
            String s3 = httpservletrequest.getParameter("userid");
            System.out.println("uid is " + s3);
            String s21 = httpservletrequest.getParameter("employeename");
            System.out.println("employeename is " + s21);
            String s5 = httpservletrequest.getParameter("address");
            System.out.println("address is " + s5);
            String s7 = httpservletrequest.getParameter("city");
            System.out.println("city is " + s7);
            String s9 = httpservletrequest.getParameter("state");
            System.out.println("state is " + s9);
            String s13 = httpservletrequest.getParameter("country");
            System.out.println("country is " + s13);
            String s30 = httpservletrequest.getParameter("zipcode");
            int j = Integer.parseInt(s30);
            System.out.println("zipcode is " + j);
            String s31 = httpservletrequest.getParameter("phoneno");
            int i = Integer.parseInt(s31);
           System.out.println("phonenumber is " + i);
            System.out.println("hello");
            String s15 = httpservletrequest.getParameter("email");
            System.out.println("email is " + s15);
            String s23 = httpservletrequest.getParameter("password1");
            System.out.println("password is " + s23);
            String s29 = httpservletrequest.getParameter("password2");
            System.out.println("password is " + s29);
            String s25 = httpservletrequest.getParameter("hintquestion");
            System.out.println("hintqt is " + s25);
            String s27 = httpservletrequest.getParameter("hintsolution");
            System.out.println("hintsol is " + s27);
            System.out.println("Before inserting");

            // int k = st.executeUpdate("insert into hdemp1 values('" +s1+ "','" + s17 + "','" + s19 + "','" + s11 + "','" + s3 + "','" + s21 + "','" + s5 + "','" + s7 + "','" + s9 + "','" + s13 + "','" + j + "','" + i + "','" + s15 + "','" + s23 + "','" + s29 + "','" + s25 + "','" + s27 + "')");
            int k = st.executeUpdate("insert into hdemp1 values('" +s1+ "','" + s17 + "','" + s19 + "','" + s11 + "','" + s3 + "','" + s21 + "','" + s5 + "','" + s7 + "','" + s9 + "','" + s13 + "','" + j + "','" + i + "','" + s15 + "','" + s23 + "','" + s29 + "','" + s25 + "','" + s27 + "')");
           
          /*ps.setString(1,s1);
          ps.setString(1,s17);
          ps.setString(1,s19);
          ps.setString(1,s17);
          ps.setString(1,s17);
          ps.setString(1,s17);
          ps.setString(1,s17);
          ps.setString(1,s17);*/
            System.out.println(k + " One row is inserted");
            httpservletresponse.sendRedirect("./employeeconfirmed.html");
    	}
    	catch(Exception e){e.printStackTrace();}
        
    }
    
Connection con;
Statement st;
    ResultSet rs;
}