entryview.jsp

This is a jsp source code.. download this for java study. this is very essential..

      boolean bPK = true;

      if ( "".equals(sEntryViewErr)) {
        // Load primary key and form parameters
        fldaddress = getParam( request, "address");
        fldname = getParam( request, "name");
        fldcity = getParam( request, "city");
        fldzip = getParam( request, "zip");
        fldstate = getParam( request, "state");
        fldcategory_id = getParam( request, "category_id");
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_address\" value=\""+getParam( request, "address")+"\">";
        transitParams += "Trn_address="+getParam( request, "address")+"&";
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_name\" value=\""+getParam( request, "name")+"\">";
        transitParams += "Trn_name="+getParam( request, "name")+"&";
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_city\" value=\""+getParam( request, "city")+"\">";
        transitParams += "Trn_city="+getParam( request, "city")+"&";
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_zip\" value=\""+getParam( request, "zip")+"\">";
        transitParams += "Trn_zip="+getParam( request, "zip")+"&";
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_state\" value=\""+getParam( request, "state")+"\">";
        transitParams += "Trn_state="+getParam( request, "state")+"&";
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_category_id\" value=\""+getParam( request, "category_id")+"\">";
        transitParams += "Trn_category_id="+getParam( request, "category_id")+"&";
        pitem_id = getParam( request, "item_id");
      }
      else {
        // Load primary key, form parameters and form fields
        flditem_id = getParam( request, "item_id");
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_address\" value=\""+getParam( request, "Trn_address")+"\">";
        transitParams += "Trn_address="+getParam( request, "Trn_address")+"&";
        
        fldname = getParam( request, "Trn_name");
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_name\" value=\""+getParam( request, "Trn_name")+"\">";
        transitParams += "Trn_name="+getParam( request, "Trn_name")+"&";
        
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_city\" value=\""+getParam( request, "Trn_city")+"\">";
        transitParams += "Trn_city="+getParam( request, "Trn_city")+"&";
        
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_zip\" value=\""+getParam( request, "Trn_zip")+"\">";
        transitParams += "Trn_zip="+getParam( request, "Trn_zip")+"&";
        
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_state\" value=\""+getParam( request, "Trn_state")+"\">";
        transitParams += "Trn_state="+getParam( request, "Trn_state")+"&";
        
        transitParamsHidden += "<input type=\"hidden\" name=\"Trn_category_id\" value=\""+getParam( request, "Trn_category_id")+"\">";
        transitParams += "Trn_category_id="+getParam( request, "Trn_category_id")+"&";
        
        pitem_id = getParam( request, "PK_item_id");
      }

      
      if ( isEmpty(pitem_id)) { bPK = false; }
      
      sWhere += "item_id=" + toSQL(pitem_id, adNumber);
      primaryKeyParams += "<input type=\"hidden\" name=\"PK_item_id\" value=\""+pitem_id+"\"/>";

      sSQL = "select * from items where " + sWhere;


      out.println("    <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">");
      out.println("     <tr>\n      <td align=\"center\" bgcolor=\"#99CCFF\" colspan=\"2\"><font style=\"font-size: 12pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Entry</font></td>\n     </tr>");
      if ( ! sEntryViewErr.equals("")) {
        out.println("     <tr>\n      <td bgcolor=\"#F5F5F5\" colspan=\"2\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+sEntryViewErr+"</font></td>\n     </tr>");
      }
      sEntryViewErr="";
      out.println("     <form method=\"get\" action=\""+sFileName+"\" name=\"EntryView\">");

      java.sql.ResultSet rs = null;

      if ( bPK &&  ! (sAction.equals("insert") && "EntryView".equals(sForm))) {

        // Open recordset
        rs = openrs( stat, sSQL);
        rs.next();
        String[] aFields = getFieldsName( rs );
        getRecordToHash( rs, rsHash, aFields );
        rs.close();
        flditem_id = (String) rsHash.get("item_id");
        fldname = (String) rsHash.get("name");
        fldaddress = (String) rsHash.get("address");
        fldcity = (String) rsHash.get("city");
        fldstate = (String) rsHash.get("state");
        fldzip = (String) rsHash.get("zip");
        fldcategory_id = (String) rsHash.get("category_id");
        fldphone = (String) rsHash.get("phone");
        fldemail = (String) rsHash.get("email");
        fldurl = (String) rsHash.get("url");
        fldnotes = (String) rsHash.get("notes");

        if (sAction.equals("") || ! "EntryView".equals(sForm)) {
      
          flditem_id = (String) rsHash.get("item_id");
          fldname = (String) rsHash.get("name");
          fldaddress = (String) rsHash.get("address");
          fldcity = (String) rsHash.get("city");
          fldstate = (String) rsHash.get("state");
          fldzip = (String) rsHash.get("zip");
          fldcategory_id = (String) rsHash.get("category_id");
          fldphone = (String) rsHash.get("phone");
          fldemail = (String) rsHash.get("email");
          fldurl = (String) rsHash.get("url");
          fldnotes = (String) rsHash.get("notes");
        }
        else {
          flditem_id = (String) rsHash.get("item_id");
          fldname = (String) rsHash.get("name");
          fldaddress = (String) rsHash.get("address");
          fldcity = (String) rsHash.get("city");
          fldstate = (String) rsHash.get("state");
          fldzip = (String) rsHash.get("zip");
          fldcategory_id = (String) rsHash.get("category_id");
          fldphone = (String) rsHash.get("phone");
          fldemail = (String) rsHash.get("email");
          fldurl = (String) rsHash.get("url");
          fldnotes = (String) rsHash.get("notes");
        }
        
      }
      else {
        if ( "".equals(sEntryViewErr)) {
          fldname = toHTML(getParam(request,"name"));
          fldaddress = toHTML(getParam(request,"address"));
          fldcity = toHTML(getParam(request,"city"));
          fldstate = toHTML(getParam(request,"state"));
          fldzip = toHTML(getParam(request,"zip"));
          fldcategory_id = toHTML(getParam(request,"category_id"));
        }
      }
      
      // Set lookup fields
          fldcategory_id = dLookUp( stat, "categories", "name", "category_id=" + toSQL(fldcategory_id, adNumber));
      if ( "".equals(sEntryViewErr)) {
      
fldemail="<a href=mailto:" + fldemail + ">" + fldemail + "</a>";
      }


      // Show form field
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Name</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldname)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Address</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldaddress)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">City</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldcity)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">State</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldstate)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">ZIP</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldzip)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Category</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldcategory_id)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Phone</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldphone)+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">E-mail</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+fldemail+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">URL</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<a href=\""+(String) rsHash.get("url")+"\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+fldurl+"</font></a>");

      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Notes</font></td><td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+fldnotes+"&nbsp;</font>");
      out.println("</td>\n     </tr>");
      
      out.print("     <tr>\n      <td colspan=\"2\" align=\"right\">");
      

      if ( bPK && ! (sAction.equals("insert") && "EntryView".equals(sForm))) {
        out.print("<input type=\"submit\" value=\"Back\" onclick=\"document.EntryView.FormAction.value = 'cancel';\">");
        out.print("<input type=\"hidden\" name=\"FormName\" value=\"EntryView\"><input type=\"hidden\" value=\"\" name=\"FormAction\">");
      }
      out.print("<input type=\"hidden\" name=\"item_id\" value=\""+toHTML(flditem_id)+"\">");
      out.print(transitParamsHidden+requiredParams+primaryKeyParams);
      out.println("</td>\n     </tr>\n     </form>\n    </table>");
      



    }
    catch (Exception e) { out.println(e.toString()); }
  } %>