xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 2.15 KB
    文件類型: .rar
    金幣: 1
    下載: 0 次
    發(fā)布日期: 2024-09-15
  • 語言: 其他
  • 標(biāo)簽: jdbcTemplate??pagination??

資源簡(jiǎn)介

jdbcTemplate分頁徹底解決,使用游標(biāo)滾動(dòng),看了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;

/**
?*?默認(rèn)構(gòu)造器,調(diào)用此方法初始化,需要調(diào)用setDataSource設(shè)置數(shù)據(jù)源
?*/
public?JdbcTemplateExtend()?{
}

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

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

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

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

?*?如果結(jié)果結(jié)合比較大應(yīng)該調(diào)用setFetchsize()?和setMaxRow兩個(gè)方法來控制一下,否則會(huì)內(nèi)存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?sql
?*????????????查詢的sql語句
?*?@param?startRow
?*????????????起始行
?*?@param?rowsCount
?*????????????獲取的行數(shù)
?*?@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));
}

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

?*?如果結(jié)果結(jié)合比較大應(yīng)該調(diào)用setFetchsize()?和setMaxRow兩個(gè)方法來控制一下,否則會(huì)內(nèi)存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?sql
?*????????????查詢的sql語句
?*?@param?startRow
?*????????????起始行
?*?@param?rowsCount
?*????????????獲取的行數(shù)
?*?@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());
}

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

?*?如果結(jié)果結(jié)合比較大應(yīng)該調(diào)用setFetchsize()?和setMaxRow兩個(gè)方法來控制一下,否則會(huì)內(nèi)存溢出
?*?
?*?@see?#setFetchSize(int)
?*?@see?#setMaxRows(int)
?*?@param?types[]
?*???????????傳遞參數(shù)的類型值?java.sql.Types.VARCHAR

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

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

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

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

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


評(píng)論

共有 條評(píng)論