<% int PNum =1; if (request.getParameter("PNum")!=null){ PNum = (int) Integer.parseInt(request.getParameter("PNum"));} int PSNum = PNum*6; int PS2Num = PSNum-6; String VolumeId=request.getParameter("VolumeId"); Vector Pages=new Vector(); String title=""; String catname=""; Connection conn= null; try { Class.forName ("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@129.128.199.91:1530:KINJI2"; conn = DriverManager.getConnection(url, "imanishi", "m0nk3y"); Statement stmt1 = conn.createStatement(); ResultSet rs1 = stmt1.executeQuery("SELECT list, catname FROM all_book_list where id='"+VolumeId+"'"); while(rs1.next()) { title=rs1.getString("list"); catname=rs1.getString("catname"); } Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select distinct identifier from all_info where rtrim (identifier) like '"+VolumeId+"0___' order by identifier"); //Loop through results of query. while(rs.next()) { String eachpageid = rs.getString("identifier").trim(); String ImageUrl = (""); Pages.add(ImageUrl); } int numberOf = Pages.size(); //Print start of table and column headers out.println("

Home | Explore the Archive| About the Project | Project News | Site Map Search the Archive How to Search the Archive Back to Categories Back to Volumes

"+title+" Category: "+catname+" Click on the thumbnail to see each image. "); for(int index=0; index < numberOf; index++){ Object pagesThumb = Pages.elementAt(index); String viewPages = pagesThumb.toString(); out.println(" " + viewPages + " "); } out.println(" "); } catch(SQLException e) { out.println("SQLException: " + e.getMessage() + " "); while((e = e.getNextException()) != null) out.println(e.getMessage() + " "); } catch(ClassNotFoundException e) { out.println("ClassNotFoundException: " + e.getMessage() + " "); } finally { //Clean up resources, close the connection. if(conn != null) { try { conn.close(); } catch (Exception ignored) {} } } %>

Copyright 2004 Pamela Asquith | Contact | Web design by Natasha Nunn