?? entryview.jsp
字號:
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)+" </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)+" </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)+" </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)+" </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)+" </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)+" </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)+" </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+" </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+" </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()); }
} %>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -