Skip to content

Instantly share code, notes, and snippets.

Avatar

Gaurav Rai Mazra gauravrmazra

View GitHub Profile
@gauravrmazra
gauravrmazra / ArrayOfBlogPosts.ts
Created Jun 8, 2020
Array of BlogPosts for gauravrmazra/gauravbytes/react-blog-posts
View ArrayOfBlogPosts.ts
const posts = [
{
id: 1,
title: 'Spring JDBC returning auto-generated keys using PreparedStatementCreator and PreparedStatementCallback',
content: `In this post, we will look into how to retrieve auto-generated keys in JDBC. We will also explore usage of PreparedStatementCreator and PreparedStatementCallback in JdbcTemplate.
There are cases when you rely on Database server to auto generate values for some columns of the table. E.g. auto increment primary key, creation_date or any other column while inserting records. There is a way with which you can retrieve those auto-generated keys when you execute the insert statement. Let's see how you can do this using Spring JDBC but first we will see what PreparedStatementCreator and PreparedStatementCallback interfaces are.
What is PreparedStatementCreator?
There are cases when you want to create PreparedStatement yourself. One use case is to return auto generated keys. In that case, Spring JDBC provides you an option to do so by provi
@gauravrmazra
gauravrmazra / EmployeeController.java
Created Jan 8, 2017
Pre Spring 4.3 request mapping annotatio example
View EmployeeController.java
@RestController
@RequestMapping("/api/employees")
public class EmployeeController {
@RequestMapping
public ResponseEntity<List<Employee>> getAll() {
return ResponseEntity.ok(Collections.emptyList());
}
@RequestMapping("/{employeeId}")
@gauravrmazra
gauravrmazra / Benchmark results
Created Jan 31, 2016
Sample Bench-marking for List's add and composed add method in Code smells
View Benchmark results
# Run complete. Total time: 00:13:40
Benchmark Mode Cnt Score Error Units
MyBenchmark.testAdd thrpt 200 7048.966 ± 188.886 ops/s
MyBenchmark.testComposed thrpt 200 7127.034 ± 178.861 ops/s