package UIB.COM;

import java.io.File;
import java.io.IOException;
import java.net.URLDecoder;

import javax.faces.application.FacesMessage.Severity;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.jsp.PageContext;

import org.apache.log4j.Logger;

import UIB.UIB03.UIB030310;

/**
 * 
 * @desc   服务器启动时执行，遍历query文件夹，获取所有XML文件。
 * @author meiguiping
 * @date   2011 5:20:45 PM
 */
public class XgSqlServlet extends HttpServlet
{
	public XgSqlServlet()
	{
		super();
	}
	
	/**
	 * 遍历WEB-INF，搜索query文件夹，获取所有XML文件
	 */
	public void init() throws ServletException
	{
		// Put your code here
		try
		{
			String	queryPath	=	this.getClass().getClassLoader().getResource("/").getPath().replaceFirst("classes/", "");
			//遍历WEB-INF，搜索query文件夹
			File baseDir = new File(URLDecoder.decode(queryPath, "utf-8"));
			File[]targerDir = baseDir.listFiles();
			for(int i =0; i <targerDir.length; i++)
			{
				if(targerDir[i].toString().indexOf("query") != -1)
				{
					queryPath = targerDir[i].toString();
					break;
				}
			}
			
			ListFilesInDirectory(URLDecoder.decode(queryPath , "utf-8"));
			System.out.println("The SQL count is : "+XmlSqlParsersFactory.getInstance().getLen());
//			Logger.getAnonymousLogger().log(Level.INFO, "The SQL count is : "+XmlSqlParsersFactory.getInstance().getLen());
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	//get request
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException
	{
	}

	//post request
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException
	{
	}
	/*
	 * get or post request
	public void service(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException
	{
	System.out.println("doPost。");
	}
	*/
	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy()
	{
		super.destroy(); // Just puts "destroy" string in log
	}
	
	/**
	 * @desc  文件夹循环
	 * @param path
	 */
	public  static  void ListFilesInDirectory(String path)
	{
		File	file	=	new File(path);
		File[]	files	=	file.listFiles();
		int len = files.length;
		for(int i = 0; i < len; i++)
		{
			if(files[i].isDirectory())
			{
				ListFilesInDirectory(files[i].toString());
			}
			else
			{
				//System.out.println(files[i].getAbsolutePath());
				DomParserFactory		dpf				=		new DomParserFactory(files[i].getAbsolutePath());
				XgDomParser				xdp				=		new XgDomParser();
				XmlSqlParsersFactory.getInstance().putAll(xdp.parserEl(dpf.getElement()));
			}
		}
		
	}
}