Jdbc

6 respostas
P

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Como soluciono esse problema???

Obrigado!

6 Respostas

Daniel_Quirino_Olive

Boa pergunta. Sem seu código fica um pouco difícil de tentar ajudar. Poste-o aqui (e coloque-o entre as tags code).

ramilani12

Pela exception vc esqueceu de declarar 1 paramtero ? :smiley:

alberto_ribeiro

manda o código… deve ter menos parametros do que espera-se.

espero ter ajudado.

Jair_Rillo_Junior

Paschoeto:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Como soluciono esse problema???

Obrigado!

A frase em negrito acima já diz tudo :wink:

P

Ae gente, foi mal o vacilo, sem o código fica difícil:

public Layout() {
    //ResultSet rs = new ResultSet();
    // TClientes.resultSet = rs;
    initComponents();
    try {
        url = "jdbc:odbc:Paschoetoserieshistoricas";
        
        Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
        connection = DriverManager.getConnection( url );
        output.append( "Connection successful\n" );
    } catch ( ClassNotFoundException cnfex ) {
// process ClassNotFoundExceptions here

cnfex.printStackTrace();

output.append( Connection unsuccessful\n +

cnfex.toString() );

} catch ( SQLException sqlex ) {

// process SQLExceptions here

sqlex.printStackTrace();

output.append( Connection unsuccessful\n +

sqlex.toString() );

} catch ( Exception ex ) {

// process remaining Exceptions here

ex.printStackTrace();

output.append( ex.toString() );

}

}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/** This method is called from within the constructor to

* initialize the form.

* WARNING: Do NOT modify this code. The content of this method is

* always regenerated by the Form Editor.

*/

// 

