String自带的获得主键方法比较繁琐,所以自己写了一个方法来和大家分享
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();
}
}