封装的基类Springjdbc代码,Java代码库,德仔网

代码语言
代码分类
【Java】封装的基类Springjdbc
作者:刘石法 / 发布于2012/10/22/ 656
一个通用的BaseDao,简化开发。包括增删查改以及分页
<div>package oa.common.dao;</div>
<div></div>
import java.util.List;</div>
<div></div>
import oa.common.model.PageModel;</div>
<div></div>
import org.springframework.jdbc.core.BeanPropertyRowMapper;</div>
import org.springframework.jdbc.core.RowMapper;</div>
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;</div>
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;</div>
import org.springframework.jdbc.core.namedparam.SqlParameterSource;</div>
<div></div>
<div>public abstract class BaseDAO<T> extends NamedParameterJdbcDaoSupport {</div>
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected final static String PAGE_SQL_PREFIX = "select * from(select m.*,rownum num from (";</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected final static String PAGE_SQL_END = ") m where rownum<=?) where num>?";</div>
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>/**</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * 适用于更新数据库,insert,update, delete</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @param namedSql</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *      :命名参数的ＳＱＬ语句，而且参数的命名必须和ＪａｖａＢｅａｎ中的属性名对应</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @param javaBean</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *      ：ｊａｖａｂｅａｎ对象</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @return</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> */</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected int update(String namedSql, Object javaBean) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>SqlParameterSource paramSource = new BeanPropertySqlParameterSource(</div>
<div><span class="Apple-tab-span" style="white-space:pre">				</span>javaBean);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getNamedParameterJdbcTemplate().update(namedSql,paramSource);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected int commonUpdate(String sql, Object... paramValue) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate().update(sql, paramValue);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected T getJavaBean(String sql, Class<T> returnType,</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>Object... paramValue) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>RowMapper<T> rowMapper = new BeanPropertyRowMapper<T>(returnType);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>try{</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate()</div>
<div><span class="Apple-tab-span" style="white-space:pre">				</span>.queryForObject(sql, rowMapper, paramValue);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>}catch(Exception ex){</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>return null;</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>}
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected List<T> getList(String sql, Class<T> returnType,</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>Object... paramValue) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>RowMapper<T> rowMapper = new BeanPropertyRowMapper<T>(returnType);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate().query(sql, rowMapper, paramValue);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div><span class="Apple-tab-span" style="white-space:pre">	</span></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected List<T> getList(String sql, Class<T> returnType) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>RowMapper<T> rowMapper = new BeanPropertyRowMapper<T>(returnType);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate().query(sql, rowMapper);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>/**</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * 计算总记录数</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @param countSQL</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *      计算总记录数的count语句</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @param paramValue</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> *      语句中对应的参数值</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> * @return 总记录数</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span> */</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected int getCount(String countSQL, List paramValue) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate().queryForInt(countSQL,</div>
<div><span class="Apple-tab-span" style="white-space:pre">				</span>paramValue.toArray());</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected int getCount(String countSQL, Object... paramValue) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return this.getJdbcTemplate().queryForInt(countSQL, paramValue);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>protected PageModel getPageModel(PageModel model,</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>StringBuilder querySQL, StringBuilder countSQL,</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>StringBuilder whereSQL, List paramList, Class<T> returnType) {</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>querySQL.append(whereSQL);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>countSQL.append(whereSQL);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>// 计算总记录数</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>int allCount = this.getCount(countSQL.toString(), paramList);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>// 获取分页记录集</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>// 1。构造完整的分页语句</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>querySQL.insert(0, PAGE_SQL_PREFIX);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>querySQL.append(PAGE_SQL_END);</div>
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>// 2.把分页语句中的参数值加入到paramList中</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>paramList.add(model.getNumPerPage()* model.getPageNum());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>paramList.add(( model.getPageNum() - 1) *model.getNumPerPage());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>List result = this.getList(querySQL.toString(), returnType,</div>
<div><span class="Apple-tab-span" style="white-space:pre">				</span>paramList.toArray());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>PageModel models = new PageModel();</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setTotalCount(allCount);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setNumPerPage(model.getNumPerPage());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setPageNum(model.getPageNum());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setResult(result);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setOrderDirection(model.getOrderDirection());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>models.setOrderField(model.getOrderField());</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>return models;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>}
<div>}
<div></div>
试试其它关键字
　Springjdbc　
同语言下
可能有用的
刘石法贡献的其它代码(3)