今日工作:今日完成Hibernate的一些练习,看了 一些Hibernate的书籍,理解一些细节。
问题:使用hql查询的时候出现类型转换错误
String hql = "SELECT new Product(p.id, p.name) from Product p";
查出来是java.lang.Object,导致类型转换异常。
解决办法:
Hibernate 使用查询部分字段,有三种字现方式:
第一种是使用高级查询DetachedCriteria实现,代码如下:
String alias = "user_"; //查詢時的table別名
DetachedCriteria dc = DetachedCriteria.forClass(User.class,alias);
ProjectionList pList = Projections.projectionList();
pList.add(Projections.property(alias + "." + "id").as("id"));
pList.add(Projections.property(alias + "." + "name").as("name"));
pList.add(Projections.property(alias + "." + "age").as("age"));
pList.add(Projections.property(alias + "." + "sex").as("sex"));
dc.setProjection(pList);
dc.setResultTransformer(Transformers.aliasToBean(User.class));
resultList = memberService.findByDetached(dc).size();
第二种方式是通过HQL语句new POJO()实现,方法如下:
实体类:
package com.my.model;
/**
* 产品实体类
*/
public class Product {
private Integer id;
private String name;
private Float price;
private String address;
public Product() {
super();
}
// HQL 部分字段查询,需要使用构造函数(必须)
// 使用 String hql = "SELECT new Product(p.id, p.name) from Product p"查询;
public Product(Integer id, String name) {
super();
this.id = id;
this.name = name;
}
public Product(String name, Float price, String address) {
super();
this.name = name;
this.price = price;
this.address = address;
}
public Product(Integer id, String name, Float price, String address) {
super();
this.id = id;
this.name = name;
this.price = price;
this.address = address;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Float getPrice() {
return price;
}
public void setPrice(Float price) {
this.price = price;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "Product [id=" + id + ", name=" + name + ", price=" + price + ", address=" + address + "]";
}
}
查询代码:
/*
* 直接使用查询的代码
* 使用的hql
*/
@Test
public void testQuery() {
Session session = sessionFactory.openSession();
Transaction trans = session.beginTransaction();
String hql = "SELECT new Product(p.id, p.name) from Product p";
List<Product> list= session.createQuery(hql).list();
for(Product p:list){
System.out.println(p);
}
trans.commit();
session.close();
}
第三种方式是通过HQL语句实现,类似SQL,方法如下:
String hql = "select id,name from Product";
Query query = session.createQuery(hql);
//默认查询出来的list里存放的是一个Object数组,还需要转换成对应的javaBean。
List<Object[]> links = query.list();
for(Object[] link : links){
String id = link[0];
String name = link[1];
System.out.println(id + " : " + name);
}
明日计划:明日计划完成Hibernate的注解配置,学习几种实体之间的关系映射。