急!

Question

如何把从xml中读取出来的内容写入mysql数据库中啊，具体应该怎么做啊，有些代码看看吧？

Answer 1

读的代码
import java.io.File;
import org.w3c.dom.Document;
import org.w3c.dom.*;import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.xml.sax.SAXException;
import org.xml.sax.SAXParseException; public class ReadAndPrintXMLFile{    public static void main (String argv []){
    try {            DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
            DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();
            Document doc = docBuilder.parse (new File("book.xml"));
           
            doc.getDocumentElement ().normalize ();
            System.out.println ("Root element of the doc is " + doc.getDocumentElement().getNodeName());            NodeList listOfPersons = doc.getElementsByTagName("person");
            int totalPersons = listOfPersons.getLength();
            System.out.println("Total no of people : " + totalPersons);            for(int s=0; s<listOfPersons.getLength() ; s++){                Node firstPersonNode = listOfPersons.item(s);
                if(firstPersonNode.getNodeType() == Node.ELEMENT_NODE){                    Element firstPersonElement = (Element)firstPersonNode;
                  
                    NodeList firstNameList = firstPersonElement.getElementsByTagName("first");
                    Element firstNameElement = (Element)firstNameList.item(0);                    NodeList textFNList = firstNameElement.getChildNodes();
                    System.out.println("First Name : " + 
                           ((Node)textFNList.item(0)).getNodeValue().trim());
                 
                    NodeList lastNameList = firstPersonElement.getElementsByTagName("last");
                    Element lastNameElement = (Element)lastNameList.item(0);                    NodeList textLNList = lastNameElement.getChildNodes();
                    System.out.println("Last Name : " + 
                           ((Node)textLNList.item(0)).getNodeValue().trim());
                 
                    NodeList ageList = firstPersonElement.getElementsByTagName("age");
                    Element ageElement = (Element)ageList.item(0);                    NodeList textAgeList = ageElement.getChildNodes();
                    System.out.println("Age : " + ((Node)textAgeList.item(0)).getNodeValue().trim());
                }
            }
        }
        catch (SAXParseException err) {
               System.out.println ("** Parsing error" + ", line " 
                                          + err.getLineNumber () + ", uri " + err.getSystemId ());
               System.out.println(" " + err.getMessage ());
        }
        catch (SAXException e) {
                Exception x = e.getException ();
                ((x == null) ? e : x).printStackTrace ();
        }
        catch (Throwable t) {
                t.printStackTrace ();
        }
    }
}

Answer 2

汗暴汗
XML文件 book.xml<book>
 <person>
  <first>Kiran</first>
  <last>Pai</last>
  <age>22</age>
 </person>
 <person>
  <first>Bill</first>
  <last>Gates</last>
  <age>46</age>
 </person>
 <person>
  <first>Steve</first>
  <last>Jobs</last>
  <age>40</age>
 </person>
</book>
写到数据库我就不说了吧