Vero l'avevo invertito ora non mi da nessun errore ma non mi compare la tabella
Posto tutto il codice
codice:
import java.awt.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import javax.swing.table.TableColumnModel;
import javax.swing.table.TableModel;
import net.proteanit.sql.DbUtils;
public class Frame1 extends javax.swing.JFrame{
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
private JPanel left,right;
public JTable tabella_busta;
private JButton mostra;
private JLabel operatore;
public Frame1(){
super ("Riparazione Orologi");
this.setSize(new Dimension(1027,768));
this.setDefaultCloseOperation(EXIT_ON_CLOSE);
this.setLayout(new BorderLayout());
conn = ConnessioneDb.connectDb();
initComponents();
//Update_table();
}
private void Update_table(){
try {
String sql= "select * from Buste";
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
tabella_busta.setModel(DbUtils.resultSetToTableModel(rs));//Aggiungere la libreria (rs2xml.jar)
pst.close();
rs.close();
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void initComponents() {
BorderLayout layout = new BorderLayout();
//pannello di sinistra
left = new JPanel();
TitledBorder titoloPLeft = new TitledBorder("Operazioni Buste");
left.setLayout(layout);
left.setBorder(titoloPLeft);
left.setPreferredSize(new Dimension(700,500));
//pannello di destra
right = new JPanel();
TitledBorder titoloPRight = new TitledBorder("Statistiche Buste");
right.setLayout(layout);
right.setBorder(titoloPRight);
//Bottoni
mostra = new JButton("Mostra");
mostra.setSize(100,20);
//right.add(mostra);
//Metto i Pannelli nel contenitore root
this.add(left, BorderLayout.LINE_START);
this.add(right,BorderLayout.WEST);
//Creo una Jtable Per le buste
try {
String sql= "select * from Buste";
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int numColonne = rsmd.getColumnCount();
Vector nomeColonne = new Vector();
for (int nr=0; nr<numColonne; nr++)
nomeColonne.add(rsmd.getColumnName(nr+1));
Vector <Vector> datiRighe = new Vector <Vector>();
while (rs.next()){
Vector<String> riga = new Vector<String>();
for (int nr=0; nr<numColonne; nr++) {
riga.add(String.valueOf(rs.getObject(nr+1)));//HO PROVATO A FARE IL CASTING
}
datiRighe.add(riga);
}
tabella_busta=new JTable(datiRighe,nomeColonne);
JScrollPane p = new JScrollPane(tabella_busta);
left.add(p);//La aggingo al pannello di sinistra
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, e);
}
}
public static void main(String[] args) {
new Frame1().setVisible(true);;
}
}
Rispondi quotando
