package UIB.UIB03;

import java.io.File;
import java.io.FileInputStream;
import java.net.URLDecoder;
import java.sql.Array;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

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

import oracle.jdbc.OracleConnection;
import oracle.sql.ARRAY;
import oracle.sql.ArrayDescriptor;

import org.apache.commons.dbcp.DelegatingConnection;

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

//import com.sun.org.apache.xerces.internal.impl.xs.dom.DOMParser;

import UIB.COM.DomParserFactory;
import UIB.COM.FileFinder;
import UIB.COM.XgDomParser;
import UIB.COM.XmlSqlParsersFactory;
import UIB.UIB03.ZBS.DataRowList;
import UIB.UIB03.ZBS.QltyTmplParser;
import UIB.UIB03.ZBS.StringFormat;

public class TestCase
{
	ArrayList al	=	new ArrayList();
	/**
	 * @param args
	 */
	private static Connection getNativeConnection(Connection con)
    throws SQLException
    {
	    if ((con instanceof DelegatingConnection)) {
	      Connection nativeCon = ((DelegatingConnection)con).getInnermostDelegate();
	      return nativeCon != null ? nativeCon : con.getMetaData().getConnection();
	    }
	    return con;
    }
	
	public static void main(String[] args)	throws Exception
	{
		try
		{
			String	driverClassName	=	"oracle.jdbc.driver.OracleDriver";
			Class.forName(driverClassName);
			//连接数据库
			String	url	=	"jdbc:oracle:thin:@10.10.0.8:1521:SQMESDB";
			String	userName	=	"jhyuser";
			String	userPsw		=	"jhyuser";
			String sqlString	=	"{call JHY_QLTY_BASE.TEST(?)}";
			
			Connection			conn		=	DriverManager.getConnection(url , userName , userPsw);
			System.out.println(conn);
			CallableStatement 	cstm		=	conn.prepareCall(sqlString);
			//Array	al	=	new ArrayList();
			String[]data = {"12" , "2" , "34"};
			ArrayList list	=	new ArrayList();
			list.add("1");
			list.add("2");
//			System.out.println(getNativeConnection(conn));
			//OracleConnection oc	=	(oracle.jdbc.OracleConnection)conn;
			ArrayDescriptor   ad = ArrayDescriptor.createDescriptor("TEST_ABC",getNativeConnection(conn));

			ARRAY  array = new ARRAY(ad,getNativeConnection(conn),data);
			System.out.println(array);
			
//			ArrayList  al = new ArrayList();
//			al.add("1");
//			al.add("2");
//			Object	obj	=	null;
//			Array  ar = conn.createArrayOf("TEST_ABC", dat);
//			cstm.setArray(1, (Array)list);
//			cstm.setArray(1, ar);
			cstm.setArray(1, array);
			 cstm.execute();
//			System.out.println(num);
//			cstm.close();
//			conn.close();
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
//		String	strPath	=	Thread.currentThread().getContextClassLoader().getResource("").getPath();
//		File baseDir = new File(URLDecoder.decode(strPath, "utf-8"));
//		File[]a = baseDir.listFiles();
//		for(int i =0; i <a.length; i++)
//		{
//			if(a[i].toString().indexOf("query") != -1)
//			{
//				ListFilesInDirectory(a[i].toString());
//				System.out.println("---------->"+a[i].toString());
//			}
//		}
////		System.out.println(strPath);
//		
////		System.out.println(XmlSqlParsersFactory.getSql("xx"));
//		System.out.println(XmlSqlParsersFactory.getInstance().getLen());
//		System.out.println(new java.util.Date());
//		
//		System.out.println("------------->"+strPath.hashCode());
//		System.out.println("------------->"+strPath.hashCode());
//		System.out.println("------------->"+strPath.hashCode());
		//ArrayList	list= (ArrayList)FileFinder.findFiles(strPath, "UIB030120-query.xml", 1);
		
		//System.out.println("#######################################"+list.size());
		
		
//		System.out.println(StringFormat.getNumber("T"));
//		TestCase	tc=	new TestCase();
//		String x = Thread.currentThread().getContextClassLoader().getResource("").getPath();
		
//		String	xpath = x+"/excelConfig/qltyExcel_Config.xml";
////		System.out.println(f.exists());
//		DomParserFactory		dpf	=	new DomParserFactory(xpath);
//		Element	e	=	dpf.getElement();
//		QltyTmplParser		qtp	=	new QltyTmplParser();
//		System.out.println(qtp.getParamer());
//		tc.setParamer(e);
//		
//		HashMap	m	=	new HashMap();
//		m.put("1", "23");
//		m.put("1", "3");
//		System.out.println(m);
//		System.out.println(tc.al.size());
//		for(int i = 0; i < tc.al.size();i++)
//		{
//			System.out.println(tc.al.get(i));
//		}
//		tt(e);
//		System.out.println(StringFormat.getNumber("01"));
//		System.out.println(true||false);
////		
//		UIB030320	uib	=	new UIB030320();
//		uib.downLoad("A00001", "");
//		
//		Runtime	rt	=	Runtime.getRuntime();
//		String[] cmd	=	{"C:\\Program Files\\Kingsoft\\WPS Office Personal\\office6\\et.exe" , "c:\\test.xls"};
//		rt.exec(cmd);
//		
//			DataRowList	drl	=	new DataRowList();
//			drl.put("1", "z");
//			drl.put("2", "x");
//			drl.put("3", "e");
//			System.out.println( drl.getValue("3")  );
//			drl.put("b", "z");
//			drl.put("a", "z");
//			drl.print();
//			String	sql	=	"";
//			
//			for(int i =0; i < 10 ;i++)
//			{
//				sql = XmlSqlParsersFactory.getSql("UIB030130_01.SELECT");
//				System.out.println(sql);
//				System.out.println(XmlSqlParsersFactory.getSql("NIE042020_OrdPrcINf.select"));
//			}
//			
			
//			List fileList = new ArrayList();
//	        //判断目录是否存在
//			String baseDirName =  "C:\\Program Files\\Apache Software Foundation\\Tomcat5.5\\webapps\\CoreFS\\WEB-INF\\classes\\query";
//	        File baseDir = new File(baseDirName);
//	        if (!baseDir.exists() || !baseDir.isDirectory()){
//	            System.out.println("文件查找失败：" + baseDirName + "不是一个目录！");
//	        }
	            
//			XgDomParser	xdp	=	new XgDomParser();
//			HashMap	hashmap	=xdp.parserEl(element);
//			Iterator	it	=	hashmap.keySet().iterator();
//			while(it.hasNext())
//			{
//				Object	key	=	it.next();
//				Object	value	=	hashmap.get(key);
//				System.out.println(key+"-->"+value);
//			}
			
//			XmlSqlParsersFactory xspf	=	new XmlSqlParsersFactory();
//			String sql = "";
//			sql = xspf.getSql("NIE042020_OrdPrcINf.select");
//			System.out.println(sql);
//			sql	=	xspf.getSql("NIE042020_OrdPrc.update");
//			System.out.println(sql);
//			Map m = xspf.parseEl(element);
//			System.out.println(m);
//			System.out.println(xspf.parser(element , "NIE042020_OrdPrcDetPk.select").get("NIE042020_OrdPrcDetPk.select")			);
//			System.out.println(xspf.parser(element , "NIE042020_OrdPrcDetPk.select"));

			/**
			 * ELEMENT_NODE 1
			 * TEXT_NODE    3
			 * CDATA_SECTION_NODE   4
			 */
			//System.out.println("Node Type : "+Node.CDATA_SECTION_NODE);
	}

	public void setParamer(Element e)
	{
		
		
		if(e.hasChildNodes())
		{
			NodeList		nodelist	=	e.getChildNodes();
			int				len			=	nodelist.getLength();
			for(int i = 0; i < len ; i++)
			{
				Node	node	=	nodelist.item(i);
				if(node.getNodeType() == Node.ELEMENT_NODE)
				{
					if(node.hasAttributes())
					{
						if("property".equals(node.getNodeName()))
						{
							HashMap	hashmap	=	new HashMap();
							NamedNodeMap	nnm	=	node.getAttributes();
							int	nnmLen	=	nnm.getLength();
							for(int j = 0; j < nnmLen ; j++)
							{
								System.out.println(node.getNodeName());
								hashmap.put(nnm.item(j).getNodeName(), nnm.item(j).getNodeValue());
							}
							al.add(hashmap);
						}
						else if("image".equals(node.getNodeName()))
						{
							HashMap	hashmap	=	new HashMap();
							NamedNodeMap	nnm	=	node.getAttributes();
							int	nnmLen	=	nnm.getLength();
							for(int j = 0; j < nnmLen ; j++)
							{
								System.out.println(node.getNodeName());
								hashmap.put(nnm.item(j).getNodeName(), nnm.item(j).getNodeValue());
							}
							al.add(hashmap);
						}
					}
					Element	element	=	(Element)node;
					setParamer(element);
				}
			}
		}
	}
	
	public static void tt(Element e)
	{
		if (e.hasChildNodes())
		{
			NodeList nodelist = e.getChildNodes();
			int j = nodelist.getLength();
			for(int i = 0 ; i< j; i++)
			{
				Node	node	=	nodelist.item(i);
				
				if(node.getNodeType() == Node.ELEMENT_NODE) //element
				{
					if(node.hasAttributes())
					{
//						System.out.println("--->"+node.getNodeName());
						NamedNodeMap	nnm	=	node.getAttributes();
						int	len	=	nnm.getLength();
						for(int z = 0 ; z < len ; z++)
						{
//							System.out.println(nnm.item(z).getNodeName()+"=========>"+nnm.item(z).getNodeValue());
						}
					}
					Element	element	=	(Element)nodelist.item(i);
//					System.out.println(element.getTagName());//取得标签名
					tt(element);
				}
//				if(node.getNodeType() == Node.CDATA_SECTION_NODE)
//				{
//					System.out.println("------>"+node.getNodeValue());
//				}
//				if(node.getNodeType() == Node.TEXT_NODE)
//				{
//					System.out.println(node.getNodeName()+"===>>"+node.getNodeValue());
//				}
//				
			}
		}
	}
	
	public  static  void ListFilesInDirectory(String path)
	{
		File	file	=	new File(path);
		File[]	files	=	file.listFiles();
		int len = files.length;
		//System.out.println(path);
		for(int i = 0; i < len; i++)
		{
			if(files[i].isDirectory())
			{
				//System.out.println("######################");
				ListFilesInDirectory(files[i].toString());
			}
			else
			{
				DomParserFactory		dpf				=		new DomParserFactory(files[i].getAbsolutePath());
				XgDomParser				xdp				=		new XgDomParser();
//				HashMap					hashmap			=		xdp.parserEl(dpf.getElement());
				XmlSqlParsersFactory.getInstance().putAll(xdp.parserEl(dpf.getElement()));
//				for(Iterator it = hashmap.keySet().iterator(); it.hasNext(); )
//				{
//					Object	key	=	it.next();
//					Object	value	=	hashmap.get(key);
//					XmlSqlParsersFactory.putSql(key, value);
//				}
			}
		}
	}
}