jdbc2xml.java

这个是jsp编写的考试系统代码

package kaoshi.tool;

import java.sql.*;
import java.io.File;
import java.util.Vector;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Text;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.Transformer;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

class Jdbc2Xml{
	Vector student_Vector=null;
		
	private void writeXMLFile(String outFile)throws Exception{
		Document doc=DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument();
		Element root=doc.createElement("学生花名册");
		doc.appendChild(root);
		for(int i=0;i<student_Vector.size();i++){
			StudentBean studentBean=(StudentBean)student_Vector.get(i);
			Element student=doc.createElement("学生");
			student.setAttribute("性别",studentBean.getSex());
			root.appendChild(student);
			
			Element name=doc.createElement("姓名");
			student.appendChild(name);
			Text tName=doc.createTextNode(studentBean.getName());
			name.appendChild(tName);
			Element age=doc.createElement("年龄");
			student.appendChild(age);
			Text tAge=doc.createTextNode(studentBean.getAge()+"");
			age.appendChild(tAge);
			Element phone=doc.createElement("电话");
			student.appendChild(phone);
			Text tPhone=doc.createTextNode(studentBean.getPhone());
			phone.appendChild(tPhone);
			
		}
		Transformer tf=TransformerFactory.newInstance().newTransformer();
		DOMSource ds=new DOMSource(root);
		StreamResult sr=new StreamResult(new File(outFile));
		tf.transform(ds,sr);
	}
	public static void main(String args[])throws Exception{
		StudentDAO sd=new StudentDAO();
		Jdbc2Xml instance=new Jdbc2Xml();
		instance.student_Vector=sd.getStudentVector();
		instance.writeXMLFile("student.xml");
	}
}