produce.ja

java操作xml文件的各种代码

import java.io.*;
import java.net.*;
import java.util.*;
import java.sql.*;
import org.w3c.dom.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.cocoon.*;
import org.apache.cocoon.framework.*;
import AddressBookInfo;
import JDAO;
import org.apache.xerces.parsers.DOMParser;
import org.xml.sax.InputSource;

public class ProducerFromDB extends AbstractProducer implements Status {
    
    public Document getDocument(HttpServletRequest request) throws Exception {
//建立数据库连接    	
    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	Connection con = DriverManager.getConnection("jdbc:odbc:address");
//执行SQL指令    	
    	Statement stmt = con.createStatement();
      	ResultSet rs = stmt.executeQuery(
        		"select 姓名,"+
        		"       昵称,"+
        		"       电子邮件帐号,"+
        		"       上次开会日期,"+
        		"       备注 "+
        		"from 名片簿;");
//使用我们的DAO
      	JDAO jDAO = new JDAO("AddressBookInfo.xml");
      	Vector vPerson = jDAO.parseResultSet(rs);

      	rs.close();
      	stmt.close();

    	StringBuffer xmlStr = new StringBuffer();
    	xmlStr.append(	"<?xml version=\"1.0\" encoding=\"gb2312\"?>"+
        	      	"<?xml-stylesheet href=\"AddressBookInfo-html.xsl\" type=\"text/xsl\" ?>"+
                        "<?cocoon-process type=\"xslt\"?>"+
                  	"<名片簿>");
    	for(int i=0; i<mainApp.vPerson.size(); i++){
      		AddressBookInfo abi = (AddressBookInfo)mainApp.vPerson.get(i);
      		xmlStr.append("<人员>");
      		xmlStr.append("<姓名>"+
               		      abi.getName()+
                    	      "</姓名>");
      		xmlStr.append("<昵称>"+
                	      abi.getNickName()+
                    	      "</昵称>");
      		xmlStr.append("<电子邮件帐号姓名>"+
                  	      abi.getEmail()+
                   	      "</电子邮件帐号姓名>");
      		xmlStr.append("<上次开会日期>"+
                	      abi.getMeetDate()+
              	 	      "</上次开会日期>");
      		xmlStr.append("<备注>"+
                	      abi.getMemo()+
                    	  "</备注>");
      		xmlStr.append("</人员>");
    	}
    	xmlStr.append("</名片簿>");

    	DOMParser parser = new DOMParser();
    	try{
    		parser.parse(new InputSource(new StringReader(xmlStr.toString())));
    	} catch( Exception e ){
      		e.printStackTrace(System.out);
   	}
     	return doc = parser.getDocument();
    } 

    public Reader getStream(HttpServletRequest request) throws Exception {
        throw new Exception("this method should never be called!");
    }
    
    public String getPath(HttpServletRequest request) {
        return "";
    }
    
    public String getStatus() {
        return "Producer from Database";
    }
}