Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("com.mysql.jdbc.Driver");
- System.out.println("Caricamento Diver");
- }catch(ClassNotFoundException e) {
- }
- String url = "jdbc:mysql://localhost:3306/scrum?user=root&password=";
- System.out.println("Connessione al database in corso...");
- try (Connection connection = DriverManager.getConnection(url)) {
- System.out.println("Database connesso!");
- Statement stm = connection.createStatement();
- Statement stm1 = connection.createStatement();
- //controllo credenziali
- ResultSet rs = stm.executeQuery("SELECT idAttività FROM soggetto");
- ResultSet rs1 = stm1.executeQuery("SELECT Nominativo FROM soggetto");
- while (rs.next() && rs1.next()) {
- cB.getItems().add(rs.getString("idAttività")+ " " + rs1.getString("Nominativo"));
- //combo = rs.getString("idAttività") + rs.getString("Nominativo");
- }
- }catch(SQLException e) {
- throw new IllegalStateException("Impossibile connettersi al database!", e);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement