<%@ page language="Java" import="java.io.*,java.sql.*,StrChk.Str"%> <%! java.sql.ResultSet resultset,rset; java.sql.Connection con; java.sql.Statement stment; int recFlag; int i; boolean flag; %> <% try{ con=dbcon.getConnection(); stment=con.createStatement(); Str str = new Str(); String p = "%"; String s = request.getParameter("alphabet").toLowerCase() + p; String s1 = request.getParameter("alphabet").toUpperCase() + p; String s2 = "select count(*) from userdet where lnm like '"+ s +"' or lnm like '"+ s1 +"' order by lnm"; resultset = stment.executeQuery(s2); if(resultset.next()) i = resultset.getInt(1); resultset.close(); if(i >= 1) { String s3 = "select * from userdet where (lnm like '" + s + "' or lnm like '" + s1 + "') and status='D' order by lnm"; for(rset = stment.executeQuery(s3); rset.next(); out.println("

")) { String s4 = rset.getString("fnm"); String s5 = rset.getString("mnm"); if(s5.equals("null") || s5.equals("") || s5.equals(null)) s5 = ""; String s6 = rset.getString("LNM"); String s7 = s6.toLowerCase(); String s8 = s7.substring(0, 1); String s9 = s7.substring(1, s7.length()); String s10 = s8.toUpperCase(); String s11 = s10 + s9; String s12 = rset.getString("TITLE"); if(s12.equals(null) || s12.equals("") || s12.equals("null")) s12 = ""; String s13 = rset.getString("AFFILIATION"); if(s13.equals(null) || s13.equals("") || s13.equals("null")) s13 = ""; String s14 = rset.getString("STREETNM"); if(s14.equals(null) || s14.equals("") || s14.equals("null")) s14 = ""; String s15 = rset.getString("city"); if(s15.equals(null) || s15.equals("") || s15.equals("null")) s15 = ""; String s16 = rset.getString("state"); if(s16.equals(null) || s16.equals("") || s16.equals("null")) s16 = ""; String s17 = rset.getString("country"); String s18 = rset.getString("zip"); if(s18.equals(null) || s18.equals("") || s18.equals("null")) s18 = ""; String s19 = rset.getString("phone"); if(s19.equals(null) || s19.equals("") || s19.equals("null")) s19 = ""; String s20 = rset.getString("fax"); if(s20.equals(null) || s20.equals("") || s20.equals("null")) s20 = ""; String s21 = rset.getString("email"); if(s21.equals(null) || s21.equals("") || s21.equals("null")) s21 = ""; String s22 = rset.getString("website"); if(s22.equals(null) || s22.equals("") || s22.equals("null")) s22 = ""; String s23 = rset.getString("keyword"); if(s23.equals(null) || s23.equals("") || s23.equals("null")) s23 = "NA"; else s23 = s23 + "."; String s24 = rset.getString("nofpubs"); if(s24.equals(null) || s24.equals("0") || s24.equals("") || s24.equals("null")) s24 = ""; else s24 = s24 + "."; String s25 = rset.getString("consult"); if(s25.equals(null)) s25 = ""; if(s25.equals("Y")) s25 = "Yes"; else if(s25.equals("N")) s25 = "No"; String s26 = rset.getString("expertwit"); if(s26.equals(null)) s26 = ""; if(s26.equals("Y")) s26 = "Yes"; else if(s26.equals("N")) s26 = "No"; String s27 = rset.getString("referee"); String s28 = rset.getString("usrname"); out.println("

"); out.println(""); out.println(""); out.println(""); out.println("

square"); if(!s11.equals(null) && !s11.equals("null") && !s11.equals("")) out.println("" + s11 + ""); if(!s4.equals(null) && !s4.equals("null") && !s4.equals("")) out.println("" + s4 + ""); if(!s5.equals(null) && !s5.equals("null") && !s5.equals("")) out.println("" + s5 + ";   "); if(!s12.equals(null) && !s12.equals("null") && !s12.equals("")) out.println("" + s12 + ";   "); if(!s13.equals(null) && !s13.equals("null") && !s13.equals("")) out.println("Affiliation: " + s13 + " "); out.println("

"); if(!s14.equals(null) && !s14.equals("null") && !s14.equals("")) out.println("Address: " + s14 + ","); if(!s15.equals(null) && !s15.equals("null") && !s15.equals("")) out.println("" + s15 + ""); if(!s16.equals(null) && !s16.equals("null") && !s16.equals("")) out.println("" + s16 + ","); if(!s17.equals(null) && !s17.equals("null") && !s17.equals("")) out.println("" + s17 + ""); if(!s18.equals(null) && !s18.equals("null") && !s18.equals("")) out.println("" + s18 + "

"); if(!s19.equals(null) && !s19.equals("null") && !s19.equals("")) out.println("Phone: " + s19 + "  "); if(!s20.equals(null) && !s20.equals("null") && !s20.equals("")) out.println("Fax: " + s20 + "

"); if(!s21.equals(null) && !s21.equals("null") && !s21.equals("")) out.println("Email: " + s21 + "  "); if(!s22.equals(null) && !s22.equals("null") && !s22.equals("")) out.println("Web Page: " + s22 + "

"); out.println("Keywords: " + s23 + "  "); if(!s24.equals(null) && !s24.equals("null") && !s24.equals("")) out.println("Number of Publications: " + s24 + "

"); out.println("Consulting: " + s25 + "  "); out.println("Expert witness: " + s26 + "  "); out.println("Review Papers and Proposals: "); if(s27.equals(null)) s27 = ""; if(s27.equals("Y")) s27 = "Yes"; else if(s27.equals("N")) s27 = "No"; out.println("" + s27 + ""); } out.println("

"); out.println("

"); rset.close(); } else { out.println("Who's Who Directory"); out.println("
"); out.println("

No one is Registered under this Alphabet Selection
"); out.println("
"); } } catch(Exception exception) { out.println("Who's Who Directory"); out.println("
"); out.println("Error is " + exception); out.println("
"); } finally { try { if(con !=null) { con.close(); } if(rset != null || resultset != null) { rset.close(); resultset.close(); } }catch(Exception e) { out.println("There is a problem in your database communication" +e); } } %>