简易高重用的jdbcutils工具封装实现类以及简易连接池实现.docVIP

? 简易高重用的jdbcutils工具封装实现类以及简易连接池实现 由于现在发现做个小项目都是导入n多的依赖包,很烦琐,只想快点开发完一个个的小需求项目,这个时候真心不想用框架,只能自己写个jdbcutils,虽然网上有很多有apache的,阿里的,但是感觉用过后都不怎么顺手,然后自己花了点时间写个新的,不喜勿喷 1.我们要写个resultset集合转成bean的回调接口,这个用过spring jdbc的人都知道这玩意 [java]?view plaincopy package?org.simple.mvc.jdbc.bean;?? ?? import?java.sql.ResultSet;?? import?java.sql.SQLException;?? ?? public?interface?RowMapperT?{?? ?? ????public?abstract?T?mapRow(ResultSet?rs)?throws?SQLException;?? ?? }?? 2.先来个基本的jdbc操作接口吧,这样好规范点 [java]?view plaincopy package?org.simple.mvc.jdbc;?? ?? import?java.sql.Connection;?? import?java.sql.PreparedStatement;?? import?java.sql.ResultSet;?? import?java.sql.SQLException;?? import?java.sql.Statement;?? import?java.util.List;?? import?java.util.Map;?? ?? import?javax.sql.DataSource;?? ?? import?org.simple.mvc.jdbc.bean.RowMapper;?? ?? public?interface?JdbcOperation?{?? ?? ????/**? ?????*?update或delete功能? ?????*?? ?????*?@param?sql? ?????*?@param?params? ?????*?@return?变更记录数? ?????*?@throws?SQLException? ?????*/?? ????public?abstract?int?execute(String?sql,?Object[]?params)?throws?SQLException;?? ?? ????/**? ?????*?update或delete功能? ?????*?? ?????*?@param?sql? ?????*?@return?变更记录数? ?????*?@throws?SQLException? ?????*/?? ????public?abstract?int?execute(String?sql)?throws?SQLException;?? ?? ????/**? ?????*?批处理update或delete功能? ?????*?? ?????*?@param?sql? ?????*?@param?params? ?????*?@return?变更记录数? ?????*?@throws?SQLException? ?????*/?? ????public?abstract?int?executeBatch(String?sql,?ListObject[]?params)?throws?SQLException;?? ?? ????/**? ?????*?批处理update或delete功能? ?????*?? ?????*?@param?sql? ?????*?@param?params? ?????*?@return?变更记录数? ?????*?@throws?SQLException? ?????*/?? ????public?abstract?int?executeBatch(String?sql)?throws?SQLException;?? ?? ????/**? ?????*?select功能? ?????*?? ?????*?@param?sql? ?????*?@param?params? ?????*?@return?原生ResultSet数据集合? ?????*?@throws?SQLException? ?????*/?? ????public?abstract?ResultSet?queryForResultSet(String?sql,?Object[]?params)?throws?SQLException;?? ?? ????/**