Boa noite a todos,
Alguém poderia me ajudar a ver o que está errado na classe abaixo?
O erro:
java.lang.RuntimeException: org.firebirdsql.jdbc.FBSQLException: The result set is closed
br.com.dataquery.dao.UsuarioDAO.existeUsuario(UsuarioDAO.java:50)
br.com.dataquery.action.LoginAction.login(LoginAction.java:22)
A Classe:
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import br.com.dataquery.conexao.ConnectionFactory;
import br.com.dataquery.modelo.Usuario;
public class UsuarioDAO
{
Connection conn;
public UsuarioDAO() throws SQLException{
new ConnectionFactory();
this.conn = ConnectionFactory.getConnection();
}
public boolean existeUsuario(Usuario usuario){
String sql = "select * from usuarios where usuario= ? and senha= ?";
try{
PreparedStatement stmt = this.conn.prepareStatement(sql);
stmt.setString(1, usuario.getUsuario());
stmt.setString(2, usuario.getSenha());
ResultSet rs = stmt.executeQuery();
stmt.execute();
//verifica se existe retorno na consulta
if(rs.next())
{
stmt.close();
return true;
}
else
{
stmt.close();
return false;
}
}
catch(SQLException e)
{
throw new RuntimeException(e);
}
}
}
Obrigado!
