自己在做一个论坛 要用到主外键关系 但是在通过外键查询字表的数据时 控制台显示sql语句 但是没有任何返回 并且更糟糕的问题是 我在测试 利用查询的的时候 cpu充到100% 不是木马的问题 我的天啊
主表 <?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping default-lazy="false">
<class name="po.Bbs" table="bbs">
<id name="bid" type="java.lang.Integer">
<column name="bid"/>
<generator class="native"/>
</id>
<many-to-one class="po.Typic" name="typic">
<column name="tid"/>
</many-to-one>
<property generated="never" lazy="false" name="bbsname" type="java.lang.String">
<column length="100" name="bbsname"/>
</property>
<property generated="never" lazy="false" name="bbscontext" type="java.lang.String">
<column length="1000" name="bbscontext"/>
</property>
<property generated="never" lazy="false" name="bbstime" type="java.util.Date">
<column length="0" name="bbstime"/>
</property>
<set cascade="all" inverse="true" lazy="false" name="messagers" sort="unsorted" table="messager">
<key>
<column name="bid"/>
</key>
<one-to-many class="po.Messager"/>
</set>
</class>
</hibernate-mapping>从表
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping default-lazy="false">
<class name="po.Messager" table="messager">
<id name="mid" type="java.lang.Integer">
<column name="mid"/>
<generator class="native"/>
</id>
<many-to-one class="po.Bbs" fetch="select" name="bbs">
<column name="bid"/>
</many-to-one>
<many-to-one class="po.Buser" fetch="select" name="buser">
<column name="bbid"/>
</many-to-one>
<property generated="never" lazy="false" name="mtitle" type="java.lang.String">
<column length="1000" name="mtitle"/>
</property>
<property generated="never" lazy="false" name="mcontext" type="java.lang.String">
<column length="5000" name="mcontext"/>
</property>
<property generated="never" lazy="false" name="mcreatetime" type="java.util.Date">
<column length="0" name="mcreatetime" not-null="true"/>
</property>
<property generated="never" lazy="false" name="mname" type="java.lang.String">
<column length="100" name="mname"/>
</property>
<property generated="never" lazy="false" name="mmoods" type="java.lang.Integer">
<column name="mmoods"/>
</property>
<set inverse="true" name="answerses" sort="unsorted">
<key>
<column name="mid"/>
</key>
<one-to-many class="po.Answers"/>
</set>
</class>
</hibernate-mapping>dao类
//查询论坛下的全部记录数
public long queryAllMessagerCount() throws Exception {
// TODO Auto-generated method stub
long count=0;
String hql="select COUNT(m.mid) from Messager as m";
Query q=this.session.createQuery(hql);
// q.setInteger(0, bid);
List all=q.list();
all.hashCode();
while(all.size()>0)
{
count=(Long)all.get(0);
}
return count;
}
测试类
public static void main(String[] args)throws Exception {
// TODO Auto-generated method stub
long a=0;
a=new MessagerDAO().queryAllMessagerCount();
System.out.print(a);在控制台有sql语句 但是没有任何返回 也不返回为0 不为null
各位大侠们 救救我啊
主表 <?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping default-lazy="false">
<class name="po.Bbs" table="bbs">
<id name="bid" type="java.lang.Integer">
<column name="bid"/>
<generator class="native"/>
</id>
<many-to-one class="po.Typic" name="typic">
<column name="tid"/>
</many-to-one>
<property generated="never" lazy="false" name="bbsname" type="java.lang.String">
<column length="100" name="bbsname"/>
</property>
<property generated="never" lazy="false" name="bbscontext" type="java.lang.String">
<column length="1000" name="bbscontext"/>
</property>
<property generated="never" lazy="false" name="bbstime" type="java.util.Date">
<column length="0" name="bbstime"/>
</property>
<set cascade="all" inverse="true" lazy="false" name="messagers" sort="unsorted" table="messager">
<key>
<column name="bid"/>
</key>
<one-to-many class="po.Messager"/>
</set>
</class>
</hibernate-mapping>从表
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping default-lazy="false">
<class name="po.Messager" table="messager">
<id name="mid" type="java.lang.Integer">
<column name="mid"/>
<generator class="native"/>
</id>
<many-to-one class="po.Bbs" fetch="select" name="bbs">
<column name="bid"/>
</many-to-one>
<many-to-one class="po.Buser" fetch="select" name="buser">
<column name="bbid"/>
</many-to-one>
<property generated="never" lazy="false" name="mtitle" type="java.lang.String">
<column length="1000" name="mtitle"/>
</property>
<property generated="never" lazy="false" name="mcontext" type="java.lang.String">
<column length="5000" name="mcontext"/>
</property>
<property generated="never" lazy="false" name="mcreatetime" type="java.util.Date">
<column length="0" name="mcreatetime" not-null="true"/>
</property>
<property generated="never" lazy="false" name="mname" type="java.lang.String">
<column length="100" name="mname"/>
</property>
<property generated="never" lazy="false" name="mmoods" type="java.lang.Integer">
<column name="mmoods"/>
</property>
<set inverse="true" name="answerses" sort="unsorted">
<key>
<column name="mid"/>
</key>
<one-to-many class="po.Answers"/>
</set>
</class>
</hibernate-mapping>dao类
//查询论坛下的全部记录数
public long queryAllMessagerCount() throws Exception {
// TODO Auto-generated method stub
long count=0;
String hql="select COUNT(m.mid) from Messager as m";
Query q=this.session.createQuery(hql);
// q.setInteger(0, bid);
List all=q.list();
all.hashCode();
while(all.size()>0)
{
count=(Long)all.get(0);
}
return count;
}
测试类
public static void main(String[] args)throws Exception {
// TODO Auto-generated method stub
long a=0;
a=new MessagerDAO().queryAllMessagerCount();
System.out.print(a);在控制台有sql语句 但是没有任何返回 也不返回为0 不为null
各位大侠们 救救我啊
解决方案 »
- spring 空指针异常
- struts2 中的action如何获取URL
- javascript出错了还是? (jason-rpc)
- 求助!!请高手指点!(有时提示“无效的游标错误!”)
- 100分求JFreeChart Developer Guide(JFreeChart开发指南),谁有请发一份给我,本人不胜感激...
- 棘手问题 在线等待回答
- 关于数组的问题?
- 图片上传的servlet处理问题。
- 为什么会有这样的错误??? 关于jsp中调用javabean的问题...???help me???
- web项目,在线编辑word
- SSH2框架中,解析Hibernate返回的List,然后添加到Json数组
- 关于文件选择的对话框
问题出在这
List all=q.list();
all.hashCode();
while(all.size()>0){
count=(Long)all.get(0);
}你不是就要取个count吗?为什么要用循环呢?用if不就行了,再说你sql写的就是取count啊,为什么最后还返回个list,不能直接返回个int型吗?