xmls

package com.monitor.resolve;

import java.io.File;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.dom4j.Document;
import org.dom4j.Element;
import org.dom4j.Node;
import org.dom4j.io.SAXReader;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import com.monitor.entity.Fcs13;
import com.monitor.service.TimeFor;

@Service
public class ReadXmlService {

Log log = LogFactory.getLog(TimeFor.class);

@Autowired(required = false)
private JdbcTemplate jdbc;

public JdbcTemplate getJdbc() {
return jdbc;
}

public void setJdbc(JdbcTemplate jdbc) {
this.jdbc = jdbc;
}

private PreparedStatement ps=null;

Fcs13 book = new Fcs13();
public void resolve(){

refreshFileList("D:\\SAICFTEST\\INTERFACE\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\");
}

private void refreshFileList(String strPath) {
String str = null;
String strctl = null;
    File dir = new File(strPath);
    File[] files = dir.listFiles();
    String fileName = null;
    String fileCtlName = null;
    List list = new ArrayList();
    List listctl = new ArrayList();
    if (files == null)
        return;
    for (int i = 0; i < files.length; i++) {
        if (files[i].isDirectory()) {
            refreshFileList(files[i].getAbsolutePath());
        } else {
            String strFileName = files[i].getAbsolutePath().toLowerCase();
            String strFileNamedaxie = strFileName.toUpperCase();
            if(strFileName.endsWith(".xml")){
            str = strFileName;
              File str1 = new File(str.trim());
               fileName = str1.getName();
                   list.add(fileName);
            }             
        }
    }
   for(int j = 0;j<list.size();j++){
   File f1 = new File((String) list.get(j));
   try {
SAXReader reader = new SAXReader();
File f=new File("D:\\SAICFTEST\\INTERFACE\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\"+f1);


Document doc = reader.read(f);
Element root=doc.getRootElement();

//取出所有的节点
List all = doc.selectNodes("//BODY/RECORD");
   for(Object obj:all){
   Node childNode =(Node) obj;
   List rfid=childNode.selectNodes("RFID");
   for(Object orfid:rfid){
   Node rf=(Node)orfid;
   book.setRfid(rf.getStringValue());
  
   }
  
   List occur_time = childNode.selectNodes("OCCUR_TIME");
   for(Object ooccur_time:occur_time){
   Node ot=(Node) ooccur_time;
   book.setOccur_Time(ot.getStringValue());
   }
  
   List monitor_flag = childNode.selectNodes("MONITOR_FLAG");
   for(Object omonitor_flag:monitor_flag){
   Node mf=(Node) omonitor_flag;
   book.setMonitor_Flag(mf.getStringValue());
   }
   try {
  
          String xmlname = f1.getName();
      
          String xmlnamesplit = xmlname.substring(0, 26);
         
          String XMLNAME = xmlnamesplit.toUpperCase();
         
         
       book.setFileName(XMLNAME);
      
   String sql = "insert into IF_GROUP_FCS13(FCS13_FileName,FCS13_Rfid,FCS13_OccurTime,FCS13_MonitorFlag,FCS13_RecStatus,FCS13_RecTime) values('"+book.getFileName()+"','"+book.getRfid()+"','"+book.getOccur_Time()+"','"+book.getMonitor_Flag()+"','0',getDate())";
  
   jdbc.execute(sql);
  
   String sql2 = "{call sp_if_gen_fcs12ctl('"+book.getFileName()+"')}";
  
   jdbc.execute(sql2);
     
} catch (Exception e) {
e.printStackTrace();
}

}
  
   File fold = new File("D:\\SAICFTEST\\INTERFACE\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\"+f1);//生成XML文件路径
   String strNewPath = "D:\\SAICFTEST\\BACKUP\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\";//移出XML文件路径
   File fnewpath = new File(strNewPath);
   if(!fnewpath.exists())
   fnewpath.mkdirs();
   File fnew = new File(strNewPath+fold.getName());
   fold.renameTo(fnew);
} catch (Exception e) {
   e.printStackTrace();
}
   }
  
//   for (int k = 0; k < files.length; k++) {
//        if (files[k].isDirectory()) {
//            refreshFileList(files[k].getAbsolutePath());
//        } else {
//           String strFileName1 = files[k].getAbsolutePath().toLowerCase();
//            if(strFileName1.endsWith(".ctl")){
//            strctl = strFileName1;
//             File strCtl = new File(strctl.trim());
//             fileCtlName = strCtl.getName();
//                  listctl.add(fileCtlName);
//            }
//        }
//    }
//  
//   for(int m = 0;m<listctl.size();m++){
//    File fctl = new File((String) listctl.get(m));
//    File foldctl = new File("D:\\SAICFTEST\\INTERFACE\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\"+fctl);//生成的CTL路径
//    String strNewPathctl = "D:\\SAICFTEST\\BACKUP\\SAICF_FCS\\FCS13_RFIDMONITORINFO\\";//移出的CTL路径
//    File fnewpathctl = new File(strNewPathctl);
//    if(!fnewpathctl.exists())
//    fnewpathctl.mkdirs();
//    File fnewctl = new File(strNewPathctl+foldctl.getName());
//    foldctl.renameTo(fnewctl);   

}

}
}