I want to get the value of the result in query.

This is my query / repository file:

@Query("select p.name, p.contact_no, p.email_address, p.time_submitted, p.date,java,spring,list,spring-boot,classcastexception"/>
	














    

		

        

            
            时间戳
        

		

		

        
		

    
















	
首页  > 解决方案 > 提取列表 result from query in Java / Spring Boot

I want to get the value of the result in query.


This is my query / repository file:


@Query("select p.name, p.contact_no, p.email_address, p.time_submitted, p.date












java - 提取列表 result from query in Java / Spring Boot

I want to get the value of the result in query.


This is my query / repository file:


@Query("select p.name, p.contact_no, p.email_address, p.time_submitted, p.date





问题描述



I want to get the value of the result in query.


This is my query / repository file:


@Query("select p.name, p.contact_no, p.email_address, p.time_submitted, p.date_due from Application p where p.application_number like ?1")
List<Application> getApplicationSummaryInfo(String application_number);



Service:


public List<Application> getApplicationSummaryInfo(String application_number);



ServiceImpl:


@Override
public List<Application> getApplicationSummaryInfo(String application_number) {
    return (List<Application>)applicationRepository.getApplicationSummaryInfo(application_number);
}



Controller:


List<Application> app_info = applicationService.getApplicationSummaryInfo(application_no);



I only know how to access this in jsp file using foreach. But I want to access the fields in my controller file.


I tried doing this:


List<Application> app_info = applicationService.getApplicationSummaryInfo(application_no);
System.out.println(app_info.get(0));



and I get this result:


[Ljava.lang.Object;@28bf8e6e



then I tried getting the exact "name" field value


List<Application> app_info = applicationService.getApplicationSummaryInfo(application_no);
System.out.println(app_info.get(0).getName());



but I get this error


java.lang.ClassCastException: class [Ljava.lang.Object; cannot be cast to class com.pckg_name.model.Application ([Ljava.lang.Object; is in module java.base of loader 'bootstrap'; com.rtc_insurance.model.Application is in unnamed module of loader 'app')



really hope you could help me. Thank you!









This is one of the very few (if not the only) usecase for an explicit Deny with a NotPrincipal:


{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Deny",
      "NotPrincipal": {
        "AWS": "arn:aws:iam::<your-account-number>:root"
      },
      "Action": "s3:*",
      "Resource": [
        "arn:aws:s3:::ih-deploy-bucket/*",
        "arn:aws:s3:::ih-deploy-bucket"
      ]
    }
  ]
}



This will explicitly deny all principals that are not (and not only) the root account user, including IAM users, assumed role sessions and federated users in that account.
And since the root user always has explicit Allows for all actions on all resources, an actual Allow is given by the root user's identity-based permissions, so the root user will have access to that bucket.


The reason why this works is that a caller identity working in your account has always multiple principals simultaneously, which are being evaluated by IAM for a policy statement:


    

  1. the account principal arn:aws:iam::<your-account-number>:root
    2. 

  2. the user, assumed role or federated user principal
    3. 



In the case of an explicit Allow if you only used the root account principal in a Principal rule in a policy statement, then any user in that account will match the allow and will be given access, since the account principal is always part of a user's principal list in that account.


However, in the case of a Deny with a NotPrincipal, things are a bit different. Here, the list of NotPrincipals must whitelist all principals of the caller's identity to be not denied.


This fact somewhat shines through in the AWS documentation about NotPrincipal: https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_policies_elements_notprincipal.html




When you use NotPrincipal with Deny, you must also specify the account
ARN of the not-denied principal. Otherwise, the policy might deny
access to the entire account containing the principal. Depending on
the service that you include in your policy, AWS might validate the
account first and then the user. If an assumed-role user (someone who
is using a role) is being evaluated, AWS might validate the account
first, then the role, and then the assumed-role user.




标签： javaspringlistspring-bootclasscastexception


解决方案









可能这会对你有所帮助。


    

  1. 使用 sql.xml 中提到的字段创建构造函数。(name,contact_no, email_address,time_submitted,date_due)在应用程序类中。
    2. 

  2. 在查询中指定它，例如“从应用程序 p 中选择新的应用程序（名称、联系人编号、电子邮件地址、时间提交、日期到期），其中 p.application_number 像？1”。
    3. 

  3. 您将以 Application 对象的形式获得结果，以便您可以访问该对象的字段。
    4. 











推荐阅读