groovy:NQY_R_Directory

//groovy:NQY_R_Directory
import groovy.io.FileType
import groovy.sql.Sql
import java.sql.Timestamp
import java.util.Calendar;
import java.util.Date;
def sql = Sql.newInstance('jdbc:oracle:thin:@192.168.170.2:1521:HEALTH','IDEMPIERE',,'IDEMPIERE','oracle.jdbc.driver.OracleDriver')

println(Calendar.getInstance().get(Calendar.HOUR_OF_DAY))   // 17
println(Calendar.getInstance().get(Calendar.MINUTE))              // 12
println(Calendar.getInstance().get(Calendar.SECOND))          // 23

def filepath = ''
def list = []
def dir = new File("C:\\PAP")

dir.eachFileRecurse (FileType.FILES) { file ->
  // println file.path
  // String result = names.substring(0, names.indexOf('-'))
     if ((file.path).indexOf('新泰宜') > 0  &&
       (file.path).indexOf('子抹電子檔') > 0 ){
          list << file
          // println file.path
       }    
}
println "矩陣讀出...."
list.each {
   println it.path
   def  fileName = it.path
   def  v_c1 = 0
   sql.eachRow("select count(*) as c1 from nqy_pap_imp_log where filename='"+fileName+"'" ) { row -> // 是否已寫入過
   println  "($row.c1)"
   }
   def  file = new File(fileName).getText('Big5')
   def lineCount = 0 
   file.eachLine() { line -> 
      def field = line.tokenize(",") 
       lineCount++ 
       println "line: ${lineCount} , ${field[0]}, ${field[1]}, ${field[2]})  "
   }
}


/*
// CREATE TABLE nqy_pap_imp_log (filename VARCHAR2(200),created  DATE);

list.each {
   println it.path
   def  fileName = it.path
   def  file = new File(fileName).getText('Big5')
// def  file = new File(fileName).getText('UTF-8')
   def lineCount = 0 
   file.eachLine() { line -> 
      def field = line.tokenize(",") 
      lineCount++ 
   // println "line: ${lineCount} , ${field[0]}, ${field[1]}, ${field[2]})  "
      f0=null
      f1=null
      f2=null
      f3=null
      f4=null
      if (field[0] != null) f0 = field[0].trim()
      if (field[1] != null) f1 = field[1].trim()
      if (field[2] != null) f2 = field[2].trim()
      if (field[3] != null) f3 = field[3].trim()
      if (field[4] != null) f4 = field[4].trim()
      if (f0!=null && (v0=="序號" || i0>0) ) {
          i0 = f0.isInteger() ? (f0 as int) : null
          if (i0!=null) {
              println "line: ${i0} "
          } 
          v0=f0;v1=f1;
      }
   }
}*/
return ""