How I can use searching by Hibernate with Java
I want to make searching on my database with hibernate in Java, how can I do that?
Normal开发者_如何转开发ly when I am using JDBC I wrote this code :
String Sql="select * from table1 where id like '"+jTextField1.getText()+"%'";
but I want to do that with hibernate database operation,
do I need to use session.load(..)
?
Thanks from now...
And can ı display results in Jtable?
You can use a Hibernate Criteria Query
Criteria crit = session.createCriteria(MyBean.class);
crit.add(Restrictions.like("name", "%xyz%"));
List results = crit.list();
Or a HQL query
session.createQuery("SELECT FROM MyBean WHERE name like '%xyz%'").list();
One way to accomplish this is to use Hibernate Criteria queries. Here's a link to a number of examples.
And, here's another.
Essentially, you'll want to create a Criteria instance using the APIs, and then add Restrictions to that Criteria.
精彩评论