jdbcTemplate获得数据库生成的主键值

最新推荐文章于 2023-05-30 15:49:35 发布

zhengbo0

最新推荐文章于 2023-05-30 15:49:35 发布

阅读量2.3k

点赞数

分类专栏： spring

本文链接：https://blog.youkuaiyun.com/zhengbo0/article/details/11171839

版权

spring 专栏收录该内容

27 篇文章

订阅专栏

本文详细描述了如何使用Spring Data JPA的transactionTemplate执行SQL插入操作，并通过GeneratedKeyHolder获取返回的主键值，确保在事务中安全地进行数据操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

JSONObject obj = new JSONObject();
			obj.put("code", transactionTemplate.execute(new TransactionCallback<Integer>() {
						@Override
						public Integer doInTransaction(TransactionStatus status) {
							Object spt = status.createSavepoint();
							
							try {
								
								final String sql = "insert into article (title, content, source, keyword, intro,"
										+ " type, author, recommend, headline,leaveNumber,clickNumber,userid,"
										+ "createtime,updatetime,deploytime) values"
										+ " (?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?) ";

								
								KeyHolder keyHolder = new GeneratedKeyHolder();
								jdbcTemplate.update(new PreparedStatementCreator() {
									
									@Override
									public PreparedStatement createPreparedStatement(Connection conn)
											throws SQLException {
										PreparedStatement pstat = conn.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS);
										pstat.setString(1, title);
										pstat.setString(2, content);
										pstat.setString(3, source);
										pstat.setString(4, keyword);
										pstat.setString(5, intro);
										pstat.setString(6, type);
										pstat.setString(7, author);
										pstat.setString(8, recommend);
										pstat.setString(9, headline);
										pstat.setString(10, leaveNumber);
										pstat.setString(11, clickNumber);
										pstat.setString(12, userid);
										pstat.setDate(13, new java.sql.Date(new  java.util.Date().getTime()));
										pstat.setDate(14, new java.sql.Date(new  java.util.Date().getTime()));
										pstat.setDate(15, new java.sql.Date(new  java.util.Date().getTime()));
										return pstat;
									}
								}, keyHolder);
								System.out.println("PK: " + keyHolder.getKey().intValue());
								/*String sqls = "insert into channel_article (articleid, channelid) values (?, ?)";
								jdbcTemplate.update(sqls, articleid, channelid);*/
								status.releaseSavepoint(spt);
								return 0;
							} catch (Exception e) {
								status.rollbackToSavepoint(spt);
								return -1;
							}
						}
					}));
		response.getWriter().write(obj.toString());