jspÁ¬½Óoracle 10gÎÊÌâ

tomcat6µÄÊÇ
ÔÚconfϵÄcontent.xmlÀï¼ÓÈëÁË
<Resource
      name="jdbc/bzydb"
      type="javax.sql.DataSource"
      password="abc123"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      maxIdle="5"
      maxWait="5000"
      username="bzy"
      url="jdbc:oracle:thin:@localhost:1521:db3cn"
      maxActive="20"/>

ÏÖÔÚÏ뽨Á¢Ò»¸öÀࣺ
package dataoper;
import java.sql.Connection;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Conn {
public static Connection conn=null;
public static Connection f_conn()
{
Context initCtx=new InitialContext();    //  ´íÎó´¦1
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/bzydb"); //´íÎó´¦2
Connection conn=ds.getConnection(); //´íÎó´¦3
return conn;
}
}

´íÎó´¦123  Óдí
¶øÕâÈýÐдúÂëдÔÚjspµÄÒ³ÃæÖÐʱ£¬¾ÍûÓдíÎó
¸Õ¿ªÊ¼×öjava¡£
ÒԺ󻹶à¹ØÕÕ£¡

---

ÏëÓÃÅäÖÃÎļþÒ²¿ÉÒÔ¶¯Ì¬µÄ¹