”工欲善其事,必先利其器。“—孔子《论语.录灵公》
首页 > 编程 > D - 依赖倒置原理(DIP)

D - 依赖倒置原理(DIP)

发布于2024-11-03
浏览:727

D - Dependency Inversion Principle(DIP)

Before understanding DIP (Dependency Inversion Principle), it's important to know what High-Level and Low-Level modules and abstractions are.

High-Level Module:

A high-level module refers to the parts of an application that manage core features or business logic. These modules usually handle larger and more critical functions of the application. High-level modules generally perform broader and more complex tasks, and they might depend on other modules to get their work done.

For example, if you're building an e-commerce application, the Order Management System would be a high-level module. It handles major tasks such as taking orders, processing them, managing deliveries, and so on.

Low-Level Module:

Low-level modules, on the other hand, are responsible for specific and smaller tasks. These modules work at a fundamental level of the application and perform more detailed work, like storing data in the database, configuring network settings, etc. Low-level modules typically help the high-level modules carry out their tasks.

Continuing with the e-commerce example, the Payment Gateway Integration would be a low-level module. Its job is specifically to process payments, which is a more specialized task in comparison to the broader functionalities of the order management system.

Abstraction:

In simple terms, abstraction refers to a general idea or representation of a system or process. It defines what should happen but does not specify how it will happen. It focuses on the essential functionality without delving into the underlying implementation details.

Example:

Imagine you are going to drive a car. The concept of driving the car (i.e., abstraction) includes:

  • Starting the car
  • Stopping the car

However, the abstraction doesn't specify how these actions will be performed. It doesn't tell you what type of car it is, what kind of engine it has, or the specific mechanisms that make the car start or stop. It only provides the general idea of what needs to be done.

Abstraction in Software Design:

In software design, abstraction means creating a general contract or structure using an interface or an abstract class that defines a set of rules or actions, but the specific implementation of those actions is left separate. This allows you to define what needs to be done without specifying how it will be done.

Example:

You could have a PaymentInterface that declares a method for processing payments. The interface specifies that a payment must be processed, but it doesn't define how the payment will be processed. That can be done through different implementations such as PayPal, Stripe, or other payment methods.

In essence, abstraction focuses on the general functionality while leaving the implementation flexible, making it easier to change or extend in the future.

What is Dependency Inversion Principle(DIP) ?

According to the Dependency Inversion Principle (DIP), high-level modules should not depend directly on low-level modules. Instead, both should rely on abstractions, such as interfaces or abstract classes. This allows both high-level and low-level modules to work independently of each other, making the system more flexible and reducing the impact of changes.

Simplified Explanation:

Imagine you have an application with multiple features. If one feature directly depends on another, then modifying one will require changes across many parts of the code. The DIP suggests that instead of direct dependency, you should make different parts of your application work through a common interface or abstraction. This way, each module can function independently, and changes to one feature will have minimal impact on the rest of the system.

Two Key Points of DIP:

  • High-level modules should not depend on low-level modules. Instead, both should rely on abstractions.

  • There should be a dependency on abstractions, not on concrete (specific implementations).

Example:

Consider a payment system where you can use both PayPal and Stripe as payment methods. If you work directly with PayPal or Stripe, adding a new payment gateway later would require extensive code changes throughout your application.

However, if you follow DIP, you would use a general PaymentInterface. Both PayPal and Stripe would implement this interface. This way, if you want to add a new payment gateway in the future, you simply need to implement the existing interface, making the process much easier.

By following this principle, DIP enhances the maintainability and flexibility of your code, allowing for smoother adaptations and extensions without major disruptions.

Example 1:

Let's consider an application where you need to start and stop different types of vehicles. You can create a Vehicle interface that serves as an abstraction. Any vehicle can implement this interface to provide its own functionality.

Java Code:

 // Abstraction: Vehicle interface
interface Vehicle {
    void start();
    void stop();
}

