<%@ page language="java" contentType="text/html" import="com.csz.contentManager.*,java.sql.*,java.util.*,org.apache.regexp.*,java.net.*" session="true" %> <% String AID = request.getParameter("AID"); if(AID == null || AID.equals("") || AID.equals("0")){ RequestDispatcher rd = request.getRequestDispatcher("abstracts.jsp"); rd.forward(request, response); } else { RE wildCard = new RE("\\*"); StringBuffer notes = new StringBuffer(); String sPub = request.getParameter("SPub"); if(sPub==null) sPub=""; String sTitle = request.getParameter("STitle"); String sAuthor = request.getParameter("SAuthor"); String sDateStart = request.getParameter("SDateStart"); String sDateStop = request.getParameter("SDateStop"); String sTopic = request.getParameter("STopic"); String sKeywords = request.getParameter("SKeywords"); String pageNumber = request.getParameter("Page"); String sortOrder = request.getParameter("sortorder"); if(sTitle == null) sTitle=""; if(sAuthor == null) sAuthor=""; if(sDateStart == null) sDateStart="mm/yyyy"; if(sDateStop == null) sDateStop ="mm/yyyy"; if(sTopic == null) sTopic = ""; if(sKeywords == null) sKeywords = ""; if(pageNumber == null || pageNumber.equals("0")) pageNumber ="1"; if(sortOrder == null) sortOrder=""; // build order changing commands for top row. String existingSearch="SPub="+java.net.URLEncoder.encode(sPub)+"&STitle="+ java.net.URLEncoder.encode(sTitle)+"&SAuthor="+java.net.URLEncoder.encode(sAuthor)+ "&SDateStart="+java.net.URLEncoder.encode(sDateStart)+"&SDateStop="+ java.net.URLEncoder.encode(sDateStop)+"&STopic="+java.net.URLEncoder.encode(sTopic)+ "&SKeywords="+java.net.URLEncoder.encode(sKeywords); String encodedSearch= existingSearch+"&Page="+pageNumber; java.sql.Connection connect = Conn.getConn(); java.sql.Statement stmt = connect.createStatement(); String q1="select rtrim(APublication),rtrim(ATitle),rtrim(ASubject),"+ "rtrim(ALink),AAbstract,rtrim(AAName),rtrim(VolChapIssue),"+ "Date_Format(APDate,'%b %c, %Y'),Date_Format(APDate,'%b %Y'),"+ "Date_Format(APDate,'%Y') from Abstract where AID="+AID; java.sql.ResultSet r = stmt.executeQuery(q1); if(!r.next()){ RequestDispatcher rd = request.getRequestDispatcher("abstracts.jsp"); rd.forward(request, response); } else { String adate=null; String d = r.getString(8); if(r.wasNull() || d.equals("")){ String d1 = r.getString(9); if(r.wasNull() || d1.equals("")) adate = r.getString(10); else adate = d1; } else adate = d; // begin page display %> 21st Century Medicine --Biopharmaceutical contract research and protocols
21st Century Medicine --Expanding the Science of Preservation

Abstract Listing

<% // APublication,ATitle,ASubject,ALink, AAbstract,AAName,VolChapIssue,PubDate Full,Pub Date M,Y, PD Y%> <% String link = r.getString(4); if(r.wasNull() || link.equals("")){ %> <% } else {%> <% }%>
Title <%= r.getString(2) %>
Authors <%= r.getString(6) %>
Publication Info <%= r.getString(1) %> <%= r.getString(7) %>
Date Published <%= adate %>
Abstract <%= r.getString(5) %>
ArticleN/A<%= link %>

 

Return to Search Results
<% connect.close(); } } %>