JarCasting
JarCasting JarCasting

io.github.mattvass:json-resultset-mapper

This allows users to simply convert their result set to json.

License

License
Categories

Categories

JSON Data
GroupId

GroupId

io.github.mattvass
ArtifactId

ArtifactId

json-resultset-mapper
Last Version

Last Version

1.0.1
Release Date

Release Date
Type

Type

jar
Description

Description

io.github.mattvass:json-resultset-mapper
This allows users to simply convert their result set to json.
Project URL

Project URL

http://maven.apache.org
Source Code Management

Source Code Management

https://github.com/mattvass/json-resultset-mapper/tree/master

Download json-resultset-mapper

Filename Size
json-resultset-mapper-1.0.1.pom
json-resultset-mapper-1.0.1.jar 6 KB
json-resultset-mapper-1.0.1-sources.jar 5 KB
json-resultset-mapper-1.0.1-javadoc.jar 36 KB
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/io.github.mattvass/json-resultset-mapper/ -->
<dependency>
    <groupId>io.github.mattvass</groupId>
    <artifactId>json-resultset-mapper</artifactId>
    <version>1.0.1</version>
</dependency>
// https://jarcasting.com/artifacts/io.github.mattvass/json-resultset-mapper/
implementation 'io.github.mattvass:json-resultset-mapper:1.0.1'
// https://jarcasting.com/artifacts/io.github.mattvass/json-resultset-mapper/
implementation ("io.github.mattvass:json-resultset-mapper:1.0.1")
'io.github.mattvass:json-resultset-mapper:jar:1.0.1'
<dependency org="io.github.mattvass" name="json-resultset-mapper" rev="1.0.1">
  <artifact name="json-resultset-mapper" type="jar" />
</dependency>
@Grapes(
@Grab(group='io.github.mattvass', module='json-resultset-mapper', version='1.0.1')
)
libraryDependencies += "io.github.mattvass" % "json-resultset-mapper" % "1.0.1"
[io.github.mattvass/json-resultset-mapper "1.0.1"]

Dependencies

compile (3)

Group / Artifact Type Version
javax.json : javax.json-api jar 1.1.2
org.glassfish : javax.json jar 1.1.2
org.apache.commons : commons-text jar 1.4

test (2)

Group / Artifact Type Version
junit : junit jar 4.12
org.mockito : mockito-all jar 1.9.5

Project Modules

There are no modules declared in this project.

Json ResultSet Mapper

Maven Central CircleCI

This allows users to simply convert their result set to json.

The following types will be cast to the appropriate type:

  • String
  • Integer
  • BigDecimal
  • Long
  • Double
  • Boolean
  • Short

Currently all other values are converted to strings values or JsonValue.NULL if the returned value is null.

The java.sql.ResultSet.getObject method is used to ensure no primitive types are set, due to methods like getBoolean or getDouble returning primitive values which have defaults. The getObject method seemed like the logical choice to ensure we are not setting any default values that weren't expected by the end user.

Add as a dependency

<dependency>
  <groupId>io.github.mattvass</groupId>
  <artifactId>json-resultset-mapper</artifactId>
  <version>see-version-number-above</version>
</dependency>

Simple Implementation

new JsonResultSet().toJson(resultSet);

Example Json Output

{
	"results": [{
		"stringColumn": "string value",
		"integerColumn": 39,
		"booleanColumn": true,
		"doubleColumn": 150000.0,
		"bigdecimalColumn": 10,
		"shortColumn": 123,
		"longColumn": 12345678910,
		"timeColumn": "10:11:12",
		"timestampColumn": "1970-05-23 17:21:18.91",
		"dateColumn": "1970-05-23"
	}, {
		"stringColumn": "string value",
		"integerColumn": 39,
		"booleanColumn": true,
		"doubleColumn": 150000.0,
		"bigdecimalColumn": 10,
		"shortColumn": 123,
		"longColumn": 12345678910,
		"timeColumn": "10:11:12",
		"timestampColumn": "1970-05-23 17:21:18.91",
		"dateColumn": "1970-05-23"
	}]
}

Versions

Version
1.0.1
1.0