java 方法命名find query_Hibernate 命名查询NamedQuery

/**

* UserBean entity. @author MyEclipse Persistence Tools

*/

public class UserBean implements java.io.Serializable {

// Fields

private String id1;

private String name1;

private java.util.Date createtime1;

private String address;

// Constructors

/** default constructor */

public UserBean() {

}

/** minimal constructor */

public UserBean(String id1) {

this.id1 = id1;

}

/** full constructor */

public UserBean(String id1, String name1, java.util.Date createtime1, String address) {

this.id1 = id1;

this.name1 = name1;

this.createtime1 = createtime1;

this.address = address;

}

// Property accessors

public String getId1() {

return this.id1;

}

public void setId1(String id1) {

this.id1 = id1;

}

public String getName1() {

return this.name1;

}

public void setName1(String name1) {

this.name1 = name1;

}

public java.util.Date getCreatetime1() {

return this.createtime1;

}

public void setCreatetime1(java.util.Date createtime1) {

this.createtime1 = createtime1;

}

public String getAddress() {

return this.address;

}

public void setAddress(String address) {

this.address = address;

}

}

/p>

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

package com.abin.lee.hibernate;

import java.util.List;

import junit.framework.TestCase;

import org.hibernate.Criteria;

import org.hibernate.HibernateException;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.hibernate.criterion.Order;

import com.lcdbtsf.air.po.UserBean;

public class UserDao extends TestCase {

public  List getAll(){

Configuration cfg = new Configuration().configure(); // 获取hibernate的配置信息

SessionFactory sf = cfg.buildSessionFactory(); // 根据config建立sessionFactory

Session session = sf.openSession(); // factory用于建立session，开启Session，相当于开启JDBC的Connection

Transaction ts = session.beginTransaction(); // 创建事务的对象ts

List list=null;

try {

Criteria criteria=session.createCriteria(UserBean.class);

criteria.addOrder(Order.desc("createtime1"));

list=criteria.list();

ts.commit();

} catch (HibernateException he) {

he.printStackTrace();

ts.rollback();

}

return list;

}

public  List getAllByAddress(String address){

Configuration cfg = new Configuration().configure(); // 获取hibernate的配置信息

SessionFactory sf = cfg.buildSessionFactory(); // 根据config建立sessionFactory

Session session = sf.openSession(); // factory用于建立session，开启Session，相当于开启JDBC的Connection

Transaction ts = session.beginTransaction(); // 创建事务的对象ts

List list=null;

try {

Query query=session.getNamedQuery("getUserBeanByAddress");

query.setParameter("address", address);

list=query.list();

ts.commit();

} catch (HibernateException he) {

he.printStackTrace();

ts.rollback();

}

return list;

}

}

package com.abin.lee.hibernate;

import java.util.List;

import junit.framework.TestCase;

import org.hibernate.HibernateException;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import com.lcdbtsf.air.po.UserBean;

public class UserDaoTest extends TestCase {

public void test() {

List list=new UserDao().getAllByAddress("shanghai");

try {

if(list.size()>0){

UserBean user =list.get(0);

System.out.println(list.get(0).getId1());

}

} catch (HibernateException he) {

he.printStackTrace();  }

}

}