Java Source Code Warehouse :: Example

<td width="100%">Search </tr> <tr> <td width="19">

<td width="100%">Check My Account </tr> <tr> <td width="19"> <td width="100%"> </tr> <tr> <td width="19">

<td width="100%">Logout </tr> </table> </td> </tr> </table> <p>
<% // Display the login user ID if((login.getUserType()).equals("admin")) { //out.println("<i>U had login as ADMIN access level

"); out.println("G'Day <b>" +staff.getUserFirstName() +", " +staff.getUserLastName() +" (Admin)"); } else if((login.getUserType()).equals("librarian")) { //out.println("<i>U had login as LIBRARIAN access level

"); out.println("G'Day <b>" +staff.getUserFirstName() +", " +staff.getUserLastName() +" (Librarian)"); } else{ out.println("G'Day <b>" +user.getUserFirstName() +", " +staff.getUserLastName() +""); } %> <br> <br> <% int numberOfOverDueRec = 0; int numberOfReserveAvailable = 0; String query = ""; String errorMsg=""; ResultSet myResultSet = null; // Calculate the total number of overdue borrow record and number of reserve item that had available already // And display the result as notice. query = "SELECT count(*) FROM `borrowrec` where borrowStatus='overdue' and borrowerID='" +login.getUserID() +"'"; try { Connection connection = connectionPool.getConnection(); myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false); connectionPool.free(connection); } catch(Exception e) { errorMsg = "Error: " + e; } if (myResultSet != null){ try{ while(myResultSet.next()) { numberOfOverDueRec = Integer.parseInt(myResultSet.getString("count(*)")); } } catch(SQLException sqle) { System.err.println("Error connecting: " +sqle); } } query = "SELECT count(*) FROM `reserverec` where reserveStatus='available' and reserverID = '" +login.getUserID() +"'"; try { Connection connection = connectionPool.getConnection(); myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false); connectionPool.free(connection); } catch(Exception e) { errorMsg = "Error: " + e; } if (myResultSet != null){ try{ while(myResultSet.next()) { numberOfReserveAvailable = Integer.parseInt(myResultSet.getString("count(*)")); } } catch(SQLException sqle) { System.err.println("Error connecting: " +sqle); } } if ((numberOfOverDueRec !=0) || (numberOfReserveAvailable !=0)){ out.println("<ul>"); if (numberOfOverDueRec != 0) out.println("<li>You have " +numberOfOverDueRec +" over due items not yet return!"); if (numberOfReserveAvailable != 0) out.println("<li>You have " +numberOfReserveAvailable +" reserve items available now!"); out.println("</ul>

"); } %>

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


<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="240"> 
      <div align="center">
    </td>
    <td> 
      <table width="100%" border="0" cellspacing="2" cellpadding="0">
        <tr> 
          <td width="19">

What this is

Other links

The source code