天天看点

websphere服务器,如何使用jndi数据源

 <% 

Hashtable<String,String> hashTable = new  Hashtable<String,String>();

hashTable.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.Websphere.naming.WsnInitialContextFactory");

Context context = new InitialContext(hashTable);

//这里需要和数据源配置中的jndi名对应上

DataSource dataSource = (DataSource)context.lookup("jdbc/test_jndi");

Connection connection = dataSource.getConnection();

Statement statement = connection.createStatement();

String sql = "select * from users";

ResultSet resultSet = statement.executeQuery(sql);

while(resultSet.next()){

    System.out.println("userName-->"+ resultSet.getString("userName"));

}

%>