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

ÈçºÎ·ÀÖ¹SQL×¢Èë¹¥»÷

BSϵͳÖУ¬´«Í³µÄ×¢Èë¹¥»÷ÊÖ¶ÎÓкܶࡣ
×î»ù±¾µÄ£¬ÀûÓõ¥ÒýºÅ¹¥»÷µÄ£¬ºÜÈÝÒ×½â¾ö£¬ÓÃÀàËÆÓÚQuotedStr()£¨Êµ¼Ê¿ª·¢ÊÇÆäËûÓïÑÔ£¬ÕâÀïÓÃDELPHIÖеĺ¯Êý´úÌæ£©µÄº¯Êý´¦Àí²ÎÊý¼´¿É¡£
µ«Êµ¼ÊÓ¦ÓÃÖУ¬²»¿É±ÜÃâ»áÓÐһЩӦÓÃÐèÒªÖ±½Ó´«µÝ²ÎÊý£¬ÀýÈç±íÃû¡¢²éѯÌõ¼þ¡¢ÅÅÐòÌõ¼þµÈµÈ
¶ÔÕâЩӦÓõÄ×¢Èë¹¥»÷·À²»Ê¤·À¡£
ÎÒ¿¼ÂÇÁËÒ»¸ö˼·£¬¹©´ó¼Ò²Î¿¼¡£
1 ¶ÔËùÓÐÍøÒ³´«ÈëµÄ²ÎÊý·ÖÈýÖÖ¡£
  a) Êý×ÖÀàÐÍ£¬ÓÃStrToIntº¯Êý´¦Àí¡£
  b) ×Ö·û´®ÀàÐÍ£¬ÓÃQuotedStrº¯Êý´¦Àí¡£
  c) ÐèÒªÖ±½Ó´«µÝµÄ²ÎÊý£¬ÕâÊÇÐèÒª×ÅÖØ¿¼ÂǵÄÀàÐÍ¡£
2 ¶ÔËùÓÐÊý¾Ý¿â²Ù×÷Ö÷Òª·ÖÎåÖÖ£¬²»ÔÊÐí³ÌÐòÖ±½ÓÖ´ÐÐSQLÓï¾ä£º
  a) select ²éѯ
  b) update ¸üÐÂ
  c) insert ÐÂÔö
  d) delete ɾ³ý
  e) exec Ö´Ðд洢¹ý³Ì
3 ¶ÔÓÚÒÔÉϼ¸ÖÖÊý¾Ý¿â²Ù×÷µÄËùÓвÎÊý£¬ÀýÈçselect ²Ù×÷ÖÐµÄ ²éѯÌõ¼þ¡¢ÅÅÐòÌõ¼þµÈ£¬¶¼½øÐкϷ¨ÐÔУÑ飺
  a) ÀïÃæ´æÔÚ "--" "/*" "*/" µÄ£¬¶¼ÊÓΪ·Ç·¨Ìõ¼þ¡£
  b) ½«Ìõ¼þ²ð·ÖΪµ¥´Ê£¬Èç¹û´æÔÚÒÔϵ¥´Ê£ºdelete insert update exec execute create drop grantµÄ£¬¶¼ÊÓΪ·Ç·¨Ìõ¼þ¡££¨Õý³£µÄ±íÃû¡¢×Ö¶ÎÃûÖв»¿ÉÄÜÓÐÉÏÃæÕâЩ¹Ø¼ü×Ö°É¡££©
  c) ´«ÈëµÄ²éѯÌõ¼þ£¬Ð£ÑéÀïÃæµÄÀ¨ºÅ£¬·²ÊÇÓÒÀ¨ºÅÔÚ×óÀ¨ºÅÇ°Ãæ£¨²»Åä¶Ô£©µÄ£¬¶¼ÊÓΪ·Ç·¨Ìõ¼þ¡£
  d) ´«ÈëµÄ²éѯÌõ¼þ£¬Ç°ºó¼ÓÀ¨ºÅ¡£
¾­¹ýÒÔÉÏУÑ飬Ӧ¸Ã»ù±¾¿ÉÒÔ±£Ö¤²ÎÊýÊÇÕý³£µÄ²ÎÊý£¬¹©´ó¼Ò²Î¿¼¡£Í¬Ê±Ò²Ï£Íû´ó¼ÒÄÜÕÒ³öÆäÖеÄ©¶´£¬ÎÒ¿ÉÒÔ½øÐиĽø^_^


Ïà¹ØÎĵµ£º

½«accessµ¼ÈëSQL server

Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Dat ......

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Êý¾Ý¿â ......

Oracle ϵÁУºPL/SQL±í

 Oracle ϵÁУº PL/SQL±í
Ò»£¬Ê²Ã´ÊÇPL/SQL±í£¿
 Ê×ÏÈPL/SQL±íºÍ¼Ç¼(Record)Ò»Ñù£¬¶¼ÊǸ´ºÏÊý¾ÝÀàÐÍ¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£
 PL/SQL±íÓɶàÁе¥ÐеıêÁ¿¹¹³ÉµÄÁÙʱË÷Òý±í¶ÔÏó¡£×é³ÉÀàËÆÓÚһάÊý×é¡£
 Çø±ðºÍÁªÏµ¼Ç¼(Record)µÄµ¥ÐжàÁкÍÎïÀí´æ´¢Êý¾ÝµÄ±í¡£
 Record + PL/SQL± ......

SQL SERVER¶àÁÐÈ¡×î´ó»òÕß×îСֵ

/*
lvl1  lvl2    lvl3    lvl4    lvl
4      3      4      1       
3      2      2&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