IntelliJ Save To Database with a Prepared Statement

Опубликовано: 28 Сентябрь 2024
на канале: Prof. Vanselow
1,075
7

final String sql = "INSERT INTO Bike (Make, Handlebars, Frame, Tyres, SeatType, NumGears) VALUES (?, ?, ?, ?, ?, ?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, make);
ps.setString(2, handlebars);
ps.setString(3, frame);
ps.setString(4, tyres);
ps.setString(5, seatType);
ps.setInt(6, numGears);

ps.executeUpdate();

https://docs.oracle.com/javase/tutori...
http://tutorials.jenkov.com/jdbc/prep...