Revision history [back]

click to hide/show revision 1
initial version

asked 2017-12-07 00:02:36 +0800

mutandaoscura gravatar image mutandaoscura

Can't display list in zul page

i have following code veicoloImp:

package model;

import java.util.LinkedList; import java.util.List;

import java.sql.*;

public class veicoloImp implements veicoloServ { List<veicolo> allAuto= new LinkedList<veicolo>(); public veicoloImp() { try { String url="jdbc:mysql://localhost:3306/odin"; Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection(url,"root","stage123"); Statement stmt= conn.createStatement(); ResultSet rs= stmt.executeQuery("SELECT *FROM vehiclemodelyear"); veicolo vei; while(rs.next()) {
vei = new veicolo(); vei.setId(rs.getInt(1)); vei.setYear(rs.getInt(2)); vei.setMake(rs.getString(3)); vei.setModel(rs.getString(4)); allAuto.add(vei); }

        }catch( SQLException | ClassNotFoundException e) {e.printStackTrace();}
}

public List<veicolo>findAll(){
    return allAuto;
    }

public List<veicolo> search(String keyword){
    List<veicolo> result = new LinkedList<veicolo>();

    if (keyword==null || "".equals(keyword)){
        result = allAuto;
    }else{
        for (veicolo c: allAuto){
            if (c.getModel().toLowerCase().contains(keyword.toLowerCase())
                ||c.getMake().toLowerCase().contains(keyword.toLowerCase())){
                result.add(c);
            }
        }
    }
    return result;

} }

veicoloServ:

package model;

import java.util.List;

public interface veicoloServ { public List<veicolo>findAll(); public List<veicolo> search(String keyword); }

veicoloController:

package controller;

import org.zkoss.zul.*; import org.zkoss.zul.ext.Selectable;

import java.util.List; import java.util.Set;

import org.zkoss.zk.ui.Component; import org.zkoss.zk.ui.select.SelectorComposer; import org.zkoss.zk.ui.select.annotation.Listen; import org.zkoss.zk.ui.select.annotation.Wire; import org.zkoss.zul.Label; import org.zkoss.zul.Listbox; import model.veicolo; import model.veicoloServ; import model.veicoloImp;

public class veicoloController extends SelectorComposer<component> { /** * */ private static final long serialVersionUID = -1772685322161992019L; @Wire private Textbox keywordBox; @Wire private Listbox carListBox; @Wire private Label modelLabel; @Wire private Label makeLabel; @Wire private Label yearLabel;

private veicoloServ carService = new veicoloImp();

@Listen("onClick = #searchButton") public void search(){ String keyword = keywordBox.getValue(); List<veicolo> result = carService.search(keyword); carListBox.setModel(new ListModelList<veicolo>(result)); }

@Listen("onSelect=#carListBox") public void show(){ Set<veicolo> selection=((Selectable<veicolo>)carListBox.getModel()).getSelection(); if (selection!=null && !selection.isEmpty()){ veicolo selected = selection.iterator().next(); yearLabel.setValue(selected.getYear().toString()); modelLabel.setValue(selected.getModel()); makeLabel.setValue(selected.getMake());} }

}

veicoloViewModel: package controller;

import java.util.List; import org.zkoss.bind.annotation.; import model.;

public class veicoloViewModel { private String keyword;

private veicolo selectedCar;

private veicoloServ carService = new veicoloImp();
private veicoloServ all=new veicoloImp();
private List<veicolo> allAuto=all.findAll();

public void setKeyword(String keyword) {
    this.keyword = keyword;
}
public String getKeyword() {
    return keyword;
}

public List<veicolo> getCarList(){
    return allAuto;

}


public void setSelectedCar(veicolo selectedCar) {
    this.selectedCar = selectedCar;
}
public veicolo getSelectedCar() {
    return selectedCar;
}


@Command
@NotifyChange("allAuto")
public void search(){
    allAuto = carService.search(keyword);

}

}

index.zul

