hibernate 一对多 hql语句问题 我好像不觉得hql里有select关键字。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 hql = " from Userfile as uf where uf.users.userName = '"+username+"'" 二楼 你给的hql我早就试过了 还是执行不了报错could not resolve property: Users of: com.ky.hibernatemapping.Userfile [from com.ky.hibernatemapping.Userfile as uf where uf.Users.userName=bbb] 这个报错是说你的Userfile类中没有对应users的映射,请去检查这个Userfile映射类 映射了 这就是Userfile类 public class Userfile implements java.io.Serializable { private UserfileId id; private Users users; } Userfile.hbm.xml <hibernate-mapping> <class name="com.ky.hibernatemapping.Users" table="users" catalog="kydata"> <id name="userName" type="string"> <column name="user_name" length="60" /> <generator class="native" /> </id> <many-to-one name="kydb" class="com.ky.hibernatemapping.Kydb" fetch="select"> <column name="dtuid" length="100" not-null="true" /> </many-to-one> <property name="userPwd" type="string"> <column name="user_pwd" length="15" not-null="true" /> </property> <property name="userGrade" type="integer"> <column name="user_grade" /> </property> </class></hibernate-mapping> 试一下 hql = " from Userfile as uf where uf.users= '"+username+"'" tryhql = " from Userfile as uf where id.users.userName = '"+username+"'" ("from Userfile where users.userName = ?", new Object[] { username })2楼hql没问题的你的配置文件有问题,用什么复合主键啊主键采用一个与业务无关的int或者long字段 让楼主给搞糊涂了public class UserfileId implements java.io.Serializable { private Integer fileindex; private Users users; private String filedir; } Userfile.java public class Userfile implements java.io.Serializable { private UserfileId id; private Users users; } UserfileId 里有users了,为什么Userfile 还要定义一个users?try hql = " from Userfile as uf where id.users= '"+username+"'" 直接执行不了修改了一下String hql = " from Userfile as uf where uf.id.users.userName = '"+username+"'";就可以了 谢谢啊 我还有一个不明白的就是为什么hibernate会自动生成UserfileId对象啊???帮忙解释一下 ..也谢谢大家啊 来者有分 [spring]怎么在给一个对象注入另一个对象时指定后者的构造方法,并传参? spring的aop应用出问题 jsp页面如何控制线程? 学了点java反射,模范mvc框架,写了一个小应用。 了解一下大家平时怎么客户交流并且追踪问题的 使用JDOM时的问题 JAVA中的引用问题! 关于在线付款的的问题?在线等待! 高手请进,肯定给分_在线等 ejb设计的问题 请大家协助解决一个搞笑的问题--在SSH开发中出现了org.springframework.beans.factory.BeanCreationException异常,请大家帮忙分析下!!! 关于文件的相对位置?
你给的hql我早就试过了 还是执行不了
报错could not resolve property: Users of: com.ky.hibernatemapping.Userfile [from com.ky.hibernatemapping.Userfile as uf where uf.Users.userName=bbb]
这就是Userfile类
public class Userfile implements java.io.Serializable {
private UserfileId id;
private Users users;
} Userfile.hbm.xml
<hibernate-mapping>
<class name="com.ky.hibernatemapping.Users" table="users" catalog="kydata">
<id name="userName" type="string">
<column name="user_name" length="60" />
<generator class="native" />
</id>
<many-to-one name="kydb" class="com.ky.hibernatemapping.Kydb" fetch="select">
<column name="dtuid" length="100" not-null="true" />
</many-to-one>
<property name="userPwd" type="string">
<column name="user_pwd" length="15" not-null="true" />
</property>
<property name="userGrade" type="integer">
<column name="user_grade" />
</property>
</class>
</hibernate-mapping>
hql = " from Userfile as uf where uf.users= '"+username+"'"
hql = " from Userfile as uf where id.users.userName = '"+username+"'"
2楼hql没问题的你的配置文件有问题,用什么复合主键啊
主键采用一个与业务无关的int或者long字段
private Integer fileindex;
private Users users;
private String filedir;
} Userfile.java
public class Userfile implements java.io.Serializable {
private UserfileId id;
private Users users;
}
UserfileId 里有users了,为什么Userfile 还要定义一个users?try
hql = " from Userfile as uf where id.users= '"+username+"'"
String hql = " from Userfile as uf where uf.id.users.userName = '"+username+"'";
就可以了
谢谢啊 我还有一个不明白的就是为什么hibernate会自动生成UserfileId对象啊???
帮忙解释一下 ..
也谢谢大家啊 来者有分