careerApplyCheck.jsp
966 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<%
out.clear();
int ishas =0;
String temName = Util.null2String(request.getParameter("lastname"));
String cmd = Util.null2String(request.getParameter("cmd"));
String id = Util.null2String(request.getParameter("id"));
try{
if(cmd.equals("add")){
String tempSql = "";
if(!temName.equals("")){
tempSql = "select lastname from HrmCareerApply where lastname='"+temName+"'";
rs.executeSql(tempSql);
if(rs.next()){
ishas++;
}
}
}else{
String tempSql = "";
if(!temName.equals("")){
tempSql = "select lastname from HrmCareerApply where lastname='"+temName+"' and id <>"+id+" ";
rs.executeSql(tempSql);
if(rs.next()){
ishas++;
}
}
}
}catch(Exception e){
e.printStackTrace();
}
out.print(ishas);
%>