Examples of com.knowgate.hipergate.QueryByForm.queryToStream()

com.knowgate.hipergate.QueryByForm.queryToStream()

Execute query and print ResultSet to an OutputStream.

Rows are directly fetched from database and printed to OutputStream one by one.

@param oConn Database Connection @param sColumnList Columns to SELECT @param sFilter Full SQL filter clause, including <> @param oOutStrm OutputStream for printing results. @param sShowAs Output Type

TSV	Tab separated values	Columns are delimited by tabs and rows are delimited by line feeds
XLS	Excel Default	Columns are delimited by ';' and rows are delimited by line feeds
CSV	Comma separated values	Columns are delimited by ',' and rows are delimited by line feeds, text is qualified with double quoutes.

@throws SQLException

         response.setContentType("text/plain");
         response.setHeader("Content-Disposition", "inline; filename=\"" + oQBF.getTitle(request.getLocale().getLanguage())+ " 1.txt\"");
       }


       if (0==sOrderBy.length())
         oQBF.queryToStream(oConn, sColumnList, oQBF.getBaseFilter(request) + " " + sWhere, oOut, sShowAs);
       else
         oQBF.queryToStream(oConn, sColumnList, oQBF.getBaseFilter(request) + " " + sWhere + " ORDER BY " + sOrderBy, oOut, sShowAs);


       oConn.close();
       oConn = null;

       }


       if (0==sOrderBy.length())
         oQBF.queryToStream(oConn, sColumnList, oQBF.getBaseFilter(request) + " " + sWhere, oOut, sShowAs);
       else
         oQBF.queryToStream(oConn, sColumnList, oQBF.getBaseFilter(request) + " " + sWhere + " ORDER BY " + sOrderBy, oOut, sShowAs);


       oConn.close();
       oConn = null;


       oOut.flush();

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.