How to update a record using JDBC PreparedStatement
How to update a record using JDBC PreparedStatement to avoid SQL injection.
How to select records using JDBC PreparedStatement
How to select records from MySQL database using JDBC PreparedStatement to avoid SQL injection.
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.