简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

jdbc sqlserver 分页

WBOY
Release： 2016-06-07 15:39:41
Original
1220 people have browsed it

(1). top ... not in ， (2). top .... id（ max ），(3).游标 这种方法感觉比上面三种要快 ，分享一下跟好的意见 使用的是org.springframework.jdbc.core. JdbcTemplate limit = 25; public ListMapString, Object findAll(String type, final int start, f

(1). top  ... not in  ， (2). top .... id>（max），(3).游标 

这种方法感觉比上面三种要快 ，分享一下跟好的意见

使用的是 org.springframework.jdbc.core.JdbcTemplate


limit = 25;
public List> findAll(String type, final int start, final int limit) {
StringBuilder builder = new StringBuilder();
List params = new ArrayList();//给占位符赋值
builder.append("select top " + (start + limit)//第一页，start=0 （）select top 25 * ,第二页 start=25 （select top 50 *）
+ " * from v_fulldata a where 1=1");
if (type != null && type != " ") {
builder.append(" and a.atype = ? ");
params.add(type);
}
builder.append(" order by wg13 desc;");

String sql = builder.toString();
List> list = (List>) getJdbc()
.query(sql, params.toArray(), new ResultSetExtractor() {
@Override
public Object extractData(ResultSet rs)
throws SQLException, DataAccessException {
List> list = new ArrayList>();
while (rs.next()) {  //将查询结果循环
if (rs.getRow() continue;
}
Map row = new HashMap();
ResultSetMetaData rsmd = rs.getMetaData();
for (int i = 1; i row.put(rsmd.getColumnName(i), rs.getString(i));
}
list.add(row);
}
return list;
}
});
return list;
}

Related labels：
jdbc NOT sqlserver top Pagination
source：php.cn
Previous article：在mysql的replicatin环境中master/slave常用参数 Next article：如何 ubuntu下启动/停止/重启MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Confluence MySQL connector connection not established I'm trying to connect MySQLDB (installed in my laptop) from ConfluenceCloudRemote access u...
From 2023-09-09 13:22:30
0
1
249
How to use JDBC in Java to implement continuous updates of the database server without increasing RAM consumption I'm writing a fighting game in JavaFX, using JDBC to update information into a MySQL datab...
From 2023-09-07 20:10:29
0
1
311
Unable to create/set up connection: Unknown system variable 'query_cache_size' I'm running an application using JDBC and MySQL, using hikari pool, but it cannot build du...
From 2023-09-03 23:32:54
0
1
305
Solving "communication link failure" issues using JDBC and MySQL I'm trying to connect to my local MySQL server but I keep getting an error message. Here i...
From 2023-08-28 10:53:42
0
1
206
Understand the functionality of the Statement.setFetchSize(nSize) method in the SQL Server JDBC driver I have a very large table with millions of records every day, and at the end of each day I...
From 2023-08-27 17:05:57
0
1
258
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！