Problem I’m writing a small program to store data in a database (a discord bot mainly). I know cleaner ways […]
Tag: jdbc
Module for building swing tables
Problem I have a module that builds swing tables based on an Object[][], then I have another module that queries […]
Online shop interacting with database, updating cart and instantiating products
Problem I’m new to programming web sites (and so on the relationship between program and database) and I have encountered […]
Simple JDBC Query By Example (QBE) for Spring JDBC Template
Problem This is a quick and dirty QBE method that covers about 60% of my use cases in my DAO. […]
Authentication via LDAP and authorization via JDBC
Problem I have a custom AuthenticationProvider for getting authentication via LDAP and authorization via JDBC. It’s running but I think […]
Connection pool for java.sql.Connection
Problem I have made a connection pool for SQL Connection objects. The purpose of this object is to provide multi […]
Using static final Strings for SQL Query in Spring Boot
Problem This is regarding code quality and coding standards with respect to Spring Ecosystem. Here there are two methods: isRecordExists […]
Creating and deleting employees in a database
Problem I’ve been learning Java Database Programming for like 2 days, I read theory at first. Now decided to get […]
Inserting tables with foreign key
Problem How can I improve this method that adds data to three tables in the database? The tables are: UserTable […]
Method to Return a Hibernate Session
Problem Can this method be improved?: public static Session getHibernateSession() throws SQLException{ synchronized(dbSessionMutex){ if(session == null || !session.isOpen()){ session = […]