<hibernate-mapping package="com.cardvalue.dao.entrty">
<class name="Sales_store" >
<id name="id">
<generator class="native" />
</id>
<property name="mid" />
<property name="app_id"/>
<set name="user" inverse="true">
<key>
<column name="store_id" not-null="true" />
</key>
<one-to-many class="com.cardvalue.dao.entrty.User" />
</set>
</class>
</hibernate-mapping>
<hibernate-mapping package="com.cardvalue.dao.entrty">
<class name="User">
<id name="id">
<generator class="native" />
</id>
<property name="username" />
<property name="password"/>
<many-to-one name="store" column="store_id"/>
</class>
</hibernate-mapping>
private static SessionFactory sessionFactory;
private HibernateUtil(){
}
static{
Configuration cfg=new Configuration();
cfg.configure();
sessionFactory=cfg.buildSessionFactory();
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
public static Session getSession(){
return sessionFactory.openSession();
}
static void query(){
Session s=null;
try{
s=HibernateUtil.getSession();
String hql="from User as user";
Query query=s.createQuery(hql);
query.setFirstResult(5);
query.setMaxResults(5);
List<User> list=query.list();//excuptQuery();
for (User user : list) {
System.out.println(user.getId()+"****"+user.getStore().getMid()+"*******"+user.getStore().getApp_id());
}
}finally{
if(s!=null)
s.close();
}
}