毕业设计的题目是在在jbuilder环境下把xml文档导入导出oracle。导出可用jbuilder的xbean组件，很简单。但是导入呢？
目前的想法是用saxparser解析文档，最后来insert into table values""""""...但value值如何从串行改为并行呢？别告诉我用字符串。因为哪几个函数都是void型。
从网上查到得例子都是只有解析部分，没有操纵value的代码。
逼得不行了。望高手们拯救小妹于水火啊，帮我改改下面的程序。不然有代码或范例也好阿。
解析程序，部分自动生成，部分修改
package com.borland.samples.xml.saxparser;
import java.io.IOException;
import org.xml.sax.*;
import org.xml.sax.helpers.*;
import javax.xml.parsers.*;
public class MySaxParser extends DefaultHandler {
private static int INDENT = 2;
private static String attList = "" ;
public static void main(String[] argv) {
if (argv.length != 1) {
System.out.println("Usage: java MySaxParser [URI]");
System.exit(0);
}
System.setProperty("javax.xml.parsers.SAXParserFactory", "org.apache.xerces.jaxp.SAXParserFactoryImpl");
String uri = argv[0];
try {
SAXParserFactory parserFactory = SAXParserFactory.newInstance();
parserFactory.setValidating(false);
parserFactory.setNamespaceAware(false);
MySaxParser MySaxParserInstance = new MySaxParser();
SAXParser parser = parserFactory.newSAXParser();
parser.parse(uri, MySaxParserInstance);
}
catch(IOException ex) {
ex.printStackTrace();
}
catch(SAXException ex) {
ex.printStackTrace();
}
catch(ParserConfigurationException ex) {
ex.printStackTrace();
}
catch(FactoryConfigurationError ex) {
ex.printStackTrace();
}
}
private int idx = 0;
得到元素内容但是如何存起来呢
public void characters(char[] ch, int start, int length) throws SAXException {
String s = new String(ch, start, length);
String T = new String(ch, start, length);
if (!s.startsWith("\n"))
System.out.println(getIndent()+ " Value: " + s);
}
我估计在这里加一个insert函数
public void endDocument() throws SAXException {
idx -= INDENT;
System.out.println(getIndent() + "end document");
System.out.println("...PARSING ends");
}
public void endElement(String uri, String localName, String qName)
throws SAXException {
if (!attList.equals(""))
System.out.println(getIndent() + " Attributes: " + attList);
attList = "";
System.out.println(getIndent() + "end element");
idx -= INDENT;
}
public void startDocument() throws SAXException {
idx += INDENT;
System.out.println("PARSING begins...");
System.out.println(getIndent() + "start document: ");
}
public void startElement(String uri, String localName, String qName,
Attributes attributes) throws SAXException {
idx += INDENT;
System.out.println('\n' + getIndent() + "start element: " + qName);
if (attributes.getLength()> 0) {
idx += INDENT;
for (int i = 0; i < attributes.getLength(); i++){
attList = attList + attributes.getQName(i) + " = " +
attributes.getValue(i);
if (i < (attributes.getLength() - 1))
attList = attList + ", ";
}
idx -= INDENT;
}
}
private String getIndent() {
StringBuffer sb = new StringBuffer();
for (int i = 0; i < idx; i++)
sb.append(" ");
return sb.toString();
}
}
要导入得xml文档
<?xml version="1.0"?>
<XmlEmployees>
<XmlEmployee>
<EmpNo>2</EmpNo>
<FirstName>Robert</FirstName>
<LastName>Nelson</LastName>
</XmlEmployee>
</XmlEmployees>
结果
PARSING begins...
start document:
start element: XmlEmployees
start element: XmlEmployee
start element: EmpNo
Value: 2
end element
start element: FirstName
Value: Robert
end element
start element: LastName
Value: Nelson
end element
end element
end element
end document
...PARSING ends
[返回] 计算机科学论坛 →
XML.ORG.CN讨论区 - XML技术 → 『 XML源码及示例(仅原创和转载) 』 → 在jbuilder环境下把xml文档导入导出oracle
(订阅本版)
2004/4/19 12:58:00
新浪微博
在jbuilder环境下把xml文档导入导出oracle
