当前位置: 代码迷 >> 综合 >> Hibernate 原生SQL 与 (标量查询、字符串查询、实体查询)
  详细解决方案

Hibernate 原生SQL 与 (标量查询、字符串查询、实体查询)

热度:10   发布时间:2024-01-18 07:42:47.0

hibernate是支持sql语句查询的,他称之为原生sql,因为他的写法并不是纯sql......

 

 

解决Hibernate原生SQL映射问题
在问答里和论坛中,经常看到有人问,怎样将使用本地SQL查询出来的结果映射为值对象的问题,这里就Hibernate中提供的方法做个结论。前提,
这里没有使用属性的延迟加载技术。
假设有个值对像,如下:
Java代码
1. package test;     
2.     
3. public class Person {     
4.     private Long id;     
5.     private String name;     
6.     private Long age;     
7.     private Long phone;     
8.     private String address;     
9.     
10.     public Person(Long id, String name, Long age, Long phone, String address) {     
11.         this.id = id;     
12.         this.name = name;     
13.         this.age = age;     
14.         this.phone = phone;     
15.         this.address = address;     
16.     }     
17.     
18.     public Long getId() {     
19.         return id;     
20.     }     
21.     
22.     public void setId(Long id) {     
23.         this.id = id;     
24.     }     
25.     
26.     public String getName() {     
27.         return name;     
28.     }     
29.     
30.     public void setName(String name) {     
31.         this.name = name;     
32.     }     
33.     
34.     public Long getAge() {     
35.         return age;     
36.     }     
37.     
38.     public void setAge(Long age) {     
39.         this.age = age;     
40.     }     
41.     
42.     public Long getPhone() {     
43.         return phone;     
44.     }     
45.     
46.     public void setPhone(Long phone) {     
47.         this.phone = phone;     
48.     }     
49.     
50.     public String getAddress() {     
51.         return address;     
52.     }     
53.     
54.     public void setAddress(String address) {     
55.         this.address = address;     
56.     }     
57. }    
58.   
59. package test;  
60.   
61. public class Person {  
62.     private Long id;  
63.     private String name;  
64.     private Long age;  
65.     private Long phone;  
66.     private String address;  
67.   
68.     public Person(Long id, String name, Long age, Long phone, String address) {  
69.         this.id = id;  
70.         this.name = name;  
71.         this.age = age;  
72.         this.phone = phone;  
73.         this.address = address;  
74.     }  
75.   
76.     public Long getId() {  
77.         return id;  
78.     }  
79.   
  相关解决方案