package mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UpdateMain {

    private static final String UPDATE_PRODUCT_QUERY =
            "UPDATE products SET description = ? 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(UPDATE_PRODUCT_QUERY);
        ){

            preparedStatement.setString(1, "new descript");
            preparedStatement.setString(2, "A%");

            int updateRecords = preparedStatement.executeUpdate();
            System.out.println("Updated record count = " + updateRecords);

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private static Connection getConnection(String url) throws SQLException {
        return DriverManager.getConnection(url,"root", "root");
    }
}