用python将csv文件写入到oracle中去，csv2oracle-v1

# -*- coding=utf-8 -*-
import xlrd
import string
import os
import pymysql
import time
import datetime
import cx_Oracle

def IsSubString(SubStrList,Str):
    flag=True
    for substr in SubStrList:
        if not(substr in Str):
            flag=False
    return flag



def fn_get_filelist(FindPath,FlagStr=[]):
    FileList=[]
    FileNames=os.listdir(FindPath)
    if (len(FileNames) > 0):
       for fn in FileNames:
           if (len(FlagStr) > 0):
               #返回指定类型的文件名
               if (IsSubString(FlagStr,fn)) :
                   fullfilename=os.path.join(FindPath,fn)
                   if   '~$' not in  fullfilename :
                       FileList.append(fullfilename)
           else:
               #默认直接返回所有文件名
               fullfilename=os.path.join(FindPath,fn)
               FileList.append(fullfilename)
    #对文件名排序
    if (len(FileList)>0):
        FileList.sort()
    for i in range(l