<window title="Search" width="600px" border="normal"
viewModel="@id('vm') @init('controller.veicoloViewModel')">
<hbox align="center">
    Keyword:
    <textbox value="@save(vm.keyword)" />
    <button label="Search"  onClick="@command('search')" />
</hbox>
<listbox rows="3" model="@load(vm.allAuto)" emptyMessage="No car found in the result"
selectedItem="@save(vm.selectedCar)">
    <listhead>
        <listheader label="Year" />
        <listheader label="Model" />
        <listheader label="Make"/>
    </listhead>
    <template name="model">
        <listitem>
            <listcell label="@init(each.year)"></listcell>
            <listcell label="@init(each.model)"></listcell>
            <listcell label="@init(each.make)"></listcell>
        </listitem>
    </template>
</listbox>
<hlayout style="margin-top:20px" width="100%">
    <image width="250px" src="@load(vm.selectedCar.preview)" />
    <vlayout hflex="1">
        <label value="@load(vm.selectedCar.year)" />
        <label value="@load(vm.selectedCar.model)" />
        <label value="@load(vm.selectedCar.make)" />

    </vlayout>
</hlayout>

</window>

when i start on server my list is empty

Can't display list in zul page

i have following code veicoloImp:

package model;

import java.util.LinkedList; import java.util.List;

import java.sql.*;

public class veicoloImp implements veicoloServ { List<veicolo> allAuto= new LinkedList<veicolo>(); public veicoloImp() { try { String url="jdbc:mysql://localhost:3306/odin"; Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection(url,"root","stage123"); Statement stmt= conn.createStatement(); ResultSet rs= stmt.executeQuery("SELECT *FROM vehiclemodelyear"); veicolo vei; while(rs.next()) {
vei = new veicolo(); vei.setId(rs.getInt(1)); vei.setYear(rs.getInt(2)); vei.setMake(rs.getString(3)); vei.setModel(rs.getString(4)); allAuto.add(vei); }

        }catch( SQLException | ClassNotFoundException e) {e.printStackTrace();}
}

public List<veicolo>findAll(){
    return allAuto;
    }

public List<veicolo> search(String keyword){
    List<veicolo> result = new LinkedList<veicolo>();

    if (keyword==null || "".equals(keyword)){
        result = allAuto;
    }else{
        for (veicolo c: allAuto){
            if (c.getModel().toLowerCase().contains(keyword.toLowerCase())
                ||c.getMake().toLowerCase().contains(keyword.toLowerCase())){
                result.add(c);
            }
        }
    }
    return result;

} }

veicoloServ:

package model;

import java.util.List;

public interface veicoloServ { public List<veicolo>findAll(); public List<veicolo> search(String keyword); }

veicoloController:

package controller;

import org.zkoss.zul.*; import org.zkoss.zul.ext.Selectable;

import java.util.List; import java.util.Set;

import org.zkoss.zk.ui.Component; import org.zkoss.zk.ui.select.SelectorComposer; import org.zkoss.zk.ui.select.annotation.Listen; import org.zkoss.zk.ui.select.annotation.Wire; import org.zkoss.zul.Label; import org.zkoss.zul.Listbox; import model.veicolo; import model.veicoloServ; import model.veicoloImp;

public class veicoloController extends SelectorComposer<component> { /** * */ private static final long serialVersionUID = -1772685322161992019L; @Wire private Textbox keywordBox; @Wire private Listbox carListBox; @Wire private Label modelLabel; @Wire private Label makeLabel; @Wire private Label yearLabel;

private veicoloServ carService = new veicoloImp();

@Listen("onClick = #searchButton") public void search(){ String keyword = keywordBox.getValue(); List<veicolo> result = carService.search(keyword); carListBox.setModel(new ListModelList<veicolo>(result)); }

@Listen("onSelect=#carListBox") public void show(){ Set<veicolo> selection=((Selectable<veicolo>)carListBox.getModel()).getSelection(); if (selection!=null && !selection.isEmpty()){ veicolo selected = selection.iterator().next(); yearLabel.setValue(selected.getYear().toString()); modelLabel.setValue(selected.getModel()); makeLabel.setValue(selected.getMake());} }

}

