advanced code snippet search

Posted By

jerryvig on 09/30/11


Tagged

java auctions gov


Versions (?)

Gov Auctions 16

 / Published in: Java
 

version 17. 9/29/2011

Expand | Embed | Plain Text 
  1. package com.mktneutral;
  2.  
  3. import java.io.IOException;
  4. import java.util.List;
  5. import java.util.ArrayList;
  6. import java.util.HashMap;
  7. import java.sql.Connection;
  8. import java.sql.Statement;
  9. import java.sql.DriverManager;
  10. import java.sql.SQLException;
  11. import java.net.URL;
  12. import java.net.MalformedURLException;
  13. import java.net.HttpURLConnection;
  14. import java.net.URLEncoder;
  15. import java.io.OutputStreamWriter;
  16. import java.io.InputStreamReader;
  17. import java.io.BufferedReader;
  18. import java.io.BufferedWriter;
  19. import java.io.FileWriter;
  20. import java.io.OutputStream;
  21. import java.util.regex.Pattern;
  22. import org.htmlparser.Parser;
  23. import org.htmlparser.Node;
  24. import org.htmlparser.util.NodeList;
  25. import org.htmlparser.util.ParserException;
  26.  
  27. public class GovAuctions {
  28.     private static String searchString;
  29.     private static String responseData; 
  30.     private static Connection hsql;
  31.     private static Statement stmt;
  32.     private static String searchState;
  33.     private static HashMap<String,String> stateMap;
  34.  
  35.     public static void main( String[] args ) {
  36. 	String resp = runScrapers("gold",16,"ALL");
  37. 	System.out.println( resp );        
  38.     }
  39.  
  40.     public static String runScrapers( String _searchString, int searchEngineInt, String _searchState ) { 
  41. 	try {
  42. 	   Class.forName("org.hsqldb.jdbcDriver");
  43. 	} catch ( ClassNotFoundException cnfe ) { cnfe.printStackTrace(); }
  44.  
  45.         String[] stateNameList = { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "District of Columbia", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming", "American Samoa", "Guam", "Northern Mariana Islands", "Puerto Rico" };
  46.         String[] stateAbbrevList = { "AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "DC", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM", "NY", "NC", "ND", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY", "AS", "GU", "MP", "PR" };
  47.  
  48.         stateMap = new HashMap<String,String>();
  49.         for ( int i=0; i<stateNameList.length; i++ ) {
  50. 	   stateMap.put( stateAbbrevList[i], stateNameList[i] );
  51.         }
  52.  
  53. 	hsql = null;
  54. 	try {
  55. 	   hsql = DriverManager.getConnection( "jdbc:hsqldb:file:govauctionsdb", "SA", "" );
  56. 	}
  57. 	catch ( SQLException sqle ) { sqle.printStackTrace(); }
  58.  
  59. 	try {
  60. 	    stmt = hsql.createStatement();
  61. 	    stmt.executeUpdate( "DROP TABLE IF EXISTS auction_records" );
  62. 	    stmt.executeUpdate( "CREATE TABLE auction_records ( website VARCHAR(64), url VARCHAR(1024), results_content VARCHAR(1536) )" );
  63. 	} catch ( SQLException sqle ) { sqle.printStackTrace(); }
  64.  
  65. 	searchState = _searchState;
  66. 	searchString = _searchString;
  67.  
  68. 	responseData = "";
  69.  
  70. 	if ( searchEngineInt == 0 ) {
  71. 	    GovLiquidation();  
  72. 	}
  73. 	if ( searchEngineInt == 1 ) {
  74. 	    GSAAuctions();
  75. 	}
  76. 	if ( searchEngineInt == 2 ) {
  77. 	    IRSAuctions(); 
  78. 	}
  79. 	if ( searchEngineInt == 3 ) {
  80. 	    BidCorp();
  81. 	}
  82. 	if ( searchEngineInt == 4 ) {
  83. 	    bid4Assets();
  84. 	}
  85.        	if ( searchEngineInt == 5 ) {
  86. 	    BankruptcySales();
  87. 	}
  88.        	if ( searchEngineInt == 6 ) {
  89. 	    PublicSurplus();
  90. 	}
  91.        	if ( searchEngineInt == 7 ) {
  92. 	    GovernmentAuction();
  93. 	}
  94.        	if ( searchEngineInt == 8 ) {
  95. 	    HomeSteps();
  96. 	}
  97.        	if ( searchEngineInt == 9 ) {
  98. 	    HomePath();
  99. 	}
  100.        	if ( searchEngineInt == 10 ) {
  101. 	    HomeSalesGov();
  102. 	}
  103.        	if ( searchEngineInt == 17 ) {
  104. 	    HudHomeStore();
  105. 	}
  106.        	if ( searchEngineInt == 11 ) {
  107. 	    GSAGov();
  108. 	}
  109.        	if ( searchEngineInt == 12 ) {
  110. 	    GovSales();
  111. 	}
  112.        	if ( searchEngineInt == 13 ) {
  113. 	    LonestarOnline();
  114. 	}
  115.        	if ( searchEngineInt == 14 ) {
  116. 	    GovDeals();
  117. 	}
  118.        	if ( searchEngineInt == 15 ) {
  119. 	    IllinoisIbid();
  120. 	}
  121.        	if ( searchEngineInt == 16 ) {
  122. 	    PropertyRoom();
  123. 	}
  124.  
  125. 	try {
  126. 	    hsql.close();
  127. 	} 
  128. 	catch ( SQLException sqle ) { sqle.printStackTrace(); }
  129.  
  130. 	return responseData;
  131.     }
  132.  
  133.     public static void GovLiquidation() {
  134.        String location = "";
  135.        String ntt = "";
  136.        String ntk = "";
  137.  
  138.        if ( !searchState.equals("ALL") ) {
  139.            ntt = "US_" + searchState + "|" + searchString;
  140.            location = "&location=US_" + searchState;
  141.            ntk = "P_Auction_Country_State|P_Lot_Title";
  142.        }
  143.        else { 
  144.           ntt = searchString;
  145.           location = "";
  146.           ntk = "P_Lot_Title"; 
  147.        }
  148.  
  149.        String message = "Ntt=" + ntt + "&Ntk=" + ntk + "&Ntx=mode+matchall|mode+matchall&N=0&Nty=1&Ns=P_Lot_Number|0" + location + "&words=" + searchString + "&cmd=keyword";
  150.  
  151.        try {
  152.         URL theUrl = new URL( "http://www.govliquidation.com/auction/endecaSearch?" + message );
  153.         String resp = "";        
  154.         BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  155.         String line;
  156.         while ((line = reader.readLine()) != null) {
  157. 	    resp += line;
  158.         }
  159.         reader.close();
  160.  
  161.         int startIdx = resp.indexOf("<TABLE CELLSPACING=\"0\" CELLPADDING=\"0\" border=\"0\" WIDTH=\"748\" ALIGN=\"CENTER\" id=\"lots_table\">");
  162.         int endIdx = resp.indexOf("<!-- Load the Brightcove JavaScript API -->");
  163.  
  164.         Parser htmlParser = new Parser();
  165.         if ( endIdx > 0 && startIdx > 0 ) {
  166.           try {
  167. 	     htmlParser.setInputHTML( resp.substring( startIdx, endIdx ) );  
  168.              NodeList nList = htmlParser.parse(null);
  169.              if ( nList.size() > 0 ) {
  170. 	       NodeList trList = nList.elementAt(0).getChildren();
  171.                for ( int i=0; i<trList.size(); i++ ) {
  172. 		   if ( trList.elementAt(i).getText().contains("resultsBackground1") || trList.elementAt(i).getText().contains("resultsBackground2") ) {
  173. 		     NodeList tdList = trList.elementAt(i).getChildren();
  174. 		     for ( int j=0; j<tdList.size(); j++ ) {
  175. 		       if ( (tdList.elementAt(j).getText()).trim().equals("TD VALIGN=\"top\" class=\"annotationText1\"") ) {
  176. 			  String resultsContent = (tdList.elementAt(j).toPlainTextString()).trim();
  177.                           resultsContent = resultsContent.replaceAll("\"", "'" );
  178. 			  resultsContent = resultsContent.replaceAll("\n", "");
  179.                           resultsContent = resultsContent.replaceAll("\t", "");
  180.  
  181. 			  NodeList aList = tdList.elementAt(j).getChildren();
  182.                           for ( int k=0; k<aList.size(); k++ ) {
  183. 			    if ( aList.elementAt(k).getText().contains("A HREF=\"http://www.govliquidation.com/auction/view") ) {
  184. 			       String anchorHref = aList.elementAt(k).getText().trim();
  185.                                String[] pieces = anchorHref.split("\"");
  186.                                anchorHref = pieces[1].trim();
  187.  
  188.                                try {
  189.                                  System.out.println( "INSERT INTO auction_records ( website, url, results_content ) VALUES ( 'http://www.govliquidation.com/', '" + anchorHref + "', '" +  resultsContent + "' )" );
  190.  
  191. 			          stmt.executeUpdate( "INSERT INTO auction_records ( website, url, results_content ) VALUES ( 'http://www.govliquidation.com/', '" + anchorHref + "', '" +  resultsContent + "' )" );
  192.                                } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  193.                             }   
  194.                           } 
  195.                        }   
  196.                      }
  197.                    }
  198.                }
  199.              }
  200.           } catch ( ParserException pe ) { pe.printStackTrace(); }
  201.         }
  202.        } catch ( MalformedURLException me ) { me.printStackTrace(); }
  203.        catch ( IOException ioe ) { ioe.printStackTrace(); }
  204.     }
  205.  
  206.     public static void GSAAuctions() {
  207.       if ( searchState.equals("ALL") ) {
  208.        try {
  209. 	String message = "Continue=" + URLEncoder.encode("Continue");       
  210.  
  211.         URL theUrl = new URL("http://gsaauctions.gov/gsaauctions/gsaauctions/");
  212.         HttpURLConnection conn = (HttpURLConnection) theUrl.openConnection();
  213.         conn.setDoOutput(true);
  214.         conn.setRequestMethod("POST");
  215.         conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");
  216.         conn.setRequestProperty("User-Agent","Mozilla/5.0");
  217.         OutputStream os = conn.getOutputStream();
  218.         os.write(message.getBytes("UTF-8"));
  219.         os.close();
  220.  
  221.         BufferedReader myReader = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  222.         String line;
  223.         String resp = "";
  224.         while ((line = myReader.readLine()) != null) {
  225. 	    resp += line;
  226.         }
  227.         myReader.close();
  228.  
  229.         int scIdx = resp.indexOf("name=\"scParam\" VALUE=\"");
  230.         if ( scIdx > 0 ) {
  231. 	  String[] pieces = resp.substring( scIdx+10, scIdx+80 ).split("VALUE=\"");
  232.           if ( pieces.length > 1 ) {          
  233. 	    String[] piecesII = pieces[1].split("\"");
  234. 	    String scParam =  piecesII[0].trim();
  235.  
  236.             int webPcmIdx = resp.indexOf("name=\"WEBPCMTRANSID\" VALUE=\"");
  237.             if ( webPcmIdx > 1 ) {
  238. 	       pieces = resp.substring( webPcmIdx+10, webPcmIdx+80 ).split("VALUE=\"");
  239.                if ( pieces.length > 0 ) {
  240. 		 piecesII = pieces[1].split("\"");
  241.                  String webPcmParam = piecesII[0].trim();
  242.  
  243.                  String msg2 = "scParam=" + URLEncoder.encode(scParam) + "&WEBPCMTRANSID=" + URLEncoder.encode( webPcmParam ) + "&sc=&scAction=" + URLEncoder.encode("AUCALSRH") + "&scRegn=&scSalNo=&scLotNo=&scQuery=&query=&order=&af2eq=&scCatCode=&scStCode=&scPassUpd=&scSrchDesc=" + URLEncoder.encode( searchString ) + "&scSrchDescCtxt=&catMenuNew=";
  244.  
  245.                  URL url2 = new URL("http://gsaauctions.gov/gsaauctions/aucindx");
  246.                  HttpURLConnection con2 = (HttpURLConnection) url2.openConnection();
  247.                  con2.setDoOutput(true);
  248.                  con2.setRequestMethod("POST");
  249.                  con2.setRequestProperty("Content-Type","application/x-www-form-urlencoded");
  250.                  con2.setRequestProperty("User-Agent","Mozilla/5.0");
  251.  
  252.                  OutputStream writer = con2.getOutputStream();
  253.                  writer.write(msg2.getBytes("UTF-8"));
  254. 	         writer.close();
  255.  
  256.                  BufferedReader leer = new BufferedReader(new InputStreamReader(con2.getInputStream()));
  257.                  line = "";
  258.                  resp = "";
  259.                  while ((line = leer.readLine()) != null) {
  260. 	          resp += line;
  261.                  }
  262.                  leer.close();
  263.  
  264.                  int startIdx = resp.indexOf("var tab=[");
  265.                  int endIdx = resp.indexOf("bldTr();"); 
  266.  
  267.                  pieces =  resp.substring( startIdx, endIdx ).split(Pattern.quote("["));
  268.                  if ( pieces.length > 1 ) {
  269.                    piecesII = pieces[1].split(Pattern.quote("]"));
  270. 		   pieces = piecesII[0].split("\",\"");
  271.  
  272.                    String resultsContent = "";
  273.                    String anchorHref = "";
  274.                    if ( pieces.length > 6 ) {
  275.                     for ( int j=0; j<pieces.length; j+=7 ) {
  276. 		     resultsContent = pieces[j].replace("\"","") + " " + pieces[j+1] + " " + pieces[j+2] + " " + pieces[j+3] + " " + pieces[j+4] + " " + pieces[j+5] + " " + pieces[j+6].replace("\",","");
  277.                      anchorHref = "javascript:itemSel('" + pieces[j+1].substring(0,11) + "','" + pieces[j+1].substring(11) + "');";
  278.                      try {
  279.                        stmt.executeUpdate( "INSERT INTO auction_records ( website, url, results_content ) VALUES ( 'http://gsaauctions.gov/', '" + anchorHref + "', '" + resultsContent + "' )" );
  280.                      } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  281. 		    }
  282.                    }
  283. 		 }
  284. 	       }
  285. 	    }
  286.           }
  287. 	}
  288.  
  289.        } catch ( MalformedURLException me ) { me.printStackTrace(); }
  290.        catch ( IOException ioe ) { ioe.printStackTrace(); }
  291.       }
  292.     }
  293.  
  294.     public static void IRSAuctions() {
  295.       if ( searchState.equals("ALL") ) {
  296.         try {         
  297. 	 URL theUrl = new URL("http://search.treas.gov/search?q=" + URLEncoder.encode(searchString) + "&output=xml_no_dtd&sort=date%3AD%3AL%3Ad1&ie=UTF-8&client=auctions&oe=UTF-8&proxystylesheet=auctions&site=Auctions");
  298.          String resp = "";        
  299.          BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  300.          String line;
  301.          while ((line = reader.readLine()) != null) {
  302. 	    resp += line;
  303.          }
  304.          reader.close();
  305.  
  306.          int startIdx =  resp.indexOf("<p><font size=\"-2\">");
  307.          int endIdx = resp.indexOf("In order to show you");
  308.  
  309.          if ( startIdx > 0 && endIdx > startIdx ) {
  310.            Parser htmlParser = new Parser();
  311.            try {
  312.              htmlParser.setInputHTML( resp.substring(startIdx,endIdx) );
  313.              NodeList nList = htmlParser.parse(null);
  314.  
  315.              for ( int i=0; i<nList.size(); i++ ) {
  316. 	      if ( nList.elementAt(i).getText().startsWith("p") ) {
  317. 		NodeList pChildList = nList.elementAt(i).getChildren();
  318.                 for ( int j=0; j<pChildList.size(); j++ ) {
  319. 		  String anchorHref = "";
  320. 		  if ( pChildList.elementAt(j).getText().startsWith("a href=\"http://www.treasury") ) {
  321. 		    String[] pieces = pChildList.elementAt(j).getText().split("\"");
  322.                     anchorHref = pieces[1].trim();      
  323.                   }
  324.                   if ( pChildList.elementAt(j).getText().startsWith("span class=\"s\"") ) {
  325. 		    String resultsContent = pChildList.elementAt(j).toPlainTextString().trim();
  326.                     resultsContent = resultsContent.replaceAll("\"", "");
  327. 		    resultsContent = resultsContent.replaceAll("\n", "");
  328.                     try {
  329.                       stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://search.treas.gov/', '" + anchorHref + "', '" + resultsContent + "' )" );
  330.                     } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  331.                   } 
  332.                 }   
  333.               }   
  334.              }            
  335.            } catch ( ParserException pe ) { pe.printStackTrace(); }                             
  336.          }
  337. 	} catch ( IOException ioe ) { ioe.printStackTrace(); }
  338.  
  339.       }
  340.     }
  341.  
  342.     public static void BidCorp() {
  343.       if ( searchState.equals("ALL" ) ) {
  344.         try {
  345. 	  URL theUrl = new URL("http://www.bidcorp.com/AdvancedSearch.aspx"); 
  346.           String resp = "";        
  347.           BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  348.           String line;
  349.           while ((line = reader.readLine()) != null) {
  350. 	    resp += line;
  351.           }
  352.           reader.close();
  353.  
  354.           int vsIdx = resp.indexOf("id=\"__VIEWSTATE\"");
  355.           int endIdx = resp.indexOf("=\" />");
  356.           String viewState = resp.substring(vsIdx,endIdx+1).split("value=\"")[1];
  357.           vsIdx = resp.indexOf("id=\"__EVENTVALIDATION\"");
  358.           endIdx = resp.indexOf("<table class=\"mainTable\""); 
  359. 	  String[] pieces = resp.substring(vsIdx,endIdx).split("value=\"");
  360.           String evtValidation = pieces[1].split("\"")[0].trim();
  361.  
  362.           String message = "__EVENTTARGET=&__EVENTARGUMENT=&__VIEWSTATE=" + URLEncoder.encode(viewState) + "&__EVENTVALIDATION=" + URLEncoder.encode(evtValidation) +  "&ctl00$ContentPlaceHolder1$txtKeywords=" + URLEncoder.encode( searchString ) + "&ctl00$ContentPlaceHolder1$rdoKeywordStatus=" + URLEncoder.encode("3") + "&ctl00$ContentPlaceHolder1$btnSubmitKeyword=" + URLEncoder.encode("Submit") + "&ctl00$ContentPlaceHolder1$txtLotNumber=";
  363.  
  364.           URL url2 = new URL("http://www.bidcorp.com/AdvancedSearch.aspx");
  365.           HttpURLConnection conn = (HttpURLConnection) url2.openConnection();
  366.           conn.setDoOutput(true);
  367.           conn.setRequestMethod("POST");
  368.           conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");
  369.           conn.setRequestProperty("User-Agent","Mozilla/5.0");
  370.  
  371.           OutputStream writer = conn.getOutputStream();
  372.           writer.write(message.getBytes("UTF-8"));
  373. 	  writer.close();
  374.  
  375.           BufferedReader myReader = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  376.           line = "";
  377.           resp = "";
  378.           while ((line = myReader.readLine()) != null) {
  379. 	     resp += line;
  380.           }
  381.           myReader.close();
  382.  
  383.           int startIdx = resp.indexOf("<table cellspacing=\"0\" cellpadding=\"4\"");
  384.           endIdx = resp.indexOf("<div style=\"margin: 5px; ");
  385.  
  386.           if ( startIdx > 0 && endIdx > startIdx ) { 
  387. 	    Parser htmlParser = new Parser();
  388.             try {
  389.               htmlParser.setInputHTML( resp.substring(startIdx,endIdx) );
  390.               NodeList nList = htmlParser.parse(null);
  391.               if ( nList.size() > 0 ) {
  392. 		NodeList trList = nList.elementAt(0).getChildren();
  393.                 for ( int i=0; i<trList.size(); i++ ) {
  394. 		  if ( trList.elementAt(i).getText().contains("bgcolor=\"White\"") || trList.elementAt(i).getText().contains("bgcolor=\"#CCCCCC\"") ) {
  395. 		     NodeList tdList = trList.elementAt(i).getChildren();
  396.                      if ( tdList.size() > 2 ) {
  397. 		        String resultsContent = (tdList.elementAt(2).toPlainTextString()).trim();
  398.                         resultsContent = resultsContent.replaceAll("\"", "");
  399. 		        resultsContent = resultsContent.replaceAll("\n", "");
  400.                         resultsContent = resultsContent.replaceAll("\t", ""); 
  401.  
  402.                         String[] piecesII = (tdList.elementAt(2).getChildren().elementAt(1).getText()).split("'");
  403.                         String anchorHref = "http://www.bidcorp.com/" + piecesII[1].trim();
  404.                         try {
  405.  
  406.                           stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.bidcorp.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  407.  
  408.                         } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  409.  
  410.                      }
  411.                   }             
  412.                 }
  413.               }
  414. 	    } catch ( ParserException pe ) { pe.printStackTrace(); }
  415.           }
  416.         } catch ( IOException ioe ) { ioe.printStackTrace(); }   
  417.       }
  418.     }
  419.  
  420.     public static void bid4Assets() {
  421. 	try { 
  422.             String stateSearch = "";
  423.             if ( searchState.equals("ALL") ) {
  424. 		stateSearch = "all"; }
  425.             else { stateSearch = searchState; }
  426.  
  427. 	    String message = "fuseaction=" + URLEncoder.encode("search") + "&type=" + URLEncoder.encode( "powerSearch" ) + "&criteria=" + URLEncoder.encode( searchString ) + "&keywordType=" + URLEncoder.encode( "allWords" ) + "&channel=" + URLEncoder.encode("all") + "&cat2=" + URLEncoder.encode("all") + "&cat3=" + URLEncoder.encode("all") + "&LocationChoice=" + URLEncoder.encode("1") + "&locatedState=" + URLEncoder.encode( stateSearch ) + "&ZIp=&ZipRadius=" + URLEncoder.encode("1") + "&assetstatus=" + URLEncoder.encode("Live") + "&DateHistory=" + URLEncoder.encode("6") + "&sort=" + URLEncoder.encode("bidCloseTime");
  428.  
  429. 	    URL theUrl = new URL( "http://www.bid4assets.com/search/index.cfm" );
  430. 	    HttpURLConnection connection = (HttpURLConnection) theUrl.openConnection();
  431. 	    connection.setDoOutput( true );
  432. 	    connection.setRequestMethod( "POST" );
  433. 	    connection.setRequestProperty( "Content-Type", "application/x-www-form-urlencoded" );
  434.  
  435. 	    OutputStream writer = connection.getOutputStream();
  436. 	    writer.write( message.getBytes("UTF-8") );
  437. 	    writer.close();
  438.  
  439. 	    BufferedReader reader = new BufferedReader(new InputStreamReader(connection.getInputStream()));
  440. 	    String line;
  441. 	    String responseContent = "";
  442.  
  443. 	    while ((line = reader.readLine()) != null) {
  444. 		responseContent += line;       
  445. 	    }
  446. 	    reader.close();
  447.  
  448. 	    int startIdx = responseContent.indexOf( "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">" );
  449. 	    int endIdx = responseContent.indexOf( "<!-- google_ad_section_end" ); 
  450.  
  451.             if ( startIdx<0 || endIdx<0 ) return;
  452.  
  453. 	    Parser htmlParser = new Parser();
  454. 	    try {
  455. 		//  System.out.println( startIdx + " " + endIdx );
  456. 	      if ( startIdx > 0 && endIdx > 0 ) { 
  457.  
  458. 		htmlParser.setInputHTML( responseContent.substring( startIdx, endIdx ) );
  459. 		NodeList nList = htmlParser.parse( null );               
  460.  
  461. 		if ( nList.size() > 4 ) {
  462.  
  463. 		   NodeList trList = nList.elementAt(4).getChildren();
  464.  
  465. 		   for ( int i=0; i<trList.size(); i++ ) {
  466. 		     if ( !trList.elementAt(i).toPlainTextString().trim().equals("") ) {
  467. 		       String resultsContent = trList.elementAt(i).toPlainTextString().trim();
  468.                        resultsContent = resultsContent.replaceAll("\"", "");
  469. 		       resultsContent = resultsContent.replaceAll("\n", " ");
  470.                        resultsContent = resultsContent.replaceAll("\t", " ");
  471.                        resultsContent = resultsContent.replace("\\", "");
  472.                        resultsContent = resultsContent.replaceAll("'", "");
  473.  
  474.                        NodeList tdList = trList.elementAt(i).getChildren();
  475.                       try {
  476.                        for ( int j=0; j<tdList.size(); j++ ) {
  477. 			 if ( tdList.elementAt(j).getText().contains("mediumArial02") ) {
  478. 			     NodeList aList = tdList.elementAt(j).getChildren();
  479.                              for ( int k=0; k<aList.size(); k++ ) {
  480. 			       if ( aList.elementAt(k).getText().contains("href") ) {
  481. 				 String href = aList.elementAt(k).getText().trim();
  482.  
  483.                                   String anchorHref = href.split("=\"")[1];
  484.                                   anchorHref = "http://www.bid4assets.com/" + anchorHref.substring(0,anchorHref.length()-1);                  
  485. 				  //System.out.println( "6" );
  486.                                   try {
  487.                                     stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.bid4assets.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  488.                                   } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  489.  
  490.                                }   
  491.                              }
  492.                          }
  493. 		       }
  494.                       } catch ( NullPointerException npe ) { npe.printStackTrace(); }
  495. 		     }
  496. 		   }
  497. 		}
  498. 	      }
  499. 	    } catch ( ParserException pe ) { pe.printStackTrace(); }      
  500. 	} catch ( IOException ioe ) { ioe.printStackTrace(); }
  501.     }
  502.  
  503.     public static void BankruptcySales() {
  504.       if ( searchState.equals("ALL" ) ) {
  505.        try {
  506. 	 String msg = "keyWord=" + URLEncoder.encode( searchString );
  507.  
  508.          URL theUrl = new URL("http://www.bankruptcysales.com/assets_search2.cfm"); 
  509.          HttpURLConnection conn = (HttpURLConnection) theUrl.openConnection();
  510.          conn.setDoOutput(true);        
  511.          conn.setRequestMethod("POST");
  512.          conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");           
  513.          conn.setRequestProperty("User-Agent","Mozilla/5.0"); 
  514.          OutputStream os = conn.getOutputStream();
  515.          os.write(msg.getBytes("UTF-8"));
  516.          os.close();
  517.  
  518.          BufferedReader lector = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  519.          String line;
  520.          String resp = "";
  521.          while ((line = lector.readLine())!= null) {
  522. 	   resp = resp.concat(line);
  523.          }
  524.          lector.close();
  525.  
  526.          int startIdx = resp.indexOf("<!-- InstanceBeginEditable name=\"Body\" -->");
  527.          int endIdx = resp.indexOf("CLASS=\"bottomLinks\"");
  528.  
  529.          Parser htmlParser = new Parser();
  530.          try {
  531. 	   htmlParser.setInputHTML( resp.substring(startIdx,endIdx) );
  532.            NodeList nList = htmlParser.parse(null);
  533.  
  534.            for ( int i=0; i<nList.size(); i++ ) {
  535. 	     if ( nList.elementAt(i).getText().startsWith("TABLE WIDTH=\"95%\"") ) {
  536. 	       NodeList nextChildren = nList.elementAt(i).getChildren();
  537.                for ( int j=0; j<nextChildren.size(); j++ ) {
  538. 		 if ( nextChildren.elementAt(j).getText().equals("TR") ) {
  539. 		   NodeList nxtChildren = nextChildren.elementAt(j).getChildren();
  540.                    if ( nxtChildren.size() > 0 ) {
  541. 		     NodeList pChildren = nxtChildren.elementAt(1).getChildren();
  542.                      for ( int k=0; k<pChildren.size(); k++ ) {
  543. 		       if ( pChildren.elementAt(k).getText().startsWith("TABLE WIDTH=\"95%\"") ) {
  544. 			  NodeList trList = pChildren.elementAt(k).getChildren();
  545.                           for ( int l=2; l<trList.size(); l++ ) {
  546. 			     if ( !trList.elementAt(l).toPlainTextString().trim().equals("") ) {
  547. 			       String resultsContent = trList.elementAt(l).toPlainTextString().trim();
  548.                                resultsContent = resultsContent.replaceAll("\t","");
  549.                                resultsContent = resultsContent.replaceAll("\n","");                                  
  550.                                while ( resultsContent.contains("  ") ) {
  551. 				  resultsContent = resultsContent.replaceAll("  ","");   
  552.                                }
  553.  
  554.                                String[] hrefCandidates = trList.elementAt(l).toHtml().split("HREF=\"");
  555.                                if ( hrefCandidates.length > 0 ) {
  556. 				  String anchorHref = hrefCandidates[1].split("\"")[0];
  557.                                   anchorHref = "http://www.bankruptcysales.com/" + anchorHref;
  558.                                   try {
  559. 				      //System.out.println(  "INSERT INTO auction_records VALUES ( 'http://www.bankruptcysales.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  560.                                      stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.bankruptcysales.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  561.                                   } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  562.                                }
  563.  
  564.                              }    
  565.                           }
  566.                        } 
  567.                      }   
  568.                    }
  569.                  }     
  570.                } 
  571.              }  
  572.            }
  573.  
  574.          } catch ( ParserException pe ) { pe.printStackTrace(); }
  575. 	} catch ( IOException ioe ) { ioe.printStackTrace(); }
  576.       }
  577.     }
  578.  
  579.     public static void PublicSurplus() {
  580.       try {
  581. 	String stateSearch = searchState;  
  582. 	if ( searchState.equals("ALL") ) stateSearch = "";
  583.  
  584. 	String message = "http://www.publicsurplus.com/sms/browse/search?posting=y&slth=&page=0&sortBy=timeLeft&keyWord=" + searchString + "&catId=-1&endHours=-1&startHours=-1&lowerPrice=0&higherPrice=0&milesLocation=-1&zipCode=&region=" + "all%2C" + stateSearch;
  585.  
  586. 	URL theUrl = new URL( message );
  587.         String resp = "";        
  588.         BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  589.         String line;
  590.         while ((line = reader.readLine()) != null) {
  591. 	   resp += line;
  592.         }
  593.         reader.close(); 
  594.  
  595.         int startIdx = resp.indexOf("<div class=\"SepTable\">");
  596.         int endIdx = resp.indexOf("Hide Images");
  597.  
  598.         if ( startIdx > 0 && endIdx > 0 ) {
  599.         //System.out.println( resp.substring(startIdx,endIdx) );
  600.  
  601.          Parser htmlParser = new Parser();
  602.          try {
  603. 	  htmlParser.setInputHTML(resp.substring(startIdx,endIdx));
  604.           NodeList nList = htmlParser.parse(null);   
  605.  
  606.           for ( int i=0; i<nList.size(); i++ ) {
  607. 	    if ( nList.elementAt(i).getText().equals("table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"5\" class=\"tabCurr\"") ) {
  608. 	       NodeList tHeadList = nList.elementAt(i).getChildren();
  609.                for ( int j=4; j<tHeadList.size(); j++ ) {
  610. 		 if ( tHeadList.elementAt(j).getText().startsWith("tr") ) {
  611. 		     String resultsContent = tHeadList.elementAt(j).toPlainTextString().trim();
  612. 		     resultsContent = resultsContent.replaceAll("&nbsp;","");
  613.                      resultsContent = resultsContent.replaceAll("\n","");
  614.                      resultsContent = resultsContent.replaceAll("\t","");
  615.                      while ( resultsContent.contains("  ") ) {
  616. 			 resultsContent = resultsContent.replaceAll("  "," ");
  617.                      }
  618.                      //System.out.println( resultsContent );
  619. 		     String[] pieces = tHeadList.elementAt(j).toHtml().split("href=\"");
  620.                      String[] piecesII = pieces[1].split("\"");
  621.                      String anchorHref = "http://www.publicsurplus.com" + piecesII[0].trim();
  622.                      try {
  623. 		        stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://http://www.publicsurplus.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  624.                      } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  625.                  }
  626.                } 
  627.             }  
  628.           }
  629.  
  630.          } catch ( ParserException pe ) { pe.printStackTrace(); }
  631. 	}
  632.       } catch ( IOException ioe ) { ioe.printStackTrace(); }    
  633.     }
  634.  
  635.     public static void GovernmentAuction() {
  636.       if ( searchState.equals("ALL" ) ) {
  637. 	String message = "http://auctions.governmentauction.com/view-auctions/individual-lots/?key=" + searchString + "&page=1&cat=&catm=any&order=timeleft&live=yes&timed=yes&regular=yes&buynow=yes&makeoffer=yes&auctioneer=&minprice=&maxprice=&items=48";
  638.         try {
  639. 	 URL theUrl = new URL( message );
  640.          String resp = "";        
  641.          BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  642.          String line;
  643.          while ((line = reader.readLine()) != null) {
  644. 	   resp += line;
  645.          }
  646.          reader.close(); 
  647.  
  648.          int startIdx = resp.indexOf("<div id=\"lac");
  649.          int endIdx = resp.indexOf("<div id=\"footer\">");
  650.  
  651.          if ( startIdx > 0 && endIdx > startIdx ) {
  652.          Parser prse = new Parser();
  653.          try {
  654. 	   prse.setInputHTML( resp.substring(startIdx,endIdx) );
  655.            NodeList nList = prse.parse(null);   
  656.  
  657.            for ( int i=0; i<nList.size(); i++ ) {
  658. 	     if ( nList.elementAt(i).getText().contains("id=\"lac") ) {
  659. 		NodeList divList = nList.elementAt(i).getChildren();
  660.                 for ( int j=0; j<divList.size(); j++ ) {
  661. 		  if ( divList.elementAt(j).getText().equals("div class=\"name\"") ) {
  662. 		    String resultsContent = divList.elementAt(j).toPlainTextString();
  663.                     resultsContent = resultsContent.replaceAll("\n","");
  664.                     resultsContent = resultsContent.replaceAll("\t","");
  665.                     while ( resultsContent.contains("  ") ) {
  666. 		       resultsContent = resultsContent.replaceAll("  "," ");
  667.                     }
  668.                     //System.out.println( resultsContent );
  669.                     String[] pieces = divList.elementAt(j).toHtml().split("href=\"");
  670.                     String[] piecesII = pieces[1].split("\"");
  671.                     String anchorHref = piecesII[0].trim();
  672.                     anchorHref = "http://auctions.governmentauction.com" + anchorHref;
  673.                     try {
  674. 		        stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://auctions.governmentauction.com', '" + anchorHref + "', '" + resultsContent + "' )" );
  675.                      } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  676.                   }  
  677.                 }
  678.              }
  679.            }
  680.          } catch ( ParserException pe ) { pe.printStackTrace(); }
  681.          } 
  682.         } catch ( IOException ioe ) { ioe.printStackTrace(); }
  683.       }
  684.     }
  685.  
  686.     public static void HomeSteps() {
  687.       if ( searchState.equals("ALL" ) ) {
  688. 	  return;
  689.       }
  690.       String msg = "City=&County=&State=" + URLEncoder.encode(searchState) + "&Zip=&PriceRangeLow=" + URLEncoder.encode("*") + "&PriceRangeHigh=" + URLEncoder.encode("*") + "&TotalRooms=" + URLEncoder.encode("*") + "&NumberBedrooms=" + URLEncoder.encode("*") + "&NumberBathrooms=" + URLEncoder.encode("*") + "&B1=Find Homes&IPP=50";
  691.  
  692.       try {
  693.         URL theUrl = new URL("http://www.homesteps.com/cgi-bin/dynamic/formsearch.cgi"); 
  694.         HttpURLConnection conn = (HttpURLConnection) theUrl.openConnection();
  695.         conn.setDoOutput(true);        
  696.         conn.setRequestMethod("POST");
  697.         conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");           
  698.         conn.setRequestProperty("User-Agent","Mozilla/5.0"); 
  699.         OutputStream os = conn.getOutputStream();
  700.         os.write(msg.getBytes("UTF-8"));
  701.         os.close();
  702.  
  703.         BufferedReader myReader = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  704.         String line;
  705.         String resp = "";
  706.         while ((line = myReader.readLine())!= null) {
  707.           resp = resp.concat(line);
  708.         }
  709.         myReader.close();
  710.  
  711.         int startIdx = resp.indexOf("<table cellpadding=1 cellspacing=1 class=tblHomesteps>");
  712.         int endIdx = resp.indexOf("Freddie Mac takes");
  713.  
  714.         Parser prsr = new Parser();
  715.         try {
  716. 	  prsr.setInputHTML(resp.substring(startIdx,endIdx));
  717.           NodeList nList = prsr.parse(null);
  718.           for ( int i=0; i<nList.size(); i++ ) {            
  719. 	    if ( nList.elementAt(i).getText().equals("table cellpadding=1 cellspacing=1 class=tblHomesteps") ) {
  720. 	       NodeList trList = nList.elementAt(i).getChildren();
  721.                for ( int j=2; j<trList.size(); j++ ) {
  722. 		 if ( trList.elementAt(j).getText().equals("tr") ) {
  723. 		    String resultsContent = trList.elementAt(j).toPlainTextString();
  724.                     resultsContent = resultsContent.replaceAll("\n","");
  725.                     resultsContent = resultsContent.replaceAll("\t","");
  726.                     while ( resultsContent.contains("  ") ) {
  727. 		       resultsContent = resultsContent.replaceAll("  "," ");
  728.                     }
  729.                     String anchorHref = "http://www.homesteps.com/featuresearch.html";
  730.                     try {
  731. 		        stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.homesteps.com/featuresearch.html', '" + anchorHref + "', '" + resultsContent + "' )" );
  732.                      } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  733.                  } 
  734.                }
  735.             }
  736.           }
  737.         } catch ( ParserException pe ) { pe.printStackTrace(); }
  738.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  739.     }
  740.  
  741.     public static void HomePath() {
  742.       if ( searchState.equals("ALL" ) ) {
  743. 	  return;
  744.       }
  745.  
  746.       String message = "http://www.homepath.com/search.html?st=" + searchState + "&cno=000&ci=&zip=&src_ref=&mlsid=&pi=&pa=&bdi=&bhi=&x=26&y=11&ms=&xs=";
  747.       try {
  748. 	 URL ubl = new URL( message );
  749.          String resp = "";        
  750.          BufferedReader reader = new BufferedReader(new InputStreamReader(ubl.openStream()));
  751.          String line;
  752.          while ((line = reader.readLine()) != null) {
  753. 	   resp += line;
  754.          }
  755.          reader.close(); 
  756.  
  757.          int startIdx = resp.indexOf("<table class=\"multipleLinesSearchResults\"");
  758.          int endIdx = resp.indexOf("Get FREE HomePath");
  759.  
  760.          if ( startIdx > 0 && endIdx > 0 ) {
  761. 	   Parser htmlParser = new Parser();
  762.            try {
  763. 	     htmlParser.setInputHTML(resp.substring(startIdx,endIdx));
  764.              NodeList nList = htmlParser.parse(null);
  765.  
  766.              for ( int i=0; i<nList.size(); i++ ) {
  767. 	       if ( nList.elementAt(i).getText().equals("table class=\"multipleLinesSearchResults\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"") ) {
  768. 		  NodeList trList = nList.elementAt(i).getChildren();
  769.                   for ( int j=0; j<trList.size(); j++ ) {
  770. 		    if ( trList.elementAt(j).getText().startsWith("tr class") ) {
  771. 		      String resultsContent = trList.elementAt(j).toPlainTextString().trim();
  772.                       resultsContent = resultsContent.replaceAll("\n","");
  773.                       resultsContent = resultsContent.replaceAll("\t","");
  774.                       resultsContent = resultsContent.replaceAll("&nbsp;","");
  775.                       resultsContent = resultsContent.replaceAll("SaveMap","");
  776.                       while ( resultsContent.contains("  ") ) {
  777. 		        resultsContent = resultsContent.replaceAll("  "," ");
  778.                       }
  779.                       //System.out.println( resultsContent );
  780.                       String[] pieces = trList.elementAt(j).toHtml().split("href=\"");
  781.                       String[] piecesII = pieces[1].split("\"");
  782.                       String anchorHref = piecesII[0].trim();
  783.                       anchorHref = anchorHref;
  784.                       anchorHref = "http://www.homepath.com" + anchorHref;
  785.                       if ( !resultsContent.equals("") ) {
  786.                         try {
  787. 		          stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.homepath.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  788.                         } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  789.                       }
  790.                     }  
  791.                   } 
  792.                }  
  793.              }
  794.            } catch ( ParserException pe ) { pe.printStackTrace(); }
  795. 	 }
  796.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  797.     }
  798.  
  799.     public static void HomeSalesGov() {
  800.       if ( searchState.equals("ALL" ) ) {
  801. 	  return;
  802.       }  
  803.       String msg = "selectedCities=" + URLEncoder.encode("ALL") + "&selBedrooms=&selBaths=&pageAction=" + URLEncoder.encode("Search for Properties") + "&stateName=" + URLEncoder.encode( stateMap.get(searchState) ) + "&state=" + URLEncoder.encode(searchState) + "&propertyType=" + URLEncoder.encode("RESIDENTIAL");
  804.       try {     
  805.         URL theUrl = new URL("http://www.homesales.gov/homesales/mainAction.do"); 
  806.         HttpURLConnection conn = (HttpURLConnection) theUrl.openConnection();
  807.         conn.setDoOutput(true);        
  808.         conn.setRequestMethod("POST");
  809.         conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");           
  810.         conn.setRequestProperty("User-Agent","Mozilla/5.0"); 
  811.         OutputStream os = conn.getOutputStream();
  812.         os.write(msg.getBytes("UTF-8"));
  813.         os.close();
  814.  
  815.         BufferedReader myReader = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  816.         String line;
  817.         String resp = "";
  818.         while ((line = myReader.readLine())!= null) {
  819.           resp = resp.concat(line);
  820.         }
  821.         myReader.close();
  822.  
  823.         int startIdx = resp.indexOf("<table width=\"80%\" align=\"center\" border=\"0\" rules=\"none\">");
  824.         int endIdx = resp.indexOf(" Total Result Pages:");
  825.  
  826.         if ( startIdx > 0 && endIdx > startIdx ) {
  827.          try {
  828. 	  Parser prs = new Parser();
  829.           prs.setInputHTML(resp.substring(startIdx,endIdx));
  830.  
  831.           NodeList nList = prs.parse(null);
  832.           for ( int i=0; i<nList.size(); i++ ) {     
  833. 	    if ( nList.elementAt(i).getText().startsWith("table width=\"80%\"") ) {
  834. 	       NodeList trList = nList.elementAt(i).getChildren();
  835.                for ( int j=0; j<trList.size(); j++ ) {
  836. 		 if ( trList.elementAt(j).getText().equals("tr") ) {
  837. 		    String resultsContent = trList.elementAt(j).toPlainTextString();
  838.                     resultsContent = resultsContent.replaceAll("&nbsp;","");
  839.                     resultsContent = resultsContent.replaceAll("\n","");
  840.                     resultsContent = resultsContent.replaceAll("\t","");
  841.                     while ( resultsContent.contains("  ") ) {
  842. 		       resultsContent = resultsContent.replaceAll("  "," ");
  843.                     }
  844.  
  845.                     String[] pieces = trList.elementAt(j).toHtml().split("href=\"");
  846.                     if ( pieces.length > 1 ) {
  847.                      String[] piecesII = pieces[1].split("\"");
  848.                      if ( piecesII.length > 0 ) {
  849.                       String anchorHref = piecesII[0].trim();
  850.                       anchorHref = anchorHref;
  851.                       try {
  852. 		        stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.homepath.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  853.                       } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  854.                      }
  855.                     }
  856.                  }  
  857.                }
  858.             }
  859.           }
  860.          } catch ( ParserException pe ) { pe.printStackTrace(); }
  861.         }
  862.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  863.     }
  864.  
  865.     public static void HudHomeStore() {
  866.       if ( searchState.equals("ALL" ) ) {
  867. 	  return;
  868.       }
  869.  
  870.       String message = "https://hudhomestore.secureportalk.net/HUD/PropertySearchResult.aspx?PageId=1&zipCode=&city=&county=&sState="+searchState+"&fromPrice=0&toPrice=0&caseNumber=&bed=0&bath=0&street=&buyerType=0&specialProgram=&Status=0&OrderbyName=SCASENUMBER&OrderbyValue=ASC&sPageSize=50";
  871.       try {
  872. 	 URL ubl = new URL( message );
  873.          String resp = "";        
  874.          BufferedReader reader = new BufferedReader(new InputStreamReader(ubl.openStream()));
  875.          String line;
  876.          while ((line = reader.readLine()) != null) {
  877. 	   resp += line;
  878.          }
  879.          reader.close(); 
  880.  
  881.          int startIdx = resp.indexOf("<tr class=\"FormTablerow\"");
  882.          int endIdx = resp.indexOf("<!-- =============  Data List");
  883.  
  884.          try {
  885. 	   Parser p = new Parser();
  886.            p.setInputHTML(resp.substring(startIdx,endIdx));           
  887.            NodeList nList = p.parse(null);
  888.            for ( int i=0; i<nList.size(); i++ ) {  
  889. 	     if ( nList.elementAt(i).getText().startsWith("tr class=\"FormTablerow") ) {
  890.                  String resultsContent = nList.elementAt(i).toPlainTextString();
  891.                  resultsContent = resultsContent.replaceAll("&nbsp;","");
  892.                  resultsContent = resultsContent.replaceAll("\n","");
  893.                  resultsContent = resultsContent.replaceAll("\t","");
  894.                  resultsContent = resultsContent.replaceAll("Exclusive","");
  895.                  resultsContent = resultsContent.replaceAll("View","");
  896.                  resultsContent = resultsContent.replaceAll("Street","");
  897.                  resultsContent = resultsContent.replaceAll("Map it","");
  898.                  resultsContent = resultsContent.replaceAll("Email","");
  899.                  resultsContent = resultsContent.replaceAll("Info","");
  900.                  resultsContent = resultsContent.replaceAll("Extended","");
  901.                  resultsContent = resultsContent.replaceAll("Lottery","");
  902.                  while ( resultsContent.contains("  ") ) {
  903. 		    resultsContent = resultsContent.replaceAll("  "," ");
  904.                  }
  905.                  //System.out.println( resultsContent );
  906.                  NodeList tdList = nList.elementAt(i).getChildren();
  907.                  for ( int j=0; j<tdList.size(); j++ ) {
  908. 		   if ( tdList.elementAt(j).getText().startsWith("td align=\"center\" valign=\"middle\"") ) {
  909. 		     NodeList aList = tdList.elementAt(j).getChildren();
  910.                      for ( int k=0; k<aList.size(); k++ ) {
  911. 		       if ( aList.elementAt(k).getText().startsWith("a href=\"#;\"") ) {
  912. 			   String[] pieces = aList.elementAt(k).getText().split(Pattern.quote("getGoogleTranslationstring(&#039;"));
  913.                          if ( pieces.length > 0 ) {
  914. 			   String[] piecesII = pieces[1].split(Pattern.quote("&#039;"));
  915.                            if ( piecesII.length > 0 ) {
  916. 			     String anchorHref = piecesII[0].trim();
  917.                              try {
  918. 			       System.out.println( "INSERT INTO auction_records VALUES ( 'http://www.hudhomestore.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  919. 		                stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.hudhomestore.com/', '" + anchorHref + "', '" + resultsContent + "' )" );
  920.                              } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  921.                            }  
  922.                          }  
  923.                        }  
  924.                      }  
  925.                    }   
  926.                  }
  927.              }                 
  928.            }
  929.          } catch ( ParserException pe ) { pe.printStackTrace(); }
  930.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  931.     }
  932.  
  933.     public static void GSAGov() {
  934.       if ( searchState.equals("ALL" ) ) {
  935. 	  return;
  936.       }
  937.  
  938.       String message = "https://extportal.pbs.gsa.gov/ResourceCenter/PRHomePage/searchProperty.do?state=5&amp;statename=" + stateMap.get(searchState).toUpperCase() +  "&amp;propType=&amp;propTypeName=ALL&amp;searchType=S";
  939.       try {
  940. 	 URL ubl = new URL( message );
  941.          String resp = "";        
  942.          BufferedReader reader = new BufferedReader(new InputStreamReader(ubl.openStream()));
  943.          String line;
  944.          while ((line = reader.readLine()) != null) {
  945. 	   resp += line;
  946.          }
  947.          reader.close(); 
  948.  
  949.          int startIdx = resp.indexOf("<div class=\"cmSectionText\">");
  950.          int endIdx = resp.indexOf("<!-- div cmSectionText -->");
  951.  
  952.         if ( startIdx > 0 && endIdx > startIdx ) {
  953. 	  Parser p = new Parser();
  954. 	  try {   
  955. 	    p.setInputHTML( resp.substring(startIdx,endIdx) );
  956.             NodeList nList = p.parse(null); 
  957.  
  958.             for ( int i=0; i<nList.size(); i++ ) {
  959. 	      if ( nList.elementAt(i).getText().startsWith("div class=\"cmSectionText\"") ) {
  960. 		NodeList divChildren = nList.elementAt(i).getChildren();
  961.                 for ( int j=0; j<divChildren.size(); j++ ) {
  962. 		  if ( divChildren.elementAt(j).getText().contains("D1D1D1") ) {
  963. 		    String resultsContent = divChildren.elementAt(j).toPlainTextString().trim();
  964.                     resultsContent = resultsContent.replaceAll("Click here for more information","");
  965.                     resultsContent = resultsContent.replaceAll("&nbsp;","");
  966.                     resultsContent = resultsContent.replaceAll("\n","");
  967.                     resultsContent = resultsContent.replaceAll("\t","");
  968.                     resultsContent = resultsContent.replaceAll("\"","");
  969.                     while ( resultsContent.contains("  ") ) {
  970. 		       resultsContent = resultsContent.replaceAll("  "," ");
  971.                     }  
  972.                     //System.out.println( resultsContent );  
  973.                     String htm = divChildren.elementAt(j).toHtml();
  974.                     //System.out.println( htm );  
  975.                     int hrefIdx = htm.indexOf("loadProperty.do");
  976.                     if ( hrefIdx > 0 ) {
  977. 		      String[] pieces = htm.substring(hrefIdx,hrefIdx+34).split(">");
  978.                       if ( pieces.length > 0 ) {
  979. 			 String anchorHref = pieces[0].substring(0,pieces[0].length()-1);
  980.                          anchorHref = "https://extportal.pbs.gsa.gov/ResourceCenter/PRHomePage/" + anchorHref;
  981.                           try {
  982. 			      //System.out.println( "INSERT INTO auction_records VALUES ( 'https://propertydisposal.gsa.gov/', '" + anchorHref + "', '" + resultsContent + "' )" );
  983. 		                stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'https://propertydisposal.gsa.gov/', '" + anchorHref + "', '" + resultsContent + "' )" );
  984.                           } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  985.                       }
  986.                     }
  987.                   } 
  988.                 } 
  989.               }  
  990.             }  
  991. 	  } catch ( ParserException pe ) { pe.printStackTrace(); }
  992.         }
  993.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  994.     }
  995.  
  996.     public static void GovSales() {
  997.       String msg = "http://www.govsales.gov/fassys/fassys/?function=010000000000";
  998.  
  999.       try {
  1000. 	URL ubl = new URL( msg );
  1001.         String resp = "";        
  1002.         BufferedReader reader = new BufferedReader(new InputStreamReader(ubl.openStream()));
  1003.         String line;
  1004.         while ((line = reader.readLine()) != null) {
  1005. 	   resp += line;
  1006.         }
  1007.         reader.close(); 
  1008.  
  1009.         String scParam = "";
  1010. 	int scParamIdx = resp.indexOf("name=scParam VALUE=\"");
  1011.         if ( scParamIdx > 0 ) {
  1012. 	   scParam = resp.substring(scParamIdx, scParamIdx+80);
  1013. 	   String[] pieces = scParam.split("VALUE=\"");
  1014.            if ( pieces.length > 1 ) {
  1015.              String[] piecesII = pieces[1].split("\"");
  1016.              if ( piecesII.length > 1 ) {
  1017. 		scParam = piecesII[0].trim();
  1018.              } 
  1019. 	   }
  1020.         }
  1021.         String webPcm = "";
  1022.         int webPcmIdx = resp.indexOf("WEBPCMTRANSID");
  1023.         if ( webPcmIdx > 0 ) {
  1024. 	   webPcm = resp.substring(webPcmIdx, webPcmIdx+40);
  1025.            String[] pieces = webPcm.split("VALUE=");
  1026.            if ( pieces.length > 1 ) {
  1027.              String[] piecesII =  pieces[1].split("\"");
  1028.              if ( piecesII.length > 1 ) {
  1029.                 webPcm = piecesII[1].trim();
  1030.              }  
  1031.            }
  1032.         }
  1033.  
  1034.         String msg2 = "scParam=" + URLEncoder.encode( scParam ) + "&scCurTabCat=" + URLEncoder.encode("010000000000") + "&scSelTabCat=" + URLEncoder.encode("010000000000") + "&scSelLink=" + URLEncoder.encode("GS") + "&scGSName=" + URLEncoder.encode( searchString.toUpperCase() ) + "&scGSOptn=" + URLEncoder.encode("1") + "&scSelState=&scSelBCCat=&scSelRow=&scSelCatList=&scSeeAllCat=&WEBPCMTRANSID=" + URLEncoder.encode( webPcm );
  1035.  
  1036.         URL usl = new URL("http://www.govsales.gov/fassys/fasallcat/");
  1037.         HttpURLConnection conn = (HttpURLConnection) usl.openConnection();
  1038.         conn.setDoOutput(true);        
  1039.         conn.setRequestMethod("POST");
  1040.         conn.setRequestProperty("Content-Type","application/x-www-form-urlencoded");           
  1041.         conn.setRequestProperty("User-Agent","Mozilla/5.0"); 
  1042.         OutputStream os = conn.getOutputStream();
  1043.         os.write(msg2.getBytes("UTF-8"));
  1044.         os.close();
  1045.  
  1046.         BufferedReader lecteur = new BufferedReader(new InputStreamReader(conn.getInputStream()));
  1047.         String rayo;
  1048.         String resp2 = "";
  1049.         while ((rayo = lecteur.readLine())!= null) {
  1050. 	    resp2 += rayo;
  1051.         }
  1052.         lecteur.close();
  1053.  
  1054.         scParam = "";
  1055. 	scParamIdx = resp2.indexOf("name=scParam VALUE=\"");
  1056.         if ( scParamIdx > 0 ) {
  1057. 	   scParam = resp2.substring(scParamIdx, scParamIdx+80);
  1058. 	   String[] pieces = scParam.split("VALUE=\"");
  1059.            if ( pieces.length > 1 ) {
  1060.              String[] piecesII = pieces[1].split("\"");
  1061.              if ( piecesII.length > 1 ) {
  1062. 		scParam = piecesII[0].trim();
  1063.              } 
  1064. 	   }
  1065.         }
  1066.         String scStoreLocal1 = "";
  1067. 	int scSL1Idx = resp2.indexOf("name=scStoreLocal1");
  1068.         if ( scSL1Idx > 0 ) {
  1069. 	   scStoreLocal1 = resp2.substring(scSL1Idx, scSL1Idx+160);
  1070. 	   String[] pieces = scStoreLocal1.split("VALUE=\"");
  1071.            if ( pieces.length > 1 ) {
  1072.              String[] piecesII = pieces[1].split("\"");
  1073.              if ( piecesII.length > 1 ) {
  1074. 		scStoreLocal1 = piecesII[0].trim();
  1075.              } 
  1076. 	   }
  1077.         }
  1078.         String scStoreLocal2 = "";
  1079. 	int scSL2Idx = resp2.indexOf("name=scStoreLocal2");
  1080.         if ( scSL1Idx > 0 ) {
  1081. 	   scStoreLocal2 = resp2.substring(scSL2Idx, scSL2Idx+160);
  1082. 	   String[] pieces = scStoreLocal2.split("VALUE=\"");
  1083.            if ( pieces.length > 1 ) {
  1084.              String[] piecesII = pieces[1].split("\"");
  1085.              if ( piecesII.length > 1 ) {
  1086. 		scStoreLocal2 = piecesII[0];
  1087.              } 
  1088. 	   }
  1089.         }
  1090.         String scStoreLocal3 = "";
  1091. 	int scSL3Idx = resp2.indexOf("name=scStoreLocal3");
  1092.         if ( scSL3Idx > 0 ) {
  1093. 	   scStoreLocal3 = resp2.substring(scSL3Idx, scSL3Idx+160);
  1094. 	   String[] pieces = scStoreLocal3.split("VALUE=\"");
  1095.            if ( pieces.length > 1 ) {
  1096.              String[] piecesII = pieces[1].split("\"");
  1097.              if ( piecesII.length > 1 ) {
  1098. 		scStoreLocal3 = piecesII[0];
  1099.              } 
  1100. 	   }
  1101.         }
  1102.         String scStoreLocal5 = "";
  1103. 	int scSL5Idx = resp2.indexOf("name=scStoreLocal5");
  1104.         if ( scSL5Idx > 0 ) {
  1105. 	   scStoreLocal5 = resp2.substring(scSL5Idx, scSL5Idx+160);
  1106. 	   String[] pieces = scStoreLocal5.split("VALUE=\"");
  1107.            if ( pieces.length > 1 ) {
  1108.              String[] piecesII = pieces[1].split("\"");
  1109.              if ( piecesII.length > 1 ) {
  1110. 		scStoreLocal5 = piecesII[0];
  1111.              } 
  1112. 	   }
  1113.         }
  1114.         webPcm = "";
  1115.         webPcmIdx = resp2.indexOf("WEBPCMTRANSID");
  1116.         if ( webPcmIdx > 0 ) {
  1117. 	   webPcm = resp2.substring(webPcmIdx, webPcmIdx+40);
  1118.            String[] pieces = webPcm.split("VALUE=");
  1119.            if ( pieces.length > 1 ) {
  1120.              String[] piecesII =  pieces[1].split("\"");
  1121.              if ( piecesII.length > 1 ) {
  1122.                 webPcm = piecesII[1].trim();
  1123.              }  
  1124.            }
  1125.         }
  1126.  
  1127.         String msg3 = "scParam=" + URLEncoder.encode( scParam ) + "&scStoreLocal1=" + URLEncoder.encode( scStoreLocal1 ) + "&scStoreLocal2=" + URLEncoder.encode( scStoreLocal2 ) + "&scStoreLocal3=" + URLEncoder.encode( scStoreLocal3 ) + "&scStoreLocal4=&scStoreLocal5=" + URLEncoder.encode( scStoreLocal5 ) + "&scStoreLocal6=&scStoreLocal7=&scStoreLocal8=&scStoreLocal9=&scStoreLocal10=&scStoreLocal11=&scStoreLocal12=&scCurTabCat=&scSelTabCat=&scSelLink=&scGSName=&scGSOptn=" + URLEncoder.encode("1") + "&scSelState=&scSelRow=" + URLEncoder.encode("2G1WB58K381263163") + "&scSortOrder=&scPageNo=" + URLEncoder.encode("1") + "&WEBPCMTRANSID=" + URLEncoder.encode("0690484,2970121");
  1128.  
  1129.         //System.out.println( msg3 );
  1130.  
  1131.         int startIdx = resp2.indexOf("var tab=");
  1132.         int endIdx = resp2.indexOf("bldTr();");
  1133.  
  1134.         String dataBlock = resp2.substring(startIdx,endIdx).replaceAll(Pattern.quote("["),"").replaceAll(Pattern.quote("];"),"");
  1135.         dataBlock = dataBlock.replaceAll("var tab=\"","");
  1136.         dataBlock = dataBlock.replaceAll("  "," "); 
  1137. 	//System.out.println( dataBlock );
  1138.         String[] dataBlockPieces = dataBlock.split("\", \"");
  1139.  
  1140.         ArrayList<String> resultsContentStrings = new ArrayList<String>();
  1141.         ArrayList<String> urlIdList = new ArrayList<String>();
  1142.  
  1143.         for ( int i=0; i<dataBlockPieces.length; i+=12 ) {
  1144. 	  String content = "";
  1145. 	  for ( int j=0; j<12; j++ ) {
  1146. 	    content += dataBlockPieces[i+j] + " ";
  1147. 	  }
  1148. 	  resultsContentStrings.add( content );
  1149.           urlIdList.add( dataBlockPieces[i+1] );
  1150.         }
  1151.  
  1152.         ArrayList<String> msgs = new ArrayList<String>();
  1153.  
  1154.         for ( String urlId : urlIdList ) {
  1155. 	    msgs.add( "scParam=" + URLEncoder.encode( scParam ) + "&scStoreLocal1=" + URLEncoder.encode( scStoreLocal1 ) + "&scStoreLocal2=" + URLEncoder.encode( scStoreLocal2 ) + "&scStoreLocal3=" + URLEncoder.encode( scStoreLocal3 ) + "&scStoreLocal4=&scStoreLocal5=" + URLEncoder.encode( scStoreLocal5 ) + "&scStoreLocal6=&scStoreLocal7=&scStoreLocal8=&scStoreLocal9=&scStoreLocal10=&scStoreLocal11=&scStoreLocal12=&scCurTabCat=&scSelTabCat=&scSelLink=&scGSName=&scGSOptn=" + URLEncoder.encode("1") + "&scSelState=&scSelRow=" + URLEncoder.encode( urlId ) + "&scSortOrder=&scPageNo=" + URLEncoder.encode("1") + "&WEBPCMTRANSID=" + URLEncoder.encode("0690484,2970121") );
  1156.         }
  1157.  
  1158.         ArrayList<String> urlList = new ArrayList<String>();
  1159.  
  1160.         for ( String msg1 : msgs ) {
  1161. 	  urlList.add( "javascript:jQuery.post( &quot;http://www.govsales.gov/fassys/fassrchlist/&quot;, &quot;" + msg1 + "&quot; )" ); 
  1162.         }
  1163.  
  1164.         for ( int i=0; i<resultsContentStrings.size()-1; i++ ) {
  1165.           try {	
  1166. 	      stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.govsales.gov/', '" + urlList.get(i) + "', '" + resultsContentStrings.get(i) + "' )" ); 
  1167.           } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  1168.         }
  1169.  
  1170.       } catch ( IOException ioe ) { ioe.printStackTrace(); }
  1171.  
  1172.     }
  1173.  
  1174.     public static void LonestarOnline() {   
  1175.        String msg = "search_type=title_search&search_name=Title+%26+Description+Search&search_text=" + searchString + "&phrase_match=any&category=-1&search_span=title&search_limit=active&order_by=title&sort_order=ASC";
  1176.  
  1177.        try {
  1178.          URL theUrl = new URL( "http://www.lonestaronline.com/search/search_results.cfm?" + msg );
  1179.          String resp = "";        
  1180.          BufferedReader reader = new BufferedReader(new InputStreamReader(theUrl.openStream()));
  1181.          String line;
  1182.          while ((line = reader.readLine()) != null) {
  1183. 	    resp += line;
  1184.          }
  1185.          reader.close();
  1186.  
  1187.          int startIdx = resp.indexOf("<table border=0 cellspacing=0 cellpadding=2 noshade width=780>");
  1188.          int endIdx = resp.indexOf("<form name=\"blah\"");
  1189.          if ( startIdx > 0 && endIdx > startIdx ) {
  1190. 	     //System.out.println( startIdx + " " + endIdx );
  1191.  
  1192.             Parser psr = new Parser();
  1193.             try {
  1194. 		//System.out.println( resp.substring( startIdx, endIdx ) );
  1195.               psr.setInputHTML( resp.substring(startIdx,endIdx) );   
  1196.               NodeList nList = psr.parse(null);
  1197.  
  1198.               for ( int i=0; i<nList.size(); i++ ) {
  1199. 		if ( nList.elementAt(i).getText().equals("table border=0 cellspacing=0 cellpadding=2 noshade width=780") ) {
  1200. 		   NodeList trList =  nList.elementAt(i).getChildren();
  1201.                    for ( int j=0; j<trList.size(); j++ ) {
  1202. 		     if ( trList.elementAt(j).getText().startsWith("tr") ) {
  1203. 			String resultsContent = trList.elementAt(j).toPlainTextString();
  1204.                         resultsContent = resultsContent.replaceAll("&nbsp;","");
  1205.                         resultsContent = resultsContent.replaceAll("\n","");
  1206.                         resultsContent = resultsContent.replaceAll("\t","");
  1207.                         resultsContent = resultsContent.replaceAll("\"","");
  1208.                         resultsContent = resultsContent.replaceAll("'","");
  1209.                         while ( resultsContent.contains("  ") ) {
  1210. 		          resultsContent = resultsContent.replaceAll("  "," ");
  1211.                         }
  1212.                         NodeList tdList = trList.elementAt(j).getChildren();
  1213.                         for ( int k=0; k<tdList.size(); k++ ) {
  1214. 			   if ( tdList.elementAt(k).getText().equals("td width=\"496\"") ) {
  1215. 			       String tdContent = tdList.elementAt(k).toHtml();
  1216.                                String[] pieces = tdContent.split("href=\"");
  1217.                                if ( pieces.length > 1 ) {
  1218. 				  String[] piecesII = pieces[1].split("\"");
  1219.                                   String anchorHref = "http://www.lonestaronline.com" + piecesII[0].trim();
  1220. 				  try {	
  1221. 	                            stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.lonestaronline.com', '" + anchorHref + "', '" + resultsContent + "' )" ); 
  1222.                                   } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  1223.                                }   
  1224.                            }   
  1225.                         }
  1226.                      }  
  1227.                    }  
  1228.                 }  
  1229.               }
  1230.             } catch ( ParserException pe ) { pe.printStackTrace(); }
  1231.          }
  1232.        } catch ( IOException ioe ) { ioe.printStackTrace(); }
  1233.     }
  1234.  
  1235.     public static void GovDeals() {
  1236.       String msg = "";
  1237.       if ( searchState.equals("ALL") ) {    
  1238.          msg = "fa=Main.AdvSearchResults&timing1=&mystate=&myseller=0&myselectbox=00&desc=" + searchString + "&inv_nbr=";
  1239.       }
  1240.       else {
  1241. 	  msg = "fa=Main.AdvSearchResults&timing1=&mystate=" + searchState + "&myseller=0&myselectbox=00&desc=" + searchString + "&inv_nbr=";
  1242.       }  
  1243.  
  1244.        try {
  1245.          URL ubl = new URL( "http://www.govdeals.com/index.cfm?" + msg );
  1246.          String resp = "";        
  1247.          BufferedReader reader = new BufferedReader(new InputStreamReader(ubl.openStream()));
  1248.          String line;
  1249.          while ((line = reader.readLine()) != null) {
  1250. 	    resp += line;
  1251.          }
  1252.          reader.close();
  1253.  
  1254.          int startIdx = resp.indexOf("<tr bgcolor=\"#CCCCCC\">");
  1255.          int endIdx = resp.indexOf("<td colspan=\"9\" style=\"border-bottom:none\" scope=\"row\">");
  1256.  
  1257.          if ( startIdx > 0 && endIdx > startIdx ) {
  1258. 	     // System.out.println( startIdx + " " + endIdx );
  1259.            Parser prse = new Parser();
  1260.            try {
  1261. 	      prse.setInputHTML( resp.substring( startIdx, endIdx ) );
  1262.               NodeList nList = prse.parse(null);
  1263.               for ( int i=0; i<nList.size(); i++ ) { 
  1264. 		 if ( nList.elementAt(i).getText().startsWith("tr valign=\"top\"") ) {
  1265. 		   String resultsContent = nList.elementAt(i).toPlainTextString();
  1266.                    resultsContent = resultsContent.replaceAll("&nbsp;","");
  1267.                    resultsContent = resultsContent.replaceAll("\n","");
  1268.                    resultsContent = resultsContent.replaceAll("\t","");
  1269.                    resultsContent = resultsContent.replaceAll("\"","");
  1270.                    resultsContent = resultsContent.replaceAll("'","");
  1271.                    resultsContent = resultsContent.replaceAll("View by same:CategoryLocationMake/BrandModelProximity-------------Terms & ConditionsView this Item","");
  1272.                    while ( resultsContent.contains("  ") ) {
  1273. 		      resultsContent = resultsContent.replaceAll("  "," ");
  1274.                    }
  1275.                    resultsContent = resultsContent.replaceAll("0Bids","0 Bids");
  1276.                    //System.out.println( resultsContent );
  1277.                    NodeList tdList = nList.elementAt(i).getChildren();
  1278.                    for ( int j=0; j<tdList.size(); j++ ) {
  1279. 		     if ( tdList.elementAt(j).getText().equals("td valign=\"top\" nowrap=\"nowrap\"") ) {
  1280. 		      String[] pieces = tdList.elementAt(j).toHtml().split("href=\"");
  1281.                       if ( pieces.length > 1 ) {
  1282. 			String[] piecesII = pieces[1].split("\"");
  1283.                         String anchorHref = "http://www.govdeals.com/" + piecesII[0];
  1284.                         try {	
  1285. 	                   stmt.executeUpdate( "INSERT INTO auction_records VALUES ( 'http://www.govdeals.com/', '" + anchorHref + "', '" + resultsContent + "' )" ); 
  1286.                         } catch ( SQLException sqle ) { sqle.printStackTrace(); }
  1287.                       }
  1288.                      }   
  1289.                    }                        
  1290.                  }
  1291.               }
  1292.            } catch ( ParserException pe ) { pe.printStackTrace(); }
  1293.          }
  1294.        } catch ( IOException ioe ) { ioe.printStackTrace(); }    
  1295.     }
  1296.  
  1297.     public static void IllinoisIbid() {
  1298.       String msg = "search=1&catid=&SearchStr=" + searchString + "&AllAnyExact=all&Region1=&Region2=&Region3=&Region4=&customs_criteria=1&cfs_txt_EqNum=&cfs_txt_VIN=&cfs_int_min_Odometer=&cfs_int_max_Odometer=&cfs_txt_make=&cfs_txt_model=&cfs_txt_modelyear=&PriceFrom=&PriceTo=&StartFrom=&StartTo=&EndFrom=&EndTo=&ExcludeStr=&OrderBy=end_asc&MaxResults=50&sbmtAdvSearch=Go#results";    
  1299.       try {
  1300.        URL ubl = new URL( "http://ibid.illinois.gov/advancedsearch.asp?" + msg );
  1301.        String resp = "";
  1302.        BufferedReader lecteur = new BufferedReader(new InputStreamReader(ubl.openStream()));
  1303.        String line;
  1304.        while ((line = lecteur.readLine()) != null) {
  1305.           resp += line;
  1306.        }
  1307.        lecteur.close();
  1308.  
  1309.        int startIdx = resp.indexOf( "<div id=\"SearchResults\">");
  1310.        int endIdx = resp.indexOf( "<div id=\"PageLinksS\">" );       
  1311.        //System.out.println( startIdx + " " + endIdx ); 
  1312.        if ( startIdx > 0 && endIdx > startIdx ) {
  1313. 	 Parser prs = new Parser();
  1314.          try { 
  1315. 	   prs.setInputHTML( resp.substring(startIdx,endIdx) );
  1316.            NodeList nList = prs.parse(null);
  1317.  
  1318.            for ( int i=0; i<nList.size(); i++ ) {
  1319. 	      if ( nList.elementAt(i).getText().equals("div id=\"SearchResults\"") ) {
  1320. 		 NodeList tblList = nList.elementAt(i).getChildren();
  1321.                  for ( int j=0; j<tblList.size(); j++ ) {
  1322. 		    if ( tblList.elementAt(j).getText().equals("table cellpadding=\"2\" cellspacing=\"1\"") ) {
  1323. 		      NodeList trList = tblList.elementAt(j).getChildren();
  1324.                       for ( int k=0; k<trList.size(); k++ ) {
  1325. 			if ( trList.elementAt(k).getText().startsWith("tr class=\"Color") ) {
  1326. 			  String resultsContent = trList.elementAt(k).toPlainTextString();
  1327.                           resultsContent = resultsContent.replaceAll("&nbsp;","");
  1328.                           resultsContent = resultsContent.replaceAll("\n","");
  1329.                           resultsContent = resultsContent.replaceAll("\t","");
  1330.                           resultsContent = resultsConte

Report this snippet  

You need to login to post a comment.