myeclipse jndi oracle,MyEclipse+WebSphere 通过 JNDI 连接 Sybase 简介

/*该代码借用了

moyunhe文章中的TestPool类,详细内容请见该文参考*/

/*

* 创建日期 2005-11-5

*

* 更改所生成文件模板为

* 窗口 > 首选项 > Java > 代码生成 > 代码和注释

*/

package

test.pool;

import

java.sql.Connection;

import

java.sql.ResultSet;

import

java.sql.SQLException;

import

java.sql.Statement;

import

javax.naming.Context;

import

javax.naming.InitialContext;

import

javax.naming.NamingException;

import

javax.sql.DataSource;

/**

*

@author

moyunhe

*

* 更改所生成类型注释的模板为

* 窗口 > 首选项 > Java > 代码生成 > 代码和注释

*/

public

class

TestPool {

private

static

Connection getConnection(String strConnPoolJndi)

throws

NamingException, SQLException  {

Context ctx

=

null

;

ctx

=

new

InitialContext();

DataSource ds

=

(DataSource)ctx.lookup(strConnPoolJndi);

Connection conn

=

ds.getConnection();

return

conn;

}

public

static

String getDBData(String strConnPoolJndi, String sql) {

String strReturn

=

""

;

Connection conn

=

null

;

Statement st

=

null

;

ResultSet rs

=

null

;

try

{

conn

=

getConnection(strConnPoolJndi);

st

=

conn.createStatement();

st.executeUpdate(

"

delete test

"

);

st.executeUpdate(

"

insert test(name) values('

"

+

sql

+

"

')

"

);

rs

=

st.executeQuery(

"

select name from test

"

);

if

(rs.next()) {

strReturn

=

rs.getString(

1

);

}

}

catch

(Exception e) {

e.printStackTrace();

strReturn

=

e.getMessage();

}

finally

{

try

{

if

(st

!=

null

) {

st.close();

st

=

null

;

}

if

(rs

!=

null

) {

rs.close();

rs

=

null

;

}

if

(conn

!=

null

) {

conn.close();

conn

=

null

;

}

}

catch

(SQLException e) {

e.printStackTrace();

}

}

return

strReturn;

}

}