81,095
社区成员
发帖
与我相关
我的任务
分享
<Resource name="jdbc/oraldb" auth="Container" type="javax.sql.DataSource"
axActive="100" maxIdle="30" maxWait="10000" username="scott" password="tiger"
riverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"/>
<resource-ref>
<res-ref-name>jdbc/oraldb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
public Connection getConnection(){
try{
Context cxt=new InitialContext();
DataSource ds=(DataSource)cxt.lookup("java:comp/env/jdbc/oraldb");
conn=ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
} catch (NamingException e) {
e.printStackTrace();
}
return conn;
}
Connection conn=DBHelper.getInstance().getConnection();
System.out.println(conn);