commons-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ggreg...@apache.org
Subject svn commit: r855435 [37/45] - in /websites/production/commons/content/proper/commons-csv: ./ apidocs/ apidocs/org/apache/commons/csv/ apidocs/org/apache/commons/csv/class-use/ apidocs/org/apache/commons/csv/writer/ apidocs/src-html/org/apache/commons/c...
Date Thu, 21 Mar 2013 15:20:21 GMT
Modified: websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVPrinterTest.html
==============================================================================
--- websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVPrinterTest.html (original)
+++ websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVPrinterTest.html Thu Mar 21 15:20:15 2013
@@ -1,12 +1,12 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
-<head>
-<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
-<title>CSVPrinterTest xref</title>
-<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
-</head>
-<body>
-<div id="overview"><a href="../../../../../testapidocs/org/apache/commons/csv/CSVPrinterTest.html">View Javadoc</a></div><pre>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>CSVPrinterTest xref</title>
+<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
+</head>
+<body>
+<div id="overview"><a href="../../../../../testapidocs/org/apache/commons/csv/CSVPrinterTest.html">View Javadoc</a></div><pre>
 
 <a class="jxr_linenumber" name="1" href="#1">1</a>   <em class="jxr_comment">/*</em>
 <a class="jxr_linenumber" name="2" href="#2">2</a>   <em class="jxr_comment"> * Licensed to the Apache Software Foundation (ASF) under one or more</em>
@@ -15,259 +15,325 @@
 <a class="jxr_linenumber" name="5" href="#5">5</a>   <em class="jxr_comment"> * The ASF licenses this file to You under the Apache License, Version 2.0</em>
 <a class="jxr_linenumber" name="6" href="#6">6</a>   <em class="jxr_comment"> * (the "License"); you may not use this file except in compliance with</em>
 <a class="jxr_linenumber" name="7" href="#7">7</a>   <em class="jxr_comment"> * the License.  You may obtain a copy of the License at</em>
-<a class="jxr_linenumber" name="8" href="#8">8</a>   <em class="jxr_comment"> * </em>
+<a class="jxr_linenumber" name="8" href="#8">8</a>   <em class="jxr_comment"> *</em>
 <a class="jxr_linenumber" name="9" href="#9">9</a>   <em class="jxr_comment"> *      <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
-<a class="jxr_linenumber" name="10" href="#10">10</a>  <em class="jxr_comment"> * </em>
+<a class="jxr_linenumber" name="10" href="#10">10</a>  <em class="jxr_comment"> *</em>
 <a class="jxr_linenumber" name="11" href="#11">11</a>  <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing, software</em>
 <a class="jxr_linenumber" name="12" href="#12">12</a>  <em class="jxr_comment"> * distributed under the License is distributed on an "AS IS" BASIS,</em>
 <a class="jxr_linenumber" name="13" href="#13">13</a>  <em class="jxr_comment"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
 <a class="jxr_linenumber" name="14" href="#14">14</a>  <em class="jxr_comment"> * See the License for the specific language governing permissions and</em>
 <a class="jxr_linenumber" name="15" href="#15">15</a>  <em class="jxr_comment"> * limitations under the License.</em>
 <a class="jxr_linenumber" name="16" href="#16">16</a>  <em class="jxr_comment"> */</em>
-<a class="jxr_linenumber" name="17" href="#17">17</a>  <strong class="jxr_keyword">package</strong> org.apache.commons.csv;
-<a class="jxr_linenumber" name="18" href="#18">18</a>  
-<a class="jxr_linenumber" name="19" href="#19">19</a>  <strong class="jxr_keyword">import</strong> java.io.IOException;
-<a class="jxr_linenumber" name="20" href="#20">20</a>  <strong class="jxr_keyword">import</strong> java.io.StringWriter;
-<a class="jxr_linenumber" name="21" href="#21">21</a>  <strong class="jxr_keyword">import</strong> java.util.Random;
-<a class="jxr_linenumber" name="22" href="#22">22</a>  
-<a class="jxr_linenumber" name="23" href="#23">23</a>  <strong class="jxr_keyword">import</strong> junit.framework.TestCase;
-<a class="jxr_linenumber" name="24" href="#24">24</a>  
-<a class="jxr_linenumber" name="25" href="#25">25</a>  <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="26" href="#26">26</a>  <em class="jxr_javadoccomment"> * CSVPrinterTest</em>
-<a class="jxr_linenumber" name="27" href="#27">27</a>  <em class="jxr_javadoccomment"> */</em>
-<a class="jxr_linenumber" name="28" href="#28">28</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/apache/commons/csv/CSVPrinterTest.html">CSVPrinterTest</a> <strong class="jxr_keyword">extends</strong> TestCase {
-<a class="jxr_linenumber" name="29" href="#29">29</a>  
-<a class="jxr_linenumber" name="30" href="#30">30</a>      String lineSeparator = CSVFormat.DEFAULT.getLineSeparator();
+<a class="jxr_linenumber" name="17" href="#17">17</a>  
+<a class="jxr_linenumber" name="18" href="#18">18</a>  <strong class="jxr_keyword">package</strong> org.apache.commons.csv;
+<a class="jxr_linenumber" name="19" href="#19">19</a>  
+<a class="jxr_linenumber" name="20" href="#20">20</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertEquals;
+<a class="jxr_linenumber" name="21" href="#21">21</a>  
+<a class="jxr_linenumber" name="22" href="#22">22</a>  <strong class="jxr_keyword">import</strong> java.io.IOException;
+<a class="jxr_linenumber" name="23" href="#23">23</a>  <strong class="jxr_keyword">import</strong> java.io.StringWriter;
+<a class="jxr_linenumber" name="24" href="#24">24</a>  <strong class="jxr_keyword">import</strong> java.sql.Connection;
+<a class="jxr_linenumber" name="25" href="#25">25</a>  <strong class="jxr_keyword">import</strong> java.sql.DriverManager;
+<a class="jxr_linenumber" name="26" href="#26">26</a>  <strong class="jxr_keyword">import</strong> java.sql.SQLException;
+<a class="jxr_linenumber" name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> java.sql.Statement;
+<a class="jxr_linenumber" name="28" href="#28">28</a>  <strong class="jxr_keyword">import</strong> java.util.Arrays;
+<a class="jxr_linenumber" name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> java.util.List;
+<a class="jxr_linenumber" name="30" href="#30">30</a>  <strong class="jxr_keyword">import</strong> java.util.Random;
 <a class="jxr_linenumber" name="31" href="#31">31</a>  
