Spring JDBC 的 sql 语句中 in 语句的使用方法 原

public List<String> getPermissionByRole(Set<String> roles) {
	NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);
	String sql = "select permission from roles_permissions where role_name in (:roleNameList)";
	MapSqlParameterSource parameterSource = new MapSqlParameterSource();
	parameterSource.addValue("roleNameList", new ArrayList<>(roles));
	List<String> permissionList = namedParameterJdbcTemplate.queryForList(sql, parameterSource, String.class);
	return permissionList;
}