Questions tagged [jdbc]
JDBC (Java DataBase Connectivity) is the base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language.
86 questions
2
votes
1
answer
109
views
Code to add order orderitems and payment details
This is order, orderitems and payment linked by foreign key.
Controller:
...
- 277
7
votes
3
answers
502
views
First Java Program: A Basic GUI Library Management System with JavaFX
Requirements:
Add/Delete member.
Add/Delete book.
Issue/Return book.
Review Request:
General coding comments, bad practices, style et cetera.
Code:
Main.java:
<...
- 71
3
votes
0
answers
85
views
Bridging the gap between Spring's JdbcTemplate and Kotlin coroutines
I'm learning about Kotlin coroutines. I'm wondering if I can use them to increase the throughput of my spring-boot application which is currently very heavily dependent on jdbc connections, without ...
- 131
9
votes
2
answers
970
views
JavaFX app with User Authentication and SQL Persistence
This JavaFX program is just supposed to allow a user to register a username and password and then have it stored in an SQL database.
There's been some criticism that it's not clean, readable or ...
- 153
1
vote
1
answer
452
views
Inserting large number of rows into database with Spring boot
I need to insert many million rows + many GB of data into a database for a project that uses Spring boot. I recreated a minimal example with a one to many relationship and am trying to find the ...
- 155
5
votes
3
answers
731
views
Mapping named parameters to indices for PreparedStatement
I needed something to map named SQL parameters into indices for JDBC queries so I wrote the ParameterMap class that takes an SQL query, searchers for parameters ...
- 44.7k
3
votes
1
answer
133
views
Company management app: Extracting data with JDBC and java.sql
I'm currently working on a company management system as a university project, and I have to get my hands in java.sql.
I have come to struggle with extracting a ...
0
votes
2
answers
177
views
Searchable database with Java and SQL
What does the code do?
Albeit unfinished (it does work, it's just not complete yet), the code creates a database (members.db) where telephone numbers, IDs, and ...
- 119
3
votes
1
answer
1k
views
Testing DAO Delete User
I have several Dao classes, including a UserDao, below. The DAOs have many methods, but I'm focussing on deleteUser:
...
- 63
1
vote
1
answer
94
views
I have a query like this that seems complicated and I want to do it by using Java Stream Api
I have method that fetches sorted and filtered data from Mysql Database, Firstly I had done It by using Java. Now I did it by Mysql but I don't like the way the code looks
I have entity that named ...
5
votes
3
answers
3k
views
Using static final Strings for SQL Query in Spring Boot
This is regarding code quality and coding standards with respect to Spring Ecosystem. Here there are two methods:
isRecordExists is using a class level static ...
- 191
4
votes
2
answers
129
views
MySQL JDBC integration into App from tutorial
I was following this tutorial for JavaFX and Gradle:
JavaFX with Gradle, Eclipse and, Scene Builder on OpenJDK11
After completion of the tutorial you will have a simple GUI which you input a lower ...
- 165
4
votes
3
answers
3k
views
Updating a huge hashmap from a resultset
I am using Java 7
Problem: I need to retrieve records from a database table based on a condition, orig_setting = 1. This query could return ~1000 records. Parameters from 1-7 of the Params object are ...
- 161
2
votes
0
answers
79
views
Library/API: simple springboot / jdbc query builder and ORM
I have been using and developing a simple ORM and query builder library that I have found useful in it's practical application. I am pretty sure there are improvements to be made, and I welcome any ...
- 121
5
votes
4
answers
375
views
Java methods to add and authenticate users in MySQL
I'm going through some code and trying to figure out how to get rid of duplicates from the following two methods. Both methods execute a simple login/register query to a local MySQL DB. I couldnt ...
- 83