Access±¨´í¡°Óï·¨´íÎó ²Ù×÷·û¶ªÊ§¡± - .NET¼¼Êõ / C#
SQL code:
select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,[B].[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description
from t_commands as A
inner join t_parameters as B on [A].[type]=[B].[code]
inner join t_parameters as C on [A].[state]=[C].[code]
where B.id=3 and C.id=4
ÈçÉÏSQL£¬Ö´ÐеÄʱºò¾ÍÌáʾ¡°Óï·¨´íÎ󣨲Ù×÷·û¶ªÊ§£©ÔÚ¡®[A].[type]=[B].[code]
inner join t_parameters as C on [A].[state]=[C].[code] ¡¯ÖС±µÄÌáʾ£¬È»ºóÎÒ·¢ÏÖÈç¹û°ÑºóÃæµÄjoinÓï¾äÈ¥µô²»Á¬½ÓµÄ»°¾ÍÄÜÕý³£²éѯ³öÊý¾Ý£¬ÊDz»ÊÇAccess²»Ö§³Ö¶à¸öÁ¬½Ó²éѯµÄ£¿
select * from (select * from table1 t1 left join table2 t2 on t1.id=t2.id) t left join table3
t3 on t.id=t3.id
Ö»ÓÐÓÃLEFT¡¡JOIN+RIGHT¡¡JOIN
select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,.[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description
from (t_commands as A
inner join t_parameters as B on [A].[type]=[B].[code] )
inner join t_parameters as C on [A].[state]=[C].[code]
where B.id=3 and C.id=4
[b]¼ÓÉÏ£¨£©
ѧϰÖÐ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~¶¥Æð£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
¸ßÊÖ¶¼°ïÄã»Ø´ðÁË
ÎҾ͸æËß
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......
ÍøÉÏCOPYÒÔ¼°ÕûÀí»Ø´ðÍøÓѵÄÎÊÌâ¡£´ó¼Ò¿ÉÒÔ¼ÓÈëÎÒн¨µÄQQȺһÆðÁÄÁÄ£¬¹²Í¬Ñ§Ï°¡£
QQȺºÅ£º109967503
c#µÄÒ»Ð©ÌØÕ÷£º
Íêȫ֧³ÖÀàºÍÃæÏò¶ÔÏó±à³Ì£¬°üÀ¨½Ó¿ÚºÍ¼Ì³Ð¡¢Ð麯ÊýºÍÔËËã·ûÖØÔØµÄ´¦Àí¡£
¶¨ÒåÍêÕû¡ ......
ÈçºÎ½«Ò»¸öListBoxÖеÄÊý¾Ý´æÔÚÊý¾Ý¿âÖеÄÒ»¸ö×Ö¶ÎÏÂÃæ£¬²¢ÇÒÿÌõ¼Ç¼µÄ×Ö·û´®¸öÊý²»Ò»¶¨ ÒÔ¼°ÈçºÎ´ÓÊý¾Ý¿âÖжÁÈ¡¸ÃListBoxÖеÄËùÓмǼ
C/C++ code:
//´æÈëÊý¾Ý¿â
void __fastcall TForm1::Button5Click(TO ......
VS2008ÖÐC#²Ù×÷AccessÊý¾Ý¿â£¬ÍøÉÏÏÂÔØÁËÒ»¸öÀ࣬¿ÉÒÔÕý³£Á¬½Ó£¬¶ÁÈ¡Êý¾Ý£¬µ«ÊDzåÈëɾ³ý²Ù×÷ËÆºõÓÐÎÊÌ⣬ÒÔÏÂÊDz¿·Ö´úÂ룺
Êý¾Ý¿âÀࣺ
namespace AccessDb
{
public class AccessDbClass
{ ......