Magic-API MCP Server

---
title: "自定义数据库方言"
date: "2022-01-30T10:13:25.000Z"
permalink: "/pages/senior/dialect/"
---
主要目的是为实现分页语句

编写java代码如下：

@Component
public class MyDialect implements Dialect {
    
    @Override
    public boolean match(String jdbcUrl) {
        // 根据jdbcUrl判断是否需要处理
        return jdbcUrl.contains(":mysql:");
    }

    @Override
    public String getPageSql(String sql, BoundSql boundSql, long offset, long limit) {
        boundSql.addParameter(offset);
        boundSql.addParameter(limit);
        return sql + " limit ?,?";
    }

}