Package au.com.bytecode.opencsv

Examples of au.com.bytecode.opencsv.CSVReader.readNext()

181
182
183
184
185
186
187
188
189
190
191
      cfMap.put(c.getField_name(), c.getId());
    }
    try {
      CSVReader reader = new CSVReader(new InputStreamReader(mFile.getInputStream(),"GBK"));
//      List<String[]> all = reader.readAll();
      String[] title = reader.readNext();
      String[] nextLine;
      ParaMap<String, Object> m = new ParaMap<String, Object>();
      m.put("customFieldList", cfList);
      m.put("table_name", project.getTable_name());
      while ((nextLine = reader.readNext()) != null) {
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
      String[] title = reader.readNext();
      String[] nextLine;
      ParaMap<String, Object> m = new ParaMap<String, Object>();
      m.put("customFieldList", cfList);
      m.put("table_name", project.getTable_name());
      while ((nextLine = reader.readNext()) != null) {
        for(int i=0;i<nextLine.length;i++){
          if (nextLine[i] != null)
          m.put("field"+cfMap.get(title[i]), nextLine[i]);
        }
        projectMapper.itemAdd(m);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
        // Compare Phoenix ResultSet with CSV file content
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES_WITH_HEADER));
        reader.readNext();
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
          assertTrue (phoenixResultSet.next());
          for (int i=0; i<csvData.length; i++) {
            assertEquals(csvData[i], phoenixResultSet.getString(i+1));
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES_WITH_HEADER));
        reader.readNext();
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
          assertTrue (phoenixResultSet.next());
          for (int i=0; i<csvData.length; i++) {
            assertEquals(csvData[i], phoenixResultSet.getString(i+1));
          }
        }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
        // Compare Phoenix ResultSet with CSV file content
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES_WITH_DELIMITER),'\u0001','\u0002','\u0003');
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
            assertTrue (phoenixResultSet.next());
            for (int i=0; i<csvData.length; i++) {
                assertEquals(csvData[i], phoenixResultSet.getString(i+1));
            }
        }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
        // Compare Phoenix ResultSet with CSV file content
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES));
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
            assertTrue (phoenixResultSet.next());
            for (int i=0; i<csvData.length; i++) {
                assertEquals(csvData[i], phoenixResultSet.getString(i+1));
            }
        }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
        // Compare Phoenix ResultSet with CSV file content
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES));
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
            assertTrue (phoenixResultSet.next());
            for (int i=0; i<csvData.length; i++) {
                assertEquals(csvData[i], phoenixResultSet.getString(i+1));
            }
        }
View Full Code Here
194
195
196
197
198
199
200
201
202
203
204
        // Compare Phoenix ResultSet with CSV file content
        PreparedStatement statement = conn.prepareStatement("SELECT SYMBOL, COMPANY FROM " + STOCK_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(STOCK_CSV_VALUES));
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
            assertTrue (phoenixResultSet.next());
            assertEquals(csvData[0], phoenixResultSet.getString(1));
            assertNull(phoenixResultSet.getString(2));
        }
       
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
    PreparedStatement statement = conn
        .prepareStatement("SELECT CKEY, CVARCHAR, CINTEGER, CDECIMAL, CUNSIGNED_INT, CBOOLEAN, CBIGINT, CUNSIGNED_LONG, CTIME, CDATE FROM "
            + DATATYPE_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(DATATYPES_CSV_VALUES));
        reader.readNext();
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
          assertTrue (phoenixResultSet.next());
          for (int i=0; i<csvData.length - 2; i++) {
            assertEquals(csvData[i], phoenixResultSet.getObject(i+1).toString().toUpperCase());
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
            + DATATYPE_TABLE);
        ResultSet phoenixResultSet = statement.executeQuery();
        reader = new CSVReader(new StringReader(DATATYPES_CSV_VALUES));
        reader.readNext();
        String[] csvData;
        while ((csvData = reader.readNext()) != null) {
          assertTrue (phoenixResultSet.next());
          for (int i=0; i<csvData.length - 2; i++) {
            assertEquals(csvData[i], phoenixResultSet.getObject(i+1).toString().toUpperCase());
          }
          // special case for matching date, time values
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.