Java Source Code Warehouse :: Example

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.
The source code

<%@ include file="/common/common.jsp" %>
<%@ include file="../common/dbconnect.jsp" %>
<% 	URLcurrent = "/JavaLibrary/libraryitem/libraryitem_view.jsp";
	URLcurrent=response.encodeURL(URLcurrent);
%>
<%! int nextRecNumber=0; %>
<html>
<head>
<title>Library Management System
<META NAME="description" CONTENT="">
<META NAME="keywords" CONTENT="">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
   A:link                  { text-decoration:  none; font-weight: bold; color: #660033}
   A:active                { text-decoration:  none; font-weight: bold; color: #660033}
   A:visited               { text-decoration:  none; font-weight: bold; color: #336699}
   A:hover                 { text-decoration:  underline; font-weight: bold; color: #FF9999}
.footerLink {  font-family: Arial, Helvetica, sans-serif; font-size: 9pt; font-weight: bold; color: #000099}
-->
</style>
</head>

<body bgcolor="#0099ff" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="">
<a name="top"> 
<%@ include file="../common/header_select.jsp" %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr bgcolor="#f1f1f1"> 
    <td width="180" align="left" valign="top"> 
	  <%@ include file = "../common/navi.jsp" %>
    </td>
        <TD width=1 bgColor=#999999>
    <td valign="top" width="100%" bgcolor="#f1f1f1"> 
      <p align="center">View Library Items

<jsp:setProperty name="form" property="formName" value="libraryitem" />
<jsp:setProperty name="form" property="formType" value="view" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/libraryitem/libraryitem_view.jsp" />
<% libraryitem.resetVariable(); %>
        <% 
			// get the parameter from HTTP request
			int itemRecNumber = 0;
			String itemRecNumberStr = request.getParameter("itemRecNumber");
			String itemCallNumber = request.getParameter("itemCallNumber");
			String query;
			ResultSet myResultSet=null;
    		String errorMsg;

		// retrieve the database data which match to the parameter
		if (itemRecNumberStr != null) {
			itemRecNumber = Integer.parseInt(itemRecNumberStr);
			query = ("SELECT * FROM libraryitem WHERE itemRecNumber = " +itemRecNumber); 
		} else {
			query = ("SELECT * FROM libraryitem WHERE itemCallNumber = '" +itemCallNumber +"'");
		}
   		try {  
      		Connection connection = connectionPool.getConnection();
			myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false);                                            
      		connectionPool.free(connection);
    	} catch(Exception e) {
      		errorMsg = "Error: " + e;    		
    	}          

		// Save all the data to libraryitem java bean and use in the form to display back the infomation
    	if (myResultSet != null){
			try{
				while(myResultSet.next()) {
				libraryitem.setItemRecNumber(Integer.parseInt(myResultSet.getString("itemRecNumber")));
				libraryitem.setItemCallNumber(myResultSet.getString("itemCallNumber"));
				libraryitem.setItemCategory(myResultSet.getString("itemCategory"));
				libraryitem.setItemSubject(myResultSet.getString("itemSubject"));
				libraryitem.setItemMediaType(myResultSet.getString("itemMediaType"));
				libraryitem.setItemLanguage(myResultSet.getString("itemLanguage"));
				libraryitem.setItemTitle(myResultSet.getString("itemTitle"));
				libraryitem.setItemBriefDesc(myResultSet.getString("itemBriefDesc"));
				libraryitem.setItemAuthor(myResultSet.getString("itemAuthor"));
				libraryitem.setItemKeyword(myResultSet.getString("itemKeyword"));
				libraryitem.setItemPublisherName(myResultSet.getString("itemPublisherName"));
				libraryitem.setItemISBN(myResultSet.getString("itemISBN"));
				libraryitem.setItemLength(myResultSet.getString("itemLength"));
				libraryitem.setItemYear(myResultSet.getString("itemYear"));
				libraryitem.setItemTotQuantity(Integer.parseInt(myResultSet.getString("itemTotQuantity")));
				libraryitem.setItemTotAvailable(Integer.parseInt(myResultSet.getString("itemTotAvailable")));
				libraryitem.setItemTotBorrow(Integer.parseInt(myResultSet.getString("itemTotBorrow")));
				libraryitem.setItemTotReserve(Integer.parseInt(myResultSet.getString("itemTotReserve")));

				}
			} catch(SQLException sqle) {
				System.err.println("Error connecting: " +sqle);		
			}
		} 
%>  
		<%@ include file="../libraryitem/libraryitem_form_view.jsp" %>
      <br>
		</td>
  </tr>
</table>
<jsp:include page="../common/footer.jsp" flush="true" />
<% connectionPool.closeAllConnections(); %>
</body>
</html>
What this is

Other links

The source code
