Jsp+beans+dao

Pessoal estou quase la… quero obter o nome e o email do usuario no jsp… estou fazendo isso…
Falta apenas saber como obtenho os dados (nome e email) do usuario no jsp… gostaria de saber tbm c esta implementacao esta correta…

Abraco a todos !!!

UsuariosDB:

package br.com.nerd.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import br.com.nerd.beans.UsuarioBean;
import br.com.nerd.util.NerdException;

public class UsuariosDb implements UsuariosDao{

    public final String INSERT = "INSERT INTO usuarios (nome_usuario,email_usuario) VALUES (?,?)";
    public final String SELECT_BYID = "SELECT nome_usuario,email_usuario FROM usuarios WHERE id_usuario = ?";
    
    public void gravarUsuario(UsuarioBean u) throws NerdException {
    
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement prepStmt = null;
        
        try{
            conn = ConnectionManager.getConexao();
            prepStmt = conn.prepareStatement(INSERT);
            prepStmt.setString(1,u.getNome());
            prepStmt.setString(2,u.getEmail());
            prepStmt.execute();
        } catch (SQLException e) {
            String msg = "[ProdutosDB][save(Produto p)]: " + e.getMessage();
            NerdException ge = new NerdException(msg, e);
            ge.print();
            throw ge;
        } finally {
            ConnectionManager.closeAll(conn, prepStmt, rs);
        }

    }
    
    public UsuarioBean getUsuarioById(int id) throws NerdException {

        Connection conn = null;
        PreparedStatement prepStmt = null;
        ResultSet rs = null;
        UsuarioBean oUsuario = null;

        try {
            conn = ConnectionManager.getConexao();
            prepStmt = conn.prepareStatement(SELECT_BYID);
            prepStmt.setInt(1, id);
            rs = prepStmt.executeQuery();
            if (rs.next()) {
                String nome = rs.getString("nome");
                String email = rs.getString("email");
                oUsuario = new UsuarioBean(nome,email);
            }
            return oUsuario;
        }
        catch (SQLException e) {
            String msg = "[ProdutosDB][getProdutoById()]: " + e.getMessage();
            NerdException ge = new NerdException(msg, e);
            ge.print();
            throw ge;
        } finally {
            ConnectionManager.closeAll(conn, prepStmt, rs);
        }

    }    
    
}

UsuariosDao:

package br.com.nerd.dao;

import br.com.nerd.beans.UsuarioBean;
import br.com.nerd.util.NerdException;

public interface UsuariosDao {

    public void gravarUsuario(UsuarioBean u) throws NerdException;
    public UsuarioBean getUsuarioById(int id) throws NerdException;
    
}

UsuarioBean:

package br.com.nerd.beans;

public class UsuarioBean {

    private int idusuario;
    private String nome;
    private String email;
    
    public UsuarioBean(String nome, String email){
        this.nome = nome;
        this.email = email;
    }
    
    public UsuarioBean(int idUsuario, String nome, String email){
        this(nome,email);
        this.idusuario = idUsuario;
    }
    
    public int getIdUsuario(){
        return this.idusuario;
    }

    public void setIdUsuario(int idUsuario){
        this.idusuario = idUsuario;
    }

    public String getNome(){
        return this.getNome();
    }
    
    public void setNome(String nome){
        this.nome = nome;
    }
    
    public String getEmail(){
        return this.email;
    }
    
    public void setEmail(String email){
        this.email = email;
    }
    
}

[code]UsuarioDao user = new UsuarioDao();
UsuarioBean bean = new UsuarioBean();

bean = (UsuarioBean) user.getUsuarioById(int id);
[/code]
Isso irá retornar o usuário que vc informou.

Ola WWatermann!
Montei a jsp com os camandos que vc me passou e esta dando este erro:

	UsuariosDao user = new UsuariosDao();
	UsuarioBean bean = new UsuarioBean();
	bean = (UsuarioBean) user.getUsuarioById(1);

mas gera o erro abaixo… pelo que sei nao posso instanciar uma interface…

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 24 in the jsp file: /index.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\jnerd\org\apache\jsp\index_jsp.java:74: br.com.nerd.dao.UsuariosDao is abstract; cannot be instantiated
	UsuariosDao user = new UsuariosDao();
                           ^


An error occurred at line: 24 in the jsp file: /index.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\jnerd\org\apache\jsp\index_jsp.java:75: cannot find symbol
symbol  : constructor UsuarioBean()
location: class br.com.nerd.beans.UsuarioBean
	UsuarioBean bean = new UsuarioBean();
                           ^
2 errors



	org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
	org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
	org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Resolvido o problema pessoal obrigado !!!