1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
connection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\tosiba\\eclipse-workspace\\training1\\src\\training1\\BDD.db");
statement = connection.prepareStatement("SELECT Nom,Prenom,prix_du_loge,Type,Bloc,Etage,N°_du_loge,Verse_1,Verse_2,Verse_3,Verse_4,Verse_5,Verse_6,Verse_7,Verse_total,Verse_restant FROM Client WHERE Nom= ? AND Prenom= ? ");
statement.setString(1, comboBox_1.getSelectedItem().toString());
statement.setString(2, comboBox_2.getSelectedItem().toString());
ResultSet rs = statement.executeQuery();
table_1.setModel(DbUtils.resultSetToTableModel(rs));
table_1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table_1.getColumn("Nom").setPreferredWidth(120);
table_1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table_1.getColumn("Prenom").setPreferredWidth(120);
table_1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table_1.getColumn("Bloc").setPreferredWidth(40);
table_1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table_1.getColumn("Etage").setPreferredWidth(40);
statement.close();
connection.close(); |
Partager