<%@ page import="java.sql.*,java.util.Date,java.util.Calendar,java.text.*,java.net.URLDecoder,java.util.StringTokenizer"%> RAC Software Tools Directory <% String strSubject = ""; String sqlStatement = ""; String strReturn = ""; String strBack = ""; String strForward = ""; String strSaveEntry = ""; int intCatcode; String strRequest = request.getQueryString() + " "; try { Class theDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver.class; Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://xxx.xx.xx.xx:1433;","", ""); ResultSet theSet; Statement theStatement; Calendar cal = Calendar.getInstance(); cal.setTime(new Date()); cal.add(Calendar.DATE, -30); Date markDay = cal.getTime(); sqlStatement = "SELECT DISTINCT reference.* "; sqlStatement = sqlStatement + "FROM reference, rcat_t "; sqlStatement = sqlStatement + "WHERE reference.ref_id = rcat_t.rcat_ref_id "; sqlStatement = sqlStatement + "AND reference.ref_valid = 'X' "; sqlStatement = sqlStatement + "AND ref_status LIKE 'Active' "; StringTokenizer st = new StringTokenizer(strRequest,"&"); String strType = st.nextToken() + ""; String strCategories = st.nextToken() + ""; int intStart = Integer.valueOf(st.nextToken() + "").intValue(); int intEnd = intStart + 10; strRequest = st.nextToken() + ""; while (st.hasMoreTokens()) { strSaveEntry = strSaveEntry + st.nextToken() + "&"; } strSaveEntry = strSaveEntry.substring(0,strSaveEntry.length()-1); strRequest = URLDecoder.decode(strRequest); if(strType.equals("Search")){ strSubject = "Search results for \"" + strRequest.trim() + "\""; strRequest = strRequest.replace("'","''"); sqlStatement = sqlStatement + "AND ((reference.ref_title LIKE '%" + strRequest.trim() + "%') OR (reference.ref_longdesc LIKE '%" + strRequest.trim() + "%') OR (reference.ref_keywords LIKE '%" + strRequest.trim() + "%')) "; } else if (strType.equals("New")){ strSubject = strRequest; SimpleDateFormat formatter = new SimpleDateFormat ("MM/dd/yyyy"); String strDate = formatter.format(markDay); sqlStatement = sqlStatement + "AND ref_ent_date >= '" + strDate.trim() + "' "; } else strSubject = strRequest; sqlStatement = sqlStatement + "AND rcat_t.rcat_cat_id in (" + strCategories.trim() + ") "; sqlStatement = sqlStatement + " ORDER BY ref_title"; theStatement = conn.createStatement(); theSet = theStatement.executeQuery(sqlStatement); int intRecCount = 0; int intPageCount = 0;%> <% if(theSet != null){ while(theSet.next()){ if (intRecCount % 2 == 0) out.println("
<%=strSubject%>
New Search

"); else out.println("
"); //parse the data String strTitle = theSet.getString("ref_title"); String strDescription = theSet.getString("ref_desc"); String strCompany = theSet.getString("ref_company"); String strAddress1 = theSet.getString("ref_address"); String strAddress2 = theSet.getString("ref_address2"); String strPhone = theSet.getString("ref_phone"); String strCity = theSet.getString("ref_city"); String strState = theSet.getString("ref_state"); String strZip = theSet.getString("ref_zip"); String strCntry = theSet.getString("ref_cntry"); String strFax = theSet.getString("ref_fax"); String strEmail = theSet.getString("ref_email"); String strWeblink = theSet.getString("ref_weblink"); String strhsRequire = theSet.getString("ref_hsreq"); String strProdurl = theSet.getString("ref_demourl"); String strInterface = theSet.getString("ref_interface"); Date entDate = theSet.getDate("ref_ent_date"); if (entDate != null){ if (entDate.after(markDay)) out.println("
" + strTitle.trim() + "
"); else out.println("
" + strTitle.trim() + "
"); } else out.println("
" + strTitle.trim() + "
"); if(strDescription == null)strDescription = "No Description Available"; out.println("" + strDescription.trim() + "
"); out.println("
    "); if (strhsRequire != null) out.println("
  • Hard/Software Req.: " + strhsRequire.trim() + ""); else out.println("
  • Hard/Software Req.: N/A"); if (strInterface != null) out.println("
  • Interface Capabilities: " + strInterface.trim() + ""); else out.println("
  • Interface Capabilities: N/A"); if (strCompany != null){ if (strWeblink != null) out.println("
  • Supplier: " + strCompany.trim() + ""); else out.println("
  • Supplier: " + strCompany.trim() + ""); } else out.println("
  • Supplier: N/A"); if (strAddress1 != null){ String strFulladdress = strAddress1.trim(); if(strAddress2 != null)strFulladdress = strFulladdress + " " + strAddress2.trim(); if(strCity != null)strFulladdress = strFulladdress + " " + strCity.trim(); if(strState != null)strFulladdress = strFulladdress + " " + strState.trim(); if(strZip != null)strFulladdress = strFulladdress + " " + strZip.trim(); if(strCntry != null)strFulladdress = strFulladdress + " " + strCntry.trim(); out.println("
  • Address: " + strFulladdress.trim() + ""); } else out.println("
  • Address: N/A"); if (strPhone != null) out.println("
  • Phone: " + strPhone.trim() + ""); else out.println("
  • Phone: N/A"); if (strFax != null) out.println("
  • FAX: " + strFax.trim() + ""); else out.println("
  • FAX: N/A"); if (strEmail != null) out.println("
  • E-mail: " + strEmail.trim() + ""); else out.println("
  • E-mail: N/A"); if (strProdurl != null){ out.println("
  • Product URL: "); if (strProdurl.length() > 40) strProdurl = strProdurl.substring(0,39) + "..."; out.println(strProdurl.trim() + ""); } else out.println("
  • Product URL: N/A"); out.println("
"); intRecCount++; }//while }//if conn.close(); } catch (SQLException se){ out.println("vendor code: " + se.getErrorCode()); out.println("Message: " + se.getMessage()); out.println("SQLState: " + se.getSQLState()); out.println("SQL: " + sqlStatement); } %>