package conexion;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Conect {
    public static void main(String[] args) {
        Connection connection = null;
        String url = "jdbc:mariadb://localhost:3306/bdclientes";
        String user = "root";
        String pwd = "6321";

        try {
            connection = DriverManager.getConnection(url, user, pwd);

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (connection != null) {
             try {
                connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
    public static void insertarcliente(Connection connection, String nombre, int nit) throws SQLException {
        String sql = "INSERT INTO clientes (nombre, nit) VALUES (?, ?)";
        try (PreparedStatement preparedStatement = connection.prepareStatement(sql)) {
            preparedStatement.setString(1, nombre);
            preparedStatement.setInt(2, nit);
            preparedStatement.executeUpdate();
            System.out.println("Cliente agregago");
        }
    }

    public static void LeerClientes(Connection connection) throws SQLException {
        String sql = "SELECT * FROM clientes";
        try (PreparedStatement preparedStatement = connection.prepareStatement(sql);
             ResultSet resultSet = preparedStatement.executeQuery()) {
            while (resultSet.next()) {
             String nombre = resultSet.getString("nombre");
             int nit = resultSet.getInt("nit");
             System.out.println("Nombre: " + nombre + ", Nit: " + nit);
            }
        }
    }

    public static void actualizarcliente(Connection connection, String nombre, int nit) throws SQLException {
        String sql = "UPDATE clientes  SET nit = ? WHERE nombre = ?";
        try (PreparedStatement preparedStatement = connection.prepareStatement(sql)) {
            preparedStatement.setString(2, nombre);
            preparedStatement.setInt(1, nit);
            preparedStatement.executeUpdate();
            System.out.println("Cliente ACTUALIZADO.");
        }
    }

    public static void eliminarcliente(Connection connection, String nombre) throws SQLException {
        String sql = "DELETE FROM clientes WHERE nombre = ?";
        try (PreparedStatement preparedStatement = connection.prepareStatement(sql)) {
            preparedStatement.setString(1, nombre);
            preparedStatement.executeUpdate();
            System.out.println("cliente eliminado");
        }
    }
}