// Car class implements Vehicle interface
class Car implements Vehicle {
    public void start() {
        System.out.println("Car started");
    }

    public void stop() {
        System.out.println("Car stopped");
    }
}

// Bike class implements Vehicle interface
class Bike implements Vehicle {
    public void start() {
        System.out.println("Bike started");
    }

    public void stop() {
        System.out.println("Bike stopped");
    }
}

// Main class
public class Main {
    public static void main(String[] args) {
        Vehicle car = new Car(); // Car as Vehicle
        car.start();
        car.stop();

        Vehicle bike = new Bike(); // Bike as Vehicle
        bike.start();
        bike.stop();
    }
}


Explanation:

Here, Vehicle serves as an abstraction that specifies what actions need to be performed (i.e., start and stop), but it does not define how those actions should be executed. The Car and Bike classes implement these methods according to their own logic. This design allows for the easy addition of new vehicle types, such as Truck, without altering the existing code.

Adding a New Vehicle: Truck
To add a new vehicle, you simply need to create a Truck class that implements the Vehicle interface and provides its own implementation of the start() and stop() methods.

Java Code for Truck:


class Truck implements Vehicle {
    public void start() {
        System.out.println("Truck started");
    }
    public void stop() {
        System.out.println("Truck stopped");
    }
}


Using Truck in the Main Class Without Any Changes:
Now, to include the Truck in the Main class, you can create an instance of Truck and use it as a Vehicle. No changes are necessary in the Main class or any other parts of the code.

Java Code for Main Class:


public class Main {
public static void main(String[] args) {
Vehicle car = new Car(); // Car as Vehicle
car.start();
car.stop();

    Vehicle bike = new Bike(); // Bike as Vehicle
    bike.start();
    bike.stop();

    // Adding Truck
    Vehicle truck = new Truck(); // Truck as Vehicle
    truck.start();
    truck.stop();
}

}

Output:
Copy code
Car started
Car stopped
Bike started
Bike stopped
Truck started
Truck stopped

Enter fullscreen mode Exit fullscreen mode




Explanation:

Here, the Truck has been added without making any changes to the existing code. The Truck class simply implements its own versions of the start() and stop() functions according to the Vehicle interface. There was no need to modify the Main class or any other part of the application. This demonstrates how the Dependency Inversion Principle (DIP) promotes flexibility and maintainability in code.

Benefits of DIP:

  • Scalability: New classes (like Truck) can be easily added to the system without affecting existing components.

  • Maintainability: The Main class and other high-level modules do not need to be modified when new features or vehicles are introduced.

  • Flexibility: It is possible to add new vehicles without relying on existing ones, allowing for easier integration of new functionality.

By adhering to the Dependency Inversion Principle, the system remains extensible and maintainable through the use of abstractions.

Importance of DIP:

In this context, Car, Bike, and Truck do not depend directly on the Main class. Instead, the Main class relies solely on the Vehicle abstraction. This means that if a new vehicle type is introduced, there is no need to make changes to the Main class. As a result, the code is much easier to maintain, and adaptability is significantly enhanced.

This approach not only reduces the risk of introducing bugs during modifications but also encourages better design practices by promoting loose coupling between components.

Example 2:

Let's say you want to create a notification system that can send different types of notifications, such as Email, SMS, or Push Notifications. If you directly rely on the Email or SMS classes, adding a new notification method would require changes throughout your code, violating the Dependency Inversion Principle (DIP).

Solution:

We will create an abstraction called Notifier, which will only specify what needs to be done (send notification) without defining how to do it. Different notifier classes (Email, SMS, Push) will implement this functionality in their own way.

JavaScript Code:


// Abstraction: Notifier
class Notifier {
sendNotification(message) {
throw new Error("Method not implemented.");
}
}

// EmailNotifier implements Notifier
class EmailNotifier extends Notifier {
sendNotification(message) {
console.log(Sending email: ${message});
}
}

