package com.linzl.cn.xmlToVo;
import java.io.StringReader;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;
import org.xml.sax.InputSource;
public class XmlToVo {
public static void main(String[] args) throws Exception {
String xmlStr = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"
+ "<accounts>"
+ "<account>"
+ "<accId>帐号ID(必填)</accId>"
+ "<name>姓名</name>"
+ "<email>邮箱 </email>"
+ "<gender>性别</gender>"
+ "<employeeNumber>员工编号</employeeNumber>"
+ "<telephoneNumber>座机</telephoneNumber>"
+ "<mobile>移动电话</mobile>"
+ "<description>描述</description>"
+ "<startTime>生效日期</startTime>"
+ "<serialNumber>排序序号</serialNumber>"
+ "<roomNumber>房间号码</roomNumber>"
+ "<position>用户职务</position>"
+ "<status>用户状态</status>"
+ "<roleInfo>角色信息</roleInfo>"
+ "<orgNumber >组织机构ID</orgNumber>"
+ "<orgName>组织机构名称</orgName>"
+ "</account>"
+ "<account>"
+ "<accId>帐号ID(必填)111</accId>"
+ "<name>姓名111</name>"
+ "<email>邮箱 111</email>"
+ "<gender>性别111</gender>"
+ "<employeeNumber>员工编号111</employeeNumber>"
+ "<telephoneNumber>座机111</telephoneNumber>"
+ "<mobile>移动电话111</mobile>"
+ "<description>描述111</description>"
+ "<startTime>生效日期111</startTime>"
+ "<serialNumber>排序序号111</serialNumber>"
+ "<roomNumber>房间号码111</roomNumber>"
+ "<position>用户职务111</position>"
+ "<status>用户状态111</status>"
+ "<roleInfo>角色信息111</roleInfo>"
+ "<orgNumber >组织机构ID111</orgNumber>"
+ "<orgName>组织机构名称111</orgName>"
+ "</account>"
+ "</accounts>";
// Document document = DocumentHelper.parseText(xmlStr);
StringReader sr=new StringReader(xmlStr);
InputSource is=new InputSource(sr);
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder=factory.newDocumentBuilder();
Document doc=builder.parse(is);
NodeList list =doc.getElementsByTagName("account");
for(int i=0;i<list.getLength();i++){
Element accountElement=(Element) list.item(i);
String accId = accountElement.getElementsByTagName("accId").item(0).getFirstChild().getNodeValue();
String name= accountElement.getElementsByTagName("name").item(0).getFirstChild().getNodeValue();
String orgNumber= accountElement.getElementsByTagName("orgNumber").item(0).getFirstChild().getNodeValue();
String orgName= accountElement.getElementsByTagName("orgName").item(0).getFirstChild().getNodeValue();
Account account = new Account();
account.setAccId(accId);
account.setName(name);
account.setOrgNumber(orgNumber);
account.setOrgName(orgName);
System.out.println(accId+"-->"+accId);
System.out.println(name+"-->"+name);
System.out.println(orgNumber+"-->"+orgNumber);
System.out.println(orgName+"-->"+orgName);
//将Account插入对应数据库
}
}
}
package com.linzl.cn.xmlToVo;
public class Account {
private String accId; //帐号ID
private String name; //姓名
private String email; //邮箱
private String gender;//性别
private String employeeNumber;//员工编号
private String telephoneNumber;//座机
private String mobile;//移动电话
private String description;//描述
private String startTime;//生效日期
private String serialNumber;//排序序号
private String roomNumber;//房间号码
private String position;//用户职务
private String status;//用户状态
private String roleInfo;//角色信息
private String orgNumber;//组织机构ID
private String orgName;//组织机构名称
public String getAccId() {
return accId;
}
public void setAccId(String accId) {
this.accId = accId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getEmployeeNumber() {
return employeeNumber;
}
public void setEmployeeNumber(String employeeNumber) {
this.employeeNumber = employeeNumber;
}
public String getTelephoneNumber() {
return telephoneNumber;
}
public void setTelephoneNumber(String telephoneNumber) {
this.telephoneNumber = telephoneNumber;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getStartTime() {
return startTime;
}
public void setStartTime(String startTime) {
this.startTime = startTime;
}
public String getSerialNumber() {
return serialNumber;
}
public void setSerialNumber(String serialNumber) {
this.serialNumber = serialNumber;
}
public String getRoomNumber() {
return roomNumber;
}
public void setRoomNumber(String roomNumber) {
this.roomNumber = roomNumber;
}
public String getPosition() {
return position;
}
public void setPosition(String position) {
this.position = position;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
public String getRoleInfo() {
return roleInfo;
}
public void setRoleInfo(String roleInfo) {
this.roleInfo = roleInfo;
}
public String getOrgNumber() {
return orgNumber;
}
public void setOrgNumber(String orgNumber) {
this.orgNumber = orgNumber;
}
public String getOrgName() {
return orgName;
}
public void setOrgName(String orgName) {
this.orgName = orgName;
}
}