SQL CRUD servlet app

CRUD actions and view for java-servlet apps

License	MIT License
GroupId	io.github.jdlopez
ArtifactId	sqlcrud
Last Version	1.0.1
Release Date	Feb 6, 2019
Type	jar
Description	SQL CRUD servlet app CRUD actions and view for java-servlet apps
Project URL	https://github.com/jdlopez/sqlcrud
Source Code Management	https://github.com/jdlopez/sqlcrud.git

Download sqlcrud

Filename	Size
sqlcrud-1.0.1.pom
sqlcrud-1.0.1.jar	52 KB
sqlcrud-1.0.1-sources.jar	32 KB
sqlcrud-1.0.1-javadoc.jar	556 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/ -->
<dependency>
    <groupId>io.github.jdlopez</groupId>
    <artifactId>sqlcrud</artifactId>
    <version>1.0.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/
implementation 'io.github.jdlopez:sqlcrud:1.0.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/
implementation ("io.github.jdlopez:sqlcrud:1.0.1")

Apache Buildr

'io.github.jdlopez:sqlcrud:jar:1.0.1'

Apache Ivy

<dependency org="io.github.jdlopez" name="sqlcrud" rev="1.0.1">
  <artifact name="sqlcrud" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='io.github.jdlopez', module='sqlcrud', version='1.0.1')
)

Scala SBT

libraryDependencies += "io.github.jdlopez" % "sqlcrud" % "1.0.1"

Leiningen

[io.github.jdlopez/sqlcrud "1.0.1"]

Dependencies

compile (1)

Group / Artifact	Type	Version
com.google.code.gson : gson	jar	2.8.5

provided (1)

Group / Artifact	Type	Version
javax.servlet : javax.servlet-api	jar	3.1.0

test (1)

Group / Artifact	Type	Version
org.junit.jupiter : junit-jupiter-api	jar	RELEASE

Project Modules

There are no modules declared in this project.

SQL CRUD

Very simple CRUD application. Servlet based, jar packaged. Could be embedded in larger applications

• C Create
• R Read
• U Update
• D Delete

CRUD wikipedia

Features:

• Pre-build bootstrap-style application (very simple but fully functional)
• All CRUD operations available + listing. Select table then show table content listings. Edit or create rows
• Custom Query window. Could be disabeled
• Reports window. Configurable: sqls in database table or properties. Could be disableled

Basic usage

Add maven dependency:

<dependency>
    <groupId>io.github.jdlopez</groupId>
    <artifactId>sqlcrud</artifactId>
    <version>${see-last-version-in-badge}</version>
</dependency>

Add config: web.xml (actions) and cruddatabase.json

Config

web.xml o java equivalent

• table filter or table list or prefix. All tables by default
• dataSource
• Access role (user in role?)

Example web.xml:

web.xml in example

Example json:

cruddatabase.json in example

Building

If you want to build your own jar library:

In base project:

mvn install

To create sample database:

mvn sql:execute

In example project to test:

mvn jetty:run

Versions

Version
1.0.1 Feb 6, 2019
1.0 Feb 5, 2019