Jtable+ jdbc+mysql[resolvido]

Assuntos Gerais
#1

olá estou com problemas para inserir dados do meu BD em uma jtable
quem souber da uma ajuda ae pessoal

[code]jCalendar1.getDayChooser().addPropertyChangeListener(new PropertyChangeListener(){
public void propertyChange(PropertyChangeEvent event) {
if ((“day”.equals(event.getPropertyName())) ||
(“month”.equals(event.getPropertyName())) ||
(“year”.equals(event.getPropertyName()))){

                Date data =new Date();
                data = jCalendar1.getDate();
                int dia = data.getDate();
                int mes = data.getMonth();
                mes++;
                int ano = data.getYear()+1900;
                String date= ano+"-"+mes+"-"+dia;
                
                
   
      try {    
       Class.forName("com.mysql.jdbc.Driver");    
       Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/bdprojeto", "root","admin");    

       int hr=0;

        for(int contl=1;contl<23;contl++){

      PreparedStatement stm = (PreparedStatement) conn.prepareStatement("select Nutricionista,paciente from consulta where hora=");  
       stm.execute(); 
       ResultSet rs = stm.getResultSet();  

 //while(rs.next()){ 
    if(rs.getString("Nutricionista")==null){
         jTable2.setValueAt(rs.getString(" "),contl,1);
         jTable2.setValueAt(rs.getString(" "),contl,2);
        }else{
       
        jTable2.setValueAt(rs.getString("Nutricionista"),contl,1);
        jTable2.setValueAt(rs.getString("paciente"),contl,2);

//}

}

}

   } catch (ClassNotFoundException ex) {    
       Logger.getLogger(ProjetoView.class.getName()).log(Level.SEVERE, null, ex);    
   } catch (SQLException ex) {    
       Logger.getLogger(ProjetoView.class.getName()).log(Level.SEVERE, null, ex);
   }


        }
        }
       }

);[/code]

ERRO
[color=red]12/06/2011 18:28:22 projeto.ProjetoView$5 propertyChange
GRAVE: null
java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841)
at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5650)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5570)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5610)
at projeto.ProjetoView$5.propertyChange(ProjetoView.java:219)
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:339)
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:276)
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:297)
at java.awt.Component.firePropertyChange(Component.java:8194)
at javax.swing.JComponent.firePropertyChange(JComponent.java:4456)
at com.toedter.calendar.JDayChooser.setDay(Unknown Source)
at com.toedter.calendar.JDayChooser.actionPerformed(Unknown Source)
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:6288)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6053)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:602)
at java.awt.EventQueue$1.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:616)
at java.awt.EventQueue$2.run(EventQueue.java:614)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
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)
[/color]

#2

Cara, quase certeza que é essa query incompleta aqui

"select Nutricionista,paciente from consulta where hora="

hora é igual a que, camarada???

#3

sim era isso e o
while(rs.next())
que eu tinha comentado tinha que estar la :roll:
vlw

#4