官網(wǎng)
http://www.h2database.com/html/quickstart.html
SQL語句
https://www.cnblogs.com/h2-database/archive/2011/07/06/2581402.html
server服務(wù)式Demo
pom文件：

 <dependencies>
        <!-- Junit 依賴-->
        <dependency>
            <groupId>junit</groupId>    
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>

        <!--spring整合JDBC的依賴 -->
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <!--H2數(shù)據(jù)庫-->
        <!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <version>RELEASE</version>
            <scope>compile</scope>
        </dependency>
    </dependencies>

測(cè)試代碼：

import java.sql.*;

/**
 * Created by IntelliJ IDEA.
 *
 * @Author 愛笑的程序猿
 * @Description: Java通過JDBC方式連接H2數(shù)據(jù)庫
 * @Data: Created in  13:38
 */
public class H2ConnTest2 {

    //數(shù)據(jù)庫連接URL，通過使用TCP/IP的服務(wù)器模式（遠(yuǎn)程連接）
    private static final String JDBC_URL = "jdbc:h2:tcp://localhost/~/test";
    //連接數(shù)據(jù)庫時(shí)使用的用戶名
    private static final String USER = "sa";
    //連接數(shù)據(jù)庫時(shí)使用的密碼
    private static final String PASSWORD = "123";
    //連接H2數(shù)據(jù)庫時(shí)使用的驅(qū)動(dòng)類元旬，org.h2.Driver這個(gè)類是由H2數(shù)據(jù)庫自己提供的更胖，在H2數(shù)據(jù)庫的jar包中可以找到
    private static final String DRIVER_CLASS = "org.h2.Driver";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // 加載H2數(shù)據(jù)庫驅(qū)動(dòng)
        Class.forName(DRIVER_CLASS);
        // 根據(jù)連接URL，用戶名铃将，密碼獲取數(shù)據(jù)庫連接
        Connection conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);
        //如果存在USER_INFO表就先刪除USER_INFO表
        Statement stmt = conn.createStatement();
        //創(chuàng)建TEST表
        // stmt.execute("DROP IF EXISTS TABLE TEST");
        //新增
        stmt.executeUpdate("INSERT INTO TEST VALUES(3,'大日如來','男')");
        stmt.executeUpdate("INSERT INTO TEST VALUES(4,'青龍','男')");

//        //刪除
//        stmt.executeUpdate("DELETE FROM TEST WHERE name='大日如來'");
//        //修改
//        stmt.executeUpdate("UPDATE TEST SET name='孤傲蒼狼' WHERE name='青龍'");
        //查詢
        ResultSet rs = stmt.executeQuery("SELECT * FROM TEST");
        //遍歷結(jié)果集
        while (rs.next()) {
            System.out.println(rs.getString("id") + "," + rs.getString("name") + "," + rs.getString("sex"));
        }
        //釋放資源
        stmt.close();
        //關(guān)閉連接
        conn.close();
    }
}

————————————————
版權(quán)聲明：本文為CSDN博主「我是豐兒你是沙」的原創(chuàng)文章，遵循 CC 4.0 BY-SA 版權(quán)協(xié)議哑梳，轉(zhuǎn)載請(qǐng)附上原文出處鏈接及本聲明劲阎。
原文鏈接：https://blog.csdn.net/qq_43147136/article/details/86610093