ÓÃjdomʵÏÖ½«Êý¾Ý¿â×ÊÁÏÉú³ÉxmlÎļþ
½ñÌìµÄÏîĿģ¿éÖÐÓõ½¸ù¾ÝÊý¾Ý¿âÀïµÄ×ÊÁÏÉú³ÉxmlÎļþ£¬Ö÷Òª²½ÖèÈçÏ£º
£¨1£© Á¬½ÓÊý¾Ý¿â£¬È¡³öÊý¾Ý£»
£¨2£© ´´½¨½áµã£¬Ìí¼Ó×ÓÏ
£¨3£© дÈëÎļþ“test.xml”ÖУ»
¾ßÌå´úÂëÈçÏ£º
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
public class CreateXml {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException,SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lalayi?user=root&password=root");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from store");
try {
Element root = new Element("µêÃæÀà");
Document Doc = new Document(root);
int i = 0;
while (rs.next()) {
Element elements = new Element("µêÃæ");
elements.addAttribute("id","" + i);
elements.addContent(new Element("µêÃæID").setText(rs.getString(1)));
elements.addContent(new Element("Ãû³Æ").setText(rs.getString(2)));
elements.addContent(new Element("ÃÜÂë").setText(rs.getString(3)));
elements.addContent(new Element("ÓÊÏä").setText(rs.getString(4)));
elements.addContent(new Element("ÈÕÆÚ").setText(rs.getString(5)));
elements.addContent(new Element("ÊÖ»ú").setText(rs.getString(6)));
elements.addContent(new Element("ÊÖ»ú2").setText(rs.getString(7)));
&nbs
Ïà¹ØÎĵµ£º
ÓÃTXT±à¼ÁËÒ»¸öXMLÎĵµ
<?xml version="1.0" encoding="utf-8"?>
<TEST>"
<Test Value="ÕâÊÇÒ»¸ö²âÊÔ" />
</TEST>
ÓÃIE´ò¿ªµÄʱºòÒ»Ö±ÏÔʾÓдíÎó£¬ÏÔʾººÓï×Ö·û²»Ö§³Ö¡£
¸ÄΪencoding=“gb2312”ºóÏÔʾÕý³£ÁË¡£
µ«Õâ¸ö½á¹ûÓë³õÖÔÎ¥±³£¬ÒòΪUTF-8ÊÇÖ§³ÖËùÓÐÓïÑԵġ£
ºóÀ´²éÕÒÔÒ ......
½ñÌìÔÚÔËÓÃspringµÄPropertyPlaceholderConfigurerʱ·¢ÏÖÒ»¸öÓÐÒâ˼µÄÄÚÈÝ£¬µ±ÄãÔÚapplicationContextÖÐÅäÖÃÒ»¸öPropertyPlaceholderConfigurerµÄbeanʱ£¬ÓÐlocationºÍlocationsµÄÊôÐÔ£¬²»Ã÷˼Òâlocation¶ÔÓ¦Ò»¸ö.propertiesÎļþ£¬
locations¶ÔÓ¦¶à¸ö.propertiesÎļþ£¬³å×ÅÏë¿´Ò»ÏÂPropertyPlaceholderConfigurerµÄʵÏÖ»úÖ ......
XML±»Éè¼ÆÓÃÀ´ÃèÊöÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÄÚÈÝ¡£
HTML±»Éè¼ÆÓÃÀ´ÏÔʾÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÍâ¹Û¡£
Ó¦¸ÃÕÆÎյĻù´¡ÖªÊ¶£º
ÔÚÄú¼ÌÐøÑ§Ï°Ö®Ç°£¬ÐèÒª¶ÔÒÔÏÂ֪ʶÓлù±¾µÄÁ˽⣺
HTML / XHTML
JavaScript or VBScript
ʲôÊÇXML?
XMLÖ¸¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨EXtensible Markup Language£©
XMLÊÇÒ»Ö ......
ÈçºÎ¼ÓÔØÓÐÍâ¹úºÍÌØÊâ×Ö·ûµÄÎĵµ£¿
¡¡¡¡Îĵµ¿ÉÒÔ°üº¬Íâ¹ú×Ö·û£¬ÀýÈ磺
¡¡¡¡foreign characters (úóí?)
¡¡¡¡ÀýÈç íá µÄÍâ¹ú×Ö·û±ØÐëÔÚÇ°Ãæ¼ÓÉÏ escape ÐòÁС£Íâ¹ú×Ö·û¿ÉÒÔÊÇ UTF-8 ±àÂë»òÓò»Í¬±àÂëÖ¸¶¨£¬ÈçÏÂËùʾ£º
¡¡¡¡foreign characters (íá)
¡¡¡ ......
XMLÏÖÔÚÒѾ³ÉΪһÖÖͨÓõÄÊý¾Ý½»»»¸ñʽ,ËüµÄƽ̨ÎÞ¹ØÐÔ,ÓïÑÔÎÞ¹ØÐÔ,ϵͳÎÞ¹ØÐÔ,¸øÊý¾Ý¼¯³ÉÓë½»»¥´øÀ´Á˼«´óµÄ·½±ã¡£¶ÔÓÚXML±¾ÉíµÄÓ﷨֪ʶÓë¼¼Êõϸ½Ú,ÐèÒªÔĶÁÏà¹ØµÄ¼¼ÊõÎÄÏ×,ÕâÀïÃæ°üÀ¨µÄÄÚÈÝÓÐDOM(Document Object Model),DTD(Document Type Definition),SAX(Simple API for XML),XSD(Xml Schema Definition),XSLT(Exten ......