`
fireinjava
  • 浏览: 476153 次
  • 性别: Icon_minigender_1
  • 来自: 福州
社区版块
存档分类
最新评论
收藏列表
标题 标签 来源
oracle 、 mysql分页 用了mybatis,我认为不需要再要写DAO 
/**
 * oracle page sql Processor
 */
public class OracleSqlProcessor implements SqlProcessor {
	public String pageSqlProcess(String sql) {
		StringBuilder sBuilder = new StringBuilder();
		sBuilder.append("select * from ( select a.*, rownum row_num from (").append(sql).append(") a where rownum <=  ? ) WHERE row_num > ? ");
		return sBuilder.toString();
	}
}

public class MySqlSqlProcessor implements SqlProcessor {
	// select * from Member limit 1000, 100
	public String pageSqlProcess(String sql) {
		StringBuilder sBuilder = new StringBuilder();
		sBuilder.append("select * from (").append(sql).append(" ) limit ? , ?");

		return sBuilder.toString();
	}
}
Global site tag (gtag.js) - Google Analytics