JAVAÁ¬½ÓÊý¾Ý¿â Oracle
±¾ÎÄÊ×ÏȽéÉÜjavaÁ¬½ÓoracleҪעÒâµÄ¼¸µã£¬È»ºó½éÉܼ¸ÖÖ³£ÓõÄÁ¬½Ó·½Ê½¡£
Ò»¡¢¼¸µã×¢Ò⣺
1¡¢ÔÚ¿Í»§¶ËÈí¼þ¿ª·¢ÖÐʹÓÃThinÇý¶¯³ÌÐò
ÔÚ¿ª·¢JavaÈí¼þ·½Ã棬OracleµÄÊý¾Ý¿âÌṩÁËËÄÖÖÀàÐ͵ÄÇý¶¯³ÌÐò£¬¶þÖÖÓÃÓÚÓ¦ÓÃÈí¼þ¡¢applets¡¢servletsµÈ¿Í»§¶ËÈí¼þ£¬ÁíÍâ¶þÖÖÓÃÓÚÊý¾Ý¿âÖеÄJava´æ´¢¹ý³ÌµÈ·þÎñÆ÷¶ËÈí¼þ¡£ÔÚ¿Í»§»ú¶ËÈí¼þµÄ¿ª·¢ÖУ¬ÎÒÃÇ¿ÉÒÔÑ¡ÔñOCIÇý¶¯³ÌÐò»òThinÇý¶¯³ÌÐò¡£OCIÇý¶¯³ÌÐòÀûÓÃJava±¾µØ»¯½Ó¿Ú£¨JNI£©£¬Í¨¹ýOracle¿Í»§¶ËÈí¼þÓëÊý¾Ý¿â½øÐÐͨѶ¡£ThinÇý¶¯³ÌÐòÊÇ´¿JavaÇý¶¯³ÌÐò£¬ËüÖ±½ÓÓëÊý¾Ý¿â½øÐÐͨѶ¡£½¨ÒéʹÓÃThinÇý¶¯³ÌÐò£¬ÒòΪͨ¹ý¶à´Î²âÊÔ·¢ÏÖ£¬ÔÚͨ³£Çé¿öÏ£¬ThinÇý¶¯³ÌÐòµÄÐÔÄܶ¼³¬¹ýÁËOCIÇý¶¯³ÌÐò¡£
2¡¢¹Ø±Õ×Ô¶¯Ìá½»¹¦ÄÜ£¬Ìá¸ßϵͳÐÔÄÜ
ÔÚµÚÒ»´Î½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Óʱ£¬ÔÚȱʡÇé¿öÏ£¬Á¬½ÓÊÇÔÚ×Ô¶¯Ìύģʽϵġ£ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬¿ÉÒÔͨ¹ýconn.setAutoCommit(false)¹Ø±Õ×Ô¶¯Ìá½»¹¦ÄÜ¡£Ò»µ©¹Ø±ÕÁË×Ô¶¯Ìá½»¹¦ÄÜ£¬ÎÒÃǾÍÐèҪͨ¹ýµ÷ÓÃConnectionÀàµÄcommit()ºÍrollback()·½·¨À´È˹¤µÄ·½Ê½¶ÔÊÂÎñ½øÐйÜÀí¡£
3¡¢¼¸ÖÖ²Ù×÷sqlµÄ¶ÔÏó£ºStatement,PreparedStatement,CallableStatement
Statement¶ÔÏó£ºÃ¿´ÎÖ´ÐÐsql£¬Êý¾Ý¿â¶¼Òª¶Ô¸Ãsql±àÒ룬¶ÔÓÚ½öÖ´ÐÐÒ»´Î²Ù×÷²¢·µ»Ø½á¹ûµÄÇéÐΣ¬Ð§ÂʸßÓÚPreparedStatement
ʹÓ÷½Ê½£º
Statement stmt =null;
ResultSet rs = stmt.executeQuery(sql); //²éѯ
int result = stmt.executeQuery(sql); //Ð޸ġ¢É¾³ý¡¢²åÈë
PreparedStatement¶ÔÏó£ºÔ¤±àÒëµÄ£¬¶ÔÓÚ¾³£»áÖظ´Ö´ÐÐÏàͬµÄSQLÓï¾ä£¬½¨ÒéʹÓ᣶ÔÓÚÅúÁ¿´¦ÀíËü¿ÉÒÔ´ó´óÌá¸ßЧÂÊ. Òò´ËËüÒ²½ÐJDBC´æ´¢¹ý³Ì¡£
ʹÓ÷½Ê½£º
²éѯ£ºÊÊÓÃÓÚ¶à´ÎÖظ´²éѯÀàËƵÄsqlÓï¾ä
PreparedStatemen
Ïà¹ØÎĵµ£º
JAVAÄÚ²¿Åàѵ×ÊÁÏ
Ò»¡¢JAVA»ù´¡ÅàѵϵÁÐ
1.ËïöÎJAVA¸ß¼¶Èí¼þ¹¤³Ìʦ°àÅàѵ¼Ïñ£¨2DVD£©
¼ò½é£º¹âÅÌÓÉËïöÎÀÏʦÇ××ÔÊڿμÖÆ¡£ÑÐò½¥½ø¡¢Í¨Ë×Ò׶®¡¢ÊµÕ½ÐÔÇ¿¡¢ÄÚÈÝÈ«Ãæ¡¢½²½âÉî¿Ì¡¢ÎÊ´ðÐÎʽÊDZ¾Ì×Åàѵ¼ÏñµÄÌØÉ«¡£Ñ§Ô±Í¨¹ý±¾Ì×¹âÅ̵Äѧϰ£¬Äܹ»¿ì
ËÙÕÆÎÕJava±à³ÌÓïÑÔ£¬³ÉΪJava¸ßÊÖ¡£
2.´«ÖDz¥¿Í ......
×¢Òâ,Óõ½ÁËÄÚ²¿Àà:
new Thread
(
new Runnable()
{
public void run()
{
try
&n ......
http://www.cn-java.com/www1/?action-viewnews-itemid-3295
ÎÒÏë£Ê£Á£Ö£ÁµÄ°®ºÃÕߣ¬ÓÈÆäÊdzõѧÕß´ó¶¼ÓйýÕâÑùµÄ¾Àú£¬¾ÍÊÇϲ»¶£Ê£Á£Ö£Á±à³ÌÓïÑÔ£¨Õâ¸öÈ˵ÄÇé¿ö¿ÉÄܲ»Ò»Ñù£©£¬µ«ÊÇÓÐʱºò×Ü»á¾õµÃJAVAµÄÓŵã±ãÊÇËýµÄ“ÖÂÃü”µÄȱµã¡£´ó¼ÒµÄÐÅÄîÒÀ¾ÉÊÇ“Ò»´Î±àÒ룬µ½´¦ÔËÐДµ«ÊǾÍÊÇÒòΪÖÁÒ»µã£Ê£Á£Ö£Á ......
http://www.cn-java.com/www1/?action-viewnews-itemid-3295
ÎÒÏë£Ê£Á£Ö£ÁµÄ°®ºÃÕߣ¬ÓÈÆäÊdzõѧÕß´ó¶¼ÓйýÕâÑùµÄ¾Àú£¬¾ÍÊÇϲ»¶£Ê£Á£Ö£Á±à³ÌÓïÑÔ£¨Õâ¸öÈ˵ÄÇé¿ö¿ÉÄܲ»Ò»Ñù£©£¬µ«ÊÇÓÐʱºò×Ü»á¾õµÃJAVAµÄÓŵã±ãÊÇËýµÄ“ÖÂÃü”µÄȱµã¡£´ó¼ÒµÄÐÅÄîÒÀ¾ÉÊÇ“Ò»´Î±àÒ룬µ½´¦ÔËÐДµ«ÊǾÍÊÇÒòΪÖÁÒ»µã£Ê£Á£Ö£Á ......
//1.JavaÖÐ×Ö·û´®²»ÄܶàÐÐÊéд¡£¶àÐÐÊéдÓÃÒýºÅ¸ô¶Ï£¬¼ÓºÅÏàÁ¬¡£
//2.JavaµÄ±êʶ·û¿ÉÒÔÓÃÃÀÔª·ûºÅ¿ªÍ·¡£
//3.JavaÖÐûÓÐÎÞ·ûºÅ±äÁ¿»òÎÞ·ûºÅ³£Á¿µÄ¸ÅÄî¡£ËùÓеıäÁ¿¶¼ÊÇÓзûºÅµÄ¡£
//4.JavaÖбäÁ¿µÄ×Ö³¤Êǹ̶¨µÄ¡£²»´æÔÚcharºÍwcharÖ®·Ö¡£
//5.JavaÖбäÁ¿Î ......