select * from t_table where id in (*)

select * from t_table where id in (**,**,**);
------------>po
public class TWeekdetailToCreate
{

private List<String> ids;

private String userid;

private String projectName;

private String worktime;

private String extratime;

private String beginDate;

private String endDate;
}

---------------slqMap

<select id="getTWeekdetailToCreate" resultparameterprepend=" a.USERID in " open="(" close=")" conjunction=",">
#ids[]#
</iterate>
</isNotEmpty>
</dynamic>
and DATE &gt;= #beginDate# and DATE &lt;= #endDate#
group by b.projectName
    </select>