<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.200</version>
</dependency>

package com.demo.h2;

import java.sql.*;

public class H2Demo {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        String url = "jdbc:h2:./database";
        String driverClass = "org.h2.Driver";

        Class.forName(driverClass);

        Connection connection = DriverManager.getConnection(url);


        Statement statement = connection.createStatement();

        // 创建数据表
        statement.execute("DROP TABLE IF EXISTS user");
        statement.execute("create table user(id int(11) primary key auto_increment, name varchar(20))");

        // 添加数据
        statement.executeUpdate("insert into user(name) values('刘备')");
        statement.executeUpdate("insert into user(name) values('关羽')");
        statement.executeUpdate("insert into user(name) values('张飞')");

        // 查询数据
        ResultSet resultSet = statement.executeQuery("select * from user");

        while (resultSet.next()){
            Integer id = resultSet.getInt("id");
            String name = resultSet.getString("name");

            System.out.println("id: " + id + ", name: " + name);
        }

        // 关闭链接
        resultSet.close();
        statement.close();
        connection.close();

    }
}