Java database connectivity (JDBC) is the JavaSoft specification of a standard application programming interface (API) that allows Java programs to access database management systems. The JDBC API consists of a set of interfaces and classes written in the Java programming language. Using these standard interfaces and classes, programmers can write applications that connect to databases, […]
Java JDBC PreparedStatement Example
Learn to execute JDBC PreparedStatement or parameterized statement to execute same or similar database statements repeatedly with high efficiency in java.
JDBC SQL DELETE Query Example
In previous posts, we have learned about types of JDBC drivers and the how to make database connection using JDBC and then how to execute SELECT Query, and then INSET Query example. Let’s move forward. In this example I am picking up execution of SQL DELETE queries using JDBC. SQL DELETE query are executed to […]
JDBC SQL INSERT Query Example
In previous posts, we have learned about types of JDBC drivers and the how to make database connection using JDBC and then how to execute SELECT Query. Let’s move forward. In this example I am picking up execution of SQL INSERT queries using JDBC. SQL INSERT query are executed to push/store data stored in relational […]
JDBC SELECT Query Example
In previous posts, we have learned about types of JDBC drivers and the how to make database connection using JDBC. Let’s move forward and start interacting with database. First example I am picking up is SQL SELECT queries. SQL SELECT query are executed to fetch data stored in relational databases. It requires following steps: 1) […]
Java – JDBC Connection Example (MySQL)
Learn to connect to MySQL database using java JDBC connectivity and how to load MySQL driver com.mysql.jdbc.Driver to open and close connection,
Java – JDBC Driver Types
There are 4 different types of java JDBC drivers i.e. JDBC-ODBC bridge driver, Native-API Driver, All Java Middleware translation driver, Pure Java driver.