Package net.sourceforge.squirrel_sql.plugins.dataimport.importer

Examples of net.sourceforge.squirrel_sql.plugins.dataimport.importer.UnsupportedFormatException

161
162
163
164
165
166
167
168
169
   */
  public Integer getInt(int column) throws IOException, UnsupportedFormatException {
    checkPointer();
    Cell cell = sheet.getCell(column, pointer);
    if (cell.getType() != CellType.NUMBER) {
      throw new UnsupportedFormatException();
    }
    return (new Double(((NumberCell) cell).getValue())).intValue();
  }
View Full Code Here
174
175
176
177
178
179
180
181
182
   */
  public Date getDate(int column) throws IOException, UnsupportedFormatException {
    checkPointer();
    Cell cell = sheet.getCell(column, pointer);
    if (cell.getType() != CellType.DATE) {
      throw new UnsupportedFormatException();
    }
    return ((DateCell) cell).getDate();
  }
View Full Code Here
187
188
189
190
191
192
193
194
195
   */
  public Long getLong(int column) throws IOException, UnsupportedFormatException {
    checkPointer();
    Cell cell = sheet.getCell(column, pointer);
    if (cell.getType() != CellType.NUMBER) {
      throw new UnsupportedFormatException();
    }
    return (new Double(((NumberCell) cell).getValue())).longValue();
  }
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
      long value = 0;
      try {
        value = Long.parseLong(getFixedValue(column));
        value += counter;
      } catch (NumberFormatException nfe) {
        throw new UnsupportedFormatException();
      }
      switch (column.getDataType()) {
      case Types.BIGINT:
         stmt.setLong(index, value);
        break;
      case Types.INTEGER:
      case Types.NUMERIC:
         stmt.setInt(index, (int)value);
        break;
      default:
        throw new UnsupportedFormatException();
      }
  }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
      switch (column.getDataType()) {
      case Types.BIGINT:
        try {
          stmt.setLong(index, Long.parseLong(value));
        } catch (NumberFormatException nfe) {
          throw new UnsupportedFormatException();
        }
        break;
      case Types.INTEGER:
      case Types.NUMERIC:
        setIntOrUnsignedInt(stmt, index, column);
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
  private void setDateOrNull(PreparedStatement stmt, int index,
      String value) throws UnsupportedFormatException, SQLException {
    if (null != value) {
      Date d = DateUtils.parseSQLFormats(value);
      if (d == null)
        throw new UnsupportedFormatException();
      stmt.setDate(index, new java.sql.Date(d.getTime()));
    } else {
      stmt.setNull(index, Types.DATE);
    }
  }
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
  private void setTimeStampOrNull(PreparedStatement stmt, int index,
      String value) throws UnsupportedFormatException, SQLException {
    if (null != value) {
      Date d = DateUtils.parseSQLFormats(value);
      if (d == null)
        throw new UnsupportedFormatException();
      stmt.setTimestamp(index, new java.sql.Timestamp(d.getTime()));
    } else {
      stmt.setNull(index, Types.TIMESTAMP);
    }
  }
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
  private void setTimeOrNull(PreparedStatement stmt, int index, String value)
      throws UnsupportedFormatException, SQLException {
    if (null != value) {
      Date d = DateUtils.parseSQLFormats(value);
      if (d == null)
        throw new UnsupportedFormatException();
      stmt.setTime(index, new java.sql.Time(d.getTime()));
    } else {
      stmt.setNull(index, Types.TIME);
    }
  }
View Full Code Here
153
154
155
156
157
158
159
160
      if (null == longS || 0 == longS.trim().length()){
        return null;
      }       
      return Long.parseLong(longS);
    } catch (NumberFormatException nfe) {
      throw new UnsupportedFormatException();
    }
  }
View Full Code Here
170
171
172
173
174
175
176
177
      if (null == intS || 0 == intS.trim().length()){
        return null;
      }
      return Integer.parseInt(intS);
    } catch (NumberFormatException nfe) {
      throw new UnsupportedFormatException(nfe);
    }
  }
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.plugins.dataimport.importer.UnsupportedFormatException

  • net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor
  • net.sourceforge.squirrel_sql.plugins.dataimport.importer.csv.CSVFileImporter
  • net.sourceforge.squirrel_sql.plugins.dataimport.importer.excel.ExcelFileImporter
    • Copyright © 2018 www.massapicom. 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.