Â¥Ö÷

ÈçºÎ½«XMLÊý¾Ýµ¼ÈëÊý¾Ý¿â ¸÷λ¸ßÊÖ£¬ÄÜ·ñ½ÌÎÒÈçºÎ½«XMLÊý¾Ýµ¼ÈëÊý¾Ý¿â°¡£¬ÎÒÔÚ×ö±ÏÒµÉè¼Æ£¬¼±ËÀÎÒÁË    Êղؠ  ·ÖÏí   ¶¥(0)

	µÚ2Â¥

¶¥Æð¡£Ï£Íû¸ßÊÖÀ´½â¾öÏ£¬ÎÒÒ²ÕýÒªÎʵģ¡

	µÚ3Â¥

so do I...

	µÚ4Â¥

ÎÒÒ²ÊDZðÈ˽̵ģ¬ÊÇ×ö±ÏÒµÉè¼ÆÓõÄ,»òÐí¿ÉÒÔ¿´¿´ÓõÃ×Å import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class connnect1 {  String driverName = "com.mysql.jdbc.Driver";  String databaseUrl = "jdbc:mysql://localhost:3306/ly";  String user = "java";  String password = "java";  static Statement stat =null;  static Connection con = null;    public void conn(){      try {    Class.forName(driverName);    System.out.println("³É¹¦¼ÓÔØMysqlÊý¾Ý¿âÇý¶¯£¡");   } catch (ClassNotFoundException e) {    System.out.println("¼ÓÔØMysqlÊý¾Ý¿âÇý¶¯Ê§°Ü£¡");    System.out.println(e.getMessage());    return;   }   try {    con = DriverManager.getConnection(databaseUrl, user,      password);    System.out.println("Êý¾Ý¿âÁ¬½Ó³É¹¦£¡");   stat = con.createStatement();     //   System.out.println(otherversions);          } catch (SQLException e) {    System.out.println("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡");    System.err.println("SQLExecption: " + e.getMessage());    return;   }  } public void ineart_Data(String virusname, String otherversions,   String alias, String details) throws SQLException {  String insertData = ("INSERT INTO kav(virusname,otherversions,alias,Details)"    + "VALUES('"    + virusname    + "','"    + otherversions    + "','"    + alias + "','" + details + "')");  stat.executeQuery(insertData); } public void close() throws SQLException{  stat.close();  con.close(); } }

	µÚ5Â¥

ÒÔÏÂÊÇÒýÓÃlinyanÔÚ2005-5-20 15:14:03µÄ·¢ÑÔ£º ÎÒÒ²ÊDZðÈ˽̵ģ¬ÊÇ×ö±ÏÒµÉè¼ÆÓõÄ,»òÐí¿ÉÒÔ¿´¿´ÓõÃ×Å import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class connnect1 {   String driverName = "com.mysql.jdbc.Driver";   String databaseUrl = "jdbc:mysql://localhost:3306/ly";   String user = "java";   String password = "java";   static Statement stat =null;   static Connection con = null;      public void conn(){        try {     Class.forName(driverName);     System.out.println("³É¹¦¼ÓÔØMysqlÊý¾Ý¿âÇý¶¯£¡");    } catch (ClassNotFoundException e) {     System.out.println("¼ÓÔØMysqlÊý¾Ý¿âÇý¶¯Ê§°Ü£¡");     System.out.println(e.getMessage());     return;    }    try {     con = DriverManager.getConnection(databaseUrl, user,       password);     System.out.println("Êý¾Ý¿âÁ¬½Ó³É¹¦£¡");    stat = con.createStatement();      //   System.out.println(otherversions);             } catch (SQLException e) {     System.out.println("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡");     System.err.println("SQLExecption: " + e.getMessage());     return;    }   } public void ineart_Data(String virusname, String otherversions,    String alias, String details) throws SQLException {   String insertData = ("INSERT INTO kav(virusname,otherversions,alias,Details)"     + "VALUES('"     + virusname     + "','"     + otherversions     + "','"     + alias + "','" + details + "')");   stat.executeQuery(insertData); } public void close() throws SQLException{   stat.close();   con.close(); } } ÊÇÔÚʲôµØ·½ÒýÓÃÕâ¶Î»°ÄØ£¿ÔÚxmlÖУ¿

	µÚ6Â¥

²»ÖªµÀÓÐûÓÐvb×öµÄ£¬Çë´Í½Ì°¡£¡£¡

	µÚ7Â¥

¶Ô°¡!Ôõô¶¼²»ÓÃvb.net×öµÄÄØ?

	µÚ8Â¥

ÒÔÏÂÊÇÎÒµÄÓÃXSLT°ÑXMLµÄÊý¾ÝÊäÈëÊý¾Ý¿â£¨MY SQL£©µÄÀý×Ó£º <xsl:stylesheet  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">   <xsl:output method = "text" indent = "yes"/>   <xsl:template match = "/" >   <xsl:apply-templates select="*"/>   </xsl:template>   <!-- get the value to insert into the table "Qnre" -->   <xsl:template match = "Qnre">     <xsl:text>insert into Qnre values ('</xsl:text>     <xsl:value-of select="@id"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@client"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@author"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@contact"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@version"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@topic"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@date"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qtitle"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qtitle/@clientlogo"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/@privacy"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/@heading"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/@para"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/@Qitem"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qbody/@action"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qbody/@uploads"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qbody/@bid"/>     <xsl:text>'); </xsl:text>     <!-- set to <Qsection> -->     <xsl:apply-templates select="Qbody/Qsection"/>   </xsl:template>   <!-- get the value to insert into the table "Qsection" -->   <xsl:template match = "Qsection">    <xsl:text>insert into Qsection values ('</xsl:text>    <xsl:value-of select="/Qnre/@id"/>    <xsl:text>','</xsl:text>    <xsl:value-of select="@sid"/>    <xsl:text>','</xsl:text>    <xsl:value-of select="Qintro/Qprivacy"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qheading"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qpara"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qitem"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="goto"/>     <xsl:text>'); </xsl:text>     <!-- set to <Question> -->     <xsl:apply-templates select="Question"/>   </xsl:template>   <!-- get the value to insert into the table "Question" -->   <xsl:template match="Question">     <xsl:text>insert into Question values ('</xsl:text>     <xsl:value-of select="/Qnre/@id"/>     <xsl:text>','</xsl:text>     <!-- set to <Qsection> -->     <xsl:value-of select="../@sid"/>     <xsl:text>','</xsl:text>    <xsl:value-of select="@qid"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@kind"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qprivacy"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qheading"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qpara"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qintro/Qitem"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qtext"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qanswer/Qother"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qanswer/@answertype"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="Qanswer/Qlink/@goto"/>     <xsl:text>'); </xsl:text>     <!-- set to <Qchoice> -->     <xsl:apply-templates select="Qanswer/Qchoice"/>   </xsl:template>   <!-- get the value to insert into the table "Qchoice" -->   <xsl:template match="Qchoice">     <xsl:text>insert into Qchoice values ('</xsl:text>     <xsl:value-of select="/Qnre/@id"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="/Qnre/Qbody/Qsection/@sid"/>     <xsl:text>','</xsl:text>     <!-- set to <Question> -->     <xsl:value-of select="../../@qid"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="@val"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="/Qother/Qlink/@goto"/>     <xsl:text>','</xsl:text>     <xsl:value-of select="."/>     <xsl:text>'); </xsl:text>     </xsl:template> </xsl:stylesheet> /=========== Êä³ö½á¹ûÎļþ¿ÉÒÔÁí´æΪSQL FILE¡£È»ºóÔÚLINUXµÄCOMMEND LINEÀïÖ±½ÓÊäÈëÎļþÃû¾ÍÄÜ ×Ô¶¯INSERT INTO DATABASEÁË¡£

	µÚ9Â¥

¿ÉÒÔÓÃÒ»ÓÃJBuilderX

----------------------------------------------
ΪÖйúµÄÈí¼þÊÂÒµ¶ø·Ü¶·ÖÕÉí£¡