java ÀûÓÃXSD ÑéÖ¤XMLÎļþ
XSDÎļþ £¨XML Schema ÓïÑÔÒ²³Æ×÷ XML Schema ¶¨Ò壨XML Schema Definition£¬XSD£©¡£ ¾ßÌåʹÓ÷½·¨ºÍ¶¨ÒåÇë²Î¿´£º
http://www.w3school.com.cn/schema/index.asp
java×Ôjdk1.5ÒÔÉÏÐÂÔöÁËSchemaFactoryÀà ¿ÉÒÔʵÏÖ¶ÔXSDÑéÖ¤µÄÖ§³Ö£¬Ê¹ÓÃÆðÀ´Ò²ºÜ·½±ã¡£
ÒÔÏ´úÂë¿ÉÓÃÔÚJDK1.5+ ÑéÖ¤xml
public class SimpleErrorHandler implements ErrorHandler {
public void warning(SAXParseException e) throws SAXException {
System.out.println(e.getMessage());
}
public void error(SAXParseException e) throws SAXException {
System.out.println(e.getMessage());
}
public void fatalError(SAXParseException e) throws SAXException {
System.out.println(e.getMessage());
}
}
SAXParserFactory factory = SAXParserFactory.newInstance();
SchemaFactory schemaFactory =
SchemaFactory.newInstance("http://www.w3.org/2001/XMLSchema");
factory.setSchema(schemaFactory.newSchema(
new Source[] {new StreamSource("contacts.xsd")}));
SAXParser parser = factory.newSAXParser();
SAXReader reader = new SAXReader(parser.getXMLReader());
reader.setValidation(false);
reader.setErrorHandler(new SimpleErrorHandler());
reader.read("contacts.xml");
¾ßÌåµÄ¿É²Î¿´£ºhttp://www.edankert.com/validate.html
ÔÚJDK1.5֮ǰ²»Ìṩ¶ÔXSDµÄÖ§³Ö£¬ÒÔΪÔÚJDK1.5֮ǰÖÚ¶àµÄXML APIÒѾÂúÌì·É ¿ÉʹÓÃDOM4j + xerces Èç¹û¶ÁÈ¡XML½ÚµãʹÓÃXPATHµÄ»° ÐèÒªsaxpath.jar
JDK1.4+DOM4J+xerces ÑéÖ¤xmlÎļþ
public class ParserErrorHandler implements ErrorHandler {
private static final Logger logger = Logger.getLogger(ParserErrorHandler.class);
public void error(SAXParseException e) throws SAXException {
//logger.error(e);
throw e;
}
public void fatalError(SAXParseException e) throws SAXException {
//logger.error(e);
throw e;
}
public void warning(SAXParseException e) throws SAXException {
//logger.error(e);
throw e;
}
}
--¶¨ÒåSAXReader ºó¶ÁÈ¡xmlÎļþÈç¹û²»·ûºÏXSD¹æÔòµÄ»°¾Í»áÅÜÒì³£
SAXReader reader = new SAXReader();
reader.setValidation(true);
Ïà¹ØÎĵµ£º
½ÌÄãÔõÑùÔÚjavaµÄÓ¦ÓóÌÐòÖмÓÈëÉùÒô
¡¡×î½üÔÚ×öjava¿Î³ÌÉè¼Æ£¬ÏëÔÚÓ¦ÓóÌÐò£¨ÓÐmain£¨£©º¯ÊýµÄ£©ÖмÓÈëÉùÒô£¬´ó¼ÒÖªµÀ
ÔÚ Java applet ÖÐÉùÒô²¥·ÅÈÎÎñºÜ¼òµ¥£¬µ«ÊÇÔÚÓ¦ÓóÌÐòÖÐȱÉÙÕâÑùµÄÖ§³Ö¡£ÏÖÔÚ¸æËßÄãÈçºÎ
ÔÚ Java Ó¦ÓóÌÐòÖв¥·ÅÉùÒôÎļþ¡£
¡¡¡¡¿´Á˺öà×ÊÁÏ·¢ÏÖÔÚ Java Ó¦ÓóÌÐòÖв¥·ÅÉùÒôÎļþÔÚÏÖÓз¢ÐÐµÄ Java ......
½ñÌìÔÚÑо¿JAX-WS£¬Å¼È»·¢ÏÖjava6µÄÖÐÎÄAPIÔÚjavax.xml.ws°ü϶ªÁËһЩannotation£¬Ò²ÊǺÜżȻ·¢ÏÖÕâÖÖÇé¿ö£¬ÎÒÔÚдjava´úÂ룬·¢ÏÖ¿ÉÒÔÓõÄannotation£¬µ«ÊÇÔÚÖÐÎÄapiÀïÕÒ²»µ½£¬ºóÀ´ÕÒÁËÒ»ÏÂÓ¢ÎÄ°æzpi£¬²Å·¢ÏÖÖÐÎİ涪ÁËһЩannotation£¬ÔÝʱ²»Çå³þ±ðµÄ°üÀïÓÐûÓжªÊ§µÄÇé¿ö¡£ÎÒÊÇʹÓÃÔÚÏßAPI£¬ºóÀ´·¢ÏÖÏÂÔØ°æºÍÔÚÏß°æÒ»Ñù¶ ......
Õâ¸öЧ¹ûÓ¦¸Ã²»ËãʲôϡÆ棬ÍøÉÏÒ²ÓÐÏֳɵĴúÂ룬ÎÒÕâ¸öҲûʲôÌرðµÄµØ·½£¬Ö»ÊÇÒòΪÎÒ×Ô¼ºÐ´µÄ£¬Ò²ËãÊÇΪѧϰDOMºóÒ»¸öÁ·Ï°£»ÔÚIEϲâÊÔͨ¹ý£»
ʵÏÖЧ¹ûÊÇÕâÑùµÄ£º
¶ÁÈ¡XMLÎĵµ£»
²ÉÓõݹéÉú³ÉÎÞÏÞ¼¶µÄÊ÷Ðβ˵¥£»
Äܹ»ÏìÓ¦Êó±êʼþ£¬Õ¹¿ªÓë²ðµþ×Ó¼¶²Ëµ¥£»
Ê×ÏÈÊÇÉú³ÉÒ»¸öXMLÎĵµ£¬ÎÒÓõÄÊÇXML SpyµÄ±à¼Æ÷£»
< ......
1.´´½¨²âÊÔ±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
insert into users values(1,'test','test');
insert into users values(2,'test','test');
insert into users values(3,'test','test');
insert into users values(4,'test','test');
insert i ......
ÔÚAccess2007ÖдÓExcelµ¼Èëʱ£¬¾³£»áÅöµ½ÈçϵĴíÎóÌáʾ£º“Õë¶Ô¸Ã¼Ü¹¹½øÐеĹ淶XMLÑé֤ʧ°Ü¡£ÒÔÏÂXMLÎĵµÐÐÖдæÔÚ´íÎ󣺣ü¡£”
ÎҵĽâ¾ö·½Ê½ÊÇÓÃÁ´½Ó±í·½Ê½À´´ò¿ªExcelÎļþ£¬È»ºóÔÚ¸´ÖÆÁ´½Ó±í£¬Õ³Ìù¡£ ......