SpringMVC+Mybatis集合整个简易Web项目

package com.kdg.dao.impl; import java.util.List; import java.util.Map; import javax.sql.DataSource; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.kdg.dao.DataDao; @Repository(value="DataDao") public class DataDaoImpl implements DataDao { private JdbcTemplate jdbcTemplate; @Autowired public void setDataSource(DataSource dataSource) { this.jdbcTemplate = new JdbcTemplate(dataSource); } @Override public JSONObject getDataListForPagination(StringBuffer sql, Integer pageNo, Integer pageSize, Object[] params) throws Exception { System.out.println(sql); for (int i=0; i<params.length; i++) { System.out.println("参数:"+(i+1)+",值:"+params[i]); } JSONObject jo = new JSONObject(); JSONArray ja = new JSONArray(); jo.put("totalSize", 0);//查询数据总共数量 jo.put("dataArray", ja);//查询数据集合 if (pageNo==null) { pageNo = 1;//默认页码 } if (pageSize==null) { pageSize = 10;//默认分页每页数据量 } jo.put("pageNo", pageNo); jo.put("pageSize", pageSize); if (sql.length()>0 && pageNo!=null && pageSize!=null) { Map<String, Object> jmap = jdbcTemplate.queryForMap(" select count(0) TotalSize from ( "+sql+" ) ", params); jo.put("totalSize", jmap!=null?jmap.get("TOTALSIZE"):0);//查询数据总共数量 StringBuffer sql_ = new StringBuffer(); sql_.append(" select a______.* from ( select rownum rc, t______.* from ( "+sql+" ) t______ "); sql_.append(" where rownum <= "+pageNo*pageSize+" ) a______ where a______.rc > "+(pageNo-1)*pageSize+" "); List<Map<String,Object>> list = jdbcTemplate.queryForList(sql_.toString(), params); for (Map<String,Object> map : list) { JSONObject jsons = new JSONObject(); for (String key : map.keySet()) { jsons.put(key.toLowerCase(), map.get(key)); } ja.add(jsons); } } return jo; } }