Changeset 20457

Timestamp:

02/23/10 13:56:46 (5 months ago)

Author:

tincholiguori

Message:

--

Files:

• trunk/tools/propertyExporter/src/net/project/poi/Import.java (modified) (7 diffs)

trunk/tools/propertyExporter/src/net/project/poi/Import.java

@@ -15 +15 @@
-import java.util.Properties;
-
+import org.apache.commons.lang.StringUtils;
-import org.apache.poi.hssf.usermodel.HSSFCell;
+import org.apache.poi.hssf.usermodel.HSSFRichTextString;
-import org.apache.poi.hssf.usermodel.HSSFRow;
-import org.apache.poi.hssf.usermodel.HSSFSheet;
@@ -60 +62 @@
-                        try {
-                                fileSystem = new POIFSFileSystem(inputStream);
-
+
-                                HSSFWorkbook workBook = new HSSFWorkbook(fileSystem);
-                                HSSFSheet sheet = workBook.getSheetAt(0);
@@ -75 +77 @@
-                                                        // set property value, property_value_clob
-                                                        HSSFCell cell = row.getCell(1);
-
+
+
+
+
+
+
-                                                                cell = row.getCell(2);
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                                                                ps.setCharacterStream(2, null, 0);
-                                                        }else{
-                                                                cell = row.getCell(2);
-                                                                ps.setString(1, null);
-                                                                StringReader reader = new StringReader(cell.getRichStringCellValue().toString());
-                                                                if (cell.getRichStringCellValue() != null && cell.getRichStringCellValue().length() > 0) {
-                                                                        ps.setCharacterStream(2, reader, cell.getRichStringCellValue().toString().length());
-                                                                } else {
-                                                                        ps.setCharacterStream(2, null, 0);
-                                                                }
-                                                        }
-                                                        
@@ -122 +135 @@
-                                                        cell = row.getCell(2);
-                                                        if ("text".equals(propertyType)) {
-
+
+
+
+
+
+
+
+
+
+
+
-                                                                ps.setCharacterStream(4, null, 0);
-                                                        } else {
-                                                                ps.setString(3, null);
-StringReader reader = new StringReader(cell.getRichStringCellValue().toString());
-if (cell.getRichStringCellValue() != null && cell.getRichStringCellValue().length() > 0) {
+if (cell != null && cell.getRichStringCellValue() != null && cell.getRichStringCellValue().length() > 0) {
+       StringReader reader = new StringReader(cell.getRichStringCellValue().toString());
-                                                                        ps.setCharacterStream(4, reader, cell.getRichStringCellValue().toString().length());
-                                                                } else {
@@ -142 +165 @@
-                                                        
-                                                        cell = row.getCell(4);
-
+
+
+
+
+
+
+
+
+
+
+
+
+
-                                                        ps.execute();
-                                                        if (rowNumber >= displayCount) {
@@ -150 +185 @@
-                                                        rowNumber++;
-                                                }
-                                                ps.close();
-                                        } catch (Exception e) {
+                                                System.err.println("Error at line: " + rowNumber);
-                                                e.printStackTrace();
+                                        } finally {
+                                                if ( ps != null) {
+                                                        ps.close();
+                                                }
-                                        }
-                                }
@@ -176 +215 @@
-                                e.printStackTrace();
-                        }
-
-                }
-        }
-
-}