mysql jdbc execute update auto increment

Public void setSimpleJdbcTemplate(SimpleJdbcTemplate simpleJdbcTemplate) Protected TransactionTemplate transactionTemplate Protected SimpleJdbcTemplate simpleJdbcTemplate Public class SubscriberDao extends NamedParameterJdbcDaoSupport Import .TransactionCallbackWithoutResult Import .namedparam.NamedParameterJdbcDaoSupport Import .namedparam.MapSqlParameterSource Import .namedparam.BeanPropertySqlParameterSource I was going to ramble on, but let me just give you all the code for my class: Your Spring DAO class also needs to extend one of the classes provided in the Spring Framework. To get this to work you'll have to do all the usual Spring wiring things in your application, which hopefully I've already provided examples for out here already (or that you are hopefully already familiar with). Source code for the complete Spring DAO class I haven't looked at the Spring JDBC docs in a while now, but if I remember right there are only a few Spring JDBC methods that support returning the value of the auto-generated key, and each of those methods use this KeyHolder class.

GetNamedParameterJdbcTemplate().update(insertFileString, fileParameters, keyHolder) KeyHolder keyHolder = new GeneratedKeyHolder() SqlParameterSource fileParameters = new BeanPropertySqlParameterSource(subscriber) + '(:websiteId, :firstName, :lastName, :password, :emailAddress) ' + '(website_id, first_name, last_name, password, email_address) VALUES ' String insertFileString = 'INSERT INTO subscribers ' Subscriber subscriber = new Subscriber(websiteId, firstName, lastName, password, email) Public int insertSubscriberRecord(int websiteId, Here's the Java source code for this Spring JDBC method: Specifically, this method uses some Spring JDBC classes and methods to (a) execute a SQL INSERT statement, (b) get the generated id from the database for the record I just inserted (i.e., the value of the auto_increment field in a MySQL database table), and (c) return that integer value at the end of the method. Solution: Here's some example Spring JDBC source code for a method I wrote to retrieve the auto-generated key following a SQL INSERT. In either case, the problem is the same: How to get the value of the primary key field following your SQL INSERT statement.) Java Spring JDBC - Auto-generated database key source code This field is known as an auto increment field in MySQL, and either an identity or serial field in other databases like SQL Server or Postgresql. (I'm not phrasing that well, but by this question I mean the value of the primary key for the record I just inserted. Spring JDBC FAQ: How do I retrieve the auto-generated database key for a serial field (also known as an auto_increment field in MySQL) after I perform a SQL INSERT using Spring JDBC?

Mysql jdbc execute update auto increment