ACCESSµÄÄ£ºý²éѯ
ÔÚSQL ServerÖÐÄ£ºý²éѯͨ³£ÊÇÕâÑùµÄSelect * from articleTable where authorName like '%jacky%'
µ«ÊÇÔÚAccessÖÐÓÃÕâÌõÓï¾äÖ´ÐеÄʱºò¾¹È»·¢Ïֲ鲻³ö½á¹û£¬Ôõô¿ÉÄÜÄØ£¿
ºóÀ´²éÁËÏÂ×ÊÁÏ£¬·¢ÏÖÎÊÌâÈçÏ£º
Òª½øÐÐÄ£ºý²éÕÒ£¬Ôò±ØÐëʹÓÃͨÅä·û£¬ACCESS¿âµÄͨÅä·ûºÍSQL SERVERµÄͨÅä·û²»Ò»Ñù¡£
ACCESS¿âµÄͨÅä·ûΪ£º
* ÓëÈκθöÊýµÄ×Ö·ûÆ¥Åä¡£
? ÓëÈκε¥¸ö×ÖĸµÄ×Ö·ûÆ¥Åä
ÔÚSQL ServerÖеÄͨÅä·ûΪ£º
% ÓëÈκθöÊýµÄ×Ö·ûÆ¥Åä
- Óëµ¥¸ö×Ö·ûÆ¥Åä
µ«ÊÇÓÖ·¢ÏÖ£¬C#Á¬½Óµ½AccessÊý¾Ý¿âÖ®ºó£¬ÓÃÕâÑùÒ»ÌõÓï¾äSelect * from articleTable where authorName like '*jacky*' £¨×¢Ò⣬Õâ±ß°´ÕÕÉÏÊöͨÅä·ûµÄÒªÇó½«%ÐÞ¸ÄΪ*ÁË£©¾¹È»ËÑË÷²»µ½Ó¦¸Ã´æÔÚµÄNÌõ¼Ç¼£¬ÎÒ¿¿
Ïà¹ØÎĵµ£º
ת×Ô
http://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ
select * from kc where rq < #2000-01-01# and rq>#2002-01-01#
²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ
ʹÓÃ# ¶ø²»ÊÇ ......
JDBCÁ¬½ÓMySQL
¼ÓÔØ¼°×¢²áJDBCÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
JDBC URL ¶¨ÒåÇý¶¯³ÌÐòÓëÊý¾ÝÔ´Ö®¼äµÄÁ¬½Ó
±ê×¼Óï·¨£º
<protocol£¨Ö÷ҪͨѶÐÒ飩>:<subprotocol£¨´ÎҪͨѶÐÒ飬¼´Çý¶¯³ÌÐòÃû³Æ£©>:<da ......
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
½ñÌ컨ÁË2¸öСʱ¼ä£¬ÔÚÍøÉÏ·¢ÏÖÒ»´ó¶ÑµÄ½â´ð£¬µ«¶¼²»´ÕЧ£¬×Ô¼ºÃþË÷£¬ÖÕÓڸ㶨Õâ¸öºÜ¶ñÐĵÄÎÊÌâ¡£
µÚÒ»²½:½øÈë/varĿ¼ Ö´ÐÐÃüÁî chmod 755 ./www/ -R £¬Ò²¾ÍÊǰÑWEBĿ¼ÏµÄÎļþµÄ·ÃÎÊȨÏÞÊʵ±´ò¿ª
µÚ¶þ²½:sudo cd /etc/apache2/sites-enabled/,·¢ÏÖÀïÃæÓм¸¸öĿ¼£¬±ÈÈçÎÒµÄÓÐ 000£default£¬ÊäÈësudo gedit /etc/apach ......