Spring JDBC Template

queryForObject() should return null instead of throwing an Exception

License	Apache License
GroupId	cn.danielw
ArtifactId	spring-jdbc-template
Last Version	0.2.1
Release Date	Feb 24, 2017
Type	jar
Description	Spring JDBC Template queryForObject() should return null instead of throwing an Exception
Project URL	https://github.com/DanielYWoo/spring-jdbc-template
Source Code Management	https://github.com/DanielYWoo/spring-jdbc-template

Download spring-jdbc-template

Filename	Size
spring-jdbc-template-0.2.1.pom
spring-jdbc-template-0.2.1.jar	5 KB
spring-jdbc-template-0.2.1-sources.jar	2 KB
spring-jdbc-template-0.2.1-javadoc.jar	29 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/cn.danielw/spring-jdbc-template/ -->
<dependency>
    <groupId>cn.danielw</groupId>
    <artifactId>spring-jdbc-template</artifactId>
    <version>0.2.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/cn.danielw/spring-jdbc-template/
implementation 'cn.danielw:spring-jdbc-template:0.2.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/cn.danielw/spring-jdbc-template/
implementation ("cn.danielw:spring-jdbc-template:0.2.1")

Apache Buildr

'cn.danielw:spring-jdbc-template:jar:0.2.1'

Apache Ivy

<dependency org="cn.danielw" name="spring-jdbc-template" rev="0.2.1">
  <artifact name="spring-jdbc-template" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='cn.danielw', module='spring-jdbc-template', version='0.2.1')
)

Scala SBT

libraryDependencies += "cn.danielw" % "spring-jdbc-template" % "0.2.1"

Leiningen

[cn.danielw/spring-jdbc-template "0.2.1"]

Dependencies

compile (1)

Group / Artifact	Type	Version
org.springframework : spring-jdbc	jar	4.3.6.RELEASE

test (3)

Group / Artifact	Type	Version
junit : junit	jar	4.11
org.mockito : mockito-core	jar	2.7.10
com.h2database : h2	jar	1.4.193

Project Modules

There are no modules declared in this project.

spring-jdbc-template

Spring jdbc template throws EmptyResultDataAccessException when no result is found, but 99.99% of developers expect NULL, right? This is a very simple wrapper for JdbcTemplate and NamedParameterJdbcTemplate, but returns null for queryForObject() methods.

usage

Exactly like Spring JdbcTemplate, actually it's a subclass of it.

e.g.

 int value = new JdbcTemplate(dataSource).queryForInt("select age from user where id=?", id);
 User u = new NamedParameterJdbcTemplate(dataSource).queryForObject(
    "select * from user where id=:id", params, rowMapper);

Versions

Version
0.2.1 Feb 24, 2017