-<a class="jxr_linenumber" name="32" href="#32">32</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter1() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="33" href="#33">33</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="34" href="#34">34</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="35" href="#35">35</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>);
-<a class="jxr_linenumber" name="36" href="#36">36</a>          assertEquals(<span class="jxr_string">"a,b"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="37" href="#37">37</a>      }
-<a class="jxr_linenumber" name="38" href="#38">38</a>  
-<a class="jxr_linenumber" name="39" href="#39">39</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter2() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="40" href="#40">40</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="41" href="#41">41</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="42" href="#42">42</a>          printer.println(<span class="jxr_string">"a,b"</span>, <span class="jxr_string">"b"</span>);
-<a class="jxr_linenumber" name="43" href="#43">43</a>          assertEquals(<span class="jxr_string">"\&quot;a,b\&quot;,b"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="44" href="#44">44</a>      }
-<a class="jxr_linenumber" name="45" href="#45">45</a>  
-<a class="jxr_linenumber" name="46" href="#46">46</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter3() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="47" href="#47">47</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="48" href="#48">48</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="49" href="#49">49</a>          printer.println(<span class="jxr_string">"a, b"</span>, <span class="jxr_string">"b "</span>);
-<a class="jxr_linenumber" name="50" href="#50">50</a>          assertEquals(<span class="jxr_string">"\&quot;a, b\&quot;,\&quot;b \&quot;"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="51" href="#51">51</a>      }
-<a class="jxr_linenumber" name="52" href="#52">52</a>  
-<a class="jxr_linenumber" name="53" href="#53">53</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter4() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="54" href="#54">54</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="55" href="#55">55</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="56" href="#56">56</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\&quot;c"</span>);
-<a class="jxr_linenumber" name="57" href="#57">57</a>          assertEquals(<span class="jxr_string">"a,\&quot;b\&quot;\&quot;c\&quot;"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="58" href="#58">58</a>      }
-<a class="jxr_linenumber" name="59" href="#59">59</a>  
-<a class="jxr_linenumber" name="60" href="#60">60</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter5() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="61" href="#61">61</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="62" href="#62">62</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="63" href="#63">63</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\nc"</span>);
-<a class="jxr_linenumber" name="64" href="#64">64</a>          assertEquals(<span class="jxr_string">"a,\&quot;b\nc\&quot;"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="65" href="#65">65</a>      }
-<a class="jxr_linenumber" name="66" href="#66">66</a>  
-<a class="jxr_linenumber" name="67" href="#67">67</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter6() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="68" href="#68">68</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="69" href="#69">69</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="70" href="#70">70</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\r\nc"</span>);
-<a class="jxr_linenumber" name="71" href="#71">71</a>          assertEquals(<span class="jxr_string">"a,\&quot;b\r\nc\&quot;"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="72" href="#72">72</a>      }
+<a class="jxr_linenumber" name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> org.junit.Test;
+<a class="jxr_linenumber" name="33" href="#33">33</a>  
+<a class="jxr_linenumber" name="34" href="#34">34</a>  <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="35" href="#35">35</a>  <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="36" href="#36">36</a>  <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="37" href="#37">37</a>  <em class="jxr_javadoccomment"> * @version $Id: CSVPrinterTest.java 1410084 2012-11-15 22:46:56Z ggregory $</em>
+<a class="jxr_linenumber" name="38" href="#38">38</a>  <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="39" href="#39">39</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/apache/commons/csv/CSVPrinterTest.html">CSVPrinterTest</a> {
+<a class="jxr_linenumber" name="40" href="#40">40</a>  
+<a class="jxr_linenumber" name="41" href="#41">41</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> String printable(<strong class="jxr_keyword">final</strong> String s) {
+<a class="jxr_linenumber" name="42" href="#42">42</a>          <strong class="jxr_keyword">final</strong> StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder();
+<a class="jxr_linenumber" name="43" href="#43">43</a>          <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; s.length(); i++) {
+<a class="jxr_linenumber" name="44" href="#44">44</a>              <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">char</strong> ch = s.charAt(i);
+<a class="jxr_linenumber" name="45" href="#45">45</a>              <strong class="jxr_keyword">if</strong> (ch &lt;= ' ' || ch &gt;= 128) {
+<a class="jxr_linenumber" name="46" href="#46">46</a>                  sb.append(<span class="jxr_string">"("</span>).append((<strong class="jxr_keyword">int</strong>) ch).append(<span class="jxr_string">")"</span>);
+<a class="jxr_linenumber" name="47" href="#47">47</a>              } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="48" href="#48">48</a>                  sb.append(ch);
+<a class="jxr_linenumber" name="49" href="#49">49</a>              }
+<a class="jxr_linenumber" name="50" href="#50">50</a>          }
+<a class="jxr_linenumber" name="51" href="#51">51</a>          <strong class="jxr_keyword">return</strong> sb.toString();
+<a class="jxr_linenumber" name="52" href="#52">52</a>      }
+<a class="jxr_linenumber" name="53" href="#53">53</a>  
+<a class="jxr_linenumber" name="54" href="#54">54</a>      String recordSeparator = CSVFormat.DEFAULT.getRecordSeparator();
+<a class="jxr_linenumber" name="55" href="#55">55</a>  
+<a class="jxr_linenumber" name="56" href="#56">56</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> doOneRandom(<strong class="jxr_keyword">final</strong> CSVFormat format) <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="57" href="#57">57</a>          <strong class="jxr_keyword">final</strong> Random r = <strong class="jxr_keyword">new</strong> Random();
+<a class="jxr_linenumber" name="58" href="#58">58</a>  
+<a class="jxr_linenumber" name="59" href="#59">59</a>          <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> nLines = r.nextInt(4) + 1;
+<a class="jxr_linenumber" name="60" href="#60">60</a>          <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> nCol = r.nextInt(3) + 1;
+<a class="jxr_linenumber" name="61" href="#61">61</a>          <em class="jxr_comment">// nLines=1;nCol=2;</em>
+<a class="jxr_linenumber" name="62" href="#62">62</a>          <strong class="jxr_keyword">final</strong> String[][] lines = <strong class="jxr_keyword">new</strong> String[nLines][];
+<a class="jxr_linenumber" name="63" href="#63">63</a>          <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; nLines; i++) {
+<a class="jxr_linenumber" name="64" href="#64">64</a>              <strong class="jxr_keyword">final</strong> String[] line = <strong class="jxr_keyword">new</strong> String[nCol];
+<a class="jxr_linenumber" name="65" href="#65">65</a>              lines[i] = line;
+<a class="jxr_linenumber" name="66" href="#66">66</a>              <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> j = 0; j &lt; nCol; j++) {
+<a class="jxr_linenumber" name="67" href="#67">67</a>                  line[j] = randStr();
+<a class="jxr_linenumber" name="68" href="#68">68</a>              }
+<a class="jxr_linenumber" name="69" href="#69">69</a>          }
+<a class="jxr_linenumber" name="70" href="#70">70</a>  
+<a class="jxr_linenumber" name="71" href="#71">71</a>          <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="72" href="#72">72</a>          <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, format);
 <a class="jxr_linenumber" name="73" href="#73">73</a>  
-<a class="jxr_linenumber" name="74" href="#74">74</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter7() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="75" href="#75">75</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="76" href="#76">76</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="77" href="#77">77</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b&#92;&#92;c"</span>);
-<a class="jxr_linenumber" name="78" href="#78">78</a>          assertEquals(<span class="jxr_string">"a,b&#92;&#92;c"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="79" href="#79">79</a>      }
-<a class="jxr_linenumber" name="80" href="#80">80</a>  
-<a class="jxr_linenumber" name="81" href="#81">81</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrinter1() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="82" href="#82">82</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="83" href="#83">83</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="84" href="#84">84</a>          printer.println(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>);
-<a class="jxr_linenumber" name="85" href="#85">85</a>          assertEquals(<span class="jxr_string">"a,b"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="86" href="#86">86</a>      }
-<a class="jxr_linenumber" name="87" href="#87">87</a>  
-<a class="jxr_linenumber" name="88" href="#88">88</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrinter2() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="89" href="#89">89</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="90" href="#90">90</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="91" href="#91">91</a>          printer.println(<span class="jxr_string">"a,b"</span>, <span class="jxr_string">"b"</span>);
-<a class="jxr_linenumber" name="92" href="#92">92</a>          assertEquals(<span class="jxr_string">"\&quot;a,b\&quot;,b"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="93" href="#93">93</a>      }
-<a class="jxr_linenumber" name="94" href="#94">94</a>  
-<a class="jxr_linenumber" name="95" href="#95">95</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrintNullValues() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="96" href="#96">96</a>          StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="97" href="#97">97</a>          CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="98" href="#98">98</a>          printer.println(<span class="jxr_string">"a"</span>, <strong class="jxr_keyword">null</strong>, <span class="jxr_string">"b"</span>);
-<a class="jxr_linenumber" name="99" href="#99">99</a>          assertEquals(<span class="jxr_string">"a,,b"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="100" href="#100">100</a>     }
-<a class="jxr_linenumber" name="101" href="#101">101</a> 
-<a class="jxr_linenumber" name="102" href="#102">102</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDisabledComment() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="103" href="#103">103</a>         StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="104" href="#104">104</a>         CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="105" href="#105">105</a>         printer.printComment(<span class="jxr_string">"This is a comment"</span>);
-<a class="jxr_linenumber" name="106" href="#106">106</a>         
-<a class="jxr_linenumber" name="107" href="#107">107</a>         assertEquals(<span class="jxr_string">""</span>, sw.toString());
-<a class="jxr_linenumber" name="108" href="#108">108</a>     }
-<a class="jxr_linenumber" name="109" href="#109">109</a> 
-<a class="jxr_linenumber" name="110" href="#110">110</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testSingleLineComment() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="111" href="#111">111</a>         StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="112" href="#112">112</a>         CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT.withCommentStart('#'));
-<a class="jxr_linenumber" name="113" href="#113">113</a>         printer.printComment(<span class="jxr_string">"This is a comment"</span>);
-<a class="jxr_linenumber" name="114" href="#114">114</a>         
-<a class="jxr_linenumber" name="115" href="#115">115</a>         assertEquals(<span class="jxr_string">"# This is a comment"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="116" href="#116">116</a>     }
-<a class="jxr_linenumber" name="117" href="#117">117</a> 
-<a class="jxr_linenumber" name="118" href="#118">118</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testMultiLineComment() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="119" href="#119">119</a>         StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="120" href="#120">120</a>         CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT.withCommentStart('#'));
-<a class="jxr_linenumber" name="121" href="#121">121</a>         printer.printComment(<span class="jxr_string">"This is a comment\non multiple lines"</span>);
-<a class="jxr_linenumber" name="122" href="#122">122</a>         
-<a class="jxr_linenumber" name="123" href="#123">123</a>         assertEquals(<span class="jxr_string">"# This is a comment"</span> + lineSeparator + <span class="jxr_string">"# on multiple lines"</span> + lineSeparator, sw.toString());
-<a class="jxr_linenumber" name="124" href="#124">124</a>     }
-<a class="jxr_linenumber" name="125" href="#125">125</a> 
-<a class="jxr_linenumber" name="126" href="#126">126</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testRandom() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="127" href="#127">127</a>         <strong class="jxr_keyword">int</strong> iter = 10000;
-<a class="jxr_linenumber" name="128" href="#128">128</a>         doRandom(CSVFormat.DEFAULT, iter);
-<a class="jxr_linenumber" name="129" href="#129">129</a>         doRandom(CSVFormat.EXCEL, iter);
-<a class="jxr_linenumber" name="130" href="#130">130</a>         doRandom(CSVFormat.MYSQL, iter);
-<a class="jxr_linenumber" name="131" href="#131">131</a>     }
-<a class="jxr_linenumber" name="132" href="#132">132</a> 
-<a class="jxr_linenumber" name="133" href="#133">133</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> doRandom(CSVFormat format, <strong class="jxr_keyword">int</strong> iter) <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="134" href="#134">134</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; iter; i++) {
-<a class="jxr_linenumber" name="135" href="#135">135</a>             doOneRandom(format);
-<a class="jxr_linenumber" name="136" href="#136">136</a>         }
-<a class="jxr_linenumber" name="137" href="#137">137</a>     }
-<a class="jxr_linenumber" name="138" href="#138">138</a> 
-<a class="jxr_linenumber" name="139" href="#139">139</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> doOneRandom(CSVFormat format) <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="140" href="#140">140</a>         Random r = <strong class="jxr_keyword">new</strong> Random();
-<a class="jxr_linenumber" name="141" href="#141">141</a>         
-<a class="jxr_linenumber" name="142" href="#142">142</a>         <strong class="jxr_keyword">int</strong> nLines = r.nextInt(4) + 1;
-<a class="jxr_linenumber" name="143" href="#143">143</a>         <strong class="jxr_keyword">int</strong> nCol = r.nextInt(3) + 1;
-<a class="jxr_linenumber" name="144" href="#144">144</a>         <em class="jxr_comment">// nLines=1;nCol=2;</em>
-<a class="jxr_linenumber" name="145" href="#145">145</a>         String[][] lines = <strong class="jxr_keyword">new</strong> String[nLines][];
-<a class="jxr_linenumber" name="146" href="#146">146</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; nLines; i++) {
-<a class="jxr_linenumber" name="147" href="#147">147</a>             String[] line = <strong class="jxr_keyword">new</strong> String[nCol];
-<a class="jxr_linenumber" name="148" href="#148">148</a>             lines[i] = line;
-<a class="jxr_linenumber" name="149" href="#149">149</a>             <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> j = 0; j &lt; nCol; j++) {
-<a class="jxr_linenumber" name="150" href="#150">150</a>                 line[j] = randStr();
-<a class="jxr_linenumber" name="151" href="#151">151</a>             }
-<a class="jxr_linenumber" name="152" href="#152">152</a>         }
-<a class="jxr_linenumber" name="153" href="#153">153</a> 
-<a class="jxr_linenumber" name="154" href="#154">154</a>         StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
-<a class="jxr_linenumber" name="155" href="#155">155</a>         CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, format);
-<a class="jxr_linenumber" name="156" href="#156">156</a> 
-<a class="jxr_linenumber" name="157" href="#157">157</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; nLines; i++) {
-<a class="jxr_linenumber" name="158" href="#158">158</a>             <em class="jxr_comment">// for (int j=0; j&lt;lines[i].length; j++) System.out.println("### VALUE=:" + printable(lines[i][j]));</em>
-<a class="jxr_linenumber" name="159" href="#159">159</a>             printer.println(lines[i]);
-<a class="jxr_linenumber" name="160" href="#160">160</a>         }
-<a class="jxr_linenumber" name="161" href="#161">161</a> 
-<a class="jxr_linenumber" name="162" href="#162">162</a>         printer.flush();
-<a class="jxr_linenumber" name="163" href="#163">163</a>         String result = sw.toString();
-<a class="jxr_linenumber" name="164" href="#164">164</a>         <em class="jxr_comment">// System.out.println("### :" + printable(result));</em>
-<a class="jxr_linenumber" name="165" href="#165">165</a> 
-<a class="jxr_linenumber" name="166" href="#166">166</a>         CSVParser parser = <strong class="jxr_keyword">new</strong> CSVParser(result, format);
-<a class="jxr_linenumber" name="167" href="#167">167</a>         String[][] parseResult = parser.getRecords();
+<a class="jxr_linenumber" name="74" href="#74">74</a>          <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; nLines; i++) {
+<a class="jxr_linenumber" name="75" href="#75">75</a>              <em class="jxr_comment">// for (int j=0; j&lt;lines[i].length; j++) System.out.println("### VALUE=:" + printable(lines[i][j]));</em>
+<a class="jxr_linenumber" name="76" href="#76">76</a>              printer.printRecord(lines[i]);
+<a class="jxr_linenumber" name="77" href="#77">77</a>          }
+<a class="jxr_linenumber" name="78" href="#78">78</a>  
+<a class="jxr_linenumber" name="79" href="#79">79</a>          printer.flush();
+<a class="jxr_linenumber" name="80" href="#80">80</a>          printer.close();
+<a class="jxr_linenumber" name="81" href="#81">81</a>          <strong class="jxr_keyword">final</strong> String result = sw.toString();
+<a class="jxr_linenumber" name="82" href="#82">82</a>          <em class="jxr_comment">// System.out.println("### :" + printable(result));</em>
+<a class="jxr_linenumber" name="83" href="#83">83</a>  
+<a class="jxr_linenumber" name="84" href="#84">84</a>          <strong class="jxr_keyword">final</strong> CSVParser parser = <strong class="jxr_keyword">new</strong> CSVParser(result, format);
+<a class="jxr_linenumber" name="85" href="#85">85</a>          <strong class="jxr_keyword">final</strong> List&lt;CSVRecord&gt; parseResult = parser.getRecords();
+<a class="jxr_linenumber" name="86" href="#86">86</a>  
+<a class="jxr_linenumber" name="87" href="#87">87</a>          Utils.compare(<span class="jxr_string">"Printer output :"</span> + printable(result), lines, parseResult);
+<a class="jxr_linenumber" name="88" href="#88">88</a>      }
+<a class="jxr_linenumber" name="89" href="#89">89</a>  
+<a class="jxr_linenumber" name="90" href="#90">90</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> doRandom(<strong class="jxr_keyword">final</strong> CSVFormat format, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> iter) <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="91" href="#91">91</a>          <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; iter; i++) {
+<a class="jxr_linenumber" name="92" href="#92">92</a>              doOneRandom(format);
+<a class="jxr_linenumber" name="93" href="#93">93</a>          }
+<a class="jxr_linenumber" name="94" href="#94">94</a>      }
+<a class="jxr_linenumber" name="95" href="#95">95</a>  
+<a class="jxr_linenumber" name="96" href="#96">96</a>      <strong class="jxr_keyword">public</strong> String randStr() {
+<a class="jxr_linenumber" name="97" href="#97">97</a>          <strong class="jxr_keyword">final</strong> Random r = <strong class="jxr_keyword">new</strong> Random();
+<a class="jxr_linenumber" name="98" href="#98">98</a>  
+<a class="jxr_linenumber" name="99" href="#99">99</a>          <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> sz = r.nextInt(20);
+<a class="jxr_linenumber" name="100" href="#100">100</a>         <em class="jxr_comment">// sz = r.nextInt(3);</em>
+<a class="jxr_linenumber" name="101" href="#101">101</a>         <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">char</strong>[] buf = <strong class="jxr_keyword">new</strong> <strong class="jxr_keyword">char</strong>[sz];
+<a class="jxr_linenumber" name="102" href="#102">102</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; sz; i++) {
+<a class="jxr_linenumber" name="103" href="#103">103</a>             <em class="jxr_comment">// stick in special chars with greater frequency</em>
+<a class="jxr_linenumber" name="104" href="#104">104</a>             <strong class="jxr_keyword">char</strong> ch;
+<a class="jxr_linenumber" name="105" href="#105">105</a>             <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> what = r.nextInt(20);
+<a class="jxr_linenumber" name="106" href="#106">106</a>             <strong class="jxr_keyword">switch</strong> (what) {
+<a class="jxr_linenumber" name="107" href="#107">107</a>                 <strong class="jxr_keyword">case</strong> 0:
+<a class="jxr_linenumber" name="108" href="#108">108</a>                     ch = '\r';
+<a class="jxr_linenumber" name="109" href="#109">109</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="110" href="#110">110</a>                 <strong class="jxr_keyword">case</strong> 1:
+<a class="jxr_linenumber" name="111" href="#111">111</a>                     ch = '\n';
+<a class="jxr_linenumber" name="112" href="#112">112</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="113" href="#113">113</a>                 <strong class="jxr_keyword">case</strong> 2:
+<a class="jxr_linenumber" name="114" href="#114">114</a>                     ch = '\t';
+<a class="jxr_linenumber" name="115" href="#115">115</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="116" href="#116">116</a>                 <strong class="jxr_keyword">case</strong> 3:
+<a class="jxr_linenumber" name="117" href="#117">117</a>                     ch = '\f';
+<a class="jxr_linenumber" name="118" href="#118">118</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="119" href="#119">119</a>                 <strong class="jxr_keyword">case</strong> 4:
+<a class="jxr_linenumber" name="120" href="#120">120</a>                     ch = ' ';
+<a class="jxr_linenumber" name="121" href="#121">121</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="122" href="#122">122</a>                 <strong class="jxr_keyword">case</strong> 5:
+<a class="jxr_linenumber" name="123" href="#123">123</a>                     ch = ',';
+<a class="jxr_linenumber" name="124" href="#124">124</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="125" href="#125">125</a>                 <strong class="jxr_keyword">case</strong> 6:
+<a class="jxr_linenumber" name="126" href="#126">126</a>                     ch = '&quot;';
+<a class="jxr_linenumber" name="127" href="#127">127</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="128" href="#128">128</a>                 <strong class="jxr_keyword">case</strong> 7:
+<a class="jxr_linenumber" name="129" href="#129">129</a>                     ch = '\'';
+<a class="jxr_linenumber" name="130" href="#130">130</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="131" href="#131">131</a>                 <strong class="jxr_keyword">case</strong> 8:
+<a class="jxr_linenumber" name="132" href="#132">132</a>                     ch = '&#92;&#92;';
+<a class="jxr_linenumber" name="133" href="#133">133</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="134" href="#134">134</a>                 <strong class="jxr_keyword">default</strong>:
+<a class="jxr_linenumber" name="135" href="#135">135</a>                     ch = (<strong class="jxr_keyword">char</strong>) r.nextInt(300);
+<a class="jxr_linenumber" name="136" href="#136">136</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="137" href="#137">137</a>                 <em class="jxr_comment">// default: ch = 'a'; break;</em>
+<a class="jxr_linenumber" name="138" href="#138">138</a>             }
+<a class="jxr_linenumber" name="139" href="#139">139</a>             buf[i] = ch;
+<a class="jxr_linenumber" name="140" href="#140">140</a>         }
+<a class="jxr_linenumber" name="141" href="#141">141</a>         <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">new</strong> String(buf);
+<a class="jxr_linenumber" name="142" href="#142">142</a>     }
+<a class="jxr_linenumber" name="143" href="#143">143</a> 
+<a class="jxr_linenumber" name="144" href="#144">144</a>     @Test
+<a class="jxr_linenumber" name="145" href="#145">145</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDisabledComment() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="146" href="#146">146</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="147" href="#147">147</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="148" href="#148">148</a>         printer.printComment(<span class="jxr_string">"This is a comment"</span>);
+<a class="jxr_linenumber" name="149" href="#149">149</a> 
+<a class="jxr_linenumber" name="150" href="#150">150</a>         assertEquals(<span class="jxr_string">""</span>, sw.toString());
+<a class="jxr_linenumber" name="151" href="#151">151</a>     }
+<a class="jxr_linenumber" name="152" href="#152">152</a> 
+<a class="jxr_linenumber" name="153" href="#153">153</a>     @Test
+<a class="jxr_linenumber" name="154" href="#154">154</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrintAllArrayOfArrays() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="155" href="#155">155</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="156" href="#156">156</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="157" href="#157">157</a>         printer.printRecords(<strong class="jxr_keyword">new</strong> String[][] { { <span class="jxr_string">"r1c1"</span>, <span class="jxr_string">"r1c2"</span> }, { <span class="jxr_string">"r2c1"</span>, <span class="jxr_string">"r2c2"</span> } });
+<a class="jxr_linenumber" name="158" href="#158">158</a>         assertEquals(<span class="jxr_string">"r1c1,r1c2"</span> + recordSeparator + <span class="jxr_string">"r2c1,r2c2"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="159" href="#159">159</a>     }
+<a class="jxr_linenumber" name="160" href="#160">160</a> 
+<a class="jxr_linenumber" name="161" href="#161">161</a>     @Test
+<a class="jxr_linenumber" name="162" href="#162">162</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrintAllArrayOfLists() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="163" href="#163">163</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="164" href="#164">164</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="165" href="#165">165</a>         printer.printRecords(<strong class="jxr_keyword">new</strong> List[] { Arrays.asList(<strong class="jxr_keyword">new</strong> String[] { <span class="jxr_string">"r1c1"</span>, <span class="jxr_string">"r1c2"</span> }), Arrays.asList(<strong class="jxr_keyword">new</strong> String[] { <span class="jxr_string">"r2c1"</span>, <span class="jxr_string">"r2c2"</span> }) });
+<a class="jxr_linenumber" name="166" href="#166">166</a>         assertEquals(<span class="jxr_string">"r1c1,r1c2"</span> + recordSeparator + <span class="jxr_string">"r2c1,r2c2"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="167" href="#167">167</a>     }
 <a class="jxr_linenumber" name="168" href="#168">168</a> 
