Tutorials - JDBC Archives | Java-Success.com

Blog Archives

01: JDBC with MySQL Beginner Tutorial Step by Step

This assumes that MySQL database is setup as per the tutorial Getting started with MySQL database beginner tutorial and ⏯ MySQL database beginner video tutorial.

Step 1: Create a maven …

01a: ⏯ JDBC with MySQL Beginner Video Tutorial

Related Links 1. JDBC with MySQL Beginner Tutorial Step by Step. Extends ⏯ MySQL database beginner video tutorial JDBC Interview Q&As 1. 12 FAQ JDBC interview questions and answers. 2. JDBC …

02: JDBC with MySQL, Datasource, and connection pool Tutorial

Step 1: pom.xml file with commons-dbcp2 for the connection pooling and abstraction layer for the datasource.

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.mytutorial</groupId>
    <artifactId>simple-persistence</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>simple-persistence</name>
    <url>http://maven.apache.org</url>

    <properties>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>

…

02a: ⏯ JDBC with MySQL, Datasource, Connection Pool, and Prepared Statements Video Tutorial

Related Links 1. JDBC with MySQL, Datasource, and connection pool Tutorial. 2. JDBC with MySQL and PreparedStatements Tutorial. Extends ⏯ MySQL database beginner video tutorial ▶ JDBC with MySQL Beginner Video …

03: JDBC with MySQL and PreparedStatements Tutorial

Step 1: Add an additional method to save data.

package com.mytutorial.dao;

import java.util.List;

import com.mytutorial.model.Account;

public interface AccountDao {
    
    public List<Account> getAccounts();
    
    public boolean saveAccount(Account account);

}

…

JDBC Tutorial with HSQLDB

This assumes that you have gone through the basic “SQL tutorial with HSQLDB”. This tutorial extends the SQL tutorial by using JDBC (Java Data Base Connectivity) to programmatically connect to the database, …