package employmaster;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class EmployeeMastAddDetails extends HttpServlet
    {


        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
        {
            String userId=new String("");
            ResultSet rs = null;
            Connection conn = null;
            RequestDispatcher rd=null;

            try 
                {


                response.setContentType("text/html");
                PrintWriter out=response.getWriter();
                String user_id=request.getParameter("empID");
                String user_name=request.getParameter("empName");
                String user_dob=request.getParameter("empDob");
                String user_gender=request.getParameter("empGender");
                String user_designationCode=request.getParameter("empDesignationCode");
                String user_CdacId=request.getParameter("empCdacId");
                String user_deptId=request.getParameter("empdeptId");
                String user_CdacEmailId=request.getParameter("empCdacEmailId");
                String user_otheremailId=request.getParameter("empotherEmailId");
                String user_contactNo=request.getParameter("empContactNo");
                String user_emergencyNo=request.getParameter("empEmergencyNo");
                String user_localAdd=request.getParameter("empLocalAddress");
                String user_Permanentadd=request.getParameter("empPermanentAddress");
                String user_Qualification=request.getParameter("empQulification");
                String user_Anniversary=request.getParameter("empAnniversaryDate");
                String user_JoiningDate=request.getParameter("empJoiningDate");
                String user_RelievingDate=request.getParameter("empRelievingdate");
                String user_IpAdd=request.getParameter("empIpAddress");
                String user_SystemDetail=request.getParameter("empSystemDetails");
                String user_IsActive=request.getParameter("empIsActive");
                String user_UserType=request.getParameter("empUserType");
                String user_password=request.getParameter("empPassword");


            String sql1="select PMSNUM_EMP_ID from PMST_EMP_MST where PMSNUM_EMP_ID="+user_id;
            conn=EmployeeMastConnection.getConnection();
            Statement st=conn.createStatement();
            st.executeQuery(sql1);
            rs = st.getResultSet();
              while (rs.next ()){
              userId=rs.getString("PMSNUM_EMP_ID");

              }

              if(userId.equals(user_id))
              {
                  out.println("Emp_Id is already exist");
                  rd=request.getRequestDispatcher("/employmaster/EmployeeMstAdd.jsp");


              }

              else
              {


                  int id=Integer.parseInt(userId);
                  if(rs.last()){
                  id=id+1;
                  userId=new Integer(id).toString();
                  }
                  String sql=" Insert into PMST_EMP_MST(PMSNUM_EMP_ID,PMSSTR_EMP_NAME,PMSDT_DOB_DATE,PMSSTR_GENDER,PMSNUM_DESIGNATION_CODE," +
                    "PMSNUM_CDAC_EMPID,PMSNUM_DEPARTMENT_ID,PMSSTR_CDAC_EMAILID,PMSSTR_OTHER_EMAILID,PMSNUM_CONTACTNO," +
                    "PMS_EMERGENCY_CONTACTNO,PMSSTR_LOCAL_ADDRESS,PMSSTR_PERMANENT_ADDRESS,PMSSTR_QUALIFICATION," +
                    "PMSDT_ANNIVERSARY_DATE,PMSDT_JOINING_DATE,PMSNUM_RELIEVE_DATE,PMSSTR_IP_ADDRESS," +
                    "PMSSTR_SYSTEM_DETAIL,PMSNUM_IS_ACTIVE,PMSNUM_USER_TYPE,PMSSTR_PASSWORD) " 
                    + " VALUES("+id+",'"+user_name+"',to_date('"+user_dob+"','dd-mm-yyyy'),'"+user_gender+
                    "',"+user_designationCode+","+user_CdacId+","+user_deptId+",'"+user_CdacEmailId +
                    "','"+user_otheremailId+"',"+user_contactNo+","+user_emergencyNo+",'"+user_localAdd +
                    "','"+user_Permanentadd+"','"+user_Qualification+"',to_date('"+user_Anniversary+"','dd-mm-yyyy'),to_date('"+user_JoiningDate+
                    "','dd-mm-yyyy'),to_date('"+user_RelievingDate+"','dd-mm-yyyy'),'"+user_IpAdd+"','"+user_SystemDetail+
                    "',"+user_IsActive+","+user_UserType+",'"+user_password+"')";

        System.out.print(sql);

            st.execute(sql);
            out.println("'"+user_name+"'" + "Data Inserted Successfully");

              }



            rs.close();
            st.close();
            conn.close();
              }

            catch (Exception e) {
                e.printStackTrace();
                try {
                    conn.rollback();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }finally{
                try {
                    conn.close();
                } catch (SQLException e) {

                    e.printStackTrace();
                }
            }
            }
}

IS THIS CODE IS CORRECT FOR GENERATING NEW USER ID PLZ REPLY