siXZTV0G

1import java.sql.*;
2
3
4public class Main {
5    public static void main(String[] args) {
6
7
8        final String url = "jdbc:mariadb://localhost:3306/jdbctest";
9        final String user = "root";
10        final String pass = "";
11
12
13        String CreateTableQuery = "CREATE TABLE IF NOT EXISTS testdaten ( PersonalNr int NOT NULL PRIMARY KEY, Nachname VARCHAR(255), Vorname VARCHAR(255))";
14
15        try(Connection conn = DriverManager.getConnection(url, user, pass);
16            Statement stmt = conn.createStatement();
17            ResultSet rs = stmt.executeQuery(CreateTableQuery)
18        ) {
19        } catch (SQLException e) {
20            throw new RuntimeException(e);
21        }
22
23
24        String InsertQuery = "INSERT INTO testdaten (PersonalNr, Nachname, Vorname) VALUES (2, 'Woods', 'Frank' )";
25
26
27        try(Connection conn = DriverManager.getConnection(url, user, pass);
28            Statement stmt = conn.createStatement();
29            ResultSet rs = stmt.executeQuery(InsertQuery)
30        ) {
31        } catch (SQLException e) {
32            throw new RuntimeException(e);
33        }
34
35
36        String SelectQuery=  "SELECT * FROM testdaten";
37
38        try(Connection conn = DriverManager.getConnection(url, user, pass);
39            Statement stmt = conn.createStatement();
40            ResultSet rs = stmt.executeQuery(SelectQuery)
41        ) {
42            while(rs.next()){
43                System.out.print("PersonalNr: " + rs.getInt("PersonalNr"));
44                System.out.print(" Nachname: " + rs.getString("Nachname"));
45                System.out.println(" Vorname: " + rs.getString("Vorname"));
46
47
48            }
49        } catch (SQLException e) {
50            throw new RuntimeException(e);
51        }
52    }}