private void initComponents() {

jFrame1 = new javax.swing.JFrame();

PanelCliente = new javax.swing.JPanel();

Find = new javax.swing.JButton();

SClientes = new javax.swing.JButton();

NomeCliente = new javax.swing.JTextField();

try {

NomeSerie =(javax.swing.JTextField)java.beans.Beans.instantiate(getClass().getClassLoader(), Layout_jTextField2);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (java.io.IOException e) {

e.printStackTrace();

}

nCliente = new javax.swing.JLabel();

nSerie = new javax.swing.JLabel();

jScrollPane1 = new javax.swing.JScrollPane();

id = new javax.swing.JTextArea();

jScrollPane2 = new javax.swing.JScrollPane();

email = new javax.swing.JTextArea();

nID = new javax.swing.JLabel();

nEmail = new javax.swing.JLabel();

jScrollPane3 = new javax.swing.JScrollPane();

output = new javax.swing.JTextArea();

add = new javax.swing.JButton();

TituloCliente = new javax.swing.JLabel();

show = new javax.swing.JButton();

PanelSerie = new javax.swing.JPanel();

showSerie = new javax.swing.JButton();

findSerie = new javax.swing.JButton();

addSerie = new javax.swing.JButton();

addValue = new javax.swing.JButton();

NomeDaSerie = new javax.swing.JTextField();

jScrollPane4 = new javax.swing.JScrollPane();

idSerie = new javax.swing.JTextArea();

jScrollPane5 = new javax.swing.JScrollPane();

TpAgreg = new javax.swing.JTextArea();

jScrollPane6 = new javax.swing.JScrollPane();

Unidade = new javax.swing.JTextArea();

jScrollPane7 = new javax.swing.JScrollPane();

fonte = new javax.swing.JTextArea();

jScrollPane8 = new javax.swing.JScrollPane();

Tag = new javax.swing.JTextArea();

nSerieSerie = new javax.swing.JLabel();

nIDSerie = new javax.swing.JLabel();

nTp = new javax.swing.JLabel();

nUnidade = new javax.swing.JLabel();

nFonte = new javax.swing.JLabel();

jLabel10 = new javax.swing.JLabel();

tituloSerie = new javax.swing.JLabel();

cancel = new javax.swing.JButton();

help = new javax.swing.JButton();
org.jdesktop.layout.GroupLayout jFrame1Layout = new org.jdesktop.layout.GroupLayout(jFrame1.getContentPane());
    jFrame1.getContentPane().setLayout(jFrame1Layout);
    jFrame1Layout.setHorizontalGroup(
        jFrame1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(0, 400, Short.MAX_VALUE)
    );
    jFrame1Layout.setVerticalGroup(
        jFrame1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(0, 300, Short.MAX_VALUE)
    );

    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    setTitle("Consulta Banco Dados");
    setFont(new java.awt.Font("Arial", 1, 10));
    PanelCliente.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(102, 102, 102), 1, true));
    PanelCliente.setFont(new java.awt.Font("Dialog", 1, 12));
    Find.setText("Find");
    Find.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            FindActionPerformed(evt);
        }
    });

    SClientes.setText("Serie Clients");

    NomeCliente.setText("Entre com o nome do cliente");
    NomeCliente.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 153, 153)));

    nCliente.setText("Cliente:");

    nSerie.setText("Serie:");

    jScrollPane1.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane1.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    id.setColumns(20);
    id.setEditable(false);
    id.setRows(5);
    jScrollPane1.setViewportView(id);

    jScrollPane2.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane2.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    email.setColumns(20);
    email.setEditable(false);
    email.setRows(5);
    jScrollPane2.setViewportView(email);

    nID.setText("ID:");

    nEmail.setText("Email:");

    output.setColumns(20);
    output.setEditable(false);
    output.setLineWrap(true);
    output.setRows(5);
    output.setWrapStyleWord(true);
    output.setInheritsPopupMenu(true);
    jScrollPane3.setViewportView(output);

    add.setText("ADD");

    TituloCliente.setFont(new java.awt.Font("Dialog", 3, 18));
    TituloCliente.setText("tbClientes");

    show.setText("Show");
    show.addContainerListener(new java.awt.event.ContainerAdapter() {
        public void componentAdded(java.awt.event.ContainerEvent evt) {
            showComponentAdded(evt);
        }
    });

    org.jdesktop.layout.GroupLayout PanelClienteLayout = new org.jdesktop.layout.GroupLayout(PanelCliente);
    PanelCliente.setLayout(PanelClienteLayout);
    PanelClienteLayout.setHorizontalGroup(
        PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(PanelClienteLayout.createSequentialGroup()
            .addContainerGap()
            .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, PanelClienteLayout.createSequentialGroup()
                    .add(show)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(Find))
                .add(org.jdesktop.layout.GroupLayout.TRAILING, nEmail)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, nID)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, nSerie)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, nCliente))
            .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(PanelClienteLayout.createSequentialGroup()
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 141, Short.MAX_VALUE)
                    .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING, false)
                        .add(org.jdesktop.layout.GroupLayout.LEADING, NomeSerie)
                        .add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane1)
                        .add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane2)
                        .add(org.jdesktop.layout.GroupLayout.LEADING, jScrollPane3)
                        .add(NomeCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 626, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .add(PanelClienteLayout.createSequentialGroup()
                    .add(12, 12, 12)
                    .add(SClientes)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(add)
                    .add(217, 217, 217)
                    .add(TituloCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 139, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
            .addContainerGap())
    );
    PanelClienteLayout.setVerticalGroup(
        PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(PanelClienteLayout.createSequentialGroup()
            .addContainerGap()
            .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(PanelClienteLayout.createSequentialGroup()
                    .add(TituloCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 32, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(37, 37, 37)
                    .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(NomeCliente, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nCliente))
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(NomeSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nSerie))
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                        .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 20, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nID))
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                        .add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 21, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nEmail))
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jScrollPane3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(PanelClienteLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(Find)
                    .add(SClientes)
                    .add(add)
                    .add(show)))
            .addContainerGap())
    );

    PanelSerie.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(102, 102, 102)));
    showSerie.setText("Show");

    findSerie.setText("Find");

    addSerie.setText("ADD Serie");

    addValue.setText("ADD Value");

    NomeDaSerie.setText("Entre com o nome da s\u00e9rie");

    jScrollPane4.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane4.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    idSerie.setColumns(20);
    idSerie.setEditable(false);
    idSerie.setRows(5);
    jScrollPane4.setViewportView(idSerie);

    jScrollPane5.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane5.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    TpAgreg.setColumns(20);
    TpAgreg.setEditable(false);
    TpAgreg.setRows(5);
    jScrollPane5.setViewportView(TpAgreg);

    jScrollPane6.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane6.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    Unidade.setColumns(20);
    Unidade.setEditable(false);
    Unidade.setRows(5);
    jScrollPane6.setViewportView(Unidade);

    jScrollPane7.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane7.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    fonte.setColumns(20);
    fonte.setEditable(false);
    fonte.setRows(5);
    jScrollPane7.setViewportView(fonte);

    jScrollPane8.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    jScrollPane8.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
    Tag.setColumns(20);
    Tag.setEditable(false);
    Tag.setRows(5);
    jScrollPane8.setViewportView(Tag);

    nSerieSerie.setText("S\u00e9rie:");

    nIDSerie.setText("ID:");

    nTp.setText("TipoAgrega\u00e7\u00e3o:");

    nUnidade.setText("Unidade:");

    nFonte.setText("Fonte:");

    jLabel10.setText("Tag:");

    tituloSerie.setFont(new java.awt.Font("Dialog", 3, 18));
    tituloSerie.setText("tbSeries");

    org.jdesktop.layout.GroupLayout PanelSerieLayout = new org.jdesktop.layout.GroupLayout(PanelSerie);
    PanelSerie.setLayout(PanelSerieLayout);
    PanelSerieLayout.setHorizontalGroup(
        PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(org.jdesktop.layout.GroupLayout.TRAILING, PanelSerieLayout.createSequentialGroup()
            .addContainerGap()
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(nTp)
                .add(jLabel10)
                .add(nFonte)
                .add(nUnidade)
                .add(nIDSerie)
                .add(nSerieSerie)
                .add(PanelSerieLayout.createSequentialGroup()
                    .add(showSerie)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(findSerie)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(addSerie)
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(jScrollPane8, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(jScrollPane6, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(jScrollPane5, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(jScrollPane4, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(NomeDaSerie, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane7, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
                .add(PanelSerieLayout.createSequentialGroup()
                    .add(addValue)
                    .add(194, 194, 194)
                    .add(tituloSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 132, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
            .addContainerGap())
    );
    PanelSerieLayout.setVerticalGroup(
        PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(PanelSerieLayout.createSequentialGroup()
            .addContainerGap()
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(PanelSerieLayout.createSequentialGroup()
                    .add(tituloSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 44, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(35, 35, 35)
                    .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(NomeDaSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nSerieSerie))
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                        .add(jScrollPane4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(nIDSerie)))
                .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(showSerie)
                    .add(findSerie)
                    .add(addSerie)
                    .add(addValue)))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(jScrollPane5, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(nTp))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(jScrollPane6, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(nUnidade))
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(jScrollPane7, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 22, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(nFonte))
            .add(12, 12, 12)
            .add(PanelSerieLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                .add(jScrollPane8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(jLabel10))
            .addContainerGap(20, Short.MAX_VALUE))
    );

    cancel.setText("Cancel");
    cancel.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            cancelActionPerformed(evt);
        }
    });

    help.setText("Help");

    org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
        layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(layout.createSequentialGroup()
            .addContainerGap()
            .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                .add(PanelSerie, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
                    .add(help)
                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                    .add(cancel))
                .add(PanelCliente, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            .addContainerGap())
    );
    layout.setVerticalGroup(
        layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
        .add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
            .addContainerGap()
            .add(PanelCliente, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
            .add(PanelSerie, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
            .add(15, 15, 15)
            .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                .add(cancel)
                .add(help))
            .addContainerGap())
    );
    pack();
}// </editor-fold>

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void showComponentAdded(java.awt.event.ContainerEvent evt) {

}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

private void cancelActionPerformed(java.awt.event.ActionEvent evt) {

System.exit(0);

}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

private void FindActionPerformed(java.awt.event.ActionEvent evt) {

try {

if ( !NomeCliente.getText().equals( “” ) ) {

Statement statement =connection.createStatement();

String query = "SELECT * FROM tbClientes " +WHERE NomeCliente = '” +

NomeCliente.getText() + “’”;

output.append( "\nSending query: " +

connection.nativeSQL( query )

+ \n );

ResultSet rs = statement.executeQuery( query );

display( rs );

output.append( \nQuery successful\n );

statement.close();

} else

NomeCliente.setText(Enter last name here then press Find );

} catch ( SQLException sqlex ) {

sqlex.printStackTrace();

output.append( sqlex.toString() );

}

}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

public void display( ResultSet rs ) {

try {

rs.next();
int recordNumber = rs.getInt( 1 );

        if ( recordNumber != 0 ) {
            id.setText( String.valueOf( recordNumber));
            NomeCliente.setText( rs.getString( 2 ) );
            email.setText( rs.getString( 3 ) );

        } else
            output.append( "\nNo record found\n" );
    } catch ( SQLException sqlex ) {
        sqlex.printStackTrace();
        output.append( sqlex.toString() );
    }
}

ta ae!O código abaixo do comentário(gigante e confuso) foi gerado pelo netbeans. Antes esse cara funcionava!!!
Abs!

dbispo

Ao que parece, é um problema na query.
Revise-a. Poste também todo o stack trace. Não se esqueça da tag code.

[]'s

Criado 26 de outubro de 2006
Ultima resposta 26 de out. de 2006
Respostas 6
Participantes 6