91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

jdbcTemplate分頁徹底解決,使用游標滾動,看了Spring源碼才解決了問題

資源截圖

代碼片段和文件信息

package?com.utils;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.List;
import?java.util.Map;
import?java.sql.Types;

import?javax.sql.DataSource;

import?org.springframework.dao.DataAccessException;
import?org.springframework.jdbc.core.JdbcTemplate;
import?org.springframework.jdbc.core.PreparedStatementCreator;
import?org.springframework.jdbc.core.PreparedStatementCreatorFactory;
import?org.springframework.jdbc.core.RowMapper;

public?class?JdbcTemplateExtend?extends?JdbcTemplate?{
@Override
public?List?queryForList(String?arg0?object[]?arg1)
throws?DataAccessException?{
return?super.queryForList(arg0?arg1);
}

private?DataSource?dataSource;

/**
?*?默認構造器,調用此方法初始化,需要調用setDataSource設置數據源
?*/
public?JdbcTemplateExtend()?{
}

/**
?*?初始構造器
?*?
?*?@param?dataSource
?*????????????數據源
?*/
public?JdbcTemplateExtend(DataSource?dataSource)?{
this.dataSource?=?dataSource;
super.setDataSource(dataSource);
}

/**
?*?普通分頁查詢

?*?如果結果結合比較大應該調用setFetchsize()?和setMaxRow兩個方法來控制一下,否則會內存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?sql
?*????????????查詢的sql語句
?*?@param?startRow
?*????????????起始行
?*?@param?rowsCount
?*????????????獲取的行數
?*?@return
?*?@throws?DataAccessException
?*/
@SuppressWarnings(“unchecked“)
public?List?querySP(String?sql?int?startRow?int?rowsCount)
throws?DataAccessException?{
return?querySP(sql?startRow?rowsCount?getColumnMapRowMapper());
}

/**
?*?自定義行包裝器查詢

?*?如果結果結合比較大應該調用setFetchsize()?和setMaxRow兩個方法來控制一下,否則會內存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?sql
?*????????????查詢的sql語句
?*?@param?startRow
?*????????????起始行
?*?@param?rowsCount
?*????????????獲取的行數
?*?@param?rowMapper
?*????????????行包裝器
?*?@return
?*?@throws?DataAccessException
?*/
@SuppressWarnings(“unchecked“)
public?List?querySP(String?sql?int?startRow?int?rowsCount
RowMapper?rowMapper)?throws?DataAccessException?{
return?(List)?query(sql?new?SplitPageResultSetExtractor(rowMapper
startRow?rowsCount));
}

/**
?*?普通分頁查詢

?*?如果結果結合比較大應該調用setFetchsize()?和setMaxRow兩個方法來控制一下,否則會內存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?sql
?*????????????查詢的sql語句
?*?@param?startRow
?*????????????起始行
?*?@param?rowsCount
?*????????????獲取的行數
?*?@return
?*?@throws?DataAccessException
?*/
@SuppressWarnings(“unchecked“)
public?List?queryForListPagination(String?sql?object[]?arg1
int?startRow?int?rowsCount)?throws?DataAccessException?{
return?queryPagination(sql?arg1?startRow?rowsCount
getColumnMapRowMapper());
}

/**
?*?普通分頁查詢

?*?如果結果結合比較大應該調用setFetchsize()?和setMaxRow兩個方法來控制一下,否則會內存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?types[]
?*???????????傳遞參數的類型值?java.sql.Types.VARCHAR

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1902??2009-05-29?14:41??SplitPageResultSetExtractor.java

?????文件???????5331??2009-05-29?14:38??JdbcTemplateExtend.java

-----------?---------??----------?-----??----

?????????????????7233????????????????????2


評論

共有 條評論