ÈçºÎ·ÀÖ¹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) ´«ÈëµÄ²éѯÌõ¼þ£¬Ç°ºó¼ÓÀ¨ºÅ¡£
¾¹ýÒÔÉÏУÑ飬Ӧ¸Ã»ù±¾¿ÉÒÔ±£Ö¤²ÎÊýÊÇÕý³£µÄ²ÎÊý£¬¹©´ó¼Ò²Î¿¼¡£Í¬Ê±Ò²Ï£Íû´ó¼ÒÄÜÕÒ³öÆäÖеÄ©¶´£¬ÎÒ¿ÉÒÔ½øÐиĽø^_^
Ïà¹ØÎĵµ£º
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Dat ......
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±í
Ò»£¬Ê²Ã´ÊÇPL/SQL±í£¿
Ê×ÏÈPL/SQL±íºÍ¼Ç¼(Record)Ò»Ñù£¬¶¼ÊǸ´ºÏÊý¾ÝÀàÐÍ¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£
PL/SQL±íÓɶàÁе¥ÐеıêÁ¿¹¹³ÉµÄÁÙʱË÷Òý±í¶ÔÏó¡£×é³ÉÀàËÆÓÚһάÊý×é¡£
Çø±ðºÍÁªÏµ¼Ç¼(Record)µÄµ¥ÐжàÁкÍÎïÀí´æ´¢Êý¾ÝµÄ±í¡£
Record + PL/SQL± ......
/*
lvl1 lvl2 lvl3 lvl4 lvl
4 3 4 1
3 2 2&nb ......