dom4j½âÎöxml - Java / Web ¿ª·¢
<?xml version="1.0" encoding="UTF-8"?>
<result>
<value>
<table>tbl_notice</table>
<sql>select title,content from tbl_notice order by id desc</sql>
<style></style>
<value>
</result>
ÓÃdom4j½âÎöÊÇÔõôÄܹ»»ñÈ¡µ½result±êÇ©ÏÂ×Ó½ÚµãµÄÃû³Æ°¡£¿
¿´ÎÒÍ·Ïñ
File file=new File(filePath);
ArrayList<Match> result=new ArrayList<Match>();
StringBuffer sb=new StringBuffer();
BufferedReader br=new BufferedReader(new InputStreamReader(new FileInputStream(file),"utf-8"));
String line="";
while ((line=br.readLine())!=null) {
sb.append(line+"\n");
}
br.close();
ByteArrayInputStream bs=new ByteArrayInputStream((sb.toString()).getBytes("utf-8"));
SAXBuilder builder=new SAXBuilder(false);
Document document=builder.build(bs);
Element root=document.getRootElement();
List<Element> child=root.getChildren();
¿´ËûµÄÍ·Ïñ
ºÇºÇ~
Java code:
Document doc=new SAXReade
Ïà¹ØÎÊ´ð£º
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......