import java.sql.*;
try (Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/app_db", "app_user", "secret")) {
try (Statement st = conn.createStatement()) {
st.execute("""
CREATE TABLE IF NOT EXISTS users(
id BIGINT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL
) ENGINE=InnoDB
""");
}
try (PreparedStatement ins = conn.prepareStatement("INSERT INTO users(name) VALUES (?)")) {
ins.setString(1, "Anna");
ins.executeUpdate();
}
try (PreparedStatement sel = conn.prepareStatement("SELECT id, name FROM users");
ResultSet rs = sel.executeQuery()) {
while (rs.next()) {
System.out.println(rs.getLong("id") + " " + rs.getString("name"));
}
}
}
import java.sql.*;
try (Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/app_db", "app_user", "secret")) {
try (Statement st = conn.createStatement()) {
st.execute("""
CREATE TABLE IF NOT EXISTS users(
id BIGINT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL
) ENGINE=InnoDB
""");
}
try (PreparedStatement ins = conn.prepareStatement("INSERT INTO users(name) VALUES (?)")) {
ins.setString(1, "Anna");
ins.executeUpdate();
}
try (PreparedStatement sel = conn.prepareStatement("SELECT id, name FROM users");
ResultSet rs = sel.executeQuery()) {
while (rs.next()) {
System.out.println(rs.getLong("id") + " " + rs.getString("name"));
}
}
}