getxml.java

某石油系统正在使用的实时报表平台系统

package dataIsland;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.sql.*;
import java.util.List;
import javax.servlet.jsp.JspException;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.input.SAXBuilder;
import org.jdom.output.Format;
import org.jdom.output.XMLOutputter;

public class getXML{

private String sUrl=null;
private String sDriver=null;
public Connection conn=null;
private String sUserName=null;
private String sPassWord=null;
public String sSql=null;




public void DBConnect()throws JspException
{
	sUrl="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
	sDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	sUserName="sa";
	sPassWord="";
	try{
		Class.forName(sDriver);
		conn=DriverManager.getConnection(sUrl,sUserName,sPassWord);
		}	
	catch(ClassNotFoundException e){
		throw new JspException("数据库驱动没有找到，错误提示:"+e.toString());	
		}
	catch(SQLException e){
		throw new JspException("SQL语句错误。错误提示:"+e.toString());
		}	
	catch(Exception e){
		throw new JspException("错误提示:"+e.toString());
		}
}

public void DBDisConnect()throws JspException
{
	try{
		if(conn!=null)
		conn.close();
		}	
	catch(Exception e){
			throw new JspException(e.toString());
		}
}

public ResultSet Query()throws SQLException,Exception
{
	sSql="select * from jobs";
	ResultSet rs=null;
		DBConnect();
		rs=null;
		try{
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sSql);
			}
		catch(SQLException e){
				throw new SQLException();
			}
		catch(Exception e){
				throw new Exception();
			}
	return (rs);
}

public void CreateFile(String fName)throws Exception
{
	ResultSet rsXML=null;
	ResultSetMetaData rsmd=null;
	int numCols ;
	rsXML=Query();
	rsmd=rsXML.getMetaData();
	numCols=rsmd.getColumnCount();
	Element root=new Element("xmldata");
	Document doc=new Document(root);
	String sElement="row";
	while(rsXML.next()){
			Element el_1=new Element(sElement);
			doc.getRootElement().addContent(el_1);
			for(int i=1;i<=numCols;i++){
					String rsstr=rsXML.getString(i);
					Element el_2=new Element(rsmd.getColumnName(i));
					el_2.setText(rsstr);
					el_1.addContent(el_2);
				}
		}
	XMLOutputter outp=new XMLOutputter(Format.getPrettyFormat());
	Format ft=outp.getFormat();
	ft.setEncoding("GB2312");
	ft.setExpandEmptyElements(true);
	outp.setFormat(ft);
	outp.output(doc,new FileOutputStream(fName));
}
}