?? entries.jsp
字號:
out.println("</td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldaddress)+" </font>");
out.println("</td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldcity)+" </font>");
out.println("</td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldstate)+" </font>");
out.println("</td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(fldzip)+" </font>");
out.println("</td>");
out.print(" <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>");
out.println(" </tr>");
iCounter++;
}
if (iCounter == 0) {
// Recordset is empty
out.println(sNoRecords);
iCounter = RecordsPerPage+1;
bIsScroll = false;
}
else {
// Parse scroller
boolean bInsert = false;
boolean bNext = rs.next();
if ( !bNext && iPage == 1 ) {
}
else {
out.print(" <tr>\n <td colspan=\"6\" bgcolor=\"#FFD9E5\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">");
if ( iPage == 1 ) {
out.print("\n <a href_=\"#\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Previous</font></a>");
}
else {
out.print("\n <a href=\""+sFileName+"?"+formParams+sSortParams+"FormEntries_Page="+(iPage - 1)+"#Form\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Previous</font></a>");
}
out.print("\n [ "+iPage+" ]");
if (!bNext) {
out.print("\n <a href_=\"#\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Next</font></a><br>");
}
else {
out.print("\n <a href=\""+sFileName+"?"+formParams+sSortParams+"FormEntries_Page="+(iPage + 1)+"#Form\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Next</font></a><br>");
}
out.println("</td>\n </tr>");
}
}
if ( rs != null ) rs.close();
out.println(" </table>");
}
catch (Exception e) { out.println(e.toString()); }
}
void Search_Show (javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, javax.servlet.http.HttpSession session, javax.servlet.jsp.JspWriter out, String sSearchErr, String sForm, String sAction, java.sql.Connection conn, java.sql.Statement stat) throws java.io.IOException {
try {
String fldname="";
String fldaddress="";
String fldcity="";
String fldstate="";
String fldzip="";
String sSQL="";
String transitParams = "";
String sQueryString = "";
String sPage = "";
out.println(" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">");
out.println(" <tr>\n <td align=\"center\" bgcolor=\"#99CCFF\" colspan=\"11\"><a name=\"Search\"><font style=\"font-size: 12pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Search</font></a></td>\n </tr>");
out.println(" <form method=\"get\" action=\"Entries.jsp\" name=\"Search\">\n <tr>");
// Set variables with search parameters
fldname = getParam( request, "name");
fldaddress = getParam( request, "address");
fldcity = getParam( request, "city");
fldstate = getParam( request, "state");
fldzip = getParam( request, "zip");
// Show fields
out.println(" <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Name</font></td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<input type=\"text\" name=\"name\" maxlength=\"100\" value=\""+toHTML(fldname)+"\" size=\"50\">");
out.println("</td>\n </tr>\n <tr>");
out.println(" <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Address</font></td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<input type=\"text\" name=\"address\" maxlength=\"255\" value=\""+toHTML(fldaddress)+"\" size=\"50\">");
out.println("</td>\n </tr>\n <tr>");
out.println(" <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">City</font></td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<input type=\"text\" name=\"city\" maxlength=\"50\" value=\""+toHTML(fldcity)+"\" size=\"50\">");
out.println("</td>\n </tr>\n <tr>");
out.println(" <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">State</font></td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<input type=\"text\" name=\"state\" maxlength=\"2\" value=\""+toHTML(fldstate)+"\" size=\"2\">");
out.println("</td>\n </tr>\n <tr>");
out.println(" <td bgcolor=\"#FFFF99\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">ZIP</font></td>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<input type=\"text\" name=\"zip\" maxlength=\"10\" value=\""+toHTML(fldzip)+"\" size=\"10\">");
out.println("</td>\n </tr>\n <tr>");
out.println(" <td align=\"right\" colspan=\"3\"><input type=\"submit\" value=\"Search\"/></td>");
out.println(" </tr>\n </form>\n </table>");
out.println("");
}
catch (Exception e) { out.println(e.toString()); }
}
void Total_Show (javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, javax.servlet.http.HttpSession session, javax.servlet.jsp.JspWriter out, String sTotalErr, String sForm, String sAction, java.sql.Connection conn, java.sql.Statement stat) throws java.io.IOException {
String sWhere = "";
int iCounter=0;
int iPage = 0;
boolean bIsScroll = true;
boolean hasParam = false;
String sOrder = "";
String sSQL="";
String transitParams = "";
String sQueryString = "";
String sPage = "";
int RecordsPerPage = 20;
String sSortParams = "";
String formParams = "";
String paddress="";
String pcategory_id="";
String pcity="";
String pname="";
String pstate="";
String pzip="";
formParams = "category_id=" + toURL(getParam( request, "category_id")) + "&city=" + toURL(getParam( request, "city")) + "&name=" + toURL(getParam( request, "name")) + "&zip=" + toURL(getParam( request, "zip")) + "&address=" + toURL(getParam( request, "address")) + "&state=" + toURL(getParam( request, "state")) + "&";
// Build WHERE statement
//-- Check address parameter and create a valid sql for where clause
paddress = getParam( request, "address");
if (paddress != null && ! paddress.equals("")) {
hasParam = true;
sWhere += "i.address like '%" + replace(paddress, "'", "''") + "%'";
}
//-- Check category_id parameter and create a valid sql for where clause
pcategory_id = getParam( request, "category_id");
if ( ! isNumber (pcategory_id)) {
pcategory_id = "";
}
if (pcategory_id != null && ! pcategory_id.equals("")) {
if (! sWhere.equals("")) sWhere += " and ";
hasParam = true;
sWhere += "i.category_id=" + pcategory_id;
}
//-- Check city parameter and create a valid sql for where clause
pcity = getParam( request, "city");
if (pcity != null && ! pcity.equals("")) {
if (! sWhere.equals("")) sWhere += " and ";
hasParam = true;
sWhere += "i.city like '%" + replace(pcity, "'", "''") + "%'";
}
//-- Check name parameter and create a valid sql for where clause
pname = getParam( request, "name");
if (pname != null && ! pname.equals("")) {
if (! sWhere.equals("")) sWhere += " and ";
hasParam = true;
sWhere += "i.name like '%" + replace(pname, "'", "''") + "%'";
}
//-- Check state parameter and create a valid sql for where clause
pstate = getParam( request, "state");
if (pstate != null && ! pstate.equals("")) {
if (! sWhere.equals("")) sWhere += " and ";
hasParam = true;
sWhere += "i.state like '%" + replace(pstate, "'", "''") + "%'";
}
//-- Check zip parameter and create a valid sql for where clause
pzip = getParam( request, "zip");
if (pzip != null && ! pzip.equals("")) {
if (! sWhere.equals("")) sWhere += " and ";
hasParam = true;
sWhere += "i.zip like '%" + replace(pzip, "'", "''") + "%'";
}
if (hasParam) { sWhere = " WHERE (" + sWhere + ")"; }
// Build full SQL statement
sSQL = "select i.address as i_address, " +
"i.category_id as i_category_id, " +
"i.city as i_city, " +
"i.item_id as i_item_id, " +
"i.name as i_name, " +
"i.state as i_state, " +
"i.zip as i_zip " +
" from items i ";
sSQL="select count(item_id) as i_item_id from items as i";
sSQL = sSQL + sWhere + sOrder;
String sNoRecords = " <tr>\n <td colspan=\"1\" bgcolor=\"#F5F5F5\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">No records</font></td>\n </tr>";
String tableHeader = "";
tableHeader = " <tr>\n <td colspan=\"1\" bgcolor=\"#FFD9E5\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica; font-weight: bold\">Items found:</font></td>\n </tr>";
try {
out.println(" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">");
out.println(tableHeader);
}
catch (Exception e) {}
try {
java.sql.ResultSet rs = null;
// Open recordset
rs = openrs( stat, sSQL);
iCounter = 0;
java.util.Hashtable rsHash = new java.util.Hashtable();
String[] aFields = getFieldsName( rs );
// Show main table based on recordset
while ( rs.next() ) {
getRecordToHash( rs, rsHash, aFields );
String flditem_id = (String) rsHash.get("i_item_id");
out.println(" <tr>");
out.print(" <td bgcolor=\"#F5F5F5\">"); out.print("<font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"+toHTML(flditem_id)+" </font>");
out.println("</td>");
out.println(" </tr>");
iCounter++;
}
if (iCounter == 0) {
// Recordset is empty
out.println(sNoRecords);
iCounter = RecordsPerPage+1;
bIsScroll = false;
}
if ( rs != null ) rs.close();
out.println(" </table>");
}
catch (Exception e) { out.println(e.toString()); }
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -