图11 搜索候选人的界面
搜索候选人的核心代码为:
<%!
//处理中文字符串的函数
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
//获得猎头号
<center><%String user_name= (String) session.getAttribute("user_name");%>
<%= session.getAttribute("user_name") %><br></center>
<%
//获得一些搜索的条件
String sqlString=null;
String sex=codeToString(request.getParameter("sex"));
String Name=codeToString(request.getParameter("Name"));
String money=codeToString(request.getParameter("money"));
String IDcar=codeToString(request.getParameter("IDcar"));
//构造查询SQL语句
if(sex==null||sex.trim().length()==0)
sqlString=new String("SELECT * FROM person where UserName='"+user_name+"'");
else
sqlString=new String("SELECT * FROM person where sex='"+sex.trim()+"'and UserName='"+user_name+"'");
if(money==null||money.trim().length()==0)
;
else
sqlString=new String("SELECT * FROM person where money='"+money.trim()+"'and UserName='"+user_name+"'");
if(IDcar==null||IDcar.trim().length()==0)
;
else
sqlString=new String("SELECT * FROM person where IDcar='"+IDcar.trim()+"'and UserName='"+user_name+"'");
if(Name==null||Name.trim().length()==0)
;
else
if(sqlString.indexOf("where")==-1)
sqlString=new String("SELECT * FROM person where UserName='"+user_name+"'")+" where Name like '%"+Name+"%'";
else
sqlString=new String("SELECT * FROM person where UserName='"+user_name+"'")+" and Name like '%"+Name+"%'";
%>
因篇幅所限,其它猎头候选人管理代码不再给出,请参考系统源程序中的代码。
4.2.4其它模块
由于整个论文的篇幅有限这些模块的代码请参考系统源程序