entendi, mas acho que é isso msm, vc só pegou a conexão, mas nao abriu ela ainda, por isso quando vc manda fecha da pau…
tenta debuga a linha onde vc recupera a con, veja se ela vem normalmente.
__________JOptionPane.showMessageDialog(null,“Conexão estabelecida”,“Mensagem do Programa”,JOptionPane.INFORMATION_MESSAGE);
_____} catch (ClassNotFoundException ex) {
__________Logger.getLogger(DesktopApplication1View.class.getName()).log(Level.SEVERE, null, ex);
__________JOptionPane.showMessageDialog(null,“Conexão não estabelecida”,“Mensagem do Programa”,JOptionPane.INFORMATION_MESSAGE);
__________}
_____finally{
_____}
}
“FAVOR DESCONSIDERAR O _____ , É SÓMENTE A TABULACAO PRA MELHOR VISUALIZAR”
E os seguintes erros foram mostrados quando eu executei o programa e cliquei no botão:
run:
22/06/2009 15:53:02 desktopapplication1.DesktopApplication1View jButton1ActionPerformed
SEVERE: null
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Nome de fonte de dados muito longo
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at desktopapplication1.DesktopApplication1View.jButton1ActionPerformed(DesktopApplication1View.java:222)
at desktopapplication1.DesktopApplication1View.access$800(DesktopApplication1View.java:28)
at desktopapplication1.DesktopApplication1View$4.actionPerformed(DesktopApplication1View.java:129)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
BUILD SUCCESSFUL (total time: 6 seconds)
o grande problema de quando se inicia o desenvolvimento em uma linguagem sem saber NADA …sem curso e afins…é que qualquer coisa te empaca.
Coloquei essas linhas dentro do try, abaixo do “con = DriverManager.getConnection(url, usuario, senha);” :
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(“SELECT * FROM Tabela1 WHERE Cod=2”);
No " Statement st = con.createStatement(); " ele infoma “Incopatible types” … e pede pra trocar para “Statement st = (Statement) con.createStatement();”
tem alguma coisa haver?
E no “ResultSet rs = st.executeQuery(“SELECT * FROM Tabela1 WHERE Cod=2”);” ele da o erro “cannot find symbol”
o (Statement) se chama “cast”, digamos que é um jeito de vc falar de forma explicita que o objeto é desse tipo…
sobre o resultSet, nao sei, tentou substituir o * pelos nomes das colunas? se bem que acho que nda av…
entao, eu trokei a linha para " java.sql.Statement st = con.createStatement(); " e funcionou !
:X
o porque eu não sei, mas funcionando ta blz !
Agora, o “ResultSet rs = st.executeQuery(“SELECT cor FROM [_m_cad_cores] WHERE Cod=2”);” funciona
Mas na hora de eu jogar para uma caixa de texto ele da erro :
jTextField1.setText(rs.getString(“cor”));
O erro acontece em tempo de execução…quando eu clico no botão…
Ele manda um monte de msg no output:
run:
22/06/2009 16:34:11 desktopapplication1.DesktopApplication1View jButton1ActionPerformed
SEVERE: null
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Estado de cursor inválido
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:411)
at desktopapplication1.DesktopApplication1View.jButton1ActionPerformed(DesktopApplication1View.java:264)
at desktopapplication1.DesktopApplication1View.access$800(DesktopApplication1View.java:30)
at desktopapplication1.DesktopApplication1View$4.actionPerformed(DesktopApplication1View.java:135)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
" java.sql.Statement st = con.createStatement(); "
essa parada tava dando zica pq vc fez o import errado, pode ver que nos imports oq vc tem Statement nao é do msm pacote que esse que vc ta usando agora, e sobre o resultSet, debuga e ve se vem vindo algum dado, ou jpgue direto no banco e veja se vm algum registro.