Java：H2数据库使用示例

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