Zk con eclipce

[difelohe]

Estoy trabajando una aplicacion como un espesie de ajenda donde se puedes agrear eventos prioridad y fecha pero cundo ejecuto la aplicaion en server me da este inforem de estado

Estado HTTP 500 -

--------------------------------------------------------------------------------

type Informe de Excepción

mensaje

descripción El servidor encontró un error interno () que hizo que no pudiera rellenar este requerimiento.

excepción

java.lang.NullPointerException
org.zkforge.todo.event.EventDAO.findAll(EventDAO.j ava:60)
org.zkforge.todo.event.EventController.getAllEvent s(EventController.java:27)
sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.zkoss.lang.reflect.Fields.get(Fields.java:119)
org.zkoss.zkplus.databind.DataBinder.fetchValue(Da taBinder.java:1003)
org.zkoss.zkplus.databind.DataBinder.myGetBeanWith Expression(DataBinder.java:989)
org.zkoss.zkplus.databind.DataBinder.getBeanAndReg isterBeanSameNodes(DataBinder.java:957)
org.zkoss.zkplus.databind.Binding.loadAttribute(Bi nding.java:333)
org.zkoss.zkplus.databind.DataBinder.loadAttrs(Dat aBinder.java:563)
org.zkoss.zkplus.databind.DataBinder.loadComponent 0(DataBinder.java:518)
org.zkoss.zkplus.databind.DataBinder.loadAll(DataB inder.java:547)
org.zkoss.zkplus.databind.AnnotateDataBinderInit.d oAfterCompose(AnnotateDataBinderInit.java:145)
org.zkoss.zk.ui.impl.RealInits.doAfterCompose(Init iators.java:84)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiE ngineImpl.java:384)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEn gineImpl.java:299)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DH tmlLayoutServlet.java:229)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtm lLayoutServlet.java:166)
javax.servlet.http.HttpServlet.service(HttpServlet .java:617)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)


nota La traza completa de la causa de este error se encuentra en los archivos de diario de Apache Tomcat/6.0.20.


--------------------------------------------------------------------------------

Apache Tomcat/6.0.20

y este es el codigo completo del eventDao
package org.zkforge.todo.event;

/**
* Event DAO.
*
* @author robbiecheng
*/

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


public class EventDAO {
private String url = "jdbc:mysql://localhost:3306/test";

private String user = "root";

private String pwd = "";

public EventDAO() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

public List findAll(){
Statement stmt = null;
Connection conn = null;
List allEvents = new ArrayList();
try {
// get connection
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from event");

// fetch all events from database
TodoEvent evt;
while (rs.next()) {
evt = new TodoEvent();
evt.setId(rs.getString(1));
evt.setName(rs.getString(2));
evt.setPriority(rs.getInt(3));
evt.setDate(rs.getDate(4));
allEvents.add(evt);
}

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

public boolean delete(TodoEvent evt){
Connection conn = null;
Statement stmt = null;
boolean result = false;
try {
// get connection
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
if (stmt.executeUpdate("delete from event where id = '" + evt.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 insert(TodoEvent evt){
Connection conn = null;
Statement stmt = null;
boolean result = false;
try {
// get connection
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
if (stmt.executeUpdate("insert into event(id,name,priority,date) " +
"values ('" + UUID.randomUUID().toString() + "','" + evt.getName() +
"'," + evt.getPriority() + ",'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(evt.getDate()) + "')") > 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 update(TodoEvent evt){
Connection conn = null;
Statement stmt = null;
boolean result = false;
try {
// get connection
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
if (stmt.executeUpdate("update event set name = '" + evt.getName() +
"', priority = " + evt.getPriority() + ", date = '" +
new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(evt.getDate())+
"' where id = '" + evt.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 resulagradesco los aportes