Skip to content

newfound-systems/JdbcExample

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

43 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

JDBC Insights for Beginners

Getting Started

Pre-Requisities

  • Basic understanding of Java and Database

Technologies

  • JDK 1.8 and above
  • Maven 3+ - Build Tool
  • SQLite - SQLite Database
  • H2 - H2 Database used for Connection Pool
  • Apache DbUtils - Third Party JDBC Wrapper API
  • Apache Log4j - Logging Framework
  • Lombok - Automate BoilerPlate Code

Topics

  • Introduction to Database and JDBC
  • Usage of SQLite and H2 Databases
  • SQL CRUD Process – Create Read Update Delete
  • Usage of log4j – Logging Framework
  • JDBC Connection Pool using HikariCP
  • Concepts to JPA with Spring JPA
  • Introduction to Database Trigger
  • Usage of Google Guava Cache for Static Data

Example(s)

  • CRUD Java Example using Non-Connection Pool using SQLite
  • Search Countries using Non-Connection Pool using SQLite
  • Search Countries using HikariCP Connection Pool using H2
  • Search Countries using Google Guava Cache
  • Ability to Persist Photo in bytes and read back.

References

Authors

Tasks

  • Finished changes
  • Baseline to GitHub
  • Published as Public Repository

Finally

  • 👍 Thanks for your time and Stay Safe! :shipit:

About

JDBC Example

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages