Java SQL (JDBC) code generator with GUI. SQL and OOP finally united.

Related tags

Spring Boot jSQL-Gen
Overview

jSQL-Gen

Java SQL (JDBC) code generator with GUI. SQL and OOP finally united.

Usage

  • Install the latest release.
  • Create a database, tables and their columns via the GUI. Its recommended to name your tables like you name your regular Java objects, and your columns like your objects' fields.
  • Press Generate Code and add the code to your project. The generated code/files can also be found in the generated folder (press Show Data on the first tab, to open the location).
  • Open Database.java and fill in your database credentials, and run your app.

Features

  • No runtime overhead for class generation (unlike other ORMs).
  • Helper/Optional WHERE class for generating SQL queries.

How?

  • Generates one class/object for each table.
  • The generated object contains static methods like get() delete() update() add() etc... to interact with the table.
  • The generated object contains fields for each column obj.id obj.name etc....
  • The generated code does not require any third party libraries and should work with Java 8 or higher. It uses the built in JDBC API for SQL queries.

UI

  • Simple UI to design databases within minutes.
  • Autosuggestions for field definitions.

Tipps

  • You can rename/refactor generated Java classes and their fields/methods etc., but keep in mind that those changes won't affect the actual database tables/columns.
  • Thus changes to the database (specially changes in data types) should be made using the GUI.
You might also like...

E library System - Java servlet, JDBC

E-Library-System-in-Java Java - E Library System Java Project based on JDBC, JSP, Java Servlet and Server Deployment System Project Aim -Develop web a

Feb 2, 2022

jdbc-plus是一款原生插件

jdbc-plus jdbc-plus是一款原生插件 拥有Mybatis-Plus的逻辑构建功能,能快速构建出单表查询逻辑 Logic logic = new Logic();//构建出逻辑对象 logic.eq(key, val);//eq操作 logic.lt(key, val);//lt操作.

Oct 2, 2022

Drifty is an open-source interactive File Downloader system built with java. It is currently available in CLI mode and has the GUI version under active development.

Drifty is an open-source interactive File Downloader system built with java. It is currently available in CLI mode and has the GUI version under active development.

Drifty Drifty is an open-source interactive File Downloader system built using Java. It takes the link to the file, the directory where it needs to be

Dec 24, 2022

Bank Statement Analyzer Application that currently runs in terminal with the commands: javac Application.java java Application [file-name].csv GUI coming soon...

Bank Statement Analyzer Application that currently runs in terminal with the commands: javac Application.java java Application [file-name].csv GUI coming soon...

May 21, 2022

Team 5468's 2022 FRC robot code. This code is written in Java and is based off of WPILib's Java control system and utilizes a command based system

FRC 2022 Team 5468's 2022 FRC robot code. This code is written in Java and is based off of WPILib's Java control system and utilizes a command based s

Oct 4, 2022

A simple and lightweight Minecraft GUI API for developers to use.

Current Version: 1.0.0 Requirements: - You must be using PaperMC or a fork of it (This will not work with just Spigot/Bukkit! - Curently this API only

May 14, 2022

Java GUI Frontend for XCH Forks

Java GUI Frontend for XCH Forks

ForkFarmer Java GUI Frontend for XCH Forks. Discord: https://discord.gg/Mx9ZNHta Requires JRE 1.8 or greater to run: https://www.java.com/en/download/

Nov 8, 2022

The Download Manager uses a simple yet effective GUI interface built with java’s Swing libraries

The Download Manager uses a simple yet effective GUI interface built with java’s Swing libraries.The use of Swing gives the interface a crisp, modern look and feel. The GUI maintains a list of downloads that are currently being managed.

Jan 2, 2022

OpenAPI Generator allows generation of API client libraries (SDK generation), server stubs, documentation and configuration automatically given an OpenAPI Spec (v2, v3)

OpenAPI Generator allows generation of API client libraries (SDK generation), server stubs, documentation and configuration automatically given an OpenAPI Spec (v2, v3)

OpenAPI Generator Master (5.4.x): 6.0.x (6.0.x): ⭐ ⭐ ⭐ If you would like to contribute, please refer to guidelines and a list of open tasks. ⭐ ⭐ ⭐ ‼️

Dec 30, 2022
Owner
Osiris-Team
Cooking some delicious code...
Osiris-Team
Spring Boot JdbcTemplate example with SQL Server: CRUD Rest API using Spring Data JDBC, Spring Web MVC

Spring Boot JdbcTemplate example with SQL Server: Build CRUD Rest API Build a Spring Boot CRUD Rest API example that uses Spring Data Jdbc to make CRU

null 7 Dec 20, 2022
Log4j-payload-generator - Log4j jndi injects the Payload generator

0x01 简介 log4j-payload-generator是 woodpecker框架 生产log4 jndi注入漏洞payload的插件。目前可以一键生产以下5类payload。 原始payload {[upper|lower]:x}类型随机混payload {[upper|lower]:x}

null 469 Dec 30, 2022
OpenApi Generator - REST Client Generator

Quarkus - Openapi Generator Welcome to Quarkiverse! Congratulations and thank you for creating a new Quarkus extension project in Quarkiverse! Feel fr

Quarkiverse Hub 46 Jan 3, 2023
A sideproject to learn more about object-oriented programming, design patterns and Java meanwhile studying an OOP-course.

MyBank Description A console application that simulates a bank with very simple functions. Potential story could be an employee using this application

null 2 Mar 23, 2022
The goal of this topic is learning OOP principles in Java and modifying elements in 2D arrays.

Homework #11 Table of Contents General Info Technologies Used Project Status Contact General Information Homework contains two topics: Generating rand

Mykhailo 1 Feb 2, 2022
A fun mini project in Java. Uses Interface, Inheritance, and other OOP concepts

Sequences---Arithmetic-and-Geometric A fun mini project in Java. Uses Interface, Sorting, Inheritance, and other OOP concepts About this project: This

Urjit Aich 2 Feb 18, 2022
Classpy is a GUI tool for investigating Java class file, Lua binary chunk, Wasm binary code, and other binary file formats.

Classpy Classpy is a GUI tool for investigating Java class file, Lua binary chunk, Wasm binary code, and other binary file formats. Inspiration This t

null 1k Dec 17, 2022
code to the rat i give to people if u want to change the webhook its in "src/main/java/github/quantizr/autogg/guis/gui" please just dont sell my rat :(

SkyblockRat My rats code join my discord! https://discord.gg/bbK6ndHqN6 i got tired of people asking "is it double hooked?!" so here is my rats code y

null 6 Dec 10, 2022
Auto-Unit-Test-Case-Generator automatically generates high-level code-coverage JUnit test suites for Java, widely used within the ANT Group.

中文README传送门 What is Auto-Unit-Test-Case-Generator Auto-Unit-Test-Case-Generator generates JUnit test suites for Java class just as its name. During te

TRaaS 108 Dec 22, 2022
A simple QR-code generator.

javaQR-generator A simple QR-code generator. Installation instructions. *Note: in order to build this program you must have JDK v1.8 or greater proper

Yoel N. Fabelo González 1 May 18, 2022