public List<WkTUser> findNameByTeacher(List<Teacher> telist) { StringBuffer queryString = new StringBuffer("from WkTUser as u where u.kuId in ("); for (int i = 0; i < telist.size(); i++) { Teacher tea = (Teacher) telist.get(i); queryString.append(tea.getKuId()); if (i < telist.size() - 1) { queryString.append(","); } } queryString.append(") order by u.kuName "); return getHibernateTemplate().find(queryString.toString()); }