public class aa {
public static void main(String[] args) {
try {
//创建解析工厂
DocumentBuilderFactory dbfactory = DocumentBuilderFactory.newInstance();
//指定DocumentBuilder
DocumentBuilder builder = dbfactory.newDocumentBuilder();
//从文件构造一个Document，因为XML文件中已经指定了编码，所以这里不必了
Document doc = builder.parse(new File("aa.xml"));
//得到Document的根（节点名：book）
Element root = doc.getDocumentElement();
System.out.println("根节点标记名：" + root.getTagName());

System.out.println("*****下面遍历XML元素*****");
//获得page元素
NodeList list = root.getElementsByTagName("page");
//遍历page元素
for (int i=0; i < list.getLength() ; i++) {
//获得page的元素
Element element = (Element)list.item(i);
//获得ID属性
String id = element.getAttribute("id");
//获得title属性
NodeList titleList = element.getElementsByTagName("title");
//获得title元素
Element titleElement = (Element)titleList.item(0);
//获得title元素的第一个值
String title = titleElement.getFirstChild().getNodeValue();
//获得file元素名称
NodeList fileList = element.getElementsByTagName("file");
//获得file元素
Element fileElement = (Element)fileList.item(0);
//获得file元素的第一个值
String file = fileElement.getFirstChild().getNodeValue();

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import java.util.List;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;

public class Cshuju extends Object{

        public static  String str_id;
        public  static String str_number;
        public static String str_name;
        public  static String str_age;     
    

    public Cshuju() {
    }
    
   public void conn() throws JDOMException{
       
     SAXBuilder builder = new SAXBuilder();
        Document read_doc = null;
        try {
            read_doc = builder.build("stu.xml");
        } catch (JDOMException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            ex.printStackTrace();
        }

        Element stu1 = read_doc.getRootElement();

        List list = stu1.getChildren("students");

        for(int i = 0;i < list.size();i++) {

            Element e = (Element)list.get(i);
             int str_id = 2;

            String str_number = e.getChildText("number");

            String str_name = e.getChildText("name");

            String str_age = e.getChildText("age");

            System.out.println("---------STUDENT--------------");

            System.out.println("NUMBER:" + str_number);

            System.out.println("NAME:" + str_name);

            System.out.println("AGE:" + str_age);

            System.out.println("------------------------------");

            System.out.println();

        }      
       
}

public static void main(String args[])throws Exception{
    
    new Stu().conn();
    
        try {
            
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
        } catch (InstantiationException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (IllegalAccessException ex) {
            ex.printStackTrace();
        }
        
        String url ="jdbc:microsoft:sqlserver://localhost:1433;databaseName=students;";
        
        Connection conn = null;
        try {
            conn = DriverManager.getConnection(url, "sa", "");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
       
        Statement statement = null;
        try {
            statement = conn.createStatement();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

  
        String sqlTxt = "insert into stu1 "+"(id,number, name, age) "+ "values

('"+str_id+"','"+str_number+"', '"+str_name+"', '"+str_age+"')";
        
        int results = statement.executeUpdate(sqlTxt);
        
    
        System.out.print("XML 数据输入完毕！");
        
    }
    
       
  }