how to make prepared statement in java code example
Example: jdbc prepared statement example
String query = "INSERT INTO artikel VALUES (?, ?, ?, ?, ?)";
try {
PreparedStatement ps = con.prepareStatement(query);
ps.setInt(1, aNumb);
ps.setString(2, aName);
ps.setFloat(3, aPrice);
ps.setInt(4, aAvailable);
ps.setString(5, aInfo);
ps.executeUpdate();
ps.close();
disconnectDB();
}catch(SQLException e){
System.out.println(e.getMessage());
}