vb+sqlµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà
ÎÒÏëÕÒ¸ö¶®vb+sqlµÄСÀÏʦ£¬¶ÔÎÒÖ¸µ¼Ò»Ï£¬ÏÖÔÚÔÚ×öͼÊé¹ÜÀíϵͳ£¬ÓкöàÎÊÌâÏëÇë½Ì£¬¿ÉÒÔ°ïÒ»ÏÂÂð£¿
ллллл~~~À²£¡
¿É·ñÁô¸öqqѽ£¿
ÕâÊÇÎÒµÄqq£º253214495
....
VB°æ±È½Ï¶à£¬ÓÑÇé°ï¶¥¡£
vbûʲô¾Ñé
ÎÒÒ²¼±¶î···
²»ºÃÒâ˼···
............
ÎÒÃÇÊÇÓÃvb6.0µÄ¡£
¸Ðл¸Ðл~~~
·¹ý °ï¶¥
vbûʲô¾Ñé
ÄãÈ¥VB°æÎÊÎÊ.
up......
You can download the example and see it again and again~~
ºÇºÇ~~~»¹ÓÃÓ¢Óïѽ£¡
ÎÒÏÖÔÚµÄÕâ¸öµ÷ÊÔ²»À´···
È¥vb°æÊǸöºÃ½¨Ò飡
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®
¿´¿´i ......
ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
A 3
A 4
B 6
... ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......