public byte[] getByteValue(ResultSet resultSet, int nCol1Based, boolean bEbcdicOutput) { try { String csValue = resultSet.getString(nCol1Based); byte[] aBytes = csValue.getBytes(); if (bEbcdicOutput) // Must outout in ebcdic AsciiEbcdicConverter.swapByteAsciiToEbcdic(aBytes, 0, aBytes.length); return aBytes; } catch (SQLException e) { return null; } }
public byte[] getExcelValue(ResultSet resultSet, int nCol1Based, boolean bEbcdicOutput) { try { String csValue = resultSet.getString(nCol1Based); csValue = csValue.trim().replace("\"", "'"); if (csValue.length() == 0) csValue = " "; csValue = "\"" + csValue + "\""; byte[] aBytes = csValue.getBytes(); if (bEbcdicOutput) // Must outout in ebcdic AsciiEbcdicConverter.swapByteAsciiToEbcdic(aBytes, 0, aBytes.length); return aBytes; } catch (SQLException e) { return null; } }
public int setByteValueInStmtCol( DbColDefErrorManager dbColDefErrorManager, DbPreparedStatement stmt, int nCol, byte arrByteValue[], int nSourceOffset, boolean bEbcdicInput) { if (bEbcdicInput) // Must outout in ebcdic AsciiEbcdicConverter.swapByteEbcdicToAscii(arrByteValue, nSourceOffset, m_nLength); String csValue = new String(arrByteValue, nSourceOffset, m_nLength); stmt.setColParam(nCol, csValue); return m_nLength; }