±¾È˳õѧc#,Á¬accessʱÓöµ½ÁËÒ»¸öСÎÊÌ⣬´úÂëÈçÏÂ
String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sql1.mdb";
String sql = @"select * from table where name = 'aaa'";
OleDbConnection conn = new OleDbConnection(connString);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
µ«ÊÇΪʲôÔÚ×îºóÒ»¾äOleDbDataReader reader = cmd.ExecuteReader();Õâ¶ù¾Í¹ý²»È¥Á˰¡
ÏÈлл¸÷λÁË
table ÕâÊDz»ÄÜÓÃÕâ¸öÃû×ÖµÄ
³öÏÖµÄÊÇʲôÒì³£°¡
ÉÏÃæµÄÓï¾äÓ¦¸Ã¶¼Ã»ÓÐÎÊÌâ
ÔÙ¿´¿´
ÄãµÄSQLÓï¾ä¶Ôô£¬Êý¾Ý¿âsql1.mdbÖдæÔÚ±ítableô£¿
table Êǹؼü×Ö°¡~£¡£¡
µÚÒ»Ñ۵ĴíÎó¾ÍÊÇËüÁË,ÄãÇ°ÃæµÄString sql = @"select * from table where name = 'aaa'";
Ö»ÊǸö×Ö·û´®, Òªµ½¸Õ²ÅÄǸöº¯ÊýÈ¥±»ÔËÐÐ,·¢ÏÖtableÊǸö·Ç·¨×Ö·û,µ±È»±¨´íÀ².¸ÄÏÂÄã±íµÄÃû×Ö°É! ²ËÄñ»Ø´ð²ËÄñÎÊÌâ,ºÇºÇ
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÎÒÓÐÒ»¸öXML.ÏëÈ¡
<Portfolio _Name="XXXX" _Id="AUD" >
ÖеÄÊôÐÔ_IdµÄÖµ.µ«ÊÇÓÃÏÂÃæµÄÓï¾äºÃÏó²»ÐÐ.
XmlNode CId = xdoc_Msg.SelectSingleNode("/Portfolio");
&n ......