<%@ page import="java.sql.*"%> Aveda Institute Chicago Application Form
 

Apply Now

We are an equal opportunity employer, dedicated to a policy of nondiscrimination in employment on any basis including age, sex, color, race, creed, national origin, religious persuasion, marital status, political belief or disability that does not prohibit performance of essential job functions.

Job Title:

To submit your profile for this job, please complete the following fields and click “Submit” when you are finished. Fields with asterisk (*) are required.

<% String submit = request.getParameter("Submit"); if(submit!=null) { //required fields String requiredFields = ""; String hereSay = request.getParameter("HereSay"); String otherHereSay = request.getParameter("OtherHereSay"); String firstName = request.getParameter("FirstName"); String lastName = request.getParameter("LastName"); String streetAddress = request.getParameter("StreeAddress"); String city = request.getParameter("City"); String state = request.getParameter("State"); String zip = request.getParameter("Zip"); String phone1 = request.getParameter("Phone1"); String phone2 = request.getParameter("Phone2"); String phone3 = request.getParameter("Phone3"); String salary = request.getParameter("Salary"); String email = request.getParameter("Email"); if((hereSay==null || hereSay.length() < 1) && (otherHereSay==null || otherHereSay.length() < 1)) requiredFields+="How did you Here About Us
"; if(firstName==null || firstName.length() < 1) requiredFields+="First Name
"; if(lastName==null || lastName.length() < 1) requiredFields+="Last Name
"; if(streetAddress==null || streetAddress.length() < 1) requiredFields+="Street Address
"; if(city==null || city.length() < 1) requiredFields+="City
"; if(state==null || firstName.length() < 1) requiredFields+="State
"; if(zip==null || firstName.length() < 1) requiredFields+="Zip
"; if((phone1==null || firstName.length() < 1) && (phone2==null || phone2.length() < 1) && (phone3==null || phone3.length() < 1)) requiredFields+="Home Phone
"; if(salary==null || salary.length() < 1) requiredFields+="Salary
"; if(email==null || email.length() < 1) requiredFields+="Email
"; //other Fields String wkPhone1 = request.getParameter("Phone1a"); String wkPhone2 = request.getParameter("Phone2a"); String wkPhone3 = request.getParameter("Phone3a"); String exp = request.getParameter("Experience"); String jobClass = request.getParameter("JobClass"); String resume = request.getParameter("Resume"); String degree = request.getParameter("Degree"); String degreeYear = request.getParameter("DegreeYear"); String degreeMajor = request.getParameter("DegreeMajor"); String inst = request.getParameter("Institution"); String gender = request.getParameter("gender"); String eth = request.getParameter("ethnicity"); if(requiredFields.length()!=0) { %> <% //out.println("

You missed some fields:

"+requiredFields+"

"); } else { String emailMessage= "How did you hear about us:\n" + hereSay +"\n" + otherHereSay +"\n\nFirst Name: " + firstName +"\nLast Name: " + lastName +"\n\nStreet Address: " + streetAddress +"\nCity: " +city +"\nState: " +state +"\nZip: " +zip +"\n\nHome Phone: " + phone1+"-"+phone2+"-"+phone3 +"\nWork Phone: " + wkPhone1+"-"+wkPhone2+"-"+wkPhone3 +"\n\nEmail: " + email +"\n\nExperience: " + exp +"\n\nSalary: " + salary +"\nJob Class: " + jobClass +"\n\nResume:\n " + resume +"\n\nDegree: " + degree +"\nDegree Year: " + degreeYear +"\nDegree Major: " + degreeMajor +"\nInstitution: " + inst +"\n\nGender:\n" + gender +"\nEthnicity:\n" + eth; wrUtils.MailBean mb = new wrUtils.MailBean("libra.lunarpages.com", "avedai2", "Oberon0409"); mb.sendMessage("resume@avedachicago.com", "resume@avedachicago.com", "Aveda Website Resume", emailMessage, null); mb.sendMessage("resume@avedachicago.com", "rivera5040@sbcglobal.net", "Aveda Website Resume", emailMessage, null); /* ID int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext refferd_by varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext first_name varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext last_name varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext street varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext city varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext state varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext zip varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext phone1 varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext phone2 varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext email varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext salary varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext Industry_Exp blob BINARY Yes NULL Change Drop Primary Index Unique Fulltext Job_Class varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext Resume_Text blob BINARY Yes NULL Change Drop Primary Index Unique Fulltext Degree_Obtained varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext Year varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext Major varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext Institution varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext gender varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext ethnicity varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext CreateDate timestamp(10) Yes NULL Change Drop Primary Index Unique Fulltext */ try{ Connection con; String error; String driverName = "org.gjt.mm.mysql.Driver"; String dbURL = "jdbc:mysql://localhost/avedai2_aveda"; //String dbURL = "DBI:mysql:avedai2_aveda:localhost"; String username = "avedai2"; String password = "aveda818"; Class.forName(driverName).newInstance(); con = DriverManager.getConnection(dbURL, username, password); String s1="insert into AVD_Resumes" +"(first_name,last_name,street,city,refferd_by,state,zip,phone1,phone2,email,salary,Industry_Exp, Job_Class, Resume_Text, Degree_Obtained, Year" +", Major Institution, ethnicity)" +"values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; PreparedStatement preparedstatement = con.prepareStatement(s1); preparedstatement.setString(1, "first_name"); preparedstatement.setString(2, "last_name"); preparedstatement.setString(3, "street"); preparedstatement.setString(4, "city"); preparedstatement.setString(5, "refferd_by"); preparedstatement.setString(6, "state"); preparedstatement.setString(7, "zip"); preparedstatement.setString(8, "phone1"); preparedstatement.setString(9, "phone2"); preparedstatement.setString(10, "email"); preparedstatement.setString(11, "salary"); preparedstatement.setString(12, "Industry_Exp"); preparedstatement.setString(13, "Job_Class"); preparedstatement.setString(14, "Resume_Text"); preparedstatement.setString(15, "Degree_Obtained"); preparedstatement.setString(16, "Year"); preparedstatement.setString(17, "Major Institution"); preparedstatement.setString(18, "ethnicity"); preparedstatement.executeUpdate(); }catch(Exception e) {} %> <% } } %>

Please tell us where you heard about this position. *

If other, please specify:

Contact Information
First Name: *
Last Name:*
Street Address:*
City:*
State:* Zipcode:*
Home Telephone:* - -
Work Telephone: - -
E-mail Address:*

Key Facts
Salary Range: *

Industry Experience:

Job Classification:

Resume Text: (Copy from a text file. Do not paste formatted text using font attributes such as bold, italics, underline, etc.)


Education Information

(Select your highest degree and related educational information.)

Degree Obtained:

Year Completed:
Major:
Institution:

Optional EEO Information
This information is collected with government and record-keeping requirements. It is completely optional for you to submit and will be used only for Equal Employment Opportunity reporting requirements. It is not viewed or used as a part of the recruiting or hiring process.

Gender:

Ethnicity:

 

 

about us | admissions and student services | client services
contact | frequently asked questions | privacy | legal
© 2005 Aveda Institute Chicago

2828 N. Clark Street • Chicago, Illinois 60657 • 1-773-883-1560