import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.RowMapperResultReader;
public class JdbcDAO extends JdbcTemplate
String sql = "";
String tsql = "";
int startNum = -1;
int pageSize = -1;
int count = 0;
1),获取分页数据
public List queryJdbcForOnePage(String sql, int startNum, int pageSize)
throws PioaGisException
{
this.tsql = sql;
this.startNum = startNum;
this.pageSize = pageSize;
sql = "SELECT * FROM (SELECT A.*,ROWNUM R FROM (" + sql +
") A WHERE ROWNUM <=" + (startNum + pageSize) +
") B WHERE B.R > " + startNum;
List listContent = query(sql,
new RowMapperResultReader(new DataRowMapper()));
List list = new LinkedList();
list.add(this.fieldNames);
for (int i = 0; i < listContent.size(); ++i) {
list.add(listContent.get(i));
}
return list;
}
示例:
SELECT * FROM (SELECT A.*,ROWNUM R FROM (SELECT 字段名 FROM 表名 WHERE ( 1 = 1 ) ORDER BY 字段名 DESC) A WHERE ROWNUM <=10) B WHERE B.R > 0
2),获取数据的数量
public int queryJdbcForMaxNum()
throws PioaGisException
{
String temp = this.tsql;
if (this.tsql.indexOf("ORDER BY") != -1)
temp = this.tsql.substring(this.tsql.indexOf("FROM"), this.tsql.indexOf("ORDER BY"));
else {
temp = this.tsql.substring(this.tsql.indexOf("FROM"));
}
String tempsql = "SELECT COUNT(1) " + temp;
Map map = queryJdbcForOneRow(tempsql);
int count = Integer.parseInt(map.get("COUNT(1)").toString());
return count;
}
public Map queryJdbcForOneRow(String sql)
throws PioaGisException
{
List list = query(sql, new OneRowMapper());
if ((list != null) && (list.size() > 0)) {
return (Map)list.get(0);
}
return null;
}
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.RowMapperResultReader;
public class JdbcDAO extends JdbcTemplate
String sql = "";
String tsql = "";
int startNum = -1;
int pageSize = -1;
int count = 0;
1),获取分页数据
public List queryJdbcForOnePage(String sql, int startNum, int pageSize)
throws PioaGisException
{
this.tsql = sql;
this.startNum = startNum;
this.pageSize = pageSize;
sql = "SELECT * FROM (SELECT A.*,ROWNUM R FROM (" + sql +
") A WHERE ROWNUM <=" + (startNum + pageSize) +
") B WHERE B.R > " + startNum;
List listContent = query(sql,
new RowMapperResultReader(new DataRowMapper()));
List list = new LinkedList();
list.add(this.fieldNames);
for (int i = 0; i < listContent.size(); ++i) {
list.add(listContent.get(i));
}
return list;
}
示例:
SELECT * FROM (SELECT A.*,ROWNUM R FROM (SELECT 字段名 FROM 表名 WHERE ( 1 = 1 ) ORDER BY 字段名 DESC) A WHERE ROWNUM <=10) B WHERE B.R > 0
2),获取数据的数量
public int queryJdbcForMaxNum()
throws PioaGisException
{
String temp = this.tsql;
if (this.tsql.indexOf("ORDER BY") != -1)
temp = this.tsql.substring(this.tsql.indexOf("FROM"), this.tsql.indexOf("ORDER BY"));
else {
temp = this.tsql.substring(this.tsql.indexOf("FROM"));
}
String tempsql = "SELECT COUNT(1) " + temp;
Map map = queryJdbcForOneRow(tempsql);
int count = Integer.parseInt(map.get("COUNT(1)").toString());
return count;
}
public Map queryJdbcForOneRow(String sql)
throws PioaGisException
{
List list = query(sql, new OneRowMapper());
if ((list != null) && (list.size() > 0)) {
return (Map)list.get(0);
}
return null;
}