SequoiaDB 巨杉数据库SDK驱动开发

SequoiaDB 巨杉数据库为应用提供通过SDK驱动进行数据库操作和集群操作的接口。目前支持SDK驱动开发的语言如下：

• C 驱动
• C++ 驱动
• CSharp 驱动
• JAVA 驱动
• PHP 驱动
• Python 驱动
• REST 驱动

JAVA SDK驱动开发

本章节以 JAVA SDK 驱动开发实现数据库增、删、改、查功能为例，本示例程序使用 Eclipse 工具开发，数据库用户名/密码默认为 sdbadmin，192.168.81.134 是数据库的服务IP，11810 端口是数据库协调节点的服务端口。

获取 JAVA 驱动开发包

从 SequoiaDB 巨杉数据库官网下载对应操作系统版本的 JAVA 驱动开发包；解压驱动开发包，从目录中获取 sequoiadb-driver.jar 文件。

配置 Eclipse 开发环境

1. 将 SequoiaDB 驱动开发包中的 sequoiadb-driver.jar 文件拷贝到工程文件目录下（建议将其放置在其他所有依赖库目录，如 lib 目录）

2. 在 Eclipse 界面中，创建/打开开发工程

3. 在 Eclipse 主窗口左侧的“Package Explore”窗口中，选择开发工程，并点击鼠标右键

4. 在菜单中选择“properties”菜单项

5. 在弹出的“property for project …”窗口中，选择“Java Build Path”->“Libraries”

6. 点击“Add External JARs…”按钮，选择添加 sequoiadb.jar 到工程中；

7. 点击“OK”完成环境配置。

连接数据库

package com.sequoiadb.util;

import com.sequoiadb.base.DBCursor;
import com.sequoiadb.base.Sequoiadb;
import com.sequoiadb.exception.BaseException;

public class Sample {
	public static void main(String[] args) {
        String connString = "192.168.81.134:11810";
        try {
        	// 建立 SequoiaDB 数据库连接
        	Sequoiadb sdb = new Sequoiadb(connString, "sdbadmin", "sdbadmin");
            // 获取所有 Collection 信息，并打印出来
            DBCursor cursor = sdb.listCollections();
            try {
                while(cursor.hasNext()) {
                    System.out.println(cursor.getNext());
                }
            } finally {
                cursor.close();
            }
        } catch (BaseException e) {
            System.out.println("Sequoiadb driver error, error description:" + e.getErrorType());
        }
    }
}

插入数据

package com.sequoiadb.util;

import org.bson.BSONObject;
import org.bson.BasicBSONObject;

import com.sequoiadb.base.CollectionSpace;
import com.sequoiadb.base.DBCollection;
import com.sequoiadb.base.Sequoiadb;
import com.sequoiadb.exception.BaseException;

public class Sample {
	public static void main(String[] args) {
        String connString = "192.168.81.134:11810";
        try {
            Sequoiadb sdb = new Sequoiadb(connString, "sdbadmin", "sdbadmin");
            //创建school集合空间
            CollectionSpace cs = sdb.createCollectionSpace("school");
            //创建student集合
            DBCollection cl = cs.createCollection("student");
            // 创建一个插入的 bson 对象
            BSONObject obj = new BasicBSONObject();
            obj.put("id", 1);
            obj.put("name", "tom");
            obj.put("age", 24);
            cl.insert(obj);
        } catch (BaseException e) {
            System.out.println("Sequoiadb driver error, error description:" + e.getErrorType());
        }
    }
}

查询数据

package com.sequoiadb.util;

import org.bson.BSONObject;
import org.bson.util.JSON;

import com.sequoiadb.base.CollectionSpace;
import com.sequoiadb.base.DBCollection;
import com.sequoiadb.base.DBCursor;
import com.sequoiadb.base.Sequoiadb;
import com.sequoiadb.exception.BaseException;

public class Sample {
	public static void main(String[] args) {
        String connString = "192.168.81.134:11810";
        // 定义一个游标对象
        DBCursor cursor = null;
        try {
            Sequoiadb sdb = new Sequoiadb(connString, "sdbadmin", "sdbadmin");
            //获取school集合空间对象
            CollectionSpace cs = sdb.getCollectionSpace("school");
            //获取student集合对象
            DBCollection cl = cs.getCollection("student");
            //查询id为1的记录
            BSONObject queryCondition = (BSONObject) JSON.parse("{id:1}");
            //查询所有记录，并把查询结果放在游标对象中
            cursor = cl.query(queryCondition, null, null, null);
            //从游标中显示所有记录
            try {
                while (cursor.hasNext()) {
                   BSONObject record = cursor.getNext();
                   String name = (String) record.get("name");
                   int age = (int) record.get("age");
                   System.out.println("name = " +  name);
                   System.out.println("age = " +  age);
                } 
            } finally {
            	if(cursor != null){
            		cursor.close();   
            	}
            }
        } catch (BaseException e) {
            System.out.println("Sequoiadb driver error, error description:" + e.getErrorType());
        }
    }
}

修改数据

package com.sequoiadb.util;

import org.bson.BSONObject;
import org.bson.util.JSON;

import com.sequoiadb.base.CollectionSpace;
import com.sequoiadb.base.DBCollection;
import com.sequoiadb.base.Sequoiadb;
import com.sequoiadb.exception.BaseException;

public class Sample {
	public static void main(String[] args) {
        String connString = "192.168.81.134:11810";
        try {
            Sequoiadb sdb = new Sequoiadb(connString, "sdbadmin", "sdbadmin");
            //获取school集合空间对象
            CollectionSpace cs = sdb.getCollectionSpace("school");
            //获取student集合对象
            DBCollection cl = cs.getCollection("student");
            //修改id为1记录的age值为30
            BSONObject queryCondition = (BSONObject) JSON.parse("{id:1}");
            BSONObject modifier = (BSONObject) JSON.parse("{$set:{age:30}}");
            cl.update(queryCondition, modifier, null);
        } catch (BaseException e) {
            System.out.println("Sequoiadb driver error, error description:" + e.getErrorType());
        }
    }
}

删除数据

package com.sequoiadb.util;

import org.bson.BSONObject;
import org.bson.util.JSON;

import com.sequoiadb.base.CollectionSpace;
import com.sequoiadb.base.DBCollection;
import com.sequoiadb.base.Sequoiadb;
import com.sequoiadb.exception.BaseException;

public class Sample {
	public static void main(String[] args) {
        String connString = "192.168.81.134:11810";
        try {
            Sequoiadb sdb = new Sequoiadb(connString, "sdbadmin", "sdbadmin");
            //获取school集合空间对象
            CollectionSpace cs = sdb.getCollectionSpace("school");
            //获取student集合对象
            DBCollection cl = cs.getCollection("student");
            //删除id为1记录
            BSONObject queryCondition = (BSONObject) JSON.parse("{id:1}");
            cl.delete(queryCondition);
        } catch (BaseException e) {
            System.out.println("Sequoiadb driver error, error description:" + e.getErrorType());
        }
    }
}

更多内容可查看巨杉数据库官网。