// SMSNotifier implements Notifier
class SMSNotifier extends Notifier {
sendNotification(message) {
console.log(Sending SMS: ${message});
}
}

// PushNotifier implements Notifier
class PushNotifier extends Notifier {
sendNotification(message) {
console.log(Sending Push Notification: ${message});
}
}

// Usage
function sendAlert(notifier, message) {
notifier.sendNotification(message);
}

// Test different notifiers
const emailNotifier = new EmailNotifier();
const smsNotifier = new SMSNotifier();
const pushNotifier = new PushNotifier();

sendAlert(emailNotifier, "Server is down!"); // Sending email
sendAlert(smsNotifier, "Server is down!"); // Sending SMS
sendAlert(pushNotifier,"Server is down!"); // Sending Push Notification




Explanation:

  • Notifier is the abstraction that specifies that a notification needs to be sent.

  • EmailNotifier, SMSNotifier, and PushNotifier implement the Notifier rules in their own ways.

  • The sendAlert function only depends on the Notifier abstraction, not on any specific notifier. Therefore, if we want to add a new notifier, there will be no need to change the existing code.

Why DIP is Important Here:

To add a new notification method (like WhatsApp), we simply need to create a new class that implements Notifier, and the rest of the code will remain unchanged.

Example 3:

Let’s say you are creating an e-commerce site where payments need to be processed using various payment gateways (like PayPal and Stripe). If you directly rely on PayPal or Stripe, making changes or adding a new gateway would require significant alterations to your code, violating the Dependency Inversion Principle (DIP).

Solution:

We will create an abstraction called PaymentGateway. Any payment gateway will operate according to this abstraction, so adding a new gateway will not require changes to other parts of the code.

JavaScript Code:


// Abstraction: PaymentGateway
class PaymentGateway {
processPayment(amount) {
throw new Error("Method not implemented.");
}
}

// PayPal class implements PaymentGateway
class PayPal extends PaymentGateway {
processPayment(amount) {
console.log(Processing $${amount} payment through PayPal);
}
}

// Stripe class implements PaymentGateway
class Stripe extends PaymentGateway {
processPayment(amount) {
console.log(Processing $${amount} payment through Stripe);
}
}

// Usage
function processOrder(paymentGateway, amount) {
paymentGateway.processPayment(amount);
}

// Test different payment gateways
const paypal = new PayPal();
const stripe = new Stripe();

processOrder(paypal, 100); // Processing $100 payment through PayPal
processOrder(stripe, 200); // Processing $200 payment through Stripe




Explanation:

  • PaymentGateway is an abstraction that specifies the requirement to process payments.

  • The PayPal and Stripe classes implement this abstraction in their own ways.

  • The processOrder function only depends on the PaymentGateway abstraction, so if you want to add a new gateway (like Bitcoin), you don’t need to make any changes to the existing code.

DIP is Important Here:

If you need to add a new payment gateway, you simply create a new class that implements the PaymentGateway, and there will be no changes to the core code. This makes the code more maintainable and flexible.

DIP কেন গুরুত্বপূর্ণ?

1. Maintainability: নতুন কিছু যোগ করতে বা পরিবর্তন করতে হলে বড় কোড পরিবর্তন করতে হয় না। DIP মেনে abstraction ব্যবহার করে সিস্টেমকে সহজে মেইনটেইন করা যায়।

2. Flexibility: নতুন ফিচার যোগ করা অনেক সহজ হয়ে যায় কারণ high-level module এবং low-level module আলাদা থাকে।

3. Scalability: DIP এর মাধ্যমে সিস্টেমে নতুন ফিচার বা ফাংশনালিটি যোগ করা সহজ এবং দ্রুত করা যায়।

4. Decoupling: High-level module এবং low-level module সরাসরি একে অপরের উপর নির্ভর না করে abstraction এর মাধ্যমে কাজ করে, যা সিস্টেমের dependencies কমিয়ে দেয়।

Dependency Inversion Principle(DIP) in React

