TUT - 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 based Java project from a command-line.

c:\projects> mvn archetype:generate -B -DgroupId=com.mytutorial -DartifactId=simple-persistence

1	c:\projects> mvn archetype:generate -B -DgroupId=com.

…

01a: ⏯ JDBC with MySQL Beginner Video Tutorial

[arve url=”https://player.vimeo.com/video/223617551″] 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…

Members Only Content

…

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>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>


        <!-- MySQL Driver -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>6.0.6</version>
        </dependency>

       <!-- Connection Pool -->
        <dependency>
            <groupId>org.apache.commons</groupId>

…

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…

Members Only Content

…

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);

}

package com.mytutorial.dao;

import java.

…

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…

Members Only Content

…

Blog Archives

01: JDBC with MySQL Beginner Tutorial Step by Step

01a: ⏯ JDBC with MySQL Beginner Video Tutorial

Members Only Content

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

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

Members Only Content

03: JDBC with MySQL and PreparedStatements Tutorial

JDBC Tutorial with HSQLDB

Members Only Content

800+ Java & Big Data Interview Q&As

200+ Java & Big Data Tutorials

Disclaimer