xml 学生管理系统

<?xml version="1.0" encoding="utf-8" standalone="no"?><students>
<student sid="001">
<name>小明</name>
<course>
<java>90</java>
<oracle>90</oracle>
<vb>89</vb>
</course>
</student>
<student sid="002">
<name>小李</name>
<course>
<java>9</java>
<oracle>70</oracle>
<vb>8</vb>
</course>
</student>
<student sid="003">
<name>小韩</name>
<course>
<java>90</java>
<oracle>70</oracle>
<vb>85</vb>
</course>
</student>
<student sid="004">
<name>小明名</name>
<course>
<java>34</java>
<oracle>50</oracle>
<vb>58</vb>
</course>
</student>
<student sid="005">
<name>小红</name>
<course>
<java>29</java>
<oracle>39</oracle>
<vb>88</vb>
</course>
</student>
<student sid="005"><name>二狗</name><cource><java>96</java><oracle>96</oracle><vb>88</vb></cource></student></students>

package com.dom.exercises;
import java.util.*;

import javax.xml.parsers.*;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.*;

public class stuManage {

	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		
		Scanner in = new Scanner(System.in);
		StudentService studentService = new StudentService();
		Student student = new Student();
		
		//显示操作界面
		System.out.println("查看所有学生的成绩----view");
		System.out.println("按照学生id号码查询学生成绩---view of id");
		System.out.println("添加一个学生---add");
		System.out.println("按照id更改一个学生的信息----change");
		System.out.println("按照id去删除一个学生-----remove");
		System.out.println("保存学生信息----save");
		System.out.println("退出系统-----exit");
		
		String operType = in.next();
		if(operType.equals("view")){
			studentService.showStudsFen();
		}else if(operType.equals("id")){
			//id查找
			System.out.println("输入要查询的id:");
			String sid = in.next();
			studentService.serchThroughId(sid);
		}else if(operType.equals("add")){
			//添加
			student.setSid("005");
			student.setName("二狗");
			student.setMy_java(96);
			student.setMy_oracle(98);
			student.setMy_vb(88);
			studentService.add(student);
		}else if(operType.equals("change")){
			//修改
		}else if(operType.equals("remove")){
			//删除
		}else if(operType.equals("save")){
			//保存
		}else if(operType.equals("exit")){
			//退出
		}
	}

}

//写一个服务类
class StudentService{
	//显示所有学生成绩的方法
	public void showStudsFen() throws Exception{
		//1.得到DocumentBuilderFactory
		DocumentBuilderFactory documentBuilderFactory = DocumentBuilderFactory.newInstance();
		//2.得到DocumentBuilder
		DocumentBuilder documentBuilder = documentBuilderFactory.newDocumentBuilder();
		
		//3.指定文件
		Document document = documentBuilder.parse("src/com/dom/exercises/stu.xml");
		
		//4.显示学生信息
		NodeList nodeList = document.getElementsByTagName("student");
		for(int i = 0;i<nodeList.getLength();i++){
			Element element = (Element)nodeList.item(i);
			//输出学生的编号
			System.out.println("编号："+element.getAttribute("sid")+"\t"+
			"姓名：\t"+getFirstElement(element,"name").getTextContent()+"\t"+
					"Java:"+getFirstElement(element,"java").getTextContent()+"\t"+
					"oracle:"+getFirstElement(element,"oracle").getTextContent()+"\t"+
					"vb:"+getFirstElement(element,"vb").getTextContent());
		}
	}
	
	//按照学生id号码查询学生成绩
	public void serchThroughId(String Id) throws Exception{
		Document document = getdocument("src/com/dom/exercises/stu.xml");
		//4.显示学生信息
		Element element = document.getElementById("002");
		System.out.println("编号："+Id+"\t"+
				"姓名：\t"+getFirstElement(element,"name").getTextContent()+"\t"+
						"Java:"+getFirstElement(element,"java").getTextContent()+"\t"+
						"oracle:"+getFirstElement(element,"oracle").getTextContent()+"\t"+
						"vb:"+getFirstElement(element,"vb").getTextContent());
	}
	
	//添加一个学生
	public void add(Student student) throws Exception{
		Document doc = getdocument("src/com/dom/exercises/stu.xml");
		//创建一个新的学生节点
		Element newStu = doc.createElement("student");
		Element newCourse = doc.createElement("cource");
		//设置属性
		newStu.setAttribute("sid", student.getSid());
		Element newStu_name = doc.createElement("name");
		newStu_name.setTextContent(student.getName());
		//Element newStu_cource = doc.createElement("course");
		Element newStu_java = doc.createElement("java");
		newStu_java.setTextContent(student.getMy_java()+"");
		Element newStu_oracle = doc.createElement("oracle");
		newStu_oracle.setTextContent(student.getMy_java()+"");
		Element newStu_vb = doc.createElement("vb");
		newStu_vb.setTextContent(student.getMy_vb()+"");
		
		newCourse.appendChild(newStu_java);
		newCourse.appendChild(newStu_oracle);
		newCourse.appendChild(newStu_vb);
		newStu.appendChild(newStu_name);
		newStu.appendChild(newCourse);
//		newStu.appendChild(newStu_java);
//		newStu.appendChild(newStu_oracle);
//		newStu.appendChild(newStu_vb);
		//把新的学生节点添加到根元素
		doc.getDocumentElement().appendChild(newStu);
		
		//得到TransformerFactory
		TransformerFactory tff = TransformerFactory.newInstance();
		//通过TransformerFactory得到一个转换器
		Transformer tf = tff.newTransformer();
		tf.transform(new DOMSource(doc), new StreamResult("src/com/dom/exercises/stu.xml"));
		System.out.println("OK");
	}
	
	//封装常用的方法
		//得到element的方法
	public Element getFirstElement(Element element,String name){
		return (Element)element.getElementsByTagName(name).item(0);
	}
		//得到document的方法
	public Document getdocument(String fullFilePath) throws Exception{
		//1.得到DocumentBuilderFactory
		DocumentBuilderFactory documentBuilderFactory = DocumentBuilderFactory.newInstance();
		//2.得到DocumentBuilder
		DocumentBuilder documentBuilder = documentBuilderFactory.newDocumentBuilder();
		
		//3.指定文件
		return documentBuilder.parse(fullFilePath);
	}
}
	

class Student{
	
	private String sid;
	private String name;
	private int my_java;
	private int my_oracle;
	private int my_vb;
	
	public String getSid() {
		return sid;
	}
	public void setSid(String sid) {
		this.sid = sid;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getMy_java() {
		return my_java;
	}
	public void setMy_java(int my_java) {
		this.my_java = my_java;
	}
	public int getMy_oracle() {
		return my_oracle;
	}
	public void setMy_oracle(int my_oracle) {
		this.my_oracle = my_oracle;
	}
	public int getMy_vb() {
		return my_vb;
	}
	public void setMy_vb(int my_vb) {
		this.my_vb = my_vb;
	}
	
}