The Dependency Inversion Principle (DIP) can make React applications more modular and maintainable. The core idea of DIP is that high-level components should not depend on low-level components or specific implementations; instead, they should work with a common rule or structure (abstraction).

To implement this concept in React, we typically use props, context, or custom hooks. As a result, components are not directly tied to specific data or logic but operate through abstractions, which facilitates easier changes or the addition of new features in the future.

Example:

  • If you are building an authentication system, instead of directly relying on Firebase, create an abstraction called AuthService. Any authentication service (like Firebase or Auth0) can work according to this abstraction, allowing you to change the authentication system without altering the entire codebase.

  • Similarly, when making API calls, instead of depending directly on fetch or Axios, you can use an abstraction called ApiService. This ensures that the rules for making API calls remain consistent while allowing changes to the implementation.

By adhering to DIP, your components remain reusable, flexible, and maintainable.

Example 1: Authentication Service

You are building a React application where users need to log in using various authentication services (like Firebase and Auth0). If you directly work with Firebase or Auth0, changing the service would require significant code modifications.

Solution:

By using the AuthService abstraction and adhering to the Dependency Inversion Principle (DIP), you can create an authentication system that allows different authentication services to work together.

JSX Code:


import React, { createContext, useContext } from "react";

// Abstraction: AuthService
const AuthServiceContext = createContext();

// FirebaseAuth implementation
const firebaseAuth = {
login: (username, password) => {
console.log(Logging in ${username} using Firebase);
},
logout: () => {
console.log("Logging out from Firebase");
}
};

// Auth0 implementation
const auth0Auth = {
login: (username, password) => {
console.log(Logging in ${username} using Auth0);
},
logout: () => {
console.log("Logging out from Auth0");
}
};

// AuthProvider component for dependency injection
const AuthProvider = ({ children, authService }) => {
return (

{children}

);
};

// Custom hook to access the AuthService
const useAuthService = () => {
return useContext(AuthServiceContext);
};

// Login component that depends on abstraction
const Login = () => {
const authService = useAuthService();

const handleLogin = () => {
authService.login("username", "password");
};

return ;
};

// App component
const App = () => {
return (



);
};

export default App;




Explanation:

  • AuthServiceContext acts as a context that serves as an abstraction for the authentication service.

  • The AuthProvider component is responsible for injecting a specific authentication service (either Firebase or Auth0) into the context, allowing any child components to access this service.

  • The Login component does not directly depend on any specific service; instead, it uses the useAuthService hook to access the authentication abstraction. This means that if you change the authentication service in the AuthProvider, the Login component will remain unchanged and continue to work seamlessly.

This design pattern adheres to the Dependency Inversion Principle (DIP), promoting flexibility and maintainability in the application.

Example 2: API Service Layer with Functional Components

You are making various API calls using fetch or Axios. If you work directly with fetch or Axios, changing the API service would require numerous code changes.

Solution:

We will create an abstraction called ApiService, which will adhere to the Dependency Inversion Principle (DIP) for making API calls. This way, if the service changes, the components will remain unchanged.

JSX Code:


import React, { createContext, useContext } from "react";

// Abstraction: ApiService
const ApiServiceContext = createContext();

// Fetch API implementation
const fetchApiService = {
get: async (url) => {
const response = await fetch(url);
return response.json();
},
post: async (url, data) => {
const response = await fetch(url, {
method: "POST",
body: JSON.stringify(data),
headers: { "Content-Type": "application/json" }
});
return response.json();
}
};

// Axios API implementation (for example purposes, similar API interface)
const axiosApiService = {
get: async (url) => {
const response = await axios.get(url);
return response.data;
},
post: async (url, data) => {
const response = await axios.post(url, data);
return response.data;
}
};

// ApiProvider for injecting the service
const ApiProvider = ({ children, apiService }) => {
return (

{children}

);
};

// Custom hook to use the ApiService
const useApiService = () => {
return useContext(ApiServiceContext);
};

