?? ????? Spring Boot 3? ?? ??? ??? ? Product ??? CRUD(Create, Read, Update, Delete) ??? ???? ? ??? ???????. ? ???? ?? Spring Boot ??? .NET Core ??? ???? .NET ???? Java ???? ???? ? ??? ??? ?????.

???? ??

???? ?? ?? ???? ?? Spring Boot ????? ???? ??? ?????.

• Spring Web: REST API ???.
• Spring Data JPA: ?????? ?????.
• PostgreSQL ????: PostgreSQL ?????? ???.

Docker? ???? ???? PostgreSQL ??

PostgreSQL? ???? ????? Docker? ???? ????? ??? ?????.

1. PostgreSQL ??? ????:
   

   docker pull postgres
   

2. PostgreSQL ???? ??:
   

   docker run --name postgres-db -e POSTGRES_PASSWORD=yourpassword -e POSTGRES_USER=yourusername -e POSTGRES_DB=mydatabase -p 5432:5432 -d postgres
   

   yourusername, yourpassword ? mydatabase? ??? ??? ??, ???? ? ?????? ???? ????.

3. ??????? ?? ??? ?????.
   

   docker ps
   

4. ?????? ?????(?: DBeaver, pgAdmin ?? psql)? ???? localhost:5432? ???? ??????? ???? ? ??? ?????.

pom.xml ?? ????

Maven? ???? ?? pom.xml ??? ?? ???? ???? ??? ?? ?????? ??? ? ??? ?????.

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>42.5.0</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

?? ???? ??? ?? ?? ????? ???? ??? ?????.

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

.NET Core?? ??:
.NET Core?? ??? ??? csproj ??? ???? ?????. PostgreSQL ?? ? API? ?? ??? ???? ??? ????.

<ItemGroup>
  <PackageReference Include="Microsoft.AspNetCore.App" />
  <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="6.0.0" />
</ItemGroup>

PostgreSQL ?????? ??

PostgreSQL ??????? ????? application.yml ??? ???????.

spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/mydatabase
    username: yourusername
    password: yourpassword
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
    hibernate:
      ddl-auto: update

mydatabase, yourusername ? yourpassword? ?? PostgreSQL ?????? ?? ??? ????. ddl-auto=update ??? Hibernate? ??? ??? ?? ???? ???? ????? ??????? ?????.

.NET Core?? ??:
.NET Core??? ??? ??? appsettings.json? ????.

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=localhost;Database=mydatabase;Username=yourusername;Password=yourpassword"
  },
  "EntityFramework": {
    "MigrationsAssembly": "YourProjectName"
  }
}

???? ?? ??

Spring Boot ????? ??? ???? ?????.

• ???: ??? ??? ?????.
• ???: ?????? ??? ?? ?????
• ????: REST ?????.
• ???(?? ??): ???? ??

? ??? .NET Core ????? ???? ??? ??, ???/?????, ???? ? ???? ?????.

1??: ?? ?? ??

Spring Boot?? ???? Entity Framework Core? ??? ???? ?????? ???? ?????. @Entity ? @Id? ?? ??? ???? ???? ???? ?????.

docker pull postgres

.NET Core? ??

docker run --name postgres-db -e POSTGRES_PASSWORD=yourpassword -e POSTGRES_USER=yourusername -e POSTGRES_DB=mydatabase -p 5432:5432 -d postgres

2??: ??? ??

Spring Boot?? ???? JpaRepository? ???? ????????. EF Core? DbContext? ??? ?? CRUD ??? ?????.

docker ps

.NET Core? ??

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>42.5.0</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

3??: ??? ?? ??(?? ??)

??? ??? ???? ??? ?????. ??????? ??? ???????? ?? ?????.

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

.NET Core? ??

<ItemGroup>
  <PackageReference Include="Microsoft.AspNetCore.App" />
  <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="6.0.0" />
</ItemGroup>

4??: ???? ??

????? ASP.NET Core??? ????? HTTP ??? ?????.

spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/mydatabase
    username: yourusername
    password: yourpassword
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
    hibernate:
      ddl-auto: update

.NET Core? ??

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=localhost;Database=mydatabase;Username=yourusername;Password=yourpassword"
  },
  "EntityFramework": {
    "MigrationsAssembly": "YourProjectName"
  }
}

5??: API ???

Postman ?? cURL? ?? ??? ???? ??????? ???? ?????? ??????. PostgreSQL ??????? ?? ??? ???? ???? ??? ?????.

??????? ???? Postman ?? cURL? ???? CRUD ?????? ??????. PostgreSQL? ?? ??? ???? ?????? ?????.

Postman?? ????? ???:

• GET /api/products: ?? ??? ?????.
• GET /api/products/{id}: ID?? ?? ??? ?????.
• POST /api/products: ? ??? ????.
• DELETE /api/products/{id}: ID?? ??? ?????.

?? ??

??

Spring Boot?? CRUD ??????? ??? ?? ?? .NET Core? ??? ?????? ?????. ??? ??, ORM ? RESTful API? ??? ? ????? ?????. ? ???? ??? ????. ?? ?????? Lombok ??, Swagger/OpenAPI, ??? ??, ?? ?? ? ?????? ??????? ?? ?????. ?? ??????!

??? ?????!

---

????

1. ??? ?? ??: https://spring.io/projects/spring-boot
2. PostgreSQL ??: https://www.postgresql.org/docs/
3. Spring ??? JPA ??: https://spring.io/projects/spring-data-jpa
4. .NET Core ???: https://docs.microsoft.com/en-us/aspnet/core/?view=aspnetcore-7.0

? ??? Spring Boot ?? .NET ??? ???? ?? Spring Boot?? ?? ??? CRUD ?????? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!