关于In的使用

public List<Object> getDocByTypeId(List<String> listTypeId) {
  IDBOperator idb = new DBOperatorImpl();
  Object[] params = new Object[listTypeId.size()];
  String sAllTypeId = "";
  int i = 0;
  for (String typeId : listTypeId) {
   sAllTypeId += ",?";
   params[i] = Integer.parseInt(typeId);
   i++;
  }
  sAllTypeId = sAllTypeId.replaceFirst(",", "");
  String sql = "select * from document_manage t where t.file_type in ("
    + sAllTypeId + ")";
  ResultSet rs = idb.executeQuery(sql, params);
  List<Object> list = ObjectUtils.ResultSetToList(new DocForm(), rs);
  try {
   if (rs != null)
    rs.close();
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   idb.close();
  }
  return list;
 }