非常抱歉,以下是针对resource_node_management表的代码生成方法:
- 添加Spring Boot和MyBatis Plus依赖
在pom.xml文件中添加以下依赖:
<!-- Spring Boot 依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- MyBatis Plus 依赖 -->
<dependency>
<groupId>com.baomidou.mybatisplus</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
<!-- MySQL 驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version>
</dependency>
<!-- lombok插件(可选)-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
- 使用MyBatis Plus的代码生成器创建POJO类。
使用MyBatis Plus的代码生成器来创建实体类。请确保您正确设置了数据库连接信息,然后按照下面的步骤操作。
在resources目录下创建generator目录,并在该目录下创建generatorConfig.xml文件。将以下内容复制到该文件中:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/database_name?serverTimezone=UTC" userId="root"
password="">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<javaModelGenerator targetPackage="com.example.demo.entity" targetProject="./src/main/java">
<property name="enableSubPackages" value="true"/>
<property name="trimStrings" value="true"/>
<!-- 是否开启lombok -->
<!--<property name="lombok" value="@Data"/>-->
</javaModelGenerator>
<sqlMapGenerator targetPackage="mapper" targetProject="./src/main/resources">
<property name="enableSubPackages" value="true"/>
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER" targetPackage=
"com.example.demo.mapper"
targetProject="./src/main/java">
<property name="enableSubPackages" value ="true"/>
</javaClientGenerator>
<!-- resource_node_management为表名,修改成自己的表名 -->
<!--<table tableName = "resource_node_management"></table>-->
<!-- 可以添加多个<table>标签,同时生成多个实体类 -->
</context>
</generatorConfiguration>
修改上述代码中的数据库连接信息和包名,然后取消注释 <table>
标签并将其 tableName
属性值修改为您要创建实体类的表名称。
在pom.xml文件中添加以下插件:
<build>
<plugins>
<!-- MyBatis Generator 插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.4.0</version>
<configuration>
<!-- 配置文件路径 -->
<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
<!-- 允许覆盖 -->
<overwrite>true</overwrite>
<!-- 输出信息日志 -->
<!--<verbose>true</verbose>-->
</configuration>
<dependencies>
<!-- mysql 驱动依赖,如使用其他数据库则修改此处-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version><!-- MySQL 版本号 -->
</dependency>
<!-- mybatis-plus-boot-starter 依赖,保证和项目中的版本一致即可-->
<dependency>
<groupId>com.baomidou.mybatisplus</groupId>
<artifactId>mybatis-plus-generator</artifactId><!-- 注意这里是 mybatis-plus-generator,而非 mybatis-plus-boot-starter !-->
<!--<version>${mybatis.plus.version}</version>-->
<!--<scope>runtime</scope>-->
</dependency>
</dependencies>
</plugin>
</plugins>
...
</build>
然后在命令行中执行以下命令:
mvn mybatis-generator:generate
- 创建对应的Mapper接口。
创建一个Mapper接口,继承MyBatis Plus提供的BaseMapper接口即可。示例代码如下:
public interface ResourceNodeManagementMapper extends BaseMapper<ResourceNodeManagement> {
}
- 创建Service层接口和实现类。
Service层接口:
public interface ResourceNodeManagementService {
boolean save(ResourceNodeManagement resourceNodeManagement);
List<ResourceNodeManagement> list();
}
Service层实现类:
@Service
public class ResourceNodeManagementServiceImpl implements ResourceNodeManagementService {
@Autowired
private ResourceNodeManagementMapper resourceNodeManagementMapper;
@Override
public boolean save(ResourceNodeManagement resourceNodeManagement) {
return resourceNodeManagementMapper.insert(resourceNodeManagement) == 1;
}
@Override
public List<ResourceNodeManagement> list() {
return resourceNodeManagementMapper.selectList(null);
}
}
- 创建Controller层,提供相应的API接口。
@RestController
@RequestMapping("/api/resource_node_management")
public class ResourceNodeManangementController {
@Autowired
private ResourceNodeManangementService resourceNodeManangementService;
@PostMapping("/")
public boolean addResource(@RequestBody Resource resource) {
return resourceService.save(resource);
}
@GetMapping("/")
public List<Resource> listResources() {
return resourceService.list();
}
}
- 运行Spring Boot应用程序,并访问http://localhost:8080/api/resource_node_management/即可进行相应的API接口操作。