Tenhu uma classe CompanyDAO num siteminha que estou fazendo, com o seguinte método
public DefaultListModel getList() throws SQLException {
DefaultListModel lista = new DefaultListModel();
PreparedStatement stmt = this.connection.prepareStatement("SELECT * FROM COMPANY");
ResultSet rs;
try {
this.connection = new ConnectionFactory().getConnection();
rs = stmt.executeQuery();
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
connection.close();
}
while(rs.next()){
Company company = new Company();
company.setSigla(rs.getString("ID"));
company.setSigla(rs.getString("NAME"));
lista.addElement(company);
}
rs.close();
stmt.close();
return lista;
}
Então to fazendo uma JTable pra apresentar os dados do DB...
package visual;
import database.CompanyDAO;
import javax.swing.DefaultListModel;
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
/**
* @author Jefferson Santana Silva
*/
public class Consulta extends JFrame throws SQLException {
public static final int ROWS = 10;
String[] columnNames = {"Sigla","Nome"};
JTable table = new JTable(new DefaultTableModel(columnNames,ROWS));
DefaultListModel lista = new CompanyDAO().getList();
}
Mas aparece o erro...
'{' expected
public class Consulta extends JFrame throws SQLException {
1 error