<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/library.jsp" %>
<%
String marc__varBook = "1";
if (request.getParameter("book_id") !=null) {marc__varBook = (String)request.getParameter("book_id");}
%>
<%
Driver Drivermarc = (Driver)Class.forName(MM_library_DRIVER).newInstance();
Connection Connmarc = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD);
PreparedStatement Statementmarc = Connmarc.prepareStatement("SELECT *  FROM marc  WHERE book_id = " + marc__varBook + "");
ResultSet marc = Statementmarc.executeQuery();
boolean marc_isEmpty = !marc.next();
boolean marc_hasData = !marc_isEmpty;
Object marc_data;
int marc_numRows = 0;
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="lmstk.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table border="0">
  <tr align="center" bgcolor="lightgrey"> 
    <td><b>leader</b></td>
    <td><b>directory</b></td>
    <td><b>001</b></td>
    <td><b>003</b></td>
    <td><b>005</b></td>
  </tr>
  <tr bgcolor="white"> 
    <td><%=(((marc_data = marc.getObject("leader"))==null || marc.wasNull())?"":marc_data)%></td>
    <td><%=(((marc_data = marc.getObject("directory"))==null || marc.wasNull())?"":marc_data)%></td>
    <td><%=(((marc_data = marc.getObject("001"))==null || marc.wasNull())?"":marc_data)%></td>
    <td><%=(((marc_data = marc.getObject("003"))==null || marc.wasNull())?"":marc_data)%></td>
    <td><%=(((marc_data = marc.getObject("005"))==null || marc.wasNull())?"":marc_data)%></td>
  </tr>
</table>

</body>
</html>
<%
marc.close();
Statementmarc.close();
Connmarc.close();
%>
