[Csvtosql-cvs] csvtosql/src/net/sf/csv2sql/renders SqlInsertRendererFromDBF.java, 1.11, 1.12 SqlIn
Brought to you by:
davideconsonni
Update of /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv25680/src/net/sf/csv2sql/renders Modified Files: SqlInsertRendererFromDBF.java SqlInsertRenderer.java SqlInsertRendererFromExcel.java AbstractRender.java SqlInsertRendererFromArray.java Log Message: Index: SqlInsertRendererFromExcel.java =================================================================== RCS file: /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders/SqlInsertRendererFromExcel.java,v retrieving revision 1.33 retrieving revision 1.34 diff -C2 -d -r1.33 -r1.34 *** SqlInsertRendererFromExcel.java 5 Mar 2005 11:52:32 -0000 1.33 --- SqlInsertRendererFromExcel.java 16 Nov 2006 16:23:03 -0000 1.34 *************** *** 2,18 **** Copyright (C) 2004 Davide Consonni <dco...@en...> ! This program is free software; you can redistribute it and/or modify ! it under the terms of the GNU General Public License as published by ! the Free Software Foundation; either version 2 of the License, or ! (at your option) any later version. ! This program is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ! GNU General Public License for more details. ! You should have received a copy of the GNU General Public License ! along with this program; if not, write to the Free Software ! Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sf.csv2sql.renders; --- 2,18 ---- Copyright (C) 2004 Davide Consonni <dco...@en...> ! This library is free software; you can redistribute it and/or ! modify it under the terms of the GNU Lesser General Public ! License as published by the Free Software Foundation; either ! version 2.1 of the License, or (at your option) any later version. ! This library is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ! Lesser General Public License for more details. ! You should have received a copy of the GNU Lesser General Public ! License along with this library; if not, write to the Free Software ! Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ package net.sf.csv2sql.renders; Index: SqlInsertRenderer.java =================================================================== RCS file: /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders/SqlInsertRenderer.java,v retrieving revision 1.52 retrieving revision 1.53 diff -C2 -d -r1.52 -r1.53 *** SqlInsertRenderer.java 12 Mar 2005 11:29:21 -0000 1.52 --- SqlInsertRenderer.java 16 Nov 2006 16:23:03 -0000 1.53 *************** *** 2,18 **** Copyright (C) 2004 Davide Consonni <dco...@en...> ! This program is free software; you can redistribute it and/or modify ! it under the terms of the GNU General Public License as published by ! the Free Software Foundation; either version 2 of the License, or ! (at your option) any later version. ! This program is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ! GNU General Public License for more details. ! You should have received a copy of the GNU General Public License ! along with this program; if not, write to the Free Software ! Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sf.csv2sql.renders; --- 2,18 ---- Copyright (C) 2004 Davide Consonni <dco...@en...> ! This library is free software; you can redistribute it and/or ! modify it under the terms of the GNU Lesser General Public ! License as published by the Free Software Foundation; either ! version 2.1 of the License, or (at your option) any later version. ! This library is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ! Lesser General Public License for more details. ! You should have received a copy of the GNU Lesser General Public ! License along with this library; if not, write to the Free Software ! Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ package net.sf.csv2sql.renders; *************** *** 205,208 **** --- 205,221 ---- BufferedReader in = new BufferedReader(new InputStreamReader(fis)); + // read field names + // this String array contains names of each column + // It is assumed that first line in the CSV file contains these names + // String[] columnNames; + // { + // String line = in.readLine(); + // if (line!=null) { + // columnNames = calculateSplitter().split(line, calculateSeparator() ); + // } + // in.close(); + // in = new BufferedReader(new InputStreamReader(fis)); + // } + //OPTION //suppress header skip first line *************** *** 247,251 **** --- 260,267 ---- // add every item to statement + // int tableLength = this.getTableStructure().getFields().size(); + // int loopLimit = ((row.length >= tableLength) ? row.length : tableLength); for (int i=0; i<this.getTableStructure().getFields().size(); i++) { + // for (int i=0; i<loopLimit; i++) { String valueToRender = null; Index: SqlInsertRendererFromDBF.java =================================================================== RCS file: /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders/SqlInsertRendererFromDBF.java,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** SqlInsertRendererFromDBF.java 9 Jan 2005 13:52:44 -0000 1.11 --- SqlInsertRendererFromDBF.java 16 Nov 2006 16:23:03 -0000 1.12 *************** *** 2,18 **** Copyright (C) 2004 Davide Consonni <dco...@en...> ! This program is free software; you can redistribute it and/or modify ! it under the terms of the GNU General Public License as published by ! the Free Software Foundation; either version 2 of the License, or ! (at your option) any later version. ! This program is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ! GNU General Public License for more details. ! You should have received a copy of the GNU General Public License ! along with this program; if not, write to the Free Software ! Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sf.csv2sql.renders; --- 2,18 ---- Copyright (C) 2004 Davide Consonni <dco...@en...> ! This library is free software; you can redistribute it and/or ! modify it under the terms of the GNU Lesser General Public ! License as published by the Free Software Foundation; either ! version 2.1 of the License, or (at your option) any later version. ! This library is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ! Lesser General Public License for more details. ! You should have received a copy of the GNU Lesser General Public ! License along with this library; if not, write to the Free Software ! Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ package net.sf.csv2sql.renders; Index: SqlInsertRendererFromArray.java =================================================================== RCS file: /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders/SqlInsertRendererFromArray.java,v retrieving revision 1.34 retrieving revision 1.35 diff -C2 -d -r1.34 -r1.35 *** SqlInsertRendererFromArray.java 9 Mar 2005 10:25:23 -0000 1.34 --- SqlInsertRendererFromArray.java 16 Nov 2006 16:23:03 -0000 1.35 *************** *** 2,18 **** Copyright (C) 2004 Davide Consonni <dco...@en...> ! This program is free software; you can redistribute it and/or modify ! it under the terms of the GNU General Public License as published by ! the Free Software Foundation; either version 2 of the License, or ! (at your option) any later version. ! This program is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ! GNU General Public License for more details. ! You should have received a copy of the GNU General Public License ! along with this program; if not, write to the Free Software ! Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sf.csv2sql.renders; --- 2,18 ---- Copyright (C) 2004 Davide Consonni <dco...@en...> ! This library is free software; you can redistribute it and/or ! modify it under the terms of the GNU Lesser General Public ! License as published by the Free Software Foundation; either ! version 2.1 of the License, or (at your option) any later version. ! This library is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ! Lesser General Public License for more details. ! You should have received a copy of the GNU Lesser General Public ! License along with this library; if not, write to the Free Software ! Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ package net.sf.csv2sql.renders; Index: AbstractRender.java =================================================================== RCS file: /cvsroot/csvtosql/csvtosql/src/net/sf/csv2sql/renders/AbstractRender.java,v retrieving revision 1.19 retrieving revision 1.20 diff -C2 -d -r1.19 -r1.20 *** AbstractRender.java 9 Jan 2005 13:52:43 -0000 1.19 --- AbstractRender.java 16 Nov 2006 16:23:03 -0000 1.20 *************** *** 2,18 **** Copyright (C) 2004 Davide Consonni <dco...@en...> ! This program is free software; you can redistribute it and/or modify ! it under the terms of the GNU General Public License as published by ! the Free Software Foundation; either version 2 of the License, or ! (at your option) any later version. ! This program is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ! GNU General Public License for more details. ! You should have received a copy of the GNU General Public License ! along with this program; if not, write to the Free Software ! Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sf.csv2sql.renders; --- 2,18 ---- Copyright (C) 2004 Davide Consonni <dco...@en...> ! This library is free software; you can redistribute it and/or ! modify it under the terms of the GNU Lesser General Public ! License as published by the Free Software Foundation; either ! version 2.1 of the License, or (at your option) any later version. ! This library is distributed in the hope that it will be useful, ! but WITHOUT ANY WARRANTY; without even the implied warranty of ! MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ! Lesser General Public License for more details. ! You should have received a copy of the GNU Lesser General Public ! License along with this library; if not, write to the Free Software ! Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ package net.sf.csv2sql.renders; |