Pope John Paul II College

<% String ArtCode = ""; String author1 = ""; String author2 = ""; String ISSN = ""; String Loc=""; String query = ""; String query1 = ""; String query2 = ""; String querys = ""; String JCode = ""; String JOUR = ""; String PAGE =""; String sTemp=""; int rec1 = 0; String status=""; String title=""; String tail=""; String VNo=""; String UCan=""; String sTest=""; int totalpages=0; double totpages; String CC=""; String reg=""; int f=0; %> <% try{ int j=0; int ss=10; int ff=Integer.parseInt(request.getParameter("start")); int i=Integer.parseInt(request.getParameter("i")); status=request.getParameter("status"); int dd=Integer.parseInt(request.getParameter("dd")); String title1 = request.getParameter("search").toUpperCase(); String fName = request.getParameter("search").toUpperCase(); String code=request.getParameter("code"); Connection con = Libcon.fetchConnection("SYS as SYSDBA","JohnLouis2008"); String CQ =""; /***********************************************/ if(code.equals("Artword")) { query1 = "SELECT JCODE,ARTCODE,ARTAUTHL,ARTAUTHF,AJTAUTH1,AJTAUTH2,ARTITLE,VOLUMENO,PAGES,LOCATION,FTITLE,ISSN FROM ARTMAST, SERIAL WHERE CONTAINS(ARTITLE,'"+title1+"')>0 AND SUBSTR(ARTCODE,1,4)=SERIAL.JCODE ORDER BY ARTITLE"; } /****************************************/ else if(code.equals("Abstract")) { query1 = "SELECT JCODE,ARTCODE,ARTAUTHL,ARTAUTHF,AJTAUTH1,AJTAUTH2,ARTITLE,VOLUMENO,PAGES,LOCATION,FTITLE,ISSN FROM ARTMAST, SERIAL WHERE CONTAINS(ABSTRACT,'"+title1+"')>0 AND SUBSTR(ARTCODE,1,4)=SERIAL.JCODE ORDER BY ARTITLE"; } /****************************************/ else if(code.equals("ArtAuthor")) { query1 = "SELECT JCODE,ARTCODE,ARTAUTHL,ARTAUTHF,AJTAUTH1,AJTAUTH2,ARTITLE,VOLUMENO,PAGES,LOCATION,FTITLE,ISSN FROM ARTMAST, SERIAL WHERE UPPER(ARTAUTHL) LIKE '"+title1+"%' AND SUBSTR(ARTCODE,1,4)=SERIAL.JCODE ORDER BY ARTITLE"; } /**************************************/ else if(code.equals("ArtTTitle")) { query1 = "SELECT JCODE,ARTCODE,ARTAUTHL,ARTAUTHF,AJTAUTH1,AJTAUTH2,ARTITLE,VOLUMENO,PAGES,LOCATION,FTITLE,ISSN FROM ARTMAST, SERIAL WHERE UPPER(ARTITLE) LIKE '"+title1+"%' AND SUBSTR(ARTCODE,1,4)=SERIAL.JCODE ORDER BY ARTITLE"; } /********************************************/ else { query1 = "SELECT JCODE,ARTCODE,ARTAUTHL,ARTAUTHF,AJTAUTH1,AJTAUTH2,ARTITLE,VOLUMENO,PAGES,LOCATION,FTITLE,ISSN FROM ARTMAST, SERIAL WHERE JCODE='"+title1+"' AND SUBSTR(ARTCODE,1,4)=SERIAL.JCODE ORDER BY ARTITLE"; } /*************************************/ //out.println(query1); Statement stc = con.createStatement(); ResultSet rsc = stc.executeQuery(query1); while(rsc.next()) { rec1++; } %> <% if(rec1!=0) { %>

Search Request: <%=title1%> Available: <%=(int)rec1%> docs of <%=(int)totpages%>

<% Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs = st.executeQuery(query1); // int i = 0;int rec = 0; if(status.equals("p")) { ss=ff-ss; st.setMaxRows(ss); rs.absolute(-11); } if(status.equals("N")) { ss=ss+ff; st.setMaxRows(ss); rs.absolute(-11); } while(rs.next()) { i=rs.getRow(); j=j+1; ArtCode=rs.getString("ARTCODE"); author1=rs.getString("ARTAUTHL"); author2=rs.getString("ARTAUTHF"); title=(rs.getString("ARTITLE")); title=title.trim(); if (title.length() >= 75) { int nLn = title.lastIndexOf(" ",76); tail = (title.substring(nLn+1,title.length())).trim(); title = (title.substring(0,nLn)).trim(); }else {tail="";} VNo=rs.getString("VOLUMENO"); PAGE=rs.getString("PAGES"); Loc=rs.getString("LOCATION"); ISSN=rs.getString("ISSN"); JCode=rs.getString("JCODE"); JOUR= rs.getString("FTITLE"); if (author2==null) { author2=""; } if (author1==null) { author1=""; } { if (i%2==1) { %>

.jpg align=left width=70 height=90,alt=<%=ISSN%>/> <%=i%> <%=title%> <%=tail%>
by <%=author1%> <%=author2%>
<%=JCode%>  <%=JOUR%>, <%=VNo%>, <%=PAGE%>
ISSN   <%=ISSN%>
Location   <%=Loc%>

<%}else{%>

.jpg align=left width=70 height=90,alt=<%=ISSN%>/> <%=i%> <%=title%> <%=tail%>
by <%=author1%> <%=author2%>
<%=JCode%>   <%=JOUR%>, <%=VNo%>, <%=PAGE%>
ISSN   <%=ISSN%>
Location   <%=Loc%>

<% } } } %>

<% if(ss>10) { %> Previous <% } if(ss<=rec1){ %> Forward <% } %> <% } else { %> No Resultes

<% } }catch(Exception e){out.println("Error in:"+e.getMessage());} %>