配置参考 https://blog.csdn.net/u014386444/article/details/105874639/
1.导包
<dependency>
<groupId>com.xpand</groupId>
<artifactId>starter-canal</artifactId>
<version>0.0.1-SNAPSHOT</version>
</dependency>
2.配置
canal.client.instances.example.host=127.0.0.1
#canal.client.instances.example.host=111.111.111.111
canal.client.instances.example.port=11111
canal.client.instances.example.batchSize=1000
3.启动类
@SpringBootApplication
@EnableCanalClient
public class CanaTestApplication {
public static void main(String[] args) {
SpringApplication.run(CanaTestApplication.class, args);
}
}
4.业务
@CanalEventListener
@Component
public class MyEventListener {
//库名 表名
@ListenPoint(schema = "leadnews_article", table = {"ap_article"})
public void onEvent4(CanalEntry.EventType eventType, CanalEntry.RowData rowData) {
List<CanalEntry.Column> list = rowData.getBeforeColumnsList();
for (CanalEntry.Column column : list) {
System.out.print(column.getName()+"="+column.getValue()+"\t");
}
System.out.println();
List<CanalEntry.Column> columns = rowData.getAfterColumnsList();
for (CanalEntry.Column column : columns) {
System.err.print(column.getName()+"="+column.getValue()+"\t");
}
System.out.println();
}
}