/** Creates a new instance of road1Insert */ public static void Insert() throws Exception{ String chooseFile = "C:\\Documents and Settings\\ggyy\\Mylib\\build\\classes\\choose.xml"; String a="",b="",c="",d="",f=""; Document chooseDoc =null;
try { DocumentBuilderFactory docbuilderfactory = DocumentBuilderFactory.newInstance(); DocumentBuilder docbuilder = docbuilderfactory.newDocumentBuilder(); chooseDoc = docbuilder.parse(chooseFile);//Instantiate the parser and parse the file System.out.println("读取 road1.xml 提取数据插入数据库"); Element chooseRoot = chooseDoc.getDocumentElement(); NodeList lines = chooseRoot.getElementsByTagName("题目"); for(int i = 0;i < lines.getLength();i++) { Element thisLine = (Element)lines.item(i); //对每条线路做处理 NodeList linename = thisLine.getElementsByTagName("题干"); if(linename.getLength()==1){ Element m=(Element) linename.item(0); Text t=(Text) m.getFirstChild(); f=t.getNodeValue();} System.out.print(f);
NodeList A = thisLine.getElementsByTagName("A"); if(A.getLength()==1){ Element m=(Element) linename.item(0); Text t=(Text) m.getFirstChild(); a=t.getNodeValue();} System.out.print(a);
NodeList B = thisLine.getElementsByTagName("B"); if(B.getLength()==1){ Element m=(Element) linename.item(0); Text t=(Text) m.getFirstChild(); b=t.getNodeValue();} System.out.print(b);
NodeList C = thisLine.getElementsByTagName("C"); if(C.getLength()==1){ Element m=(Element) linename.item(0); Text t=(Text) m.getFirstChild(); c=t.getNodeValue();} System.out.print(c);
NodeList D = thisLine.getElementsByTagName("D"); if(D.getLength()==1){ Element m=(Element) linename.item(0); Text t=(Text) m.getFirstChild(); d=t.getNodeValue();} System.out.print(d);
就是我目前有一个xml文档,
我想把文档中内容插入到mysql中
- <试题信息>
- <题目>
<题干>1、 1MB等于()</题干>
<A>1000字节</A>
<B>1024字节</B>
<C>1000?w1000字节</C>
<D>1024?w1024字节</D>
</题目>
- <题目>
<题干>2、 与十六进制数200等值得十进制数为()</题干>
<A>256</A>
<B>512</B>
<C>1024</C>
<D>2048</D>
</题目>
</试题信息>以上是我的xml文档,大虾们救命啊
import java.sql.*;
import com.mg.admin.*;
import javax.xml.parsers.*;
import org.w3c.dom.*;
import org.w3c.dom.Text;public class Insert {
/** Creates a new instance of road1Insert */
public static void Insert() throws Exception{
String chooseFile = "C:\\Documents and Settings\\ggyy\\Mylib\\build\\classes\\choose.xml";
String a="",b="",c="",d="",f="";
Document chooseDoc =null;
try {
DocumentBuilderFactory docbuilderfactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docbuilder = docbuilderfactory.newDocumentBuilder();
chooseDoc = docbuilder.parse(chooseFile);//Instantiate the parser and parse the file
System.out.println("读取 road1.xml 提取数据插入数据库");
Element chooseRoot = chooseDoc.getDocumentElement();
NodeList lines = chooseRoot.getElementsByTagName("题目");
for(int i = 0;i < lines.getLength();i++) {
Element thisLine = (Element)lines.item(i);
//对每条线路做处理
NodeList linename = thisLine.getElementsByTagName("题干");
if(linename.getLength()==1){
Element m=(Element) linename.item(0);
Text t=(Text) m.getFirstChild();
f=t.getNodeValue();}
System.out.print(f);
NodeList A = thisLine.getElementsByTagName("A");
if(A.getLength()==1){
Element m=(Element) linename.item(0);
Text t=(Text) m.getFirstChild();
a=t.getNodeValue();}
System.out.print(a);
NodeList B = thisLine.getElementsByTagName("B");
if(B.getLength()==1){
Element m=(Element) linename.item(0);
Text t=(Text) m.getFirstChild();
b=t.getNodeValue();}
System.out.print(b);
NodeList C = thisLine.getElementsByTagName("C");
if(C.getLength()==1){
Element m=(Element) linename.item(0);
Text t=(Text) m.getFirstChild();
c=t.getNodeValue();}
System.out.print(c);
NodeList D = thisLine.getElementsByTagName("D");
if(D.getLength()==1){
Element m=(Element) linename.item(0);
Text t=(Text) m.getFirstChild();
d=t.getNodeValue();}
System.out.print(d);
}
}catch(Exception e) {
System.out.println("Error "+e.getMessage());
throw e;
}
}
}
1、读取XML文件
2、将读取到的数据INSERT到数据库
用Insert语句阿