Hi,
have a query like this:
PreparedStatement stmt = con.prepareStatement("SELECT
donor_last_name,donor_middle_name,donor_first_name,donor_height,donor_sex,donor_race,donor_dob,donor_ssn from PCMSP_DONOR where donor_last_name like '?*' "
;
stmt.setString(1,l_name);
rs=stmt.executeQuery();
if(rs.next()){
out.println(rs.getString("donor_last_name");
}
How can I join the placeholder and '*' operator in a like search?
have a query like this:
PreparedStatement stmt = con.prepareStatement("SELECT
donor_last_name,donor_middle_name,donor_first_name,donor_height,donor_sex,donor_race,donor_dob,donor_ssn from PCMSP_DONOR where donor_last_name like '?*' "
;stmt.setString(1,l_name);
rs=stmt.executeQuery();
if(rs.next()){
out.println(rs.getString("donor_last_name"
);}
How can I join the placeholder and '*' operator in a like search?