@sqlresultsetmapping

@NamedNativeQuery(name = "Schedules",
  query = "SELECT * FROM schedule_days WHERE employeeId = 8",
  resultSetMapping = "ScheduleResult")

Source: baeldung.com

@sqlresultsetmapping

@SqlResultSetMapping(
    name="ScheduleResult",
    classes={
      @ConstructorResult(
        targetClass=com.baeldung.sqlresultsetmapping.ScheduledDay.class,
        columns={
          @ColumnResult(name="id", type=Long.class),
          @ColumnResult(name="employeeId", type=Long.class),
          @ColumnResult(name="dayOfWeek")})})

Source: baeldung.com

Similar codes

0 vote184 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote185 views1 answer
Oracle db get table sizes
SQL
1 vote181 views1 answer
Substr sql last character
SQL
39 votes207 views5 answers
Sql drop column
SQL
16 votes176 views3 answers
Order by sql query
SQL
0 vote149 views2 answers
Jupyter notebook connect to database
SQL
0 vote225 views2 answers
Mysql update two tables at once
SQL
0 vote196 views1 answer
Many rows to 1 string mysql
SQL
0 vote203 views1 answer
Mysql dump for selected row
SQL
0 vote198 views1 answer
Template MySQL Zabbix agent
SQL