import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;

import org.dom4j.Document;
import org.dom4j.Element;


public class XMLToDatabase {

	
	
	
		
		
	
	public static void toDatabase(){
		
		Connection connection=null;
		PreparedStatement statement=null;
		ResultSet rs=null;
		connection=JDBCUtilSingle.getInitJDBCUtil().getConnection();
		String sql="INSERT INTO `xmlanddb`.`dict` (`id`, `word`, `meaning`, `lx`) VALUES (NULL, ?, ?, ?);";
		try {
			statement=connection.prepareStatement(sql);
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
		
		Document document=Dom4j.load("dict.xml");
		Element root=Dom4j.getRootElement(document);
		List words = root.elements("word"); //word节点列表      
		String wordStr="",meaningStr="",lxStr="";
		for (Iterator i = words.iterator(); i.hasNext();) {  
			
				    Element word= (Element) i.next(); //单个word节点
				    
				    for(Iterator k=word.elementIterator();k.hasNext();){  //遍历 name mean lx节点     
		                Element element = (Element) k.next();     
		                if(element.getName().equals("name")){
		                	wordStr=element.getText();
		                	
		                }
		                if(element.getName().equals("mean")){
		                	meaningStr=element.getText();
		                }
		                if(element.getName().equals("lx")){
		                	lxStr=element.getText();
		                }      
		            } 
				 
					try {
					
						statement.setString(1,wordStr);
						statement.setString(2,meaningStr);
						statement.setString(3,lxStr);
						statement.executeUpdate();
					    
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
			
		   
		}      
		JDBCUtilSingle.getInitJDBCUtil().closeConnection(rs, statement, connection);
	}
	
	
	public static void main(String[] args){
		toDatabase();
	}
	
	
	
	
}