Hi,I am having difficulties in retrieving data from database when i am using the LIKE clause in my sql statement.What I actually want is when the user enters a name in the search function,names that are similar to the user input will be retrieve out from the database.But unfortunately,I keep retrieving null.My code looks some thing like this.
I am using microsoft access for my database.

public class MemberDetails{

String name;

public MemberDetails(String name){
this.name = name;

public ArrayList<String> getMemberSearchResults() {
ArrayList<String> hi = new ArrayList<String>();
ResultSet rs = null;
DBController db = new DBController();
String dbQuery = "SELECT alumni_Name FROM AlumniMembers WHERE alumni_Name
LIKE '*" + name + "*'";
dbQuery += " Order by alumni_Name";
rs = db.readRequest(dbQuery);
try {
while (rs.next()) {
name = rs.getString("alumni_Name");
} catch (Exception e) {
return hi;

public static void main(String args[]) {
MemberDetails md = new MemberDetails("p");