Insertar Datos en Java

En el método save(Employee employee) implementamos la funcionalidad para insertar un nuevo registro de empleado en la base de datos.

Dentro del método, definimos una consulta SQL de inserción y la almacenamos en una variable de tipo String. Luego, utilizamos un objeto PreparedStatement para preparar la consulta y asignar los valores de los parámetros.

Una vez que todos los valores se han asignado, ejecutamos el método executeUpdate() del PreparedStatement para ejecutar la consulta y realizar la inserción en la base de datos.

Esta fue la forma que encontré de acuerdo a la clase

    @Override
    public void save(Employee employee) throws SQLException {
        String sql;

        if (employee.getId() < 1) {
            sql = "INSERT INTO employees(first_name, pa_surname, ma_surname, email, salary) VALUES(?, ?, ?, ?, ?)";
        } else {
            sql = "UPDATE employees set first_name = ?, pa_surname = ?, ma_surname = ?, email = ?, salary = ? WHERE id = ?";
        }

        try(PreparedStatement myStmt = getConnection().prepareStatement(sql)){

            myStmt.setString(1, employee.getFirst_name());
            myStmt.setString(2, employee.getPa_surname());
            myStmt.setString(3, employee.getMa_surname());
            myStmt.setString(4, employee.getEmail());
            myStmt.setFloat(5, employee.getSalary());

            if (employee.getId() != 0){
                myStmt.setInt(6, employee.getId());
            }

            int rows = myStmt.executeUpdate();

            if (rows > 0) {
                System.out.println("All that's good");
            } else {
                System.out.println("Something is going wrong");
            }
        }
    }```

Propuesta solución a reto

public void save(Landscapes landscape, Integer id) throws SQLException {
        String sql = null;
        String sqlins = "INSERT INTO landscapes (NameLands,Continent) VALUES (?,?)";
        String sqlupd = "UPDATE landscapes SET NameLands = ?, Continent = ? WHERE IDLands = "+id;
        if(id == 0)
            sql = sqlins;
        else
            sql = sqlupd;
        try (PreparedStatement myStamt = getConnection().prepareStatement(sql)) {
                myStamt.setString(1, landscape.getNameLands());
                myStamt.setString(2, landscape.getContinent());
                myStamt.executeUpdate();
            }
    }

Yo lo solucione de esta forma me gustaria me dieran retroalimentacion por favor:

@Override
    public void save(Employee employee) throws SQLException {


        if(employee.getId() != null && employee.getId() > 0){
           String sqlUpdate = "UPDATE " +
                    "employees SET first_name = ?, pa_surname= ?, ma_surname = ?, email = ?, salary= ?" +
                    "WHERE ID = ?";

            try(PreparedStatement myStamp = getConection().prepareStatement(sqlUpdate)){
                myStamp.setString(1, employee.getFirst_name());
                myStamp.setString(2, employee.getPa_surname());
                myStamp.setString(3, employee.getMa_surname());
                myStamp.setString(4, employee.getEmail());
                myStamp.setDouble(5, employee.getSalary());
                myStamp.setInt(6, employee.getId());

                myStamp.executeUpdate();
            }



        }else{
            String sql = "INSERT INTO employees(first_name, pa_surname, ma_surname, email, salary)" +
                    "VALUES(?, ?, ?, ?, ?)";

            try(PreparedStatement myStamp = getConection().prepareStatement(sql)){
                myStamp.setString(1, employee.getFirst_name());
                myStamp.setString(2, employee.getPa_surname());
                myStamp.setString(3, employee.getMa_surname());
                myStamp.setString(4, employee.getEmail());
                myStamp.setDouble(5, employee.getSalary());

                myStamp.executeUpdate();
            }
        }



    }

Se me hace muy extraño que el index que toman las funciones set del statement empiecen por 1 y no por 0 😆

Yo solamente agregue un pequeño if, aquí mi aporte:

public void save(Employee employee) throws SQLException {
        if (employee.getId() == null) {
            String sql = "INSERT INTO employees (first_name, pa_surname, ma_surname, email, salary) VALUES (?,?,?,?,?)";
            try(PreparedStatement myStamt = getConnection().prepareStatement(sql);) {
                myStamt.setString(1, employee.getFirst_name());
                myStamt.setString(2, employee.getPa_surname());
                myStamt.setString(3, employee.getMa_surname());
                myStamt.setString(4, employee.getEmail());
                myStamt.setFloat(5, employee.getSalary());
                myStamt.executeUpdate();
            }
        } else {
            String sql = "UPDATE employees SET first_name = ?, pa_surname = ?, ma_surname = ?, email = ?, salary = ? WHERE id = ?";
            try(PreparedStatement myStamt = getConnection().prepareStatement(sql);) {
                myStamt.setString(1, employee.getFirst_name());
                myStamt.setString(2, employee.getPa_surname());
                myStamt.setString(3, employee.getMa_surname());
                myStamt.setString(4, employee.getEmail());
                myStamt.setFloat(5, employee.getSalary());
                myStamt.setInt(6, employee.getId());
                myStamt.executeUpdate();
            }
        }

    }