清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
String自带的获得主键方法比较繁琐,所以自己写了一个方法来和大家分享
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.ParameterDisposer; import org.springframework.jdbc.core.PreparedStatementCreator; import org.springframework.jdbc.core.PreparedStatementSetter; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.support.GeneratedKeyHolder; import org.springframework.jdbc.support.KeyHolder; /** * 数据存取适配器 * @author David Day */ public class JdbcTemplateAdapter extends JdbcTemplate { public JdbcTemplateAdapter() { super (); } public JdbcTemplateAdapter(DataSource ds) { super (ds); } /** * 增加并且获取主键 * @param sql sql语句 * @param params 参数列表 * @return 主键 */ public Object insertAndGetKey( final String sql, final Object... params) { logger.debug( "Executing SQL update and returning generated keys" ); final KeyHolder key = new GeneratedKeyHolder(); update( new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS); PreparedStatementSetter pss = newArgPreparedStatementSetter(params); try { if (pss != null ) { pss.setValues(ps); } } finally { if (pss instanceof ParameterDisposer) { ((ParameterDisposer) pss).cleanupParameters(); } } return ps; } }, key); return key.getKey(); } } |