tomcat6.0Á¬½Ó³ØÁ¬½Óoracleʧ°Ü
ÎҵĻ·¾³
windows XP £¬tomcat6.0,java5.0.oracle9i
ÏÂÃæÊÇÎÒµÄÅäÖÃÎļþ
1.ÔÚD:\tomca6.0\conf\server.xml
ÎÒµÄÊý¾ÝÔ´ÅäÖÃÐÅÏ¢ÈçÏ£º
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"
username="randy" password="randy" maxActive="20" maxIdle="10"
maxWait="-1"/>
½«driverClassName »»Îª¡°oracle.jdbc.driver.OracleDriver¡±»¹ÊDZ¨Ò»ÑùµÄ´íÎó
2.ÔÚD:\tomca6.0\conf\context.xml
<ResourceLink
name="jdbc/myoracle"
type="javax.sql.DataSource"
global="jdbc/myoracle"
/>
3.web.xml
<resource-ref>
<description>Oracle Datasource example </description>
<res-ref-name>jdbc/myoracle </res-ref-name>
<res-type>javax.sql.DataSource </res-type>
<res-auth>Container </res-auth>
</resource-ref>
4.ÎҵIJâÊÔ³ÌÐò
public class DBPool {
private stat
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......