Hi Tom-
I'll post my code for this concept i am working on.
Maybe you can see better from a more complete posting.
I was trying to be brief but sometimes it may be better to see the code.
It is kind of like a prototype of my querybuilder not attached to a GUI yet.
I still plan on looking at your code later as i am trying to learn java and
need to read code examples.
I will fix the rest of the constructors to not include all of the null
initializations later.
the reason i use the treemaps is to have a record of what i am doing so
when i hook it up to the builder GUI screen i can delete , add,
and maybe edit the history based on the treemap values.
the methods are greater than, less than, equal to, between,
like etc.
hope someone likes this example.
i am going to try and add it to my checkbook program
when it is completed.
later,
jim
package demolib;
import org.hibernate.criterion.Criterion;
public class E {
public String str1 = null ;
public String str2 = null;
public String str3 =null;
private Criterion crit1 = null;
private Criterion crit2 = null ;
private Object obj1 = null;
private Object obj2 = null;
E(String s1, String s2, String s3)
{
str1 = s1;
str2 = s2;
str3 = s3;
}
E(String s1, String s2, Object object1, String s3, Object object2,
Criterion c1, Criterion c2)
{
str1 = s1;
str2 = s2;
obj1 = object1;
str3 = null;
obj2 = null;
crit1 = null;
crit2 = null;
}
E(String s1, Criterion c1, Criterion c2, String s2, String s3,
Object object1, Object object2){
str1 = s1;
crit1 = c1;
crit2 = c2;
str2 = null;
str3 = null;
obj1 = null;
obj2 = null;
}
E(String s1, Object object1, Object object2, String s2, String s3,
Criterion c1, Criterion c2)
{
str1 = s1;
obj1 = object1;
obj2 = object2;
str2 = null;
str3 = null;
crit1 = null;
crit2 = null;
}
public static void main(String[] args){
//E e = new E("like","payeepayor","chas%");
}
}
package demolib;
import java.util.Iterator;
import org.eclipse.jface.dialogs.MessageDialog;
import org.eclipse.swt.widgets.Shell;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.Criterion;
import org.hibernate.Criteria;
import java.util.List;
import org.hibernate.Query;
import demolib.Transact;
import java.util.TreeMap;
public class D {
static Criterion restriction;
static Criterion[] rArray = new Criterion[10];
Session session;
List lst;
Query qry;
Transact tTbl;
Transaction tx;
static TreeMap<Integer,E> tm = new TreeMap<Integer,E>();
static TreeMap<Integer,Criterion> tm2 = new TreeMap<Integer,Criterion>();
static int counter = -1;
public Criterion and(Criterion crit1, Criterion crit2){
restriction =
Restrictions.and(crit1, crit2);
counter = counter + 1;
return restriction;
}
public Criterion or(Criterion crit1, Criterion crit2){
restriction =
Restrictions.or(crit1, crit2);
counter = counter + 1;
return restriction;
}
public Criterion like(String str1, String str2){
restriction =
Restrictions.like(str1,str2);
counter = counter + 1;
return restriction;
}
public Criterion ilike(String str1, String str2){
restriction =
Restrictions.ilike(str1,str2);
counter = counter + 1;
return restriction;
}
public Criterion eq(String str1,Object obj1){
restriction =
Restrictions.eq(str1, obj1);
counter = counter + 1;
return restriction;
}
public Criterion gt(String str1,Object obj1){
restriction =
Restrictions.gt(str1, obj1);
counter = counter + 1;
return restriction;
}
public Criterion ge(String str1,Object obj1){
restriction =
Restrictions.ge(str1, obj1);
counter = counter + 1;
return restriction;
}
public Criterion lt(String str1,Object obj1){
restriction =
Restrictions.lt(str1, obj1);
counter = counter + 1;
return restriction;
}
public Criterion le(String str1,Object obj1){
restriction =
Restrictions.le(str1, obj1);
counter = counter + 1;
return restriction;
}
public Criterion between(String str1,Object obj1, Object obj2){
restriction =
Restrictions.between(str1, obj1, obj2);
counter = counter + 1;
return restriction;
}
public void runQuery(Criterion[] restriction){
try{
session =
HibernateUtil.getSessionFactory().openSession();
tx =
session.beginTransaction();
Criteria criteriaVal = session.createCriteria(Transact.class);
for(int i = 0; i < counter + 1; i++)
criteriaVal.add(restriction);
lst = criteriaVal.list();
for ( Iterator iter = lst.iterator();
iter.hasNext(); ) {
tTbl = (Transact)
iter.next();
System.out.println(tTbl.getTransactionid());
}
tx.commit();
HibernateUtil.shutdown();
} catch (HibernateException e) {
if (tx != null) tx.rollback();
Shell shellcreature = new Shell();
MessageDialog messageDialog = new
MessageDialog(shellcreature,"ERROR",null,e.getMessage(),MessageDialog.ERROR,
new String[]{"ok"},0);
messageDialog.open();
e.printStackTrace();
}catch(Exception e1){
e1.printStackTrace();
}finally {
if (session != null)
session.close();
}
}
public static void main(String[] args){
D d = new D();
//restriction = d.like("payeepayor", "chase%");
//rArray[counter]=restriction;
//restriction = d.like("paytype", "payor%");
//rArray[counter]=restriction;
//restriction = d.between("transactionamount",11.25,11.26);
//rArray[counter]=restriction;
//d.runQuery(rArray);
E e = new E("like","payeepayor","chas%");
if (e.str1.equals("like"))
restriction = d.like(e.str2, e.str3);
tm.put(Integer.valueOf(counter),e);
tm2.put(Integer.valueOf(counter),restriction );
rArray[counter]=restriction;
d.runQuery(rArray);
}
}