// Component using ApiService abstraction
const DataFetcher = () => {
const apiService = useApiService();

const fetchData = async () => {
const data = await apiService.get("https://jsonplaceholder.typicode.com/todos");
console.log(data);
};

return ;
};

// App component
const App = () => {
return (



);
};

export default App;




Explanation:

  • ApiServiceContext is a context that serves as an abstraction for making API calls.

  • The ApiProvider component injects a specific API service.

  • The DataFetcher component does not directly depend on fetch or Axios; it relies on the abstraction instead. If you need to switch from fetch to Axios, you won't need to modify the component.

Example 3: Form Validation with Functional Components

You have created a React app where form validation is required. If you write the validation logic directly inside the component, any changes to the validation logic would require modifications throughout the code.

Solution:

We will create an abstraction called FormValidator. Different validation libraries (such as Yup or custom validation) will work according to this abstraction.

JSX Code:


import React from "react";

// Abstraction: FormValidator
const FormValidatorContext = React.createContext();

// Yup validator implementation
const yupValidator = {
validate: (formData) => {
console.log("Validating using Yup");
return true; // Dummy validation
}
};

// Custom validator implementation
const customValidator = {
validate: (formData) => {
console.log("Validating using custom logic");
return true; // Dummy validation
}
};

// FormValidatorProvider for injecting the service
const FormValidatorProvider = ({ children, validatorService }) => {
return (

{children}

);
};

// Custom hook to use the FormValidator
const useFormValidator = () => {
return React.useContext(FormValidatorContext);
};

// Form component using FormValidator abstraction
const Form = () => {
const validator = useFormValidator();

const handleSubmit = () => {
const formData = { name: "John Doe" };
const isValid = validator.validate(formData);
console.log("Is form valid?", isValid);
};

return ;
};

// App component
const App = () => {
return (



);
};

export default App;




Explanation:

  • FormValidatorContext acts as an abstraction for form validation.

  • The FormValidatorProvider component injects a specific validation logic (e.g., Yup or custom logic).

  • The Form component does not depend directly on Yup or custom validation. Instead, it works with the abstraction. If the validation logic needs to be changed, such as switching from Yup to custom validation, the Form component will remain unchanged.

Disadvantages of Dependency Inversion Principle (DIP):

While the Dependency Inversion Principle (DIP) is a highly beneficial design principle, it also comes with some limitations or disadvantages. Below are some of the key drawbacks of using DIP:

1. Increased Complexity: Following DIP requires creating additional interfaces or abstract classes. This increases the structure's complexity, especially in smaller projects. Directly using low-level modules makes the code simpler, but adhering to DIP requires introducing multiple abstractions, which can add complexity.

2. Overhead of Managing Dependencies: Since high-level and low-level modules are not directly connected, additional design patterns like dependency injection or context are needed to manage dependencies. This increases the maintenance overhead of the project.

3. Unnecessary for Small Projects: In smaller projects or in cases with fewer dependencies or low complexity, using DIP can be unnecessary. Implementing DIP creates additional abstractions that make the code more complicated, while directly using low-level modules can be simpler and more effective.

4. Performance Overhead: By introducing abstractions between high-level and low-level modules, there can be some performance overhead, especially if there are many abstraction layers. Each abstraction adds extra processing, which can slightly impact performance.

5. Misuse of Abstraction: Excessive or incorrect use of abstraction can reduce the readability and maintainability of the code. If abstractions are not thoughtfully implemented, they can create more disadvantages than the intended benefits of DIP.

6. Harder to Debug: Due to the use of abstractions and interfaces, debugging can become more challenging. Without directly working with the implementation, identifying where a problem originates from can take more time.

7. Dependency Injection Tools Required: Implementing DIP often requires using dependency injection frameworks or tools, which take time and effort to learn. Additionally, the use of these frameworks increases the complexity of the project.

Conclusion:

