C#ÓëORACLE³ÌÐòÎÊÌâ(ÔÚÏßµÈ)¡£
StringBuilder yzb3 = new StringBuilder();
yzb2.Append("select count(device) as j from temp_a ");
DbHelperSQL.ExecuteSimpleSql(yzb3.ToString());
ÎÒÏë°Ñj×÷Ϊ±äÁ¿ÔÚ³ÌÐòÖÐʹÓá£Ó¦¸ÃÔõô×ö¡£
ÐèÇóûÓÐ˵Ã÷Çå³þ£¬jÊÇÒª¶¯Ì¬´«È룿»¹ÊÇÆäËüÒâ˼
ÄãµÃÔÚ³ÌÐòÖж¨ÒåÒ»¸öDATASET½ÓÊÕ·µ»ØµÄ½á¹û¼¯ºÍ,È»ºó¾Í¿ÉÒÔ°ÑDATASETÀïµÄJ×ֶθ³Öµ¸øÄãµÄ³ÌÐò±äÁ¿,ÕâÑù¿ÉÒÔʹÓÃÁË
ÄãµÃÔÚ³ÌÐòÖж¨ÒåÒ»¸öDATASET½ÓÊÕ·µ»ØµÄ½á¹û¼¯ºÍ,È»ºó¾Í¿ÉÒÔ°ÑDATASETÀïµÄJ×ֶθ³Öµ¸øÄãµÄ³ÌÐò±äÁ¿,ÕâÑù¿ÉÒÔʹÓÃÁË
Õý½â
лл´ó¼Ò¡£ÎÒ×Ô¼º´ÓͼÊé¹Ý½èÁ˱¾ÊéÀ´¿´¡£ÆäʵÕâ¸ö¶«Î÷ÿ¸öÈ˶¼ÓÐÿ¸öÈ˵Äʵ¼ÊÇé¿ö£¬Ïë·¨²»Ò»Ñù£¬Ë¼Â·¾Í²»Ò»Ñù¡£ÎÒ½áÌùÁË¡£Ð»Ð»´ó¼Ò¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......