hibernate中的模糊查询

1.首先是一个简单的jsp表单

<form action="usersearch" method="post">
<table>
<tr><td>用户名：</td><td><input name="name" type="text"></td></tr>
<tr><td>电话：</td><td><input name="phone" type="text"></td></tr>
<tr><td><input name="search" type="submit" value="查询"></td></tr>
</table>

</form>

2.响应的Action

package cn.hncj.action;

import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import Bean.User;


public class usersSearchAction extends ActionSupport implements ModelDriven<User> {
private User user= new User();
public User getModel() {
return user;
}
public String execute() throws Exception {
Configuration config =new Configuration().configure();
SessionFactory sessionFactory =config.buildSessionFactory();
Session session=sessionFactory.openSession();
Transaction t =session.beginTransaction();

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

                        // 这里是通过两个输入条件进行查询，如果你在表单里只输入一个也能查出来   

criteria.add(Restrictions.like("name", "%"+user.getName()+"%"));   //利用模型驱动得到的属性值
criteria.add(Restrictions.like("phone", "%"+user.getPhone()+"%"));
List<User> user=new ArrayList<User>();
user=criteria.list();
HttpServletRequest request=ServletActionContext.getRequest();
request.setAttribute("user", user);
t.commit();
session.close();
sessionFactory.close();
return SUCCESS;
}
}