veicoloViewModel: package controller;

import java.util.List; import org.zkoss.bind.annotation.; import model.;

public class veicoloViewModel { private String keyword;

private veicolo selectedCar;

private veicoloServ carService = new veicoloImp();
private veicoloServ all=new veicoloImp();
private List<veicolo> allAuto=all.findAll();

public void setKeyword(String keyword) {
    this.keyword = keyword;
}
public String getKeyword() {
    return keyword;
}

public List<veicolo> getCarList(){
    return allAuto;

}


public void setSelectedCar(veicolo selectedCar) {
    this.selectedCar = selectedCar;
}
public veicolo getSelectedCar() {
    return selectedCar;
}


@Command
@NotifyChange("allAuto")
public void search(){
    allAuto = carService.search(keyword);

}

}

index.zul

<window title="Search" width="600px" border="normal"
viewModel="@id('vm') @init('controller.veicoloViewModel')">
<hbox align="center">
    Keyword:
    <textbox value="@save(vm.keyword)" />
    <button label="Search"  onClick="@command('search')" />
</hbox>
<listbox rows="3" model="@load(vm.allAuto)" emptyMessage="No car found in the result"
selectedItem="@save(vm.selectedCar)">
    <listhead>
        <listheader label="Year" />
        <listheader label="Model" />
        <listheader label="Make"/>
    </listhead>
    <template name="model">
        <listitem>
            <listcell label="@init(each.year)"></listcell>
            <listcell label="@init(each.model)"></listcell>
            <listcell label="@init(each.make)"></listcell>
        </listitem>
    </template>
</listbox>
<hlayout style="margin-top:20px" width="100%">
    <image width="250px" src="@load(vm.selectedCar.preview)" />
    <vlayout hflex="1">
        <label value="@load(vm.selectedCar.year)" />
        <label value="@load(vm.selectedCar.model)" />
        <label value="@load(vm.selectedCar.make)" />

    </vlayout>
</hlayout>

</window>

when i start on server my list is empty

click to hide/show revision 3
No.3 Revision

updated 2017-12-11 09:34:37 +0800

cor3000 gravatar image cor3000

Can't display list in zul page

i have following code veicoloImp:

package model;

import java.util.LinkedList; import java.util.List;

import java.sql.*;

java.util.List; import java.sql.*; public class veicoloImp implements veicoloServ { List<veicolo> allAuto= new LinkedList<veicolo>(); public veicoloImp() { try { String url="jdbc:mysql://localhost:3306/odin"; Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection(url,"root","stage123"); Statement stmt= conn.createStatement(); ResultSet rs= stmt.executeQuery("SELECT *FROM vehiclemodelyear"); veicolo vei; while(rs.next()) {
vei = new veicolo(); vei.setId(rs.getInt(1)); vei.setYear(rs.getInt(2)); vei.setMake(rs.getString(3)); vei.setModel(rs.getString(4)); allAuto.add(vei); }

}

        }catch( SQLException | ClassNotFoundException e)  {e.printStackTrace();}
 }

public List<veicolo>findAll(){
    return allAuto;
    }

public List<veicolo> search(String keyword){
    List<veicolo> result = new LinkedList<veicolo>();

    if (keyword==null || "".equals(keyword)){
        result = allAuto;
    }else{
        for (veicolo c: allAuto){
            if (c.getModel().toLowerCase().contains(keyword.toLowerCase())
                ||c.getMake().toLowerCase().contains(keyword.toLowerCase())){
                result.add(c);
            }
        }
    }
    return result;
}
}

} }

veicoloServ:

package model;

import java.util.List;

import java.util.List; public interface veicoloServ { public List<veicolo>findAll(); public List<veicolo> search(String keyword); }

}

veicoloController:

package controller;

