Witam,
Chciałbym pobrać dane z bazy do jLabel2 i jLabel4
Kod wygląda następująco:
package komis;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.*;
public class OknoBazaAut extends javax.swing.JFrame {
/** Creates new form OknoBazaAut */
public OknoBazaAut() {
super("Baza Aut");
initComponents();
}
@SuppressWarnings("unchecked")
//
private void wstecz(java.awt.event.ActionEvent evt) {
dispose();
new Menu().show();// TODO add your handling code here:
}
public void run() {
new OknoBazaAut().setVisible(true);
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try
{
Class.forName("org.firebirdsql.jdbc.FBDriver");// zaladowanie sterownika
connection = DriverManager.getConnection("jdbc:firebirdsql://localhost:3050/C:/BAZAAUT.gdb", "sysdba", "masterkey");
statement = connection.createStatement();
resultSet = statement.executeQuery("SELECT id_auta, marka, model, rocznik, przebieg, cena FROM auta");
while(resultSet.next()){
jLabel2.setText(resultSet.getString("id_auta"));
jLabel4.setText(resultSet.getString("marka"));
}
} catch (Exception e) {
e.printStackTrace();}
finally {
try {
resultSet.close();
statement.close();
connection.close();
}catch (Exception e) {
e.printStackTrace();
}
}
}