The post (“JDBC Select Records”) will give an example, and show how to select and parse records. Continue reading
Author Archives: James
JDBC Insert Records Using PreparedStatement
The post (“JDBC Insert Records Using PreparedStatement”) will give an example, and show how to add records using PreparedStatement. JDBC Prepared Statement is used to handle precompiled query. If you want to execute a Statement object many times, it usually reduces execution time to use a PreparedStatement object instead. Continue reading
JDBC Insert Records Using Statement
The post (“JDBC Insert Records Using Statement”) will give an example, and show how to insert records using JDBC. Continue reading
JDBC Drop Table
The post (“JDBC Drop Table”) will give an example, and show how to drop a table using JDBC. Continue reading
JDBC Create Table
The post (“JDBC Create Table”) will give an example, and show how to create a table using JDBC. Continue reading
JDBC Drop Database
The post (“JDBC Drop Database”) will give an example, and show how to drop a database using JDBC. Continue reading
JDBC Create Database
The post (“JDBC Create Database”) will give an example, and show how to create a database using JDBC. Continue reading
Get JDBC Connection
To get JDBC connection, normally there are two ways: 1. database driver manager 2. use data source Continue reading
JDBC by Examples
The Java Database Connectivity (JDBC) API is a collection of classes and interfaces, and is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases and other tabular data sources. Continue reading
Block IP Address on CentOS / Redhat
To block / unblock an IP address, you’d update iptables setting (root / sudoer only). Continue reading