ResultSet rs=null;
%>
……….
<%
//根据获得的猎头号作为搜索条件对数据库中person表进行搜索
String String_sql="select *from person where UserName='"+user_name+"'";
rs=statement.executeQuery(String_sql);
//设置指针
rs.afterLast();
while(rs.previous())
{//输出查询到的内容
……………
}
//关闭连接
rs.close();
statement.close();
con.close();
}
catch(Exception e)
{
//数据库出现错误时的代码
out.println("<font color=red size=5><b>");
out.println("数据库出现错误！");
out.println("</b></font>");
}
%>
</table>
搜索候选人的界面如图11所示:
图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其它模块
由于整个范文的篇幅有限这些模块的代码请参考系统源程序