Pessoal, estou com um probleminha em meu sistema.
Tenho uma agenda telefonica feita em java, onde posso pesquisar por nome e por referencia(palavra chave), quando pesquiso por nome, funciona tudo certo mas por referencia nao da certo. Da o seguinte erro.
cara,
esta meio dificil de te ajudar, manda o codigo pra gente dar uma olhada…
Falow
carioca
Aqui esta o codigo
importjavax.swing.*;importjavax.swing.event.*;importjava.awt.*;importjava.awt.event.*;importjava.io.*;importjava.sql.*;publicclassconsulta_agendaextendsJFrame{JLabell0,barra_hor;JTextFieldt1,t2,t3,t4,t5,t6,t7,t8;JButtonalterar,fechar;Containerc;Connectionconnection;intop=0;intmatr;publicconsulta_agenda(){super(".:GAMEACTION:.-Consultandoumtelefonenaagenda:");setLocation(0,0);c=newContainer();c=getContentPane();c.setLayout(newFlowLayout());Stringurl="jdbc:odbc:vet";Stringusername="anonymous";Stringpassword="guest";// Load the driver to allow connection to the databasetry{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");connection=DriverManager.getConnection(url,username,password);}catch(ClassNotFoundExceptioncnfex){System.err.println("FailedtoloadJDBC/ODBCdriver.");cnfex.printStackTrace();System.exit(1);// terminate program}catch(SQLExceptionsqlex){System.err.println("Nãofoipossívelconectar");sqlex.printStackTrace();}//------ADICIONANDO COMPONENTES barra_hor=newJLabel("");c.add(barra_hor);barra_hor=newJLabel("LOCADORAGAMEACTIONLTDA");c.add(barra_hor);barra_hor=newJLabel("CADASTRANDOUMTELEFONENAAGENDA");c.add(barra_hor);barra_hor=newJLabel("_____________________________________________________________________________________________________________");c.add(barra_hor);l0=newJLabel("Nome:");c.add(l0);t1=newJTextField(29);t1.setEditable(false);c.add(t1);l0=newJLabel("Referência:");c.add(l0);t2=newJTextField(29);t2.setEditable(false);c.add(t2);l0=newJLabel("Endereço:");c.add(l0);t3=newJTextField(19);t3.setEditable(false);c.add(t3);l0=newJLabel("Bairro:");c.add(l0);t4=newJTextField(17);t4.setEditable(false);c.add(t4);l0=newJLabel("Cidade:");c.add(l0);t5=newJTextField(17);t5.setEditable(false);c.add(t5);l0=newJLabel("TelefoneResidencial:");c.add(l0);t6=newJTextField(12);t6.setEditable(false);c.add(t6);l0=newJLabel("TelefoneComercial:");c.add(l0);t7=newJTextField(12);t7.setEditable(false);c.add(t7);l0=newJLabel("TelefoneCelular:");c.add(l0);t8=newJTextField(12);t8.setEditable(false);c.add(t8);alterar=newJButton("Alterar");c.add(alterar);fechar=newJButton("Fechar");c.add(fechar);setSize(800,575);show();fechar.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){dispose();}});alterar.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){if(op==0){t1.setEditable(true);t2.setEditable(true);t3.setEditable(true);t4.setEditable(true);t5.setEditable(true);t6.setEditable(true);t7.setEditable(true);t8.setEditable(true);alterar.setText("Salvar");op=1;fechar.setEnabled(false);repaint();}else{try{Statementstatement=connection.createStatement();Stringquery="UPDATEagendaSET"+"nome='"+t1.getText()+"',ref='"+t2.getText()+"',end='"+t3.getText()+"',bairro='"+t4.getText()+"',cidade='"+t5.getText()+"',foneres='"+t6.getText()+"',fonecom='"+t7.getText()+"',fonecel='"+t8.getText()+"'WHEREmatr="+matr;intresult=statement.executeUpdate(query);}catch(SQLExceptionsqlex){sqlex.printStackTrace();JOptionPane.showMessageDialog(null,sqlex.toString());}t1.setEditable(false);t2.setEditable(false);t3.setEditable(false);t4.setEditable(false);t5.setEditable(false);t6.setEditable(false);t7.setEditable(false);t8.setEditable(false);alterar.setText("Alterar");op=0;fechar.setEnabled(true);repaint();}}});try{RandomAccessFiletemp=newRandomAccessFile("dbtemp.dat","rw");matr=temp.readInt();temp.close();Statementstatement=connection.createStatement();Stringquery="SELECT*FROMagendaWHEREmatr="+matr;ResultSetrs=statement.executeQuery(query);rs.next();t1.setText(rs.getString(2));t2.setText(rs.getString(3));t3.setText(rs.getString(4));t4.setText(rs.getString(5));t5.setText(rs.getString(6));t6.setText(rs.getString(7));t7.setText(rs.getString(8));t8.setText(rs.getString(9));}catch(SQLExceptionsqlex){sqlex.printStackTrace();JOptionPane.showMessageDialog(null,sqlex.toString());}catch(IOExceptiontempex){JOptionPane.showMessageDialog(null,tempex.toString());}}}//main