Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AccessÖÐ"ÊÇ/·ñ"Êý¾ÝÀàÐÍÊÇÔõÑù´¦ÀíµÄ

¼ÙÉèNews±íÖÐÓÐÒ»¸öÊôÐÔPassed£¬Êý¾ÝÀàÐÍÊÇ“ÊÇ/·ñ“
1,¶Á²Ù×÷£ºstring str="select * from News where Passed=True";(access)¶Á“ÊÇ“²Ù×÷¡£
string str="select * from News where Passed=False";(access)¶Á“·ñ“²Ù×÷¡£
2,д²Ù×÷£º
string str="Delete from News where Passed=True";(access)“ÊÇ“²Ù×÷¡£
string str="Update News set Passed=0  where Passed=True";(access)¡£
string str="Insert into  News (Passed)values(0) ";(access)¡£
3,ʹÓÃParametersʱעÒâÊÂÏî
 myCommand.Parameters.Add("@Passed",OleDbType.TinyInt).Value=1;


Ïà¹ØÎĵµ£º

EA2A(Excel/Access to Access)

Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐÆ½Ì¨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔ­ÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼Èë£¨Ç¨ÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......

JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,Oracle

import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
  
public static void main(String[] args)throws Exception {
  
   Connection conn=null;
  
       //====Á¬½ÓACCESSÊý¾Ý¿â ......

SQL Access Advisor

Oracle Êý¾Ý¿â 10g ÌṩÁË´óÁ¿°ïÖú³ÌÐò£¨»ò“¹ËÎʳÌÐò”£©£¬¿É°ïÖúÄú¾ö¶¨×î¼Ñ²Ù×÷Á÷³Ì¡£ÆäÖÐÒ»¸öʾÀýÊÇ SQL Tuning Advisor£¬Ëü¿ÉÒÔÌṩÓйزéѯµ÷ÕûÒÔ¼°ÔÚÁ÷³ÌÖÐÑÓ³¤Õû¸öÓÅ»¯¹ý³ÌµÄ½¨Òé¡£
µ«Ç뿼ÂÇÒÔϵ÷Õû°¸Àý£º¼ÙÉèÒ»¸öË÷ÒýȷʵÓÐÖúÓÚij¸ö²éѯ£¬µ«¸Ã²éѯִֻÐÐÒ»´Î¡£ÕâÑù£¬¼´Ê¹¸Ã²éѯ¿ÉÒÔµÃÒæÓÚ´ËË÷Òý£¬µ«´´ ......

½»»»»úÈýÖÖ¶Ë¿ÚģʽAccess¡¢HybridºÍTrunkµÄÀí½â

untag¾ÍÊÇÆÕͨµÄethernet±¨ÎÄ£¬ÆÕͨPC»úµÄÍø¿¨ÊÇ¿ÉÒÔʶ±ðÕâÑùµÄ±¨ÎĽøÐÐͨѶ£»
tag±¨ÎĽṹµÄ±ä»¯ÊÇÔÚÔ´macµØÖ·ºÍÄ¿µÄmacµØÖ·Ö®ºó£¬¼ÓÉÏÁË4bytesµÄvlanÐÅÏ¢£¬Ò²¾ÍÊÇvlan tagÍ·£»Ò»°ãÀ´ËµÕâÑùµÄ±¨ÎÄÆÕͨPC»úµÄÍø¿¨ÊDz»ÄÜʶ±ðµÄ
ÏÂͼ˵Ã÷ÁË802.1Q·â×°tag±¨ÎÄÖ¡½á¹¹
´ø802.1QµÄÖ¡ÊÇÔÚ±ê×¼ÒÔÌ«ÍøÖ¡ÉϲåÈëÁË4¸ö×ֽڵıêʶ¡£Æä ......

ACCESSÖлñÈ¡ËùÓÐ×é¼þ´úÂë

 Private Sub cmdListProperties_Click()
    ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
    Dim ctl As Control
    Dim prp As Property
    On Error GoTo props_err
    For Each ctl In ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