How to insert a record using JDBC PreparedStatement
How to insert a new record using JDBC PreparedStatement in Java to avoid SQL injection. Example with auto-increment table.
How to create a table using JDBC Statement
How to create a new table from Java using JDBC Statement in simple steps: connect, get the statement, execute and close.
JDBC Statement vs PreparedStatement
JDBC Statement vs PreparedStatement with example. Comparison between around SQL Injection using SELECT query.
How to connect to MySQL with JDBC driver
How to connect to MySQL database with MySQL JDBC driver. Get a new connection using DriverManager class.
How to create Generic Object Pool in Java
In a application you can have resources that are limited or time consuming to create a new one. e.g. a connection to a database, a new thread. A solution is to create a the limited resource once and reuse it. To address this problem the object pool pattern was introduced. The object pool design will have the mechanism to create a new object to keep the objects and to destroy the objects if necessary.
How to create Singleton Design Pattern in Java
A design pattern is a general solution to a common problem. The singleton pattern is used to restricts the instantiation of a class to one single object.