<%@ page language="Java" import="java.io.*,java.sql.*,StrChk.Str,java.util.*"%> <%! java.sql.ResultSet resultset,rs,rs4,rs5; java.sql.Connection con; java.sql.Statement statement; String inDate = null; %> Directory of Jobs Available <% try{ con=dbcon.getConnection(); statement=con.createStatement(); Str str = new Str(); String user = null; String password = null; String s = request.getParameter("jobAvaUserName"); s = str.retString(s); String s1 = request.getParameter("jobAvaPassword"); s1 = str.retString(s1); String s2 = request.getParameter("jobAvaTypeOfJob"); s2 = str.retString(s2); String s3 = request.getParameter("jobAvaCompName"); s3 = str.retString(s3); String s4 = request.getParameter("jobAvaBranch"); if(s4.equals(null) || s4.equals("")) s4 = "null"; s4 = str.retString(s4); String s5 = request.getParameter("jobAvaEmail"); s5 = str.retString(s5); String s6 = request.getParameter("jobAvaWebSite"); if(s6.equals(null) || s6.equals("")) s6 = "null"; s6 = str.retString(s6); String s7 = request.getParameter("jobAvaPhoneNo"); s7 = str.retString(s7); String s8 = request.getParameter("jobAvaFaxNo"); if(s8.equals(null) || s8.equals("")) s8 = "null"; s8 = str.retString(s8); String s9 = request.getParameter("jobAvaAddress"); s9 = str.retString(s9); String s10 = request.getParameter("jobAvaCity"); s10 = str.retString(s10); String s11 = request.getParameter("jobAvaState"); s11 = str.retString(s11); String s12 = request.getParameter("jobAvaCountry"); String s13 = request.getParameter("jobAvaZipCode"); s13 = str.retString(s13); String s14 = request.getParameter("jobAvaDesc"); s14 = str.retString(s14); resultset = statement.executeQuery("select date_format(now(),'%d-%m-%Y')AS Date"); if(resultset.next()) inDate = resultset.getString("Date"); resultset.close(); String s15 = "select usrname from usermast where usrname like '" + s + "'"; resultset = statement.executeQuery(s15); if(resultset.next()) user = resultset.getString("usrname"); resultset.close(); String s16 = "select count(*) from jobprovide where usrname like '" + s + "' and typeofjob like '" + s2 + "'"; resultset = statement.executeQuery(s16); int i = 0; resultset.next(); i = Integer.parseInt(resultset.getString(1)); resultset.close(); if(!s.equals(user) && !s1.equals(password)) { out.println("New Jobs Available Registration"); out.println(""); %> <%@ include file="../Inserthead.inc" %> <% out.println("



The username and password you have entered do not correspond to valid registered values. Please check your entries and re-enter. If you have forgotten your username and password please send email to contact@efluids.com. If you have not previously obtained a USERNAME and PASSWORD, please register now using the New User Registration Form before entering data in this category. Registration allows you to have secure, personal ENTER and EDIT privileges for your data entries.

"); out.println("Back"); out.println("
"); } else if(s.equals(user)) { String s17 = "select pssword from usermast where usrname like '" + s + "'"; rs4 = statement.executeQuery(s17); rs4.next(); password = rs4.getString("pssword"); rs4.close(); if(s1.equals(password)) { if(i >= 1) { out.println("New Jobs Available Registration"); %> <%@ include file="../Inserthead.inc" %> <% out.println("



Registered user exist with the same JobName! Please verify .

"); out.println("Back"); out.println("
"); } else { String s19 = "insert into jobprovide values('" + s2 + "','" + s3 + "','" + s4 + "','" + s5 + "','" + s6 + "','" + s7 + "','" + s8 + "','" + s9 + "','" + s10 + "','" + s11 + "','" + s12 + "','" + s13 + "','" + s14 + "','" + s + "','" + inDate + "','D')"; int j = statement.executeUpdate(s19); if(j != 0) { out.println("New Jobs Available Registration"); %> <%@ include file="../Inserthead.inc" %> <% out.println("



Thanks for Registering at efluids.com.

"); out.println("


Your form has been submitted successfully.

"); out.println("


Click DISPLAY to see the Listings of Available Jobs.

"); out.println("


Click HOME to return to the Home Page.

"); out.println("
"); } } } else { out.println("New Jobs Available Registration"); out.println(""); %> <%@ include file="../Inserthead.inc" %> <% out.println("



The password you have entered do not correspond to valid registered value. Please check your entry and re-enter. If you have forgotten the password please send email to contact@efluids.com. If you have not previously obtained a USERNAME and PASSWORD, please register now using the New User Registration Form before entering data in this category. Registration allows you to have secure, personal ENTER and EDIT privileges for your data entries.

"); out.println("Back"); out.println("
"); } } else { String s18 = null; String s20 = "select pssword from usermast where pssword like '" + s1 + "'"; rs5 = statement.executeQuery(s20); rs5.next(); s18 = rs5.getString("pssword"); rs5.close(); if(s1.equals(s18)) { out.println("New Jobs Available Registration"); out.println(""); %> <%@ include file="../Inserthead.inc" %> <% out.println("



The username you have entered do not correspond to valid registered value. Please check your entry and re-enter. If you have forgotten the username please send email to contact@efluids.com. If you have not previously obtained a USERNAME and PASSWORD, please register now using the New User Registration Form before entering data in this category. Registration allows you to have secure, personal ENTER and EDIT privileges for your data entries.

"); out.println("Back"); out.println("
"); } } } catch(Exception exception) { out.println("New Jobs Available Registration"); %> <%@ include file="../Inserthead.inc" %> <% out.println("

Error

"); out.println("the error is: " + exception); out.println("
"); } finally { try { if(con !=null) { con.close(); } if(rs != null || resultset != null || rs4 != null || rs5 != null) { rs.close(); resultset.close(); rs4.close(); rs5.close(); } }catch(Exception e) { } } %>