定义一个Handler,处理sax解析
package com.jb.f1.scd.service.impl;
import java.lang.reflect.Field;
import java.util.LinkedList;
import java.util.List;
import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;
public class ScdServiceHandler extends DefaultHandler {
String currentTag = null;
String currentValue = null;
String nodeName = null;
Object object = null;
Class<?> objClas = null;
List<Object> list = null;
public ScdServiceHandler(String nodeName) {
this.nodeName = nodeName;
}
public List<Object> getList() {
return list;
}
@Override
public void startDocument() {
list = new LinkedList<Object>();
try {
// objClas = Class.forName(this.getClass().getPackage().getName() + "."+ nodeName);
objClas = Class.forName("com.jb.f1.scd.model.TB_SCD_" + nodeName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
@Override
public void startElement(String uri, String localName, String qName,
Attributes attributes) {
if (qName.equals(nodeName)) {
try {
object = objClas.newInstance();
} catch (Exception e) {
e.printStackTrace();
}
if (attributes != null && object != null) {
for (int i = 0; i < attributes.getLength(); i++) {
try {
setField(attributes.getQName(i), attributes.getValue(i));
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
currentTag = qName;
}
private void setField(String qName, String value) throws Exception {
Class<?> cls = object.getClass();
Field[] fields = cls.getDeclaredFields();
for (int i = 0; i < fields.length; i++) {
Field f = fields[i];
if(!f.getName().equalsIgnoreCase(qName)){
continue;
}
f.setAccessible(true);
String type = f.getType().toString();
if (type.endsWith("String")) {
f.set(object, value);
} else {
System.out.println("暂时不支持非String类型");
}
}
}
@Override
public void characters(char[] ch, int start, int length)
throws SAXException {
// TODO Auto-generated method stub
// if (currentTag != null && map != null) {
// currentValue = new String(ch, start, length);
// if (currentValue != null && !currentValue.trim().equals("")
// && !currentValue.trim().equals("\n")) {
// // map.put(currentTag, currentValue);
// }
currentTag = null;
currentValue = null;
// }
}
@Override
public void endElement(String uri, String localName, String qName)
throws SAXException {
if (qName.equals(nodeName)) {
list.add(object);
object = null;
}
}
@Override
public void endDocument() throws SAXException {
super.endDocument();
}
}
2、定义一个serviceImpl
package com.jb.f1.scd.service.impl;
import java.io.InputStream;
import java.util.List;
import javax.annotation.Resource;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import org.springframework.stereotype.Service;
import com.jb.dao.GenericDao;
import com.jb.f1.scd.model.TB_SCD_IED;
import com.jb.f1.scd.service.ScdSerivce;
import com.jb.ui.service.EntityOperationServiceAdapter;
/**
* @author leipan
*
*/
@Service("scdServiceImpl")
public class ScdServiceImpl extends EntityOperationServiceAdapter<TB_SCD_IED>
implements ScdSerivce {
@Resource(name = "genericDao")
protected GenericDao genericDao;
/**
* 通过文件路径的方式解析文件
* uri: 文件路径
* nodeName:节点名称
*/
@Override
public List<Object> readSCD(String uri, String NodeName) {
try {
SAXParserFactory parserFactory = SAXParserFactory.newInstance();
SAXParser parser = parserFactory.newSAXParser();
ScdServiceHandler myhandler = new ScdServiceHandler(NodeName);
parser.parse(uri, myhandler);
return myhandler.getList();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* 通过文件流的方式解析文件
* @param in:文件输入流
* @param NodeName:节点名称
* @return
*/
public List<Object> readSCD(InputStream in, String NodeName) {
try {
SAXParserFactory parserFactory = SAXParserFactory.newInstance();
SAXParser parser = parserFactory.newSAXParser();
ScdServiceHandler myhandler = new ScdServiceHandler(NodeName);
parser.parse(in, myhandler);
return myhandler.getList();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* 将解析的节点对象持久化到数据库中
*/
@Override
public String saveSCDIED(List<Object> arg0) {
for (Object obj : arg0) {
if (obj instanceof TB_SCD_IED) {
genericDao.savePo((TB_SCD_IED) obj);
}
}
return null;
}
@Override
public String[] getZBGUID() {
String sql = "select guid from us_sys.tb_file_zb";
genericDao.exeSql(sql);
return null;
}
}
3、增加测试类
public static void main(String[] args) throws FileNotFoundException {
ScdServiceImpl s = new ScdServiceImpl();
long time = System.currentTimeMillis();
InputStream in = new FileInputStream("E:\\scd\\1.scd");
List<Object> list = s.readSCD(in, "IED");
System.out.println(System.currentTimeMillis() - time);
for (int i = 0; i < list.size(); i++) {
System.out.println("(" + (i + 1) + ")" + list.get(i));
}
}
4、定义一个实体类,用于将解析的节点对应到Model中。
package com.jb.f1.scd.model;
import com.jb.model.PersistClass;
@SuppressWarnings("serial")
public class TB_SCD_IED extends PersistClass {
private String name;
private String type;
private String desc;
private String manufacturer;
private String configVersion;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getDesc() {
return desc;
}
public void setDesc(String desc) {
this.desc = desc;
}
public String getManufacturer() {
return manufacturer;
}
public void setManufacturer(String manufacturer) {
this.manufacturer = manufacturer;
}
public String getConfigVersion() {
return configVersion;
}
public void setConfigVersion(String configVersion) {
this.configVersion = configVersion;
}
@Override
public String toString() {
return "IED [name=" + name + ", type=" + type + ", desc=" + desc
+ ", manufacturer=" + manufacturer + ", configVersion="
+ configVersion + "]";
}
}