Hi,

Following code examples can be used:

PreparedStatement  pstmt = 
    conn.prepareStatement("select id from keyworduniquetable  where keyword=?"); 
pstmt.setString(1, keyword); 
ResultSet rstSelect = pstmt.executeQuery();

while(rstSelect.next()) {


}
rstSelect.close();
pstmt.close();

Thanks