H2数据库的环境搭建

最新推荐文章于 2024-04-18 03:16:25 发布

嘿丷如歌

最新推荐文章于 2024-04-18 03:16:25 发布

阅读量807

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_35776392/article/details/100875808

版权

数据库专栏收录该内容

9 篇文章 1 订阅

订阅专栏

官网下载地址

运行h2.bat批处理程序启动H2数据库

JDBC链接H2

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

package com.ruge;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.UUID;

/**
 * 创建人 ：爱丽丝、如歌
 * 创建时间 ：2019-09-16  8:37
 * 描述 ：
 */
public class ConnH2 {
    private static final String JDBC_URL = "jdbc:h2:D:\\databases\\h2\\db\\ruge2";
    private static final String USER = "alice";
    private static final String PASSWORD = "ruge";
    private static final String DRIVER_CLASS = "org.h2.Driver";

    public static void main(String[] args) throws Exception {
        Class.forName(DRIVER_CLASS);
        // 根据连接URL，用户名，密码获取数据库连接
        Connection conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);
        Statement stmt = conn.createStatement();
        //如果存在USER_INFO表就先删除USER_INFO表
        stmt.execute("DROP TABLE IF EXISTS USER_INFO");
        //创建USER_INFO表
        stmt.execute("CREATE TABLE USER_INFO(id VARCHAR(36) PRIMARY KEY,name VARCHAR(100),sex VARCHAR(4))");
        //新增
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三1','男')");
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三2','男')");
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三3','男')");
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三4','女')");
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三5','男')");
        stmt.executeUpdate("INSERT INTO USER_INFO VALUES('" + UUID.randomUUID()+ "','张三6','男')");
        //删除
        stmt.executeUpdate("DELETE FROM USER_INFO WHERE name='张三6'");
        //修改
        stmt.executeUpdate("UPDATE USER_INFO SET name='张三55' WHERE name='张三5'");
        //查询
        ResultSet rs = stmt.executeQuery("SELECT * FROM USER_INFO");
        //遍历结果集
        while (rs.next()) {
            System.out.println(rs.getString("id") + "," + rs.getString("name")+ "," + rs.getString("sex"));
        }
        //释放资源
        stmt.close();
        //关闭连接
        conn.close();

    }
}

"D:\Program Files\Java\jdk-9.0.4\bin\java.exe" -javaagent:D:\JetBrains\Toolbox\apps\IDEA-U\ch-1\182.5262.2\lib\idea_rt.jar=11417:D:\JetBrains\Toolbox\apps\IDEA-U\ch-1\182.5262.2\bin -Dfile.encoding=UTF-8 -classpath "D:\pro_idea\rugebase\java-base\target\classes;D:\Program Files\vresionController\localRepository\org\springframework\boot\spring-boot-starter\2.1.1.RELEASE\spring-boot-starter-2.1.1.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\boot\spring-boot\2.1.1.RELEASE\spring-boot-2.1.1.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-context\5.1.3.RELEASE\spring-context-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-aop\5.1.3.RELEASE\spring-aop-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-beans\5.1.3.RELEASE\spring-beans-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-expression\5.1.3.RELEASE\spring-expression-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\boot\spring-boot-autoconfigure\2.1.1.RELEASE\spring-boot-autoconfigure-2.1.1.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\boot\spring-boot-starter-logging\2.1.1.RELEASE\spring-boot-starter-logging-2.1.1.RELEASE.jar;D:\Program Files\vresionController\localRepository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\Program Files\vresionController\localRepository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\Program Files\vresionController\localRepository\org\apache\logging\log4j\log4j-to-slf4j\2.11.1\log4j-to-slf4j-2.11.1.jar;D:\Program Files\vresionController\localRepository\org\apache\logging\log4j\log4j-api\2.11.1\log4j-api-2.11.1.jar;D:\Program Files\vresionController\localRepository\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\Program Files\vresionController\localRepository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-core\5.1.3.RELEASE\spring-core-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\springframework\spring-jcl\5.1.3.RELEASE\spring-jcl-5.1.3.RELEASE.jar;D:\Program Files\vresionController\localRepository\org\yaml\snakeyaml\1.23\snakeyaml-1.23.jar;D:\Program Files\vresionController\localRepository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\Program Files\vresionController\localRepository\junit\junit\4.12\junit-4.12.jar;D:\Program Files\vresionController\localRepository\org\apache\commons\commons-lang3\3.8.1\commons-lang3-3.8.1.jar;D:\Program Files\vresionController\localRepository\commons-io\commons-io\2.6\commons-io-2.6.jar;D:\Program Files\vresionController\localRepository\org\apache\commons\commons-collections4\4.2\commons-collections4-4.2.jar;D:\Program Files\vresionController\localRepository\org\apache\commons\commons-compress\1.18\commons-compress-1.18.jar;D:\Program Files\vresionController\localRepository\commons-dbutils\commons-dbutils\1.7\commons-dbutils-1.7.jar;D:\Program Files\vresionController\localRepository\org\apache\httpcomponents\httpclient\4.5.7\httpclient-4.5.7.jar;D:\Program Files\vresionController\localRepository\org\apache\httpcomponents\httpcore\4.4.10\httpcore-4.4.10.jar;D:\Program Files\vresionController\localRepository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;D:\Program Files\vresionController\localRepository\commons-beanutils\commons-beanutils\1.9.3\commons-beanutils-1.9.3.jar;D:\Program Files\vresionController\localRepository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;D:\Program Files\vresionController\localRepository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\Program Files\vresionController\localRepository\mysql\mysql-connector-java\8.0.13\mysql-connector-java-8.0.13.jar;D:\Program Files\vresionController\localRepository\org\projectlombok\lombok\1.18.4\lombok-1.18.4.jar;D:\Program Files\vresionController\localRepository\cn\hutool\hutool-all\4.4.5\hutool-all-4.4.5.jar;D:\Program Files\vresionController\localRepository\org\mybatis\mybatis\3.4.6\mybatis-3.4.6.jar;D:\Program Files\vresionController\localRepository\org\quartz-scheduler\quartz\2.3.0\quartz-2.3.0.jar;D:\Program Files\vresionController\localRepository\com\mchange\mchange-commons-java\0.2.11\mchange-commons-java-0.2.11.jar;D:\Program Files\vresionController\localRepository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\Program Files\vresionController\localRepository\joda-time\joda-time\2.10.1\joda-time-2.10.1.jar;D:\Program Files\vresionController\localRepository\com\h2database\h2\1.4.199\h2-1.4.199.jar" com.ruge.ConnH2
0f18bd5d-65cc-440f-af6a-7fdb987b21f2,张三1,男
2f959ae3-cc98-44f2-912a-d3298118da02,张三2,男
014a0bbb-dec8-444a-87be-bd14d6e05e41,张三3,男
ee08a75b-df66-41ca-8485-c75745784a01,张三4,女
a3773d72-29ee-4bd6-872c-f1d5e3cd9500,张三55,男

Process finished with exit code 0

嘿丷如歌

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
H2数据库的环境搭建

官网下载地址h2　　|---bin　　| |---h2-1.1.116.jar 　　//H2数据库的jar包（驱动也在里面）　　| |---h2.bat 　　 //Windows控制台启动脚本　　| |---h2.sh //Linux控制台启动脚本　　| |---h2w.bat /...
复制链接

扫一扫