commonselectcp.java

用于按照xml文件配置直接生成SQL脚本文件

//通用查询的xml配置解析器

package find;


import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.servlet.ServletException;
import javax.servlet.RequestDispatcher;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Properties;

import org.xml.sax.Attributes;
import org.xml.sax.helpers.DefaultHandler;
import org.xml.sax.SAXException;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import java.net.URL;
import java.net.URLDecoder;
import java.io.File;


public class CommonSelectCP extends DefaultHandler{
	
	//private String currentSet;
	//private String currentName;
	private int step;//用于xml元素解析步骤
	
	private StringBuffer currentValue = new StringBuffer();
	
	
	public CommonSelectCP(){
		this.clear();
	}
	
	//清空
	public void clear(){
	}
	
	
	//定义开始解析元素的方法. 这里是将<xxx>中的名称xxx提取出来.
	
	public void startElement(String uri, String localName, String qName, Attributes attributes) throws SAXException {
		currentValue.delete(0, currentValue.length());
		if(qName.equals("标题名")) this.step = 5;
	
	}
	
	//这里是将<xxx></xxx>之间的值加入到currentValue
	
	public void characters(char[] ch, int start, int length) throws SAXException {
		currentValue.append(ch, start, length);
	}
	
	//在遇到</xxx>结束后,
	
	public void endElement(String uri, String localName, String qName) throws SAXException {
	
		this.step++;
		//props.put(qName.toLowerCase(), currentValue.toString().trim());

	}
	
	
	public void parse(String filename) throws Exception {
		
		SAXParserFactory factory = SAXParserFactory.newInstance();
		//factory.setNamespaceAware(false);
		//factory.setValidating(false);
		SAXParser parser = factory.newSAXParser();
		
		
		try{
			
			parser.parse(new File(filename).toURL().toString(), this); 
		}finally{
			factory=null;
			parser=null;
		}
	
	}

	
}