eXtremeDb集成开发篇(Java)

2022-07-28 00:00:00 专区 数据管理 引入 实时 寒山

开发语言:Java

集成框架:Maven,Spring,Mybatis

1. 先新建spring框架(ssh或者用sprintboot随意,若无此基础,请先学习相应知识点)

2. resources下从eXtremeDb中引入extremedb.jar、extremedb_jdbc.jar

resources>lib>extremedb.jar

resources>lib>extremedb_jdbc.jar

3. 在pom.xml中引入依赖;maven中央仓库上无此依赖自行引入

<dependency>
<groupId>extremedb_jdbc.jar</groupId>
<artifactId>mcobject-extremedb-jdbc</artifactId>
<version>1.0.0</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/lib/extremedb_jdbc.jar</systemPath>
</dependency>
<dependency>
<groupId>extremedb.jar</groupId>
<artifactId>mcobject-extremedb</artifactId>
<version>1.0.0</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/lib/extremedb.jar</systemPath>
</dependency>
3. 在spring的application.properties中数据库配置数据库连接

spring.datasource.url=jdbc:extremedb:168.168.168.168:5001
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver-class-name=com.mcobject.jdbc.McoDriver
4. 新建Mabatis接口 HelloMapper.xml

import java.util.List;

public interface HelloMapper {
List<Hello> getInfo();
}


public class Hello {
private String iname;
private String msg;
}



<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="HelloMapper" >
<resultMap id="BaseResultMap" type="com.croot.rms.core.entity.Hello" >
<id column="iname" property="iname" jdbcType="VARCHAR" />
<result column="msg" property="msg" jdbcType="CHAR" />
</resultMap>
<select id="getInfo" resultMap="BaseResultMap">
select iname,msg from helloworld
</select>
</mapper>

5. service或者controller层使用mapper;


@Api(value = "HelloController", tags = "Hello")
@RestController
@RequestMapping("/hello")
public class HelloController {
@Autowired
private HelloMapperhelloMapper;

@ApiOperation(value = "world", notes = "world")
@PostMapping("/world")
public String world() {
List<Hello> info = helloMapper.getInfo();
return info.toString();
}
}
6. 通过请求测试即可

安装启动参考 eXtreamDb安装启动篇_z3191595的博客-CSDN博客

-- 有缘登山,寒山不寒
————————————————
版权声明:本文为CSDN博主「缘上寒山」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/z3191595/article/details/120318071

相关文章