[Err] 1054 - Unknown column 'subitems0_.itemid' in 'field list'
ssh 级联 二个分类 item >
itemidsubitem>
关联 itemiid(用一样的itemid)
~~~这里试过用一样的字段就出错,然后把sql输出就得到上面的错误
select subitems0_.itemid as itemid1_, subitems0_.subid as subid1_, subitems0_.subid as subid0_, subitems0_.itemid as itemid7_0_, subitems0_.subnname as subnname7_0_, subitems0_.itemiid as itemiid7_0_, subitems0_.subccode as subccode7_0_ from subitem subitems0_ where subitems0_.itemid=1~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~item.hbm.xml<?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 - Hibernate Tools
-->
<hibernate-mapping>
<class name="org.xieztao.newdat.vo.Item" table="item" >
<id name="itemid" type="java.lang.Integer">
<column name="itemid" />
<generator class="native"></generator>
</id>
<property name="itemnname" type="java.lang.String">
<column name="itemnname" length="50" />
</property>
<property name="itemccode" type="java.lang.Integer">
<column name="itemccode" />
</property>
<property name="itemttype" type="java.lang.Integer">
<column name="itemttype" />
</property>
<property name="piidd" type="java.lang.Integer">
<column name="piidd" />
</property>
<property name="itemwebpic" type="java.lang.String">
<column name="itemwebpic" length="100" />
</property>
<set name="subitems" inverse="true" cascade="all" table="subitem">
<key>
<column name="itemid" />
</key>
<one-to-many class="org.xieztao.newdat.vo.Subitem" />
</set> </class>
</hibernate-mapping>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~subitem.hbm.xml<?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 - Hibernate Tools
-->
<hibernate-mapping>
<class name="org.xieztao.newdat.vo.Subitem" table="subitem">
<id name="subid" type="java.lang.Integer">
<column name="subid" />
<generator class="native"></generator>
</id>
<many-to-one name="item" class="org.xieztao.newdat.vo.Item">
<column name="itemid"></column>
</many-to-one>
<property name="subnname" type="java.lang.String">
<column name="subnname" length="50" />
</property>
<property name="itemiid" type="java.lang.Integer">
<column name="itemiid" />
</property>
<property name="subccode" type="java.lang.Integer">
<column name="subccode" />
</property>
</class>
</hibernate-mapping>然后, Action这样与的,应该都没错,都拿出来了public ActionForward selecteall(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ItemForm itemForm = (ItemForm) form;
List all=null;
try {
all=this.iitemdao.queryAll();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
request.setAttribute("all", all);
return mapping.findForward("newsiinnfo");
页面上是页面上内容<logic:present name="all" scope="request">
<logic:iterate id="item" scope="request" name="all">
${item.itemnname}
<logic:iterate id="subitem" name="item" property="subitems">
|-- ${subitems.subnname}
</logic:iterate>
</logic:iterate>
</logic:present>
但是去掉<logic:iterate id="subitem" name="item" property="subitems">
|-- ${subitems.subnname}
</logic:iterate>
就可以正常,不知道什么问题,我新手,希望可以指点下,
web.xml 也加了
<filter>
<filter-name>opensession</filter-name>
<filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>opensession</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>
ssh 级联 二个分类 item >
itemidsubitem>
关联 itemiid(用一样的itemid)
~~~这里试过用一样的字段就出错,然后把sql输出就得到上面的错误
select subitems0_.itemid as itemid1_, subitems0_.subid as subid1_, subitems0_.subid as subid0_, subitems0_.itemid as itemid7_0_, subitems0_.subnname as subnname7_0_, subitems0_.itemiid as itemiid7_0_, subitems0_.subccode as subccode7_0_ from subitem subitems0_ where subitems0_.itemid=1~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~item.hbm.xml<?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 - Hibernate Tools
-->
<hibernate-mapping>
<class name="org.xieztao.newdat.vo.Item" table="item" >
<id name="itemid" type="java.lang.Integer">
<column name="itemid" />
<generator class="native"></generator>
</id>
<property name="itemnname" type="java.lang.String">
<column name="itemnname" length="50" />
</property>
<property name="itemccode" type="java.lang.Integer">
<column name="itemccode" />
</property>
<property name="itemttype" type="java.lang.Integer">
<column name="itemttype" />
</property>
<property name="piidd" type="java.lang.Integer">
<column name="piidd" />
</property>
<property name="itemwebpic" type="java.lang.String">
<column name="itemwebpic" length="100" />
</property>
<set name="subitems" inverse="true" cascade="all" table="subitem">
<key>
<column name="itemid" />
</key>
<one-to-many class="org.xieztao.newdat.vo.Subitem" />
</set> </class>
</hibernate-mapping>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~subitem.hbm.xml<?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 - Hibernate Tools
-->
<hibernate-mapping>
<class name="org.xieztao.newdat.vo.Subitem" table="subitem">
<id name="subid" type="java.lang.Integer">
<column name="subid" />
<generator class="native"></generator>
</id>
<many-to-one name="item" class="org.xieztao.newdat.vo.Item">
<column name="itemid"></column>
</many-to-one>
<property name="subnname" type="java.lang.String">
<column name="subnname" length="50" />
</property>
<property name="itemiid" type="java.lang.Integer">
<column name="itemiid" />
</property>
<property name="subccode" type="java.lang.Integer">
<column name="subccode" />
</property>
</class>
</hibernate-mapping>然后, Action这样与的,应该都没错,都拿出来了public ActionForward selecteall(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ItemForm itemForm = (ItemForm) form;
List all=null;
try {
all=this.iitemdao.queryAll();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
request.setAttribute("all", all);
return mapping.findForward("newsiinnfo");
页面上是页面上内容<logic:present name="all" scope="request">
<logic:iterate id="item" scope="request" name="all">
${item.itemnname}
<logic:iterate id="subitem" name="item" property="subitems">
|-- ${subitems.subnname}
</logic:iterate>
</logic:iterate>
</logic:present>
但是去掉<logic:iterate id="subitem" name="item" property="subitems">
|-- ${subitems.subnname}
</logic:iterate>
就可以正常,不知道什么问题,我新手,希望可以指点下,
web.xml 也加了
<filter>
<filter-name>opensession</filter-name>
<filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>opensession</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>
学艺不精,还希望可以请教一二~谢谢
<column name="itemid" />
</key>code]
[code=XML]<property name="itemiid" type="java.lang.Integer">
<column name="itemiid" />
</property>[code]
<logic:present name="all" scope="request">
<logic:iterate id="item" scope="request" name="all">
${item.itemnname}
<logic:iterate id="subitem" name="item" property="subitems">
|-- ${subitems.subnname}
</logic:iterate>
</logic:iterate>
</logic:present>我的表达式有问题吗~
这个 subnname 字段对应在库里可以找到~