multi criteria HQL, please help me

answered 2009-12-11 04:00:20 +0800

JoH
105 ● 2 ● 3

@TerryTornado

Thanx for the reply,
Sorry that I posted my thread twice, since I clicked the wrong category.

I would like to do it in three text boxes, but I'm still novice, so I don't know how to do it.
So the only solution is to constraint the input with fixed rule.
If you can tell me how to write three input parameters in three different textboxes, I would be really happy.

I solved the problem yesterday night, that instead of single string, one shall write an array like this in DAO,

public List<Item> findAllAdvance(String[] advance)

and respectively in the implementation,

@SuppressWarnings("unchecked")
public List<Item> findAllAdvance(String[] advance) {
String hql = "FROM Item WHERE description = ? or multi = ? or charge = ? ";
return getHibernateTemplate().find(hql, advance);
}

And the java class to search and list it, and split the strings

public void submit2(){
String advance = ((Textbox)getFellow("advance")).getValue().trim();

String [] temp = null;
temp = advance.split(",");

Listbox listbox = (Listbox)getFellow("items");
listbox.getItems().clear();

ApplicationContext ctx =
WebApplicationContextUtils.getRequiredWebApplicationContext(
(ServletContext)getDesktop().getWebApp().getNativeContext());

Adminop admin = (Adminop)ctx.getBean("adminop");


List<Item> items = admin.getSearchedItem2(temp);
Iterator<Item> it = items.iterator();
...etc.

answered 2009-12-14 03:54:01 +0800

JoH
105 ● 2 ● 3

@Stephan

Großartig! vielen Dank Stephan.

It works well. But why did you write List<Order> instead List<Item>?

I still have one problem, I would like to separate that search window to another .zul file, say "search.zul". So by clicking a special button from the main site, a window will show up with those three text boxes. And if one enters 3 parameters it will search, and show the results again in the main window. How could I realise this?

Again many thanks for you!

answered 2009-12-15 06:05:50 +0800

JoH
105 ● 2 ● 3

Hi Stephan,

I solved the problem yesterday using Path.getComponent(etc...) and doModal Window for the search function.

I found an interesting part from your sample application. If one double click the customer list and click the edit button, the information from the list will be showed up in the edit window.

But since I'm still newbie, I can't understand fully your code. How did you do this actually?

I tried like this but failed,

My AdminWindow.java

public void onEdit() throws SuspendNotAllowedException, InterruptedException{
Listbox listbox = (Listbox)getFellow("items");
Listitem lt = listbox.getSelectedItem();

String filepath = ((de.qcdb.lmu.domain.Item)lt.getValue()).getFilepath();
Textbox tb_filepath = new Textbox();
tb_filepath.setValue(filepath);

Window win = (Window)Executions.createComponents("edit.zul", null, null);
win.doModal();
}

And the main window "Root.zul" consists a button

<button label="Edit" onClick="adminWnd.onEdit()" />

And my edit.zul

File Path:
<textbox value="${editWnd????}" id="tb_filepath" />

How to pass the value of the selected things to the textbox?

Thanks in advance