JarCasting
JarCasting JarCasting

SQL CRUD servlet app

CRUD actions and view for java-servlet apps

License

License
GroupId

GroupId

io.github.jdlopez
ArtifactId

ArtifactId

sqlcrud
Last Version

Last Version

1.0.1
Release Date

Release Date
Type

Type

jar
Description

Description

SQL CRUD servlet app
CRUD actions and view for java-servlet apps
Project URL

Project URL

https://github.com/jdlopez/sqlcrud
Source Code Management

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
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/ -->
<dependency>
    <groupId>io.github.jdlopez</groupId>
    <artifactId>sqlcrud</artifactId>
    <version>1.0.1</version>
</dependency>
// https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/
implementation 'io.github.jdlopez:sqlcrud:1.0.1'
// https://jarcasting.com/artifacts/io.github.jdlopez/sqlcrud/
implementation ("io.github.jdlopez:sqlcrud:1.0.1")
'io.github.jdlopez:sqlcrud:jar:1.0.1'
<dependency org="io.github.jdlopez" name="sqlcrud" rev="1.0.1">
  <artifact name="sqlcrud" type="jar" />
</dependency>
@Grapes(
@Grab(group='io.github.jdlopez', module='sqlcrud', version='1.0.1')
)
libraryDependencies += "io.github.jdlopez" % "sqlcrud" % "1.0.1"
[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.

Maven

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
1.0