Olá pessoal, estou tendo um erro quando vou fazer a busca no banco, esta dando um nullpointerexception na linha da variável pstmt!
Alguem tem alguma sugestão??
Estou rachando a cabeça aqui, mas nao consigo resolver.
public static ArrayList<Evento> getAll( ) {
String query="SELECT * FROM evento ";
try {
ArrayList<Evento> listAll = null;
pstmt = (PreparedStatement) Conexao.getConnection().prepareStatement(query); // [b]<<-----NULL POINTER EXCEPTION!!!!!!! [/b]
rs = pstmt.executeQuery();
if (rs.next()) {
do {
Evento evento = new Evento();
evento.setIdevento(rs.getString("idevento"));
evento.setAtivo(rs.getString("ativo"));
evento.setData(rs.getString("data"));
evento.setDescricao(rs.getString("descricao"));
evento.setFlyer(rs.getString("flyer"));
evento.setResenha(rs.getString("resenha"));
evento.setThumb(rs.getString("thumb"));
listAll.add(evento);
} while (rs.next());
}
rs.close();
pstmt.close();
return listAll;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
package model;
import beans.Evento;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
/**
*
* @author Marcelo
*/
public class EventoDAO {
private static PreparedStatement pstmt = null;
private static ResultSet rs = null;
public static boolean create(Evento evento) {
try {
pstmt = (PreparedStatement) Conexao.getConnection().prepareStatement(
"INSERT INTO evento(descricao, data, thumb, flyer, resenha, ativo) VALUES(?,?,?,?,?,?)"
);
pstmt.setString(1, evento.getDescricao());
pstmt.setString(2, evento.getData());
pstmt.setString(3, evento.getThumb());
pstmt.setString(4, evento.getFlyer());
pstmt.setString(5, evento.getResenha());
pstmt.setString(6, evento.getAtivo());
pstmt.executeUpdate();
pstmt.close();
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
public static ArrayList<Evento> getAll( ) {
String query="SELECT * FROM evento ";
try {
ArrayList<Evento> listAll = null;
pstmt = (PreparedStatement) Conexao.getConnection().prepareStatement(query);
rs = pstmt.executeQuery();
if (rs.next()) {
do {
Evento evento = new Evento();
evento.setIdevento(rs.getString("idevento"));
evento.setAtivo(rs.getString("ativo"));
evento.setData(rs.getString("data"));
evento.setDescricao(rs.getString("descricao"));
evento.setFlyer(rs.getString("flyer"));
evento.setResenha(rs.getString("resenha"));
evento.setThumb(rs.getString("thumb"));
listAll.add(evento);
} while (rs.next());
}
rs.close();
pstmt.close();
return listAll;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
}
