Forum:

Problems with Vector and JNDI

Greenhorn

Posts: 9

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please I need your help. I make class Artigos for list my BD MYSQL but I didn't make in page jsp index using Vector.
They see my class Artigos below

public class Artigo {

private int codigo;
private String assunto;
private String conteudo;
private int prioridade;

private Context ctx;
private DataSource ds;

public Connection conn;
public String mensagem = "";
 
/**
 * @param codigo
 * @param assunto
 * @param conteudo
 * @param prioridade
 */
public Artigo(int codigo, String assunto, String conteudo, int prioridade) {
this.codigo=codigo;
 this.assunto=assunto;
 this.conteudo=conteudo;
 this.prioridade=prioridade;
 }

public String getAssunto() {
return this.assunto;
}
 
public void setAssunto(String assunto) {
this.assunto = assunto;
}
 
public int getCodigo() {
return this.codigo;
}
 
public void setCodigo(int codigo) {
this.codigo = codigo;
}
public String getConteudo() {
return this.conteudo;
}
 
public void setConteudo(String conteudo) {
this.conteudo = conteudo;
}
 
public int getPrioridade() {
return this.prioridade;
}
 
public void setPrioridade(int prioridade) {
this.prioridade = prioridade;
}

public String getLista() {  
conecta();
    Vector x = new Vector(); // Here  I have doubts !!!!
try {
PreparedStatement sql = conn.prepareStatement("select * from artigos");
ResultSet rs = sql.executeQuery();
while (rs.next()) {
 x.appendElement(new Artigo(rs.getInt("codigo"),
 rs.getString("assunto"),
 rs.getString("conteudo"),
     rs.getInt("prioridade")));

}
rs.close();
conn.close(); // Volta conex�o para o pool
} catch (Exception ex) {
mensagem = ex.getMessage();
ex.getStackTrace();
}
return mensagem;
}
 
public void conecta() {
try {
ctx = new InitialContext(); // pega as configura��es do ambiente
if (ctx == null) {
throw new Exception("Falha no Context");
}
ds = (DataSource) ctx.lookup("java:comp/env/conecta");
conn = ds.getConnection(); // pega uma conex�o do pool
 
mensagem = "Conex�o: " + conn.toString();
} catch (Exception ex) {
mensagem = ex.getMessage();
ex.getStackTrace();
}
}

My index.jsp I don't know make!!!

Thanks ;)

Adriana

Bear Bibeault

Sheriff

Posts: 67637

173

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

"Ada Consultoria em Tecnologia",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

adriana cardoso

Greenhorn

Posts: 9

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ok modified

Thanks

Adriana

Bear Bibeault

Sheriff

Posts: 67637

173

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please read my message again: your display name must be a first and a last name separated by a space character.

[Asking smart questions] [About Bear] [Books by Bear]

adriana cardoso

Greenhorn

Posts: 9

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

ok modified !

Adriana

adriana cardoso

Greenhorn

Posts: 9

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please help me

Adriana

Ben Souther

Sheriff

Posts: 13411

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by Ada Consultoria em Tecnologia:
Please I need your help. I make class Artigos for list my BD MYSQL but I didn't make in page jsp index using Vector.
They see my class Artigos below

I'm not sure what you're saying.
Do you mean that the source code to your java class is showing up in the browser?

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf

adriana cardoso

Greenhorn

Posts: 9

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Yes, I need to use a command that lists all my objects of the MYQSL in the line that I placed a message of you doubt and later placing in my index.jsp that it shows the list.

Adriana

I didn't do it. You can't prove it. Nobody saw me. The sheep are lying! This tiny ad is my witness!

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat