First ZK Test

asked 2015-01-13 18:51:04 +0800

Maestro2012
1

updated 2015-01-13 19:09:59 +0800

chillworld
5367 ● 4 ● 9
https://github.com/chillw...

Hello, I come by this post submit a problem that I encountered. Indeed, at the workplace, I was asked to develop an application using the zk framework. First I wanted to make a grip trying a CRUD on a small database named Client with one person table (id, name, first name). That's when I run the index.zul I exceptions that I do not understand. I put here my various java and zul files. help me please

Personne.java:

package essaibd.crud.bo;

public class Personne {
private String id;
private String nom;
private String prenom;

public Personne(){
}
public Personne (String id, String nom, String prenom){
    this.id = id;
    this.nom = nom;
    this.prenom = prenom;
}

public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getNom() {
    return nom;
}
public void setNom(String nom) {
    this.nom = nom;
}
public String getPrenom() {
    return prenom;
}
public void setPrenom(String prenom) {
    this.prenom = prenom;
}

}

PersonneDAO.java:

package essaibd.crud.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import essaibd.crud.bo.Personne;



public class PersonneDAO {
 private String url = "jdbc:mysql://localhost:3306/clientdb";

    private String user = "root";

    private String password = "passer";

public PersonneDAO (){
    try{
    Class.forName("com.mysql.jdbc.Driver");
    }
    catch (ClassNotFoundException e){
    e.printStackTrace();
    }
}
public List<Personne> getAllPersonne(){
    Statement stmt = null;
    Connection conn = null;
    List<Personne> maList = new ArrayList<Personne>();
    try{
         conn = DriverManager.getConnection("url, user, password");
         stmt = conn.createStatement();
         ResultSet rs = stmt.executeQuery("select * from personne");

         while (rs.next()){

            Personne p = new Personne();
            p.setId(rs.getString(1));
            p.setNom(rs.getString(2));
            p.setPrenom(rs.getString(3));
            maList.add(p);
        }
     } catch (SQLException e) {
            e.printStackTrace();
     }finally{
             try {
                    stmt.close();
             } catch (SQLException e) {
                  e.printStackTrace();
               }
               try {
                    conn.close();
                } catch (SQLException e) {
                  e.printStackTrace();
                }
    }
    return maList;
}
public boolean AddPerson (Personne p){
    Connection conn = null;
    Statement stmt = null;
    boolean result = false;
    try {
        // get connection
        conn = DriverManager.getConnection(url, user, password);
        stmt = conn.createStatement();
        if (stmt.executeUpdate("insert into personne(id,nom,prenom) " +
                "values ('" + p.getId() + "','" + p.getNom() +
                "','" + p.getPrenom() + "')") > 0);
        result = true;

    } catch (SQLException e) {
        e.printStackTrace();
    }finally{
        try {
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    return result;
}
public boolean UpdatePersonne (Personne p){
    Connection conn = null;
    Statement stmt = null;
    boolean result =false;
 try{   
     conn = DriverManager.getConnection("url, user, password");
     stmt = conn.createStatement();
     if (stmt.executeUpdate("update personne set nom = '" + p.getNom() + 
                "', prenom = " + p.getPrenom() + " where id = '" +p.getId() + "'") > 0);
    result = true;
    }catch (SQLException e){
        e.printStackTrace();
    }finally{
        try {
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try{
            conn.close();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
 return result;
}
public boolean deletePersonne (Personne p){
    Connection conn = null;
    Statement stmt = null;
    boolean result =false;
     try{   
         conn = DriverManager.getConnection("url, user, password");
         stmt = conn.createStatement();
         if (stmt.executeUpdate("delete from peronne where id = '" + p.getId()+ "'") > 0);
         result = true;
     } catch (SQLException e) {
            e.printStackTrace();
     }finally {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
     return result;
}
}

PersonneControlleur.java:

package essaibd.crud.control;

import java.util.List;

import org.zkoss.zk.ui.util.GenericForwardComposer;
import org.zkoss.zul.Listbox;
import org.zkoss.zul.Messagebox;

import essaibd.crud.bo.Personne;
import essaibd.crud.dao.PersonneDAO;

public class PersonneController extends GenericForwardComposer{

PersonneDAO persdao = new PersonneDAO();
Personne pers = new Personne();
Listbox box;

public Personne getPers() {
    return pers;
}
public void setPers(Personne pers) {
    this.pers = pers;
}

public List<Personne> getAllPersonne(){
    return persdao.getAllPersonne();
} 
public void onClick$add(){
    Personne newPers = new Personne(pers.getId(), pers.getNom(), pers.getPrenom());
    persdao.AddPerson(newPers);
    Messagebox.show("Personne ajoutée");
}
public void onClick$update(){
    if (box.getSelectedItem()!=null);
    persdao.UpdatePersonne((Personne) box.getSelectedItem().getValue());
}
public void onClick$delete() {      
    if (box.getSelectedItem() != null) {
        persdao.deletePersonne((Personne) box.getSelectedItem().getValue());
    }
}

}

index.zul:

<?init class="org.zkoss.zkplus.databind.AnnotateDataBinderInit"?>

<window id="win" title="Liste Personne" width="640px" border="normal" apply="essaibd.crud.control.PersonneController">
<listbox id="box" multiple="true" rows="5"   
selectedItem="@{win$composer.pers}">
    <listhead>
        <listheader label="Id"/>
        <listheader label="Nom" width="90px"/>
        <listheader label="Prenom" width="90px"/>
    </listhead>
    <listitem self="@{each='event'}" value="@{event}">
        <listcell label="@{event.id}" />
        <listcell label="@{event.nom}" />
        <listcell label="@{event.prenom}" />
    </listitem>
</listbox>
<groupbox>
    <caption label="Personne" />
    Id: <textbox id="num" cols="25" value="@{win$composer.pers.id}" />
    Nom: <textbox id="nom" cols="25" value="@{win$composer.pers.nom}" />
    Prenom: <textbox id="prenom" cols="25" value="@{win$composer.pers.prenom}" />
    <button id="add" label="Add" width="36px" height="24px"/>
    <button id="update" label="Update" width="46px" height="24px"/> 
    <button id="delete" label="Delete" width="46px" height="24px"/> 
</groupbox> 
</window>

and here is the error at runtime: Etat HTTP 500 - Expects java.util.Set, java.util.List, java.util.Map, Object[], Enum Class, GroupsModel, ListModel,or BindingListModel only. class essaibd.crud.control.PersonneController

type Rapport d'exception

message Expects java.util.Set, java.util.List, java.util.Map, Object[], Enum Class, GroupsModel, ListModel,or BindingListModel only. class essaibd.crud.control.PersonneController

description Le serveur a rencontré une erreur interne qui l'a empêché de satisfaire la requête.

exception 

org.zkoss.zk.ui.UiException: Expects java.util.Set, java.util.List, java.util.Map, Object[], Enum Class, GroupsModel, ListModel,or BindingListModel only. class essaibd.crud.control.PersonneController
org.zkoss.zkplus.databind.ListModelConverter.coerceToUi(ListModelConverter.java:67)
org.zkoss.zkplus.databind.Binding.myLoadAttribute(Binding.java:384)
org.zkoss.zkplus.databind.Binding.loadAttribute(Binding.java:337)
org.zkoss.zkplus.databind.DataBinder.loadAttrs(DataBinder.java:586)
org.zkoss.zkplus.databind.DataBinder.loadComponent0(DataBinder.java:543)
org.zkoss.zkplus.databind.DataBinder.loadAll(DataBinder.java:571)
org.zkoss.zkplus.databind.AnnotateDataBinderInit.doAfterCompose(AnnotateDataBinderInit.java:187)
org.zkoss.zk.ui.impl.Initiators$RealInits.doAfterCompose(Initiators.java:122)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:450)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:356)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

note La trace complète de la cause mère de cette erreur est disponible dans les fichiers journaux de Apache Tomcat/6.0.43.