import org.zkoss.zul.*; import org.zkoss.zul.ext.Selectable;

org.zkoss.zul.ext.Selectable; import java.util.List; import java.util.Set;

java.util.Set; import org.zkoss.zk.ui.Component; import org.zkoss.zk.ui.select.SelectorComposer; import org.zkoss.zk.ui.select.annotation.Listen; import org.zkoss.zk.ui.select.annotation.Wire; import org.zkoss.zul.Label; import org.zkoss.zul.Listbox; import model.veicolo; import model.veicoloServ; import model.veicoloImp;

model.veicoloImp; public class veicoloController extends SelectorComposer<component> SelectorComposer<Component> { /** * */ private static final long serialVersionUID = -1772685322161992019L; @Wire private Textbox keywordBox; @Wire private Listbox carListBox; @Wire private Label modelLabel; @Wire private Label makeLabel; @Wire private Label yearLabel;

yearLabel; private veicoloServ carService = new veicoloImp();

veicoloImp(); @Listen("onClick = #searchButton") public void search(){ String keyword = keywordBox.getValue(); List<veicolo> result = carService.search(keyword); carListBox.setModel(new ListModelList<veicolo>(result)); }

} @Listen("onSelect=#carListBox") public void show(){ Set<veicolo> selection=((Selectable<veicolo>)carListBox.getModel()).getSelection(); if (selection!=null && !selection.isEmpty()){ veicolo selected = selection.iterator().next(); yearLabel.setValue(selected.getYear().toString()); modelLabel.setValue(selected.getModel()); makeLabel.setValue(selected.getMake());} }} }

veicoloViewModel:

}

veicoloViewModel: 

package controller;
 
controller;

import java.util.List;
import org.zkoss.bind.annotation.;
import model.;
 
org.zkoss.bind.annotation.*;
import model.*;

public class veicoloViewModel {
    private String keyword;
 
keyword;

    private veicolo selectedCar;

 private veicoloServ carService = new veicoloImp();
 private veicoloServ all=new veicoloImp();
 private List<veicolo> allAuto=all.findAll();

 public void setKeyword(String keyword) {
     this.keyword = keyword;
}
    }
    public String getKeyword() {
     return keyword;
}

    }

    public List<veicolo> getCarList(){
     return allAuto;

}


    }


    public void setSelectedCar(veicolo selectedCar) {
     this.selectedCar = selectedCar;
}
    }
    public veicolo getSelectedCar() {
     return selectedCar;
}


    }


    @Command
 @NotifyChange("allAuto")
 public void search(){
     allAuto = carService.search(keyword);
}


}

 
}
 
}
 
index.zul
 
<window title="Search" width="600px" border="normal"
viewModel="@id('vm') @init('controller.veicoloViewModel')">
<hbox align="center">
    Keyword:
    <textbox value="@save(vm.keyword)" />
    <button label="Search"  onClick="@command('search')" />
</hbox>
<listbox rows="3" model="@load(vm.allAuto)" emptyMessage="No car found in the result"
selectedItem="@save(vm.selectedCar)">
    <listhead>
        <listheader label="Year" />
        <listheader label="Model" />
        <listheader label="Make"/>
    </listhead>
    <template name="model">
        <listitem>
            <listcell label="@init(each.year)"></listcell>
            <listcell label="@init(each.model)"></listcell>
            <listcell label="@init(each.make)"></listcell>
        </listitem>
    </template>
</listbox>
<hlayout style="margin-top:20px" width="100%">
    <image width="250px" src="@load(vm.selectedCar.preview)" />
    <vlayout hflex="1">
        <label value="@load(vm.selectedCar.year)" />
        <label value="@load(vm.selectedCar.model)" />
        <label value="@load(vm.selectedCar.make)" />

    </vlayout>
</hlayout>
</window>

 
</window>
 
when i start on server my list is empty
About Us | Faq | Help | Privacy Policy | Contact Us
Copyright Potix Corporation 2015.
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More