使用Spring的JdbcTemplate执行保存并返回主键ID的方法

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
import org.springframework.stereotype.Repository;

import com.jinhetech.trading.map.dao.PotatoPreventPeriodDao;

//通过jdbctemplate返回主键
		  KeyHolder keyHolder = new GeneratedKeyHolder();  
		    jdbcTemplate.update(new PreparedStatementCreator() {  
		        public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {  
		              
		         
		               PreparedStatement ps = connection.prepareStatement("sql语句",Statement.RETURN_GENERATED_KEYS);  
		               
		               return ps;  
		        }  
		    }, keyHolder);  
		    keyHolder.getKey().longValue();  




sql语句通过方法参数传递过来即可。