-<a class="jxr_linenumber" name="169" href="#169">169</a>         <strong class="jxr_keyword">if</strong> (!equals(lines, parseResult)) {
-<a class="jxr_linenumber" name="170" href="#170">170</a>             System.out.println(<span class="jxr_string">"Printer output :"</span> + printable(result));
-<a class="jxr_linenumber" name="171" href="#171">171</a>             assertTrue(false);
-<a class="jxr_linenumber" name="172" href="#172">172</a>         }
-<a class="jxr_linenumber" name="173" href="#173">173</a>     }
-<a class="jxr_linenumber" name="174" href="#174">174</a> 
-<a class="jxr_linenumber" name="175" href="#175">175</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">boolean</strong> equals(String[][] a, String[][] b) {
-<a class="jxr_linenumber" name="176" href="#176">176</a>         <strong class="jxr_keyword">if</strong> (a.length != b.length) {
-<a class="jxr_linenumber" name="177" href="#177">177</a>             <strong class="jxr_keyword">return</strong> false;
-<a class="jxr_linenumber" name="178" href="#178">178</a>         }
-<a class="jxr_linenumber" name="179" href="#179">179</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; a.length; i++) {
-<a class="jxr_linenumber" name="180" href="#180">180</a>             String[] linea = a[i];
-<a class="jxr_linenumber" name="181" href="#181">181</a>             String[] lineb = b[i];
-<a class="jxr_linenumber" name="182" href="#182">182</a>             <strong class="jxr_keyword">if</strong> (linea.length != lineb.length) {
-<a class="jxr_linenumber" name="183" href="#183">183</a>                 <strong class="jxr_keyword">return</strong> false;
-<a class="jxr_linenumber" name="184" href="#184">184</a>             }
-<a class="jxr_linenumber" name="185" href="#185">185</a>             <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> j = 0; j &lt; linea.length; j++) {
-<a class="jxr_linenumber" name="186" href="#186">186</a>                 String aval = linea[j];
-<a class="jxr_linenumber" name="187" href="#187">187</a>                 String bval = lineb[j];
-<a class="jxr_linenumber" name="188" href="#188">188</a>                 <strong class="jxr_keyword">if</strong> (!aval.equals(bval)) {
-<a class="jxr_linenumber" name="189" href="#189">189</a>                     System.out.println(<span class="jxr_string">"expected  :"</span> + printable(aval));
-<a class="jxr_linenumber" name="190" href="#190">190</a>                     System.out.println(<span class="jxr_string">"got       :"</span> + printable(bval));
-<a class="jxr_linenumber" name="191" href="#191">191</a>                     <strong class="jxr_keyword">return</strong> false;
-<a class="jxr_linenumber" name="192" href="#192">192</a>                 }
-<a class="jxr_linenumber" name="193" href="#193">193</a>             }
-<a class="jxr_linenumber" name="194" href="#194">194</a>         }
-<a class="jxr_linenumber" name="195" href="#195">195</a>         <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="196" href="#196">196</a>     }
-<a class="jxr_linenumber" name="197" href="#197">197</a> 
-<a class="jxr_linenumber" name="198" href="#198">198</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> String printable(String s) {
-<a class="jxr_linenumber" name="199" href="#199">199</a>         StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder();
-<a class="jxr_linenumber" name="200" href="#200">200</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; s.length(); i++) {
-<a class="jxr_linenumber" name="201" href="#201">201</a>             <strong class="jxr_keyword">char</strong> ch = s.charAt(i);
-<a class="jxr_linenumber" name="202" href="#202">202</a>             <strong class="jxr_keyword">if</strong> (ch &lt;= ' ' || ch &gt;= 128) {
-<a class="jxr_linenumber" name="203" href="#203">203</a>                 sb.append(<span class="jxr_string">"("</span>).append((<strong class="jxr_keyword">int</strong>) ch).append(<span class="jxr_string">")"</span>);
-<a class="jxr_linenumber" name="204" href="#204">204</a>             } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="205" href="#205">205</a>                 sb.append(ch);
-<a class="jxr_linenumber" name="206" href="#206">206</a>             }
-<a class="jxr_linenumber" name="207" href="#207">207</a>         }
-<a class="jxr_linenumber" name="208" href="#208">208</a>         <strong class="jxr_keyword">return</strong> sb.toString();
-<a class="jxr_linenumber" name="209" href="#209">209</a>     }
-<a class="jxr_linenumber" name="210" href="#210">210</a> 
-<a class="jxr_linenumber" name="211" href="#211">211</a>     <strong class="jxr_keyword">public</strong> String randStr() {
-<a class="jxr_linenumber" name="212" href="#212">212</a>         Random r = <strong class="jxr_keyword">new</strong> Random();
-<a class="jxr_linenumber" name="213" href="#213">213</a>         
-<a class="jxr_linenumber" name="214" href="#214">214</a>         <strong class="jxr_keyword">int</strong> sz = r.nextInt(20);
-<a class="jxr_linenumber" name="215" href="#215">215</a>         <em class="jxr_comment">// sz = r.nextInt(3);</em>
-<a class="jxr_linenumber" name="216" href="#216">216</a>         <strong class="jxr_keyword">char</strong>[] buf = <strong class="jxr_keyword">new</strong> <strong class="jxr_keyword">char</strong>[sz];
-<a class="jxr_linenumber" name="217" href="#217">217</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; sz; i++) {
-<a class="jxr_linenumber" name="218" href="#218">218</a>             <em class="jxr_comment">// stick in special chars with greater frequency</em>
-<a class="jxr_linenumber" name="219" href="#219">219</a>             <strong class="jxr_keyword">char</strong> ch;
-<a class="jxr_linenumber" name="220" href="#220">220</a>             <strong class="jxr_keyword">int</strong> what = r.nextInt(20);
-<a class="jxr_linenumber" name="221" href="#221">221</a>             <strong class="jxr_keyword">switch</strong> (what) {
-<a class="jxr_linenumber" name="222" href="#222">222</a>                 <strong class="jxr_keyword">case</strong> 0:
-<a class="jxr_linenumber" name="223" href="#223">223</a>                     ch = '\r';
-<a class="jxr_linenumber" name="224" href="#224">224</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="225" href="#225">225</a>                 <strong class="jxr_keyword">case</strong> 1:
-<a class="jxr_linenumber" name="226" href="#226">226</a>                     ch = '\n';
-<a class="jxr_linenumber" name="227" href="#227">227</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="228" href="#228">228</a>                 <strong class="jxr_keyword">case</strong> 2:
-<a class="jxr_linenumber" name="229" href="#229">229</a>                     ch = '\t';
-<a class="jxr_linenumber" name="230" href="#230">230</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="231" href="#231">231</a>                 <strong class="jxr_keyword">case</strong> 3:
-<a class="jxr_linenumber" name="232" href="#232">232</a>                     ch = '\f';
-<a class="jxr_linenumber" name="233" href="#233">233</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="234" href="#234">234</a>                 <strong class="jxr_keyword">case</strong> 4:
-<a class="jxr_linenumber" name="235" href="#235">235</a>                     ch = ' ';
-<a class="jxr_linenumber" name="236" href="#236">236</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="237" href="#237">237</a>                 <strong class="jxr_keyword">case</strong> 5:
-<a class="jxr_linenumber" name="238" href="#238">238</a>                     ch = ',';
-<a class="jxr_linenumber" name="239" href="#239">239</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="240" href="#240">240</a>                 <strong class="jxr_keyword">case</strong> 6:
-<a class="jxr_linenumber" name="241" href="#241">241</a>                     ch = '&quot;';
-<a class="jxr_linenumber" name="242" href="#242">242</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="243" href="#243">243</a>                 <strong class="jxr_keyword">case</strong> 7:
-<a class="jxr_linenumber" name="244" href="#244">244</a>                     ch = '\'';
-<a class="jxr_linenumber" name="245" href="#245">245</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="246" href="#246">246</a>                 <strong class="jxr_keyword">case</strong> 8:
-<a class="jxr_linenumber" name="247" href="#247">247</a>                     ch = '&#92;&#92;';
-<a class="jxr_linenumber" name="248" href="#248">248</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="249" href="#249">249</a>                 <strong class="jxr_keyword">default</strong>:
-<a class="jxr_linenumber" name="250" href="#250">250</a>                     ch = (<strong class="jxr_keyword">char</strong>) r.nextInt(300);
-<a class="jxr_linenumber" name="251" href="#251">251</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="252" href="#252">252</a>                 <em class="jxr_comment">// default: ch = 'a'; break;</em>
-<a class="jxr_linenumber" name="253" href="#253">253</a>             }
-<a class="jxr_linenumber" name="254" href="#254">254</a>             buf[i] = ch;
-<a class="jxr_linenumber" name="255" href="#255">255</a>         }
-<a class="jxr_linenumber" name="256" href="#256">256</a>         <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">new</strong> String(buf);
-<a class="jxr_linenumber" name="257" href="#257">257</a>     }
-<a class="jxr_linenumber" name="258" href="#258">258</a> 
-<a class="jxr_linenumber" name="259" href="#259">259</a> }
-</pre>
-<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
-</html>
-
+<a class="jxr_linenumber" name="169" href="#169">169</a>     @Test
+<a class="jxr_linenumber" name="170" href="#170">170</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrintAllIterableOfArrays() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="171" href="#171">171</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="172" href="#172">172</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="173" href="#173">173</a>         printer.printRecords(Arrays.asList(<strong class="jxr_keyword">new</strong> String[][] { { <span class="jxr_string">"r1c1"</span>, <span class="jxr_string">"r1c2"</span> }, { <span class="jxr_string">"r2c1"</span>, <span class="jxr_string">"r2c2"</span> } }));
+<a class="jxr_linenumber" name="174" href="#174">174</a>         assertEquals(<span class="jxr_string">"r1c1,r1c2"</span> + recordSeparator + <span class="jxr_string">"r2c1,r2c2"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="175" href="#175">175</a>     }
+<a class="jxr_linenumber" name="176" href="#176">176</a> 
+<a class="jxr_linenumber" name="177" href="#177">177</a>     @Test
+<a class="jxr_linenumber" name="178" href="#178">178</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrintAllIterableOfLists() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="179" href="#179">179</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="180" href="#180">180</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="181" href="#181">181</a>         printer.printRecords(Arrays.asList(<strong class="jxr_keyword">new</strong> List[] { Arrays.asList(<strong class="jxr_keyword">new</strong> String[] { <span class="jxr_string">"r1c1"</span>, <span class="jxr_string">"r1c2"</span> }),
+<a class="jxr_linenumber" name="182" href="#182">182</a>                 Arrays.asList(<strong class="jxr_keyword">new</strong> String[] { <span class="jxr_string">"r2c1"</span>, <span class="jxr_string">"r2c2"</span> }) }));
+<a class="jxr_linenumber" name="183" href="#183">183</a>         assertEquals(<span class="jxr_string">"r1c1,r1c2"</span> + recordSeparator + <span class="jxr_string">"r2c1,r2c2"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="184" href="#184">184</a>     }
+<a class="jxr_linenumber" name="185" href="#185">185</a> 
+<a class="jxr_linenumber" name="186" href="#186">186</a>     @Test
+<a class="jxr_linenumber" name="187" href="#187">187</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrinter1() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="188" href="#188">188</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="189" href="#189">189</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="190" href="#190">190</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>);
+<a class="jxr_linenumber" name="191" href="#191">191</a>         assertEquals(<span class="jxr_string">"a,b"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="192" href="#192">192</a>     }
+<a class="jxr_linenumber" name="193" href="#193">193</a> 
+<a class="jxr_linenumber" name="194" href="#194">194</a>     @Test
+<a class="jxr_linenumber" name="195" href="#195">195</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelPrinter2() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="196" href="#196">196</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="197" href="#197">197</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.EXCEL);
+<a class="jxr_linenumber" name="198" href="#198">198</a>         printer.printRecord(<span class="jxr_string">"a,b"</span>, <span class="jxr_string">"b"</span>);
+<a class="jxr_linenumber" name="199" href="#199">199</a>         assertEquals(<span class="jxr_string">"\&quot;a,b\&quot;,b"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="200" href="#200">200</a>     }
+<a class="jxr_linenumber" name="201" href="#201">201</a> 
+<a class="jxr_linenumber" name="202" href="#202">202</a>     @Test
+<a class="jxr_linenumber" name="203" href="#203">203</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testJdbcPrinter() <strong class="jxr_keyword">throws</strong> IOException, ClassNotFoundException, SQLException {
+<a class="jxr_linenumber" name="204" href="#204">204</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="205" href="#205">205</a>         Class.forName(<span class="jxr_string">"org.h2.Driver"</span>);
+<a class="jxr_linenumber" name="206" href="#206">206</a>         <strong class="jxr_keyword">final</strong> Connection connection = DriverManager.getConnection(<span class="jxr_string">"jdbc:h2:mem:my_test;"</span>, <span class="jxr_string">"sa"</span>, <span class="jxr_string">""</span>);
+<a class="jxr_linenumber" name="207" href="#207">207</a>         <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="208" href="#208">208</a>             <strong class="jxr_keyword">final</strong> Statement stmt = connection.createStatement();
+<a class="jxr_linenumber" name="209" href="#209">209</a>             stmt.execute(<span class="jxr_string">"CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255))"</span>);
+<a class="jxr_linenumber" name="210" href="#210">210</a>             stmt.execute(<span class="jxr_string">"insert into TEST values(1, 'r1')"</span>);
+<a class="jxr_linenumber" name="211" href="#211">211</a>             stmt.execute(<span class="jxr_string">"insert into TEST values(2, 'r2')"</span>);
+<a class="jxr_linenumber" name="212" href="#212">212</a>             <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="213" href="#213">213</a>             printer.printRecords(stmt.executeQuery(<span class="jxr_string">"select ID, NAME from TEST"</span>));
+<a class="jxr_linenumber" name="214" href="#214">214</a>             assertEquals(<span class="jxr_string">"1,r1"</span> + recordSeparator + <span class="jxr_string">"2,r2"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="215" href="#215">215</a>         } <strong class="jxr_keyword">finally</strong> {
+<a class="jxr_linenumber" name="216" href="#216">216</a>             connection.close();
+<a class="jxr_linenumber" name="217" href="#217">217</a>         }
+<a class="jxr_linenumber" name="218" href="#218">218</a>     }
+<a class="jxr_linenumber" name="219" href="#219">219</a> 
+<a class="jxr_linenumber" name="220" href="#220">220</a>     @Test
+<a class="jxr_linenumber" name="221" href="#221">221</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testMultiLineComment() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="222" href="#222">222</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="223" href="#223">223</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.newBuilder().withCommentStart('#').build());
+<a class="jxr_linenumber" name="224" href="#224">224</a>         printer.printComment(<span class="jxr_string">"This is a comment\non multiple lines"</span>);
+<a class="jxr_linenumber" name="225" href="#225">225</a> 
+<a class="jxr_linenumber" name="226" href="#226">226</a>         assertEquals(<span class="jxr_string">"# This is a comment"</span> + recordSeparator + <span class="jxr_string">"# on multiple lines"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="227" href="#227">227</a>     }
+<a class="jxr_linenumber" name="228" href="#228">228</a> 
+<a class="jxr_linenumber" name="229" href="#229">229</a>     @Test
+<a class="jxr_linenumber" name="230" href="#230">230</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter1() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="231" href="#231">231</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="232" href="#232">232</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="233" href="#233">233</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>);
+<a class="jxr_linenumber" name="234" href="#234">234</a>         assertEquals(<span class="jxr_string">"a,b"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="235" href="#235">235</a>     }
+<a class="jxr_linenumber" name="236" href="#236">236</a> 
+<a class="jxr_linenumber" name="237" href="#237">237</a>     @Test
+<a class="jxr_linenumber" name="238" href="#238">238</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter2() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="239" href="#239">239</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="240" href="#240">240</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="241" href="#241">241</a>         printer.printRecord(<span class="jxr_string">"a,b"</span>, <span class="jxr_string">"b"</span>);
+<a class="jxr_linenumber" name="242" href="#242">242</a>         assertEquals(<span class="jxr_string">"\&quot;a,b\&quot;,b"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="243" href="#243">243</a>     }
+<a class="jxr_linenumber" name="244" href="#244">244</a> 
+<a class="jxr_linenumber" name="245" href="#245">245</a>     @Test
+<a class="jxr_linenumber" name="246" href="#246">246</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter3() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="247" href="#247">247</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="248" href="#248">248</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="249" href="#249">249</a>         printer.printRecord(<span class="jxr_string">"a, b"</span>, <span class="jxr_string">"b "</span>);
+<a class="jxr_linenumber" name="250" href="#250">250</a>         assertEquals(<span class="jxr_string">"\&quot;a, b\&quot;,\&quot;b \&quot;"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="251" href="#251">251</a>     }
+<a class="jxr_linenumber" name="252" href="#252">252</a> 
+<a class="jxr_linenumber" name="253" href="#253">253</a>     @Test
+<a class="jxr_linenumber" name="254" href="#254">254</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter4() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="255" href="#255">255</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="256" href="#256">256</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="257" href="#257">257</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\&quot;c"</span>);
+<a class="jxr_linenumber" name="258" href="#258">258</a>         assertEquals(<span class="jxr_string">"a,\&quot;b\&quot;\&quot;c\&quot;"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="259" href="#259">259</a>     }
+<a class="jxr_linenumber" name="260" href="#260">260</a> 
+<a class="jxr_linenumber" name="261" href="#261">261</a>     @Test
+<a class="jxr_linenumber" name="262" href="#262">262</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter5() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="263" href="#263">263</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="264" href="#264">264</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="265" href="#265">265</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\nc"</span>);
+<a class="jxr_linenumber" name="266" href="#266">266</a>         assertEquals(<span class="jxr_string">"a,\&quot;b\nc\&quot;"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="267" href="#267">267</a>     }
+<a class="jxr_linenumber" name="268" href="#268">268</a> 
+<a class="jxr_linenumber" name="269" href="#269">269</a>     @Test
+<a class="jxr_linenumber" name="270" href="#270">270</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter6() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="271" href="#271">271</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="272" href="#272">272</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="273" href="#273">273</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\r\nc"</span>);
+<a class="jxr_linenumber" name="274" href="#274">274</a>         assertEquals(<span class="jxr_string">"a,\&quot;b\r\nc\&quot;"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="275" href="#275">275</a>     }
+<a class="jxr_linenumber" name="276" href="#276">276</a> 
+<a class="jxr_linenumber" name="277" href="#277">277</a>     @Test
+<a class="jxr_linenumber" name="278" href="#278">278</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrinter7() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="279" href="#279">279</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="280" href="#280">280</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="281" href="#281">281</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b&#92;&#92;c"</span>);
+<a class="jxr_linenumber" name="282" href="#282">282</a>         assertEquals(<span class="jxr_string">"a,b&#92;&#92;c"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="283" href="#283">283</a>     }
+<a class="jxr_linenumber" name="284" href="#284">284</a> 
+<a class="jxr_linenumber" name="285" href="#285">285</a>     @Test
+<a class="jxr_linenumber" name="286" href="#286">286</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testPrintNullValues() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="287" href="#287">287</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="288" href="#288">288</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="289" href="#289">289</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <strong class="jxr_keyword">null</strong>, <span class="jxr_string">"b"</span>);
+<a class="jxr_linenumber" name="290" href="#290">290</a>         assertEquals(<span class="jxr_string">"a,,b"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="291" href="#291">291</a>     }
+<a class="jxr_linenumber" name="292" href="#292">292</a> 
+<a class="jxr_linenumber" name="293" href="#293">293</a>     @Test
+<a class="jxr_linenumber" name="294" href="#294">294</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testQuoteAll() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="295" href="#295">295</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="296" href="#296">296</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.newBuilder().withQuotePolicy(Quote.ALL).build());
+<a class="jxr_linenumber" name="297" href="#297">297</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\nc"</span>, <span class="jxr_string">"d"</span>);
+<a class="jxr_linenumber" name="298" href="#298">298</a>         assertEquals(<span class="jxr_string">"\&quot;a\&quot;,\&quot;b\nc\&quot;,\&quot;d\&quot;"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="299" href="#299">299</a>     }
+<a class="jxr_linenumber" name="300" href="#300">300</a> 
+<a class="jxr_linenumber" name="301" href="#301">301</a>     @Test
+<a class="jxr_linenumber" name="302" href="#302">302</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testQuoteNonNumeric() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="303" href="#303">303</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="304" href="#304">304</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.newBuilder().withQuotePolicy(Quote.NON_NUMERIC).build());
+<a class="jxr_linenumber" name="305" href="#305">305</a>         printer.printRecord(<span class="jxr_string">"a"</span>, <span class="jxr_string">"b\nc"</span>, Integer.valueOf(1));
+<a class="jxr_linenumber" name="306" href="#306">306</a>         assertEquals(<span class="jxr_string">"\&quot;a\&quot;,\&quot;b\nc\&quot;,1"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="307" href="#307">307</a>     }
+<a class="jxr_linenumber" name="308" href="#308">308</a> 
+<a class="jxr_linenumber" name="309" href="#309">309</a>     @Test
+<a class="jxr_linenumber" name="310" href="#310">310</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testRandom() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="311" href="#311">311</a>         <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> iter = 10000;
+<a class="jxr_linenumber" name="312" href="#312">312</a>         doRandom(CSVFormat.DEFAULT, iter);
+<a class="jxr_linenumber" name="313" href="#313">313</a>         doRandom(CSVFormat.EXCEL, iter);
+<a class="jxr_linenumber" name="314" href="#314">314</a>         doRandom(CSVFormat.MYSQL, iter);
+<a class="jxr_linenumber" name="315" href="#315">315</a>     }
+<a class="jxr_linenumber" name="316" href="#316">316</a> 
+<a class="jxr_linenumber" name="317" href="#317">317</a>     @Test
+<a class="jxr_linenumber" name="318" href="#318">318</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testSingleLineComment() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="319" href="#319">319</a>         <strong class="jxr_keyword">final</strong> StringWriter sw = <strong class="jxr_keyword">new</strong> StringWriter();
+<a class="jxr_linenumber" name="320" href="#320">320</a>         <strong class="jxr_keyword">final</strong> CSVPrinter printer = <strong class="jxr_keyword">new</strong> CSVPrinter(sw, CSVFormat.newBuilder().withCommentStart('#').build());
+<a class="jxr_linenumber" name="321" href="#321">321</a>         printer.printComment(<span class="jxr_string">"This is a comment"</span>);
+<a class="jxr_linenumber" name="322" href="#322">322</a> 
+<a class="jxr_linenumber" name="323" href="#323">323</a>         assertEquals(<span class="jxr_string">"# This is a comment"</span> + recordSeparator, sw.toString());
+<a class="jxr_linenumber" name="324" href="#324">324</a>     }
+<a class="jxr_linenumber" name="325" href="#325">325</a> 
+<a class="jxr_linenumber" name="326" href="#326">326</a> }
+</pre>
+<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
+</html>



Mime
View raw message