<%
int z=0;
try{
String search=request.getParameter("search");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/CLINIHR", "root", "Clinica123");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from users where first_name like '%"+search+"%' or last_name like '%"+search+"%' or emp_code like '%"+search+"%'");
while(rs.next()){
z=1;
%>
<%
}
%>
<%
} catch (Exception e) {
out.println(e);
}
%>
<%if(z==0){%>