windowsÖÐÔõÑùÓÃoracleÇý¶¯Á¬Êý¾Ý¿â
ÈçÌ⣬ÔõÑùÁ¬£¬ÐèÒªÏÂÔØÊ²Ã´Çý¶¯Âð£¬Çë¸øÎÒ¸öÏêϸµÄ²½Ö裬лл
Á¬½Ó¹ýsqlserver»òmysql°É£¬Ö»Òª°ÑÇý¶¯°ü»»Ò»Ï¾ͿÉÒÔÁË¡£
²»¹ÜÊÇLINUX»¹ÊÇWINDOWS£¬Á¬Êý¾Ý¿âµÄ·½·¨ÊÇÒ»ÑùµÄ¡£±¾È˽¨ÒéÄãÏÈBAIDUһϣ¬Éϱß˵µÄÄǸö²Å½ÐͼÎIJ¢Ã²
ÏÂÔØclass12.jar¼´¿É£¬Á¬½Ó´úÂëÉÏÍøÏ¸ö
Õâ¸öÖ÷Òª¿´ÄãÓÃʲôÓïÑÔÈ¥Á¬½ÓÁË£¿
ÿÖÖÓïÑÔ¶¼»áÓжÔÓ¦µÄÇý¶¯°ü£¬Â¥Ö÷¿ÉÒÔÈ¥¹Ù·½ÏÂÔØ¡£
ÄãÊÇÏëÓÃoracleÁª½ÓÊý¾Ý¿âÂ𣿠oracleÓÐºÜ¶à°æ±¾¡£ÏÖÔÚÒ»°ãÓÃoracle9iÊý¾Ý¿â.
Èç¹ûÁª½Óoracle9iµÄ»°£¬ÄãÒªÈ¥ÍøÉÏÏÂÔØÒ»¸öoracle9iµÄÇý¶¯°ü¡£²»ÏÂÔØµÄ»°ÔÚoracle9iµÄ°²×°Ä¿Â¼ÏÂÃæÓÐÒ»¸ö×Ô´øµÄclass12.jar°ü¡£Õâ¸ö¾ÍÊÇÇý¶¯°üÁË.ÄãÒ²¿ÉÒÔÓÃ×Ô´øµÄ°ü
Èç¹ûÓÃoracle10gµÄ»°¾ÍÈ¥ÍøÉÏÏÂÔØÒ»¸öÇý¶¯°ü£¬ÕâÊǰüµÄÎÊÌâ
Áª½ÓÊý¾Ý¿âµÄ»°¾ÍЩ´úÂë°É.
ÕÒµ½ÏàÓ¦°æ±¾µÄÇý¶¯°ü,È»ºóµ¼Èë¾ÍÐÐÁË
google
Äã¿ÉÒÔµ½ Oracle µÄ¹Ù·½ÍøÕ¾ÉÏÏÂÔØ×îÐ嵀 JDBC Çý¶¯³ÌÐò£¬ÏÂÔØÇ°ÐèҪע²áΪ OTN µÄÓû§¡£
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
ÏñÏÖÔÚ×îеİ汾Ϊ 11.0.2.0 °æ±¾£¬Èç¹û Java °æ±¾ÊÇ JDK 5 µÄ»°£¬¿ÉÒÔÏÂÔØ ojdbc5.jar£¬Èç¹ûÊÇ JDK 6 µÄ»°¿ÉÒÔÏÂÔØ ojdc6.jar
ÐèҪ˵Ã÷һϵÄÊÇ£¬²»ÒªÒÔΪ 11.0.2.0 µÄ JDBC Çý¶¯Ö»ÄÜÁ¬½Ó Oracle 11.0.2.0 µÄÊý¾Ý¿â£¬¸ù¾Ý Oracle JDBC µÄ¼æÈÝÐÔÁÐ±í£ºhttp://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#02_02 ÌṩµÄÐÅÏ¢£¬9.2.0 µÄ JDBC Çý¶¯Ò²ÄÜÁ¬½Ó Oracle 11.0.2.0 µÄÇý¶¯¡£
ËäÈ»ÊÇÕâÑù£¬µ«»¹Êǽ¨ÒéÏÂÔØ×îÐ嵀 JDBC Çý¶¯¡£±ÈÈçÎÒÔÚʹÓà Oracle 10.2.0.3 Êý¾Ý¿â£¬Ê¹ÓÃÆä°²×°Ê±ÌṩµÄ ojdbc4.jar Çý¶¯£¬ÔÚʹÓà JSTL µÄ sql ±êÇ©»ñÈ¡´
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
score±í
scoreid course studentid score
1 Êýѧ 2 99
2 Êýѧ 3 60
3 Êýѧ 4 80
4 ÓïÎÄ 5 79
5 ÓïÎÄ 6 58
6 ÓïÎÄ 1 66
7 Ó¢Óï 6 76
8 Ó¢Óï 4 87
9 Ó¢Óï 3 100
10Ó¢Óï 2 69
ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......