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

…

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 Overview Interview Questions and Answers….

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>

       <!--

…

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 Tutorial JDBC Interview Q&As 1. 12 FAQ JDBC interview questions and answers. 2. JDBC Overview Interview Questions and Answers…. …

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

…

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, write data to the database, and read data from the database. This is also known as the CRUD operations,… …

300+ Java Interview FAQs

200+ Java Key Areas FAQs

150+ Java Architect FAQs

150+ Java Coding FAQs

80+ Java Code Quality FAQs

300+ Big Data Interview FAQs

Big Data Tutorials

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

03: JDBC with MySQL and PreparedStatements Tutorial

JDBC Tutorial with HSQLDB

Java developer & architect Q&As

Big Data engineer Q&As

Java developers Q&As

Disclaimer