Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mysql;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- public class DeleteMain {
- private static final String DELETE_PRODUCT_QUERY =
- "DELETE FROM products WHERE name LIKE ?";
- public static void main(String[] args){
- String url = "jdbc:mysql://localhost:3306/products_ex";
- try(Connection connection = getConnection(url);
- PreparedStatement preparedStatement =
- connection.prepareStatement(DELETE_PRODUCT_QUERY);
- ){
- preparedStatement.setString(1, "%1%");
- int updateRecords = preparedStatement.executeUpdate();
- System.out.println("Deleted records count = " + updateRecords);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- private static Connection getConnection(String url) throws SQLException {
- return DriverManager.getConnection(url,"root", "root");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement