81,092
社区成员
发帖
与我相关
我的任务
分享
String queryString = "select am.menuid,am.menuname,am.menucode from AcMenu am where am.menuid in('2','3','4')";
public List findByChildrens(final List childrens){
log.debug("finding all AcMenu instances");
try {
final String queryString = "select am from AcMenu am where am.menuid in('2','3','4')";
List operatorList = null;
AcMenu acMenu = (AcMenu)this.getSession().load(AcMenu.class,"2");
System.out.println(acMenu.getMenucode());
operatorList = this.getSession().createQuery(queryString).list();
for(Iterator acMenuListIt =operatorList.iterator();acMenuListIt.hasNext(); ){
AcMenu acMenuLast = (AcMenu)acMenuListIt.next();
System.out.println("------" + acMenuLast.getMenucode());
}
return operatorList;
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
package com.zixuan.acframe.acmenu.domain;
/**
* AcMenu entity.
*
* @author MyEclipse Persistence Tools
*/
public class AcMenu {
// Fields
private String menuid;
private String menuname;
private String menucode;
// Constructors
// Property accessors
public String getMenuid() {
return this.menuid;
}
public void setMenuid(String menuid) {
this.menuid = menuid;
}
public String getMenuname() {
return this.menuname;
}
public void setMenuname(String menuname) {
this.menuname = menuname;
}
public String getMenucode() {
return this.menucode;
}
public void setMenucode(String menucode) {
this.menucode = menucode;
}
}
<?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>
<class name="com.zixuan.acframe.acmenu.domain.AcMenu" table="ac_menu" catalog="acframe" lazy= "false">
<id name="menuid" type="java.lang.String">
<column name="MENUID"/>
<generator class="assigned" />
</id>
<property name="menuname" type="java.lang.String">
<column name="MENUNAME" length="40" not-null="true" />
</property>
<property name="menucode" type="java.lang.String">
<column name="MENUCODE" length="40" />
</property>
</class>
</hibernate-mapping>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="hibernate.connection.url">
jdbc:mysql://192.168.35.3:3306/acframe
</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">
zhou1212
</property>
<property name="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="hibernate.show_sql">true</property>
<mapping
resource="com/zixuan/acframe/acmenu/domain/AcMenu.hbm.xml" />
<mapping
</hibernate-configuration>