1.MySql

驱动名称：com.mysql.cj.jdbc.Driver

连接地址：jdbc:mysql://IP:PORT/TABLE_NAME

分页语句：select * from 表名 limit startrow,pagesize

2.oracle

驱动名称：oracle.jdbc.driver.OracleDriver

连接地址：jdbc:oracle:thin:@://IP:PORT:SERVICENAME

分页语句：select * from (select a.*,rownum rc from 表名 where rownum<=endrow) a where a.rc>=startrow

3.达梦

驱动名称：dm.jdbc.driver.DmDriver

连接地址：jdbc:dm://IP:PORT;databaseName=TABLE_NAME

分页语句：select * from (select a.*,rownum rc from 表名 where rownum<=endrow) a where a.rc>=startrow

4.db2

驱动名称：com.ibm.db2.jcc.DB2Driver

连接地址：jdbc:db2://IP:PORT/TABLE_NAME

分页语句：select * from (select rownumber() over() as rc,a.* from (select * from 表名 order by 列名) as a) where rc between startrow and endrow

5.SQLserver

驱动名称：com.microsoft.sqlserver.jdbc.SQLServerDriver

连接地址：jdbc:sqlserver://IP:PORT;databaseName=TABLE_NAME

分页语句：

• Top Not IN 方式（查询靠前的数据较快）