将批量xml文件 数据批量添加…

注：前提是把sqlite的java 驱动添加到项目

package com.joke.data;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Map;

public class mysqlite {
 
 public static void main(String[] args) throws Exception {
  fileUtils f=new fileUtils();
  mysqlite m=new mysqlite();
  ArrayList list=f.getAllFile();
  System.out.println("^_^开始！");
  for (File file : list) {
   ArrayList

  conn.setAutoCommit(false);
  prep.executeBatch();
  conn.setAutoCommit(true);
//  ResultSet rs = stat.executeQuery("select * from joke;");
//  while (rs.next()) {
//   System.out.println("title = " + rs.getString("title"));
//   System.out.println("content = " + rs.getString("content"));
//   System.out.println("pid = " + rs.getString("pid"));
//  }
//  rs.close();
  conn.close();
 }
}
文件处理类：

package com.joke.data;

import java.io.File;
import java.io.FileInputStream;
import java.io.FilenameFilter;
import java.io.IOException;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;

import org.w3c.dom.Document;
import org.xml.sax.SAXException;

public class fileUtils {

 public ArrayList

 public ArrayList getAllFile() {
  ArrayList list = null;
  try {
   File doc = new File("E:/assets");
   if (doc.exists() && doc.isDirectory()) {
    File[] flist = doc.listFiles(new filefilter());
    if (flist.length > 0) {
     list = new ArrayList();
     for (int i = 0; i < flist.length; i++) {
      list.add(flist[i]);
     }
    }
   }
  } catch (Exception e) {
   // TODO: handle exception
   e.printStackTrace();
  }
  return list;
 }
 private class filefilter implements FilenameFilter {

  @Override
  public boolean accept(File arg0, String arg1) {
   // TODO Auto-generated method stub
   return arg1.endsWith("xml");
  }

 }

}