ÓÃSSH¿ò¼ÜÕûºÏOracleÊý¾Ý¿âʱ³ö´íÔõô°ì
ÓÃSSH¿ò¼ÜÕûºÏOracleÊý¾Ý¿âʱÈç¹ûÏȼÓSpring¿ò¼Ü£¬ÏȼÓSpring ÔÙ¼Ó Hibernate È»ºóÅäÖÃOracle Êý¾Ý¿â»á³ö´í
Èç¹ûÏÈÓÃHibernateÔÙ¼ÓSpring²»±¨´íµ«µÃ×Ô¼ºÊÖ¶¯ÅäÖÃSessionfactory
ÇëÎÊÓа취ÏÈÓÃSpring+Hibernate+Oracle ²»±¨´íµÄ·½·¨Ã»£¿
·¹ý¡£¡£¡£¡£
Æ®¹ý
Ŷ£¬ÓõÄÊÇMyEclipse6.5µÄ£¬7.0Ì«¿¨£¬àÅ£¬¿ÉÒÔÈ¥ÊÔһϠÊDZ¨Ò»¸ö°æ±¾µÄÎÊÌâ
Æäʵ±¨´íÄãÓ¦¸Ã¸Ðµ½¸ßÐË¡£ÄãÓÖ¿ÉÒÔѧµã¶«Î÷ÁË¡£
Óëµ½´íÎó²»Òª»Å¡£ÂýÂýµÄ·ÖÎö£¬ÕÒµ½ÎÊÌâ³öÔںδ¦¡£È»ºó½â¾öËû¡£
Mark£¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
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
ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......