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;
}
}
|