| 
 package com.kuaff.ejb3.di; 
  
import java.util.List; 
import java.util.ArrayList; 
import javax.ejb.Stateless; 
import javax.ejb.Resource; 
import javax.sql.*; 
  
import java.sql.*; 
  
@Stateless 
public class JmsUsersBean implements JmsUsers 
{ 
    @Resource(jndiName="java:/DefaultDS",resourceType="javax.sql.DataSource")  
    public DataSource customerDB; 
     
    public List<String> getUsers()  
    { 
        List<String> list = new ArrayList<String>(); 
        try 
        { 
            Connection conn = customerDB.getConnection(); 
            Statement st = conn.createStatement(); 
            ResultSet rs = st.executeQuery("select * from jms_users"); 
            while(rs.next()) 
            { 
                list.add(rs.getString("userid")); 
            } 
        } 
        catch(SQLException e) 
        { 
             
        } 
         
        return list; 
    } 
     
         
} 
   |