JDBC方式访问图数据库 OrientDB

最新推荐文章于 2023-03-30 16:59:38 发布

修行修心

最新推荐文章于 2023-03-30 16:59:38 发布

阅读量1.7k

点赞数

分类专栏：图文章标签：图数据库 OrientDB JDBC

本文链接：https://blog.youkuaiyun.com/yitengtongweishi/article/details/82428301

版权

图专栏收录该内容

8 篇文章

订阅专栏

友情提示：图数据库 OrientDB 安装及初步使用

额外的Jar包

上官网下载 OrientDB JDBC 驱动

https://orientdb.com/download-2/，单击此链接，如下图所示
这里写图片描述
下载矩形方框中的驱动即可。

当然，官方也说了可以通过Maven来管理依赖，如下所示

<dependency>
<groupId>com.orientechnologies</groupId>
<artifactId>orientdb-client</artifactId>
<version>3.0.6</version>
</dependency>

但这种方式，笔者尝试过，会报错，还需要添加其他依赖。

测试

import com.orientechnologies.orient.jdbc.OrientJdbcConnection;

import java.sql.*;
import java.util.Properties;

/**
 * Created by Administrator on 2018/8/12 20:59 in Beijing.
 */

public class OrientDBJdbc {
    public static void main(String[] args) throws SQLException {
        /* declare admin credentials */
        Properties properties = new Properties();
        properties.put("user", "root");
        properties.put("password", "root");

        /* obtain a connection */
        Connection conn = (OrientJdbcConnection) DriverManager.getConnection("jdbc:orient:remote:localhost/graphdb", properties);

        /* perform a query */
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * from V");

        /* consume the resultset */
        while (rs.next()) {
            int vertexVersion = rs.getInt("@version");
            String vertexName = rs.getString("name");
            String vertexClass = rs.getString("@class");
            System.out.println("version=" + vertexVersion + ", name=" + vertexName + ", class=" + vertexClass);
        }

        rs.close();
        stmt.close();
        conn.close();
    }
}

输出

version=14, name=Bob, class=Vgraphx
version=5, name=David, class=Vgraphx
version=14, name=Charlie, class=Vgraphx
version=6, name=Esther, class=Vgraphx
version=5, name=Fanny, class=Vgraphx
version=3, name=Gabby, class=Vgraphx
version=8, name=Alice, class=Vgraphx