SellerRepository (with insert).java

public class SellerRepository {

    private Connection conn;
    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");

    public SellerRepository(){
        ConnectionFactory connectionFactory = new ConnectionFactory();
        conn = connectionFactory.getConnection();
    }

    public void insert(){

        PreparedStatement statement = null;
        ResultSet resultSet = null;

        try {

            statement = conn.prepareStatement("INSERT INTO seller (Name, Email, BirthDate, BaseSalary, DepartmentId) VALUES (?, ?, ?, ?, ?)");

            statement.setString(1, "Jeff Cyan");
            statement.setString(2, "[email protected]");
            statement.setDate(3, new java.sql.Date(sdf.parse("22/04/1985").getTime()));
            statement.setDouble(4, 1500.0);
            statement.setInt(5, 4);

            int rowsAffected = statement.executeUpdate();

            System.out.println("Done! " + rowsAffected + " row(s) affected.");

        } catch (Exception e) {
            System.out.println(e.getMessage());
        }

    }
}