jdbc连接池java

jdbc连接池java

我需要在作为会话bean实现的 Java Web服务中建立数据库连接,我不确定我是否做得对.

我创建了一个类

public final class SQLUtils {

//.....

private static DataSource m_ds=null;

static

{

try

{

InitialContext ic = new InitialContext();

m_ds = (DataSource) ic.lookup(dbName); //Connection pool and jdbc resource previously created in Glassfish , dbName contains the proper JNDI resource name

}

catch (Exception e)

{

e.printStackTrace();

m_ds = null;

}

}

public static Connection getSQLConnection() throws SQLException

{

return Connection();

}

}

每当我需要连接时,我都会这样做

Connection cn = null;

try

{

cn = SQLConnection();

// use connection

}

finally

{

if (null != cn)

{

try

{

cn.close();

}

catch (SQLException e)

{

}

}

}

以这种方式使用它是否可以,或者我DataSource必须是bean的成员？

@Stateless

@WebService

public class TestBean {

private @Resource(name=dbName) DataSource m_ds;

}

如果这是一个nube问题,我很抱歉,但我对Java很新.提前致谢.