采用注解方式开发MyBatis无法完成数组List传参问题解决方案

采用<script>标签，之后转换成xml类似的格式即可：

@Select("<script>" +
			"SELECT app.* FROM " +
			"`cscp_application` app " +
			"LEFT OUTER JOIN `cscp_project_application` pro_app " +
			"ON app.id = pro_app.app_id " +
			"WHERE pro_app.project_id IN " +
			"<foreach item='item' index='index' collection='projectIds' open='(' separator=',' close=')'>" +
			"#{item}" +
			"</foreach>" +
			"</script>")
	@Results({ @Result(column = "app_id", property = "appId"),
			@Result(column = "app_name", property = "appName"),
			@Result(column = "app_desc", property = "appDesc"),
			@Result(column = "app_git_url", property = "appGitUrl"),
			@Result(column = "app_create_time", property = "appCreateTime"),
			@Result(column = "project_id", property = "projectId"),
			@Result(column = "project_name", property = "projectName"),
			@Result(column = "chart_type", property = "chartType"),
			@Result(column = "app_name2", property = "appName2"),
			@Result(column = "project_code", property = "projectCode") })
	List<ApplicationDTO> selectApplicationsByProjectIds(@Param("projectIds") List<Integer> projectIds);