📄 searchjobseekerdo1.jsp
字号:
<%@ page contentType="text/html; charset=GB2312"%><%@ page import="myutil.*"%><%@ page import="java.sql.*"%><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> </head> <body> <table width="500" border="0" align="center" cellpadding="0" cellspacing="0"> <tr align="center"> <td height="27" colspan="4" ><div id="reg"><font color=red>已搜索到的求职者信息</font></div></td> </tr><tr> <%DataBaseConn con=new DataBaseConn();ShowErrorBox show=new ShowErrorBox(); String Vocation=request.getParameter("vocation"); String Province=request.getParameter("province"); String Kind=request.getParameter("kind"); String Major=request.getParameter("major"); String Degree=request.getParameter("degree"); String Gender=request.getParameter("gender"); String Salary=request.getParameter("salary"); String Years=request.getParameter("years"); String Curr_province=request.getParameter("curr_province"); String N_province=request.getParameter("n_province"); DealString str=new DealString();String sql="select t_jobseeker.trueName,t_jobseeker.sex,t_jobseeker.age,t_jobseeker.hkPro,t_jobseeker.hkCity,t_jobseeker.inhabitPro,t_jobseeker.inhabitCity,t_jobseeker.telephone,t_jobseeker.email,t_jobseeker.address, t_jobseeker.postCode,t_jobseeker.major,t_jobseeker.diploma,t_jobseeker.school,t_jobseeker.workPeriod,t_jobseeker.foreignLag,t_jobseeker.lagLevel,t_applyjob.workPlace1,t_applyjob.salary,t_applyjob.job1,t_applyjob.worktype,t_jobseeker.resume from t_jobseeker,t_applyjob where "; String s1,s2,s3,s4,s5,s6,s7,s8,s9,s10;if(Vocation==""&&Province==""&&Kind==""&&Major==""&&Degree==""&&Gender==""&&Salary==""&&Years==""&&Curr_province==""&&N_province=="") {out.print("<script>alert('必须选择一项');document.location='searchJobSeeker.html';</script>");} if(Vocation=="")s1=""; else s1=" job1='"+str.toGb(Vocation)+"'";sql=sql.concat(s1); if(Province=="")s2="";else {s2="workPlace1='"+str.toGb(Province)+"'";if(Vocation!=""&&Province!="")sql=sql+" AND"; sql=sql.concat(s2);}if(Kind=="")s3=""; else {s3="worktype='"+str.toGb(Kind)+"' ";if(Vocation!=""&&Province!=""&&Kind!="" )sql=sql+" AND";sql=sql.concat(s3);} if(Major=="")s4=""; else {s4="major='"+str.toGb(Major)+"'";if(Vocation!=""&&Province!=""&&Kind!=""&&Major!="" )sql=sql+" AND";sql=sql.concat(s4);} if(Degree=="")s5="";else {s5="diploma='"+str.toGb(Degree)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!="")sql=sql+" AND"; sql=sql.concat(s5);} if(Gender=="")s6="";else {s6="sex='"+str.toGb(Gender)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!=""&&Gender!="")sql=sql+" AND"; sql=sql.concat(s6);} if(Salary=="")s7="";else {s7="salary='"+str.toGb(Salary)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!=""&&Gender!=""&&Salary!="")sql=sql+" AND"; sql=sql.concat(s7);} if(Years=="")s8="";else {s8="workPeriod='"+str.toGb(Years)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!=""&&Gender!=""&&Salary!=""&&Years!="")sql=sql+" AND"; sql=sql.concat(s8);} if(Curr_province=="")s9="";else {s9="inhabitPro='"+str.toGb(Curr_province)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!=""&&Gender!=""&&Salary!=""&&Years!=""&&Curr_province!="")sql=sql+" AND"; sql=sql.concat(s9);} if(N_province=="")s10="";else {s10="hkPro='"+str.toGb(N_province)+"'"; if(Vocation!=""&&Province!=""&&Kind!=""&&Major!=""&&Degree!=""&&Gender!=""&&Salary!=""&&Years!=""&&Curr_province!=""&&N_province!="")sql=sql+" AND"; sql=sql.concat(s10);} sql=sql.concat(" and t_jobseeker.auserName=t_applyjob.auserName"); %><% ResultSet rs=con.getRs(sql);while(rs.next()){ %> <table cellpadding="0" cellspacing="0" width="450" border="0" valign="top" align="center"> <tr> <td valign="top" align="center" width="450"> <table width="700" border="0" align="center" cellpadding="1" cellspacing="0"> <tr> <td align="center"> <table width="450" border="0" cellspacing="0" > <tr bgcolor="#F0F0F0"> <td > <div align="left" > 姓名<b>：</b></div></td> <td colspan="3" ><%=rs.getString("trueName")%></td> </tr> <tr> <td > <div align="left">性 别<b>：</b></div></td> <td colspan="3" > <%=(rs.getInt("sex")<1)?"女":"男"%> </td> </tr> <tr> <td bgcolor="#F0F0F0" > <div align="left"> 年 龄<b>：</b></div></td> <td colspan="3" bgcolor="#F0F0F0" ><%=rs.getString("age")%></td> </tr> <tr> <td > <div align="left"> 户口所在地<b>：</b></div></td> <td colspan="3" > <%=rs.getString("hkPro")%> <%=rs.getString("hkCity")%> </td> </tr> <tr> <td bgcolor="#F0F0F0" > <div align="left">现居住地<b>：</b></div></td> <td colspan="3" bgcolor="#F0F0F0" > <%=rs.getString("inhabitPro")%> <%=rs.getString("inhabitCity")%> </td> </tr> <tr> <td > <div align="left">联系电话<b>：</b></div></td> <td colspan="3" > <%=rs.getString("telephone")%>; </td> </tr> <tr> <td > <div align="left"> 电子邮件<b>：</b></div></td> <td colspan="3" ><%=rs.getString("email")%> </td> </tr> <tr> <td > <div align="left"> 通信地址<b>：</b></div></td> <td colspan="3" > <%=rs.getString("address")%> </td> </tr> <tr> <td bgcolor="#F0F0F0" > <div align="left"> 邮政编码<b>：</b></div></td> <td colspan="3" bgcolor="#F0F0F0" > <%=rs.getString("postCode")%> </td> </tr> <tr> <td > <div align="left">所学专业<b>：</b></div></td> <td colspan="3" > <%=rs.getString("major")%> </td> </tr> <tr bgcolor="#F0F0F0"> <td align="left">学 历<b>：</b></td> <td colspan="3" > <%=rs.getString("diploma")%> </td> </tr> <tr> <td align="left">毕业学校<b>：</b></td> <td colspan="3"> <%=rs.getString("school")%> </td> </tr> <tr> <td width="110" align="left">工作年限<b>：</b></td> <td colspan="3"> <%=rs.getString("workPeriod")%> </td> </tr> <tr> <td width="110" ><div align="left">外语语种<b>：</b></div></td> <td colspan="3" > <%=rs.getString("foreignLag")%> </td> </tr> <tr bgcolor="#F0F0F0"> <td width="110" ><div align="left">外语水平<b>：</b></div></td> <td colspan="3" > <%=rs.getString("lagLevel")%> </td> </tr> <tr bgcolor="#F0F0F0"> <td rowspan="2" valign="top" > <div align="left">希望工作地区<b>：</b></div></td> <td width="120" > <%=rs.getString("workPlace1")%> </td> </tr> <tr> <td width="110" >希望月薪范围<b>：</b></td> <td colspan="3" > <%=rs.getString("salary")%> </td> </tr> <tr> <td width="110" valign="top" ><div align="left">应聘行业和职位<b>：</b></div></td> <td colspan="3" > <%=rs.getString("job1")%> </td> </tr> <tr bgcolor="#F0F0F0"> <td width="110" ><div align="left">工作性质<b>：</b></div></td> <td colspan="3" ><%=rs.getString("worktype")%> </td> </tr> <tr> <td colspan="4" align="center" > 个人简历</td> </tr> <tr bgcolor="#F0F0F0"> <td colspan="4" align="center"><textarea rows="12" name="resume" cols="90" style="overflow:auto;background-color:#FFFFFF ; border-bottom: 1px double; border-left: 1px double; border-right: 1px double; border-top: 1px double; color: #000000; font-size:9pt; letter-spacing:0.08em; line-height:12pt; text-decoration:blink; font-family:Arial, Helvetica, sans-serif; "> <%=rs.getString("resume")%> </textarea> </td> </tr> </table> </form></td> </tr> </table></td> </tr> </table><% } %> </tr> </table></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -