Ciao graze..ma non funzia ti mando esempio..
import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import net.proteanit.sql.DbUtils;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
public class provaTabella extends JFrame {
private JPanel contentPane;
private JTable tabellina;
private Connection connection;
private PreparedStatement pst;
private ResultSet rs;
private JButton btnNewButton;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
provaTabella frame = new provaTabella();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
public void refreshTable() {
connection = sqliteConnection.dbConnector();
try {
String query = "select * from Prodotti"; // la selezione di quello che voglio visualizzare del Database
pst = connection.prepareStatement(query);
ResultSet rs = pst.executeQuery();
tabellina.setModel(DbUtils.resultSetToTableModel(r s));
pst.close();
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* Create the frame.
*/
public provaTabella() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 750, 639);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(73, 68, 452, 186);
contentPane.add(scrollPane);
tabellina = new JTable();
((TableModel) tabellina).addTableModelListener(new TableModelListener() {
@Override
public void tableChanged(TableModelEvent e) {
if (e.getType() == TableModelEvent.UPDATE) {
if (e.getFirstRow() == e.getLastRow() && e.getColumn() >= 0) {
int riga = e.getFirstRow();
int colonna = e.getColumn();
System.out.println(riga+" "+colonna);
}
}
}
});
scrollPane.setViewportView(tabellina);
btnNewButton = new JButton("refresh1");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
refreshTable();
}
});
btnNewButton.setBounds(496, 566, 89, 23);
contentPane.add(btnNewButton);
}
}
Rispondi quotando
Originariamente inviata da antonello2
