Class .forName("oracle.jdbc.driver.OracleDriver");
        Connection connect = DriverManager.getConnection("jdbc:oracle:thin:@host:1521:orex", "****", "****");
          while (next)
         {       
           Statement st = connect.createStatement();
           ResultSet seqval = st.executeQuery("select TEST_SEQ.nextval from dual");
           resbuff.append("INSERT INTO TEST (ID, NID) VALUES ( " + seqval.getString( 1 ) + " ," + nid);
           CallableStatement cstmt = connect.prepareCall(ex);        
           cstmt.execute();
           cstmt.close();
           seqval.close();
           count++;
            if (count== 1000 )
           {
             connect.commit();
             st.executeQuery("select sysdate from dual");
           }
           resbuff.delete( 0 , resbuff.length());
           st.close();
        }
         connect.commit();

         while (zis.available()> 0 )
        {
         zis.getNextEntry();
         DBFReader dbfr =  new  DBFReader(zis);
         StringBuffer resbuff =  new  StringBuffer();
         Object [] rows =  null ;
          int  countf = dbfr.getFieldCount();
          int  count= 0 ;
          while (dbfr.hasNextRecord())
         {       
           Statement st = connect.createStatement();
           rows = dbfr.nextRecord();
           ResultSet refid = st.executeQuery("select secid from test where CODE='" + typefdb(rows[0],dbfr.getField(0).getType(),inXML)+"'");
           refid.next();
           String sid = refid.getString( 1 );
           ResultSet seqval = st.executeQuery("select TEST_SEQ.nextval from dual");
           seqval.next();
           resbuff.append("INSERT INTO TEST (ID, SID, DATETIME, P, Q, V) VALUES ( " + seqval.getString( 1 ) + " ," + sid);
            for ( int  i= 1 ;i<countf;i++)
           {
              if (i== 3 )
             {
                continue ;
             }
              if (dbfr.getField(i).getType()=='D')
             {
               resbuff.append(", TO_DATE( '").append(typefdb(rows[i],dbfr.getField(i).getType(),inXML)).append(" ").append(typefdb(rows[i+1],dbfr.getField(i+1).getType(),inXML)).append("','YYYY-MM-DD HH24:MI:SS')");
               i++;
                continue ;
             }
             resbuff.append(", ").append(typefdb(rows[i],dbfr.getField(i).getType(),inXML));
           }
           resbuff.append(")");
           String ex = resbuff.toString();
           CallableStatement cstmt = connect.prepareCall(ex);        
           cstmt.execute();
           cstmt.close();
           seqval.close();
           count++;
            if (count== 1000 )
           {
             connect.commit();
             st.executeQuery("select sysdate from dual");
           }
           resbuff.delete( 0 , resbuff.length());
           st.close();
         }
         connect.commit();