Java+XML将数据导入SQL Server中

Java+XML将数据导入SQL Server中

String password=null;} public String getUrl(){return url;} public String getPassword(){return password;} public void setDbClass(String str){ dbClass=str;} public void setUrl(String str){ url=str;} public void setUsername(String str){username=str;} public void

setPassword(String str){password=str;

Java+XML将数据导入SQL Server中

文件ConnPara.java，表示以类形式表示的数据库连接参数。

public class ConnPara

{

String dbClass=null;

String url=null;

String username=null;

String password=null;

public ConnPara() { }

public ConnPara(String pdbClass,String purl,String pusername,String

ppassword)

{

dbClass=pdbClass;

url=purl;

username=pusername;

password=ppassword;

}

Java+XML将数据导入SQL Server中

public String getDbClass(){return dbClass;}

public String getUrl(){return url;}

public String getUsername(){return username;}

public String getPassword(){return password;}

public void setDbClass(String str){ dbClass=str;}

public void setUrl(String str){ url=str;}

public void setUsername(String str){username=str;}

public void setPassword(String str){password=str;}

}

文件DbXmlParser.java封装了对xml文件的操作。

import javax.xml.parsers.*;

import org.w3c.dom.*;

import org.xml.sax.*;

import java.io.*;

public class DbXmlParser

{

static String xmlfile;

public DbXmlParser(String filename)

{

Java+XML将数据导入SQL Server中

xmlfile=filename;

}

public static Element loadDocument()

{

try

{

//工厂

DocumentBuilderFactory

dcfactory=DocumentBuilderFactory.newInstance();

//文档构造器

DocumentBuilder db=dcfactory.newDocumentBuilder();

//构造的文档

Document doc=db.parse(xmlfile);

//根元素

Element root=doc.getDocumentElement();

return root;

}catch( ParserConfigurationException e){

System.out.println("ParserConfigurationException");

e.printStackTrace();

Java+XML将数据导入SQL Server中

}catch(IOException e) {

System.out.println("IOException ");

e.printStackTrace();

}catch(SAXException e) {

System.out.println("SAXException ");

e.printStackTrace();

}catch(Exception e) {

e.printStackTrace();

}

return null;

}

public ConnPara getSource()

{

Element root=loadDocument();

if( root==null) { return null; }

NodeList nodes=root.getElementsByTagName("source");

if(nodes.getLength()＞0)

{

Node node=nodes.item(0);

Java+XML将数据导入SQL Server中

String connclass=getChildElementValue(node,"class");

String url=getChildElementValue(node,"url");

String username=getChildElementValue(node,"user");

String password=getChildElementValue(node,"password");

return new ConnPara(connclass,url,username,password);

}

return null;

}

public ConnPara getDest()

{

Element root=loadDocument();

if( root==null) return null;

NodeList nodes=root.getElementsByTagName("dest");

if(nodes.getLength()＞0)

{

Node node=nodes.item(0);

String connclass=getChildElementValue(node,"class");

String url=getChildElementValue(node,"url");

String username=getChildElementValue(node,"user");

Java+XML将数据导入SQL Server中

String password=getChildElementValue(node,"password");

return new ConnPara(connclass,url,username,password);

}

return null;

}

//得到子元素的值

private String getChildElementValue(Node node,String subTagName) {

String returnString = "";

if(node != null)

{

NodeList children = node.getChildNodes();

for(int innerLoop = 0; innerLoop ＜ children.getLength(); innerLoop++) {

Node child = children.item(innerLoop);

if(child == null || child.getNodeName() == null

|| !child.getNodeName().equals(subTagName))

continue;

Node grandChild = child.getFirstChild();

Java+XML将数据导入SQL Server中

if(grandChild.getNodeValue() != null) return grandChild.getNodeValue(); }

}

return returnString;

}

}

本文来源：https://www.bwwdw.com/article/a8ij.html