Although DIP is a powerful and beneficial principle, it does have its limitations. In smaller projects or less complex contexts, adhering to DIP may be unnecessary. Therefore, proper analysis is needed to determine when and where to apply this principle for the best results.

? Connect with me on LinkedIn:

I regularly share insights on JavaScript, Node.js, React, Next.js, software engineering, data structures, algorithms, and more. Let’s connect, learn, and grow together!

Follow me: Nozibul Islam

版本声明 本文转载于:https://dev.to/nozibul_islam_113b1d5334f/d-dependency-inversion-principledip-3m0?1如有侵犯,请联系[email protected]删除
最新教程 更多>
  • 为什么HTML无法打印页码及解决方案
    为什么HTML无法打印页码及解决方案
    无法在html页面上打印页码? @page规则在@Media内部和外部都无济于事。 HTML:Customization:@page { margin: 10%; @top-center { font-family: sans-serif; font-weight: bo...
    编程 发布于2025-07-02
  • C++成员函数指针正确传递方法
    C++成员函数指针正确传递方法
    如何将成员函数置于c 的函数时,接受成员函数指针的函数时,必须同时提供对象的指针,并提供指针和指针到函数。需要具有一定签名的功能指针。要通过成员函数,您需要同时提供对象指针(此)和成员函数指针。这可以通过修改Menubutton :: SetButton()(如下所示:[&& && && &&华)...
    编程 发布于2025-07-02
  • 我可以将加密从McRypt迁移到OpenSSL,并使用OpenSSL迁移MCRYPT加密数据?
    我可以将加密从McRypt迁移到OpenSSL,并使用OpenSSL迁移MCRYPT加密数据?
    将我的加密库从mcrypt升级到openssl 问题:是否可以将我的加密库从McRypt升级到OpenSSL?如果是这样,如何?答案:是的,可以将您的Encryption库从McRypt升级到OpenSSL。可以使用openssl。附加说明: [openssl_decrypt()函数要求iv参...
    编程 发布于2025-07-02
  • 如何使用替换指令在GO MOD中解析模块路径差异?
    如何使用替换指令在GO MOD中解析模块路径差异?
    在使用GO MOD时,在GO MOD 中克服模块路径差异时,可能会遇到冲突,其中3个Party Package将另一个PAXPANCE带有导入式套件之间的另一个软件包,并在导入式套件之间导入另一个软件包。如回声消息所证明的那样: go.etcd.io/bbolt [&&&&&&&&&&&&&&&&...
    编程 发布于2025-07-02
  • 如何使用Python的请求和假用户代理绕过网站块?
    如何使用Python的请求和假用户代理绕过网站块?
    如何使用Python的请求模拟浏览器行为,以及伪造的用户代理提供了一个用户 - 代理标头一个有效方法是提供有效的用户式header,以提供有效的用户 - 设置,该标题可以通过browser和Acterner Systems the equestersystermery和操作系统。通过模仿像Chro...
    编程 发布于2025-07-02
  • 为什么PYTZ最初显示出意外的时区偏移?
    为什么PYTZ最初显示出意外的时区偏移?
    与pytz 最初从pytz获得特定的偏移。例如,亚洲/hong_kong最初显示一个七个小时37分钟的偏移: 差异源利用本地化将时区分配给日期,使用了适当的时区名称和偏移量。但是,直接使用DateTime构造器分配时区不允许进行正确的调整。 example pytz.timezone(...
    编程 发布于2025-07-02
  • 为什么我会收到MySQL错误#1089:错误的前缀密钥?
    为什么我会收到MySQL错误#1089:错误的前缀密钥?
    mySQL错误#1089:错误的前缀键错误descript [#1089-不正确的前缀键在尝试在表中创建一个prefix键时会出现。前缀键旨在索引字符串列的特定前缀长度长度,可以更快地搜索这些前缀。了解prefix keys `这将在整个Movie_ID列上创建标准主键。主密钥对于唯一识别...
    编程 发布于2025-07-02
  • 如何使用不同数量列的联合数据库表?
    如何使用不同数量列的联合数据库表?
    合并列数不同的表 当尝试合并列数不同的数据库表时,可能会遇到挑战。一种直接的方法是在列数较少的表中,为缺失的列追加空值。 例如,考虑两个表,表 A 和表 B,其中表 A 的列数多于表 B。为了合并这些表,同时处理表 B 中缺失的列,请按照以下步骤操作: 确定表 B 中缺失的列,并将它们添加到表的末...
    编程 发布于2025-07-02
  • 为什么不````''{margin:0; }`始终删除CSS中的最高边距?
    为什么不````''{margin:0; }`始终删除CSS中的最高边距?
    在CSS 问题:不正确的代码: 全球范围将所有余量重置为零,如提供的代码所建议的,可能会导致意外的副作用。解决特定的保证金问题是更建议的。 例如,在提供的示例中,将以下代码添加到CSS中,将解决余量问题: body H1 { 保证金顶:-40px; } 此方法更精确,避免了由全局保证金重置引...
    编程 发布于2025-07-02
  • 将图片浮动到底部右侧并环绕文字的技巧
    将图片浮动到底部右侧并环绕文字的技巧
    在Web设计中围绕在Web设计中,有时可以将图像浮动到页面右下角,从而使文本围绕它缠绕。这可以在有效地展示图像的同时创建一个吸引人的视觉效果。 css位置在右下角,使用css float and clear properties: img { 浮点:对; ...
    编程 发布于2025-07-02
  • 如何限制动态大小的父元素中元素的滚动范围?
    如何限制动态大小的父元素中元素的滚动范围?
    在交互式接口中实现垂直滚动元素的CSS高度限制问题:考虑一个布局,其中我们具有与用户垂直滚动一起移动的可滚动地图div,同时与固定的固定sidebar保持一致。但是,地图的滚动无限期扩展,超过了视口的高度,阻止用户访问页面页脚。$("#map").css({ marginT...
    编程 发布于2025-07-02
  • MySQL中如何高效地根据两个条件INSERT或UPDATE行?
    MySQL中如何高效地根据两个条件INSERT或UPDATE行?
    在两个条件下插入或更新或更新 solution:的答案在于mysql的插入中...在重复键更新语法上。如果不存在匹配行或更新现有行,则此功能强大的功能可以通过插入新行来进行有效的数据操作。如果违反了唯一的密钥约束。实现所需的行为,该表必须具有唯一的键定义(在这种情况下为'名称'...
    编程 发布于2025-07-02
  • 如何处理PHP文件系统功能中的UTF-8文件名?
    如何处理PHP文件系统功能中的UTF-8文件名?
    在PHP的Filesystem functions中处理UTF-8 FileNames 在使用PHP的MKDIR函数中含有UTF-8字符的文件很多flusf-8字符时,您可能会在Windows Explorer中遇到comploreer grounder grounder grounder gro...
    编程 发布于2025-07-02
  • 在Pandas中如何将年份和季度列合并为一个周期列?
    在Pandas中如何将年份和季度列合并为一个周期列?
    pandas data frame thing commans date lay neal and pree pree'和pree pree pree”,季度 2000 q2 这个目标是通过组合“年度”和“季度”列来创建一个新列,以获取以下结果: [python中的concate...
    编程 发布于2025-07-02
  • 如何克服PHP的功能重新定义限制?
    如何克服PHP的功能重新定义限制?
    克服PHP的函数重新定义限制在PHP中,多次定义一个相同名称的函数是一个no-no。尝试这样做,如提供的代码段所示,将导致可怕的“不能重新列出”错误。 但是,PHP工具腰带中有一个隐藏的宝石:runkit扩展。它使您能够灵活地重新定义函数。 runkit_function_renction_re...
    编程 发布于2025-07-02

免责声明: 提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发到邮箱:[email protected] 我们会第一时间内为您处理。

Copyright© 2022 湘ICP备2022001581号-3