ProcessDB实时/时序数据库——JAVA_API操作数据表对象

ProcessDB

已于 2022-12-12 14:47:48 修改

阅读量70

点赞数

分类专栏： # ProcessDB的JAVA开发接口文章标签： java 时序数据库物联网数据库开发 ProcessDB

于 2022-11-04 17:33:10 首次发布

本文链接：https://blog.csdn.net/sun_race/article/details/127663485

版权

ProcessDB的JAVA开发接口专栏收录该内容

16 篇文章 0 订阅

订阅专栏

一、数据表字段介绍

	 int     databaseId;//所属数据库ID

	 int     tableId;//数据表ID

     String  tableName;//数据表名称

	 boolean isReffer;//是否引用其他表

	 int     refferObjectId;//引用其他表ID

	 String  tableDesc; //数据表表述

     int     createrId; //创建表用户的ID

     int     createTime; //创建表时间

     int     timeout;//数据表超时时长(时间秒)

	 String  dbName;//所属数据库名称

二、新建数据表

import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBRoot;
import com.processdb.connection.DBase;
import com.processdb.driver.common.ConnectInfo;
import com.processdb.driver.common.TableInfo;
public class Test {
	 public static void main(String[] args) throws Exception
	    {
	    	ConnectInfo host = new ConnectInfo();
	    	host.setConnectName("instance01");
	    	host.setHostName("127.0.0.1");
	    	host.setHostPort(8301);
	    	host.setUserName("root");
	    	host.setPassword("root");
	    	host.setCacheable(false);
	    	DBConnect myConn = null;
			myConn = DBConnectManager.getInstance().getConnect(host);
            String databaseName = "D30";
			DBRoot root = DBRoot.getInstance(myConn);
            //该方法会创建一个表名和表id相同的表
			DBase dbase = root.getCachedDatabaseByName(databaseName);
			TableInfo talbeInfo01 = new TableInfo();
			talbeInfo01.setTableDesc("TEST");
			int res01 = dbase.addTableIdForName(talbeInfo01);
            //该方法会创建一个表信息与设定信息相同的表
			String tableName = "T31";
			TableInfo talbeInfo02 = new TableInfo();
			talbeInfo02.setTableName(tableName);
			talbeInfo02.setTableDesc("T31 TEST");
			int res02 = dbase.add(talbeInfo02);
			if (res01>=0&&res02>=0) {
				System.out.println("Create Table Success");
			}else {
				if (res01<0) {
					System.out.print("res01 Create Table failed! error Code:" + res01);
				}
				if (res02<0) {
					System.out.print("res02 Create Table failed! error Code:" + res02);
				}
			}
}}

三、删除数据表

import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBRoot;
import com.processdb.connection.DBase;
import com.processdb.driver.common.ConnectInfo;
public class Test {
	 public static void main(String[] args) throws Exception
	    {
	    	ConnectInfo host = new ConnectInfo();
	    	host.setConnectName("instance01");
	    	host.setHostName("127.0.0.1");
	    	host.setHostPort(8301);
	    	host.setUserName("root");
	    	host.setPassword("root");
	    	host.setCacheable(false);
	    	DBConnect myConn = null;
			myConn = DBConnectManager.getInstance().getConnect(host);
			String databaseName = "D30";
			DBRoot root = DBRoot.getInstance(myConn);
			DBase dbase = root.getCachedDatabaseByName(databaseName);
			String tableName = "T31";
			int res = dbase.delete(tableName);

			if(res != 0)
			{
				System.out.print("Delete Table failed, error code: " + res);
				return;
			}
			else
			{
				System.out.print("Delete Table success.");
			}

}}

四、修改数据表

import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBRoot;
import com.processdb.connection.DBase;
import com.processdb.driver.common.ConnectInfo;
import com.processdb.driver.common.TableInfo;
public class Test {
	 public static void main(String[] args) throws Exception
	    {
	    	ConnectInfo host = new ConnectInfo();
	    	host.setConnectName("instance01");
	    	host.setHostName("127.0.0.1");
	    	host.setHostPort(8301);
	    	host.setUserName("root");
	    	host.setPassword("root");
	    	host.setCacheable(false);
	    	DBConnect myConn = null;
			myConn = DBConnectManager.getInstance().getConnect(host);
	        DBRoot root = DBRoot.getInstance(myConn);
			String dbname ="D30";
			String tableName ="T31";
			DBase dBase = root.getCachedDatabaseByName(dbname);
			TableInfo tableInfo = dBase.getCachedTableByName(tableName).getTableInfo();
			tableInfo.setTableDesc("TEST UPDATE");
			int res = dBase.update(tableInfo);	
			if(res != 0)
			{
				System.out.print("Update Table failed, error code: " + res);
				return;
			}
			else
			{
				System.out.print("Update Table success.");
			}

}}

五、查询数据表

import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBRoot;
import com.processdb.connection.DBTable;
import com.processdb.driver.common.ConnectInfo;
public class Test {
	 public static void main(String[] args) throws Exception
	    {
	    	ConnectInfo host = new ConnectInfo();
	    	host.setConnectName("instance01");
	    	host.setHostName("127.0.0.1");
	    	host.setHostPort(8301);
	    	host.setUserName("root");
	    	host.setPassword("root");
	    	host.setCacheable(false);
	    	DBConnect myConn = null;
			myConn = DBConnectManager.getInstance().getConnect(host);
			DBRoot root = DBRoot.getInstance(myConn);
			String dbName = "PUBLIC";
			String tableName = "SYS";
		    DBTable table = 
            root.getCachedDatabaseByName(dbName).getCachedTableByName(tableName);
		    System.out.println("PUBLIC库下的SYS表的信息：");
			System.out.println("名称："+table.getName()+",ID："+table.getID()
            +",描述："+table.getDesc());
}}

示例运行结果：

PUBLIC库下的SYS表的信息：
名称：SYS,ID：10010001,描述：Cpu memroy and disk stat, read o

六、查询数据表列表

import java.util.Vector;
import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBRoot;
import com.processdb.connection.DBTable;
import com.processdb.connection.DBase;
import com.processdb.driver.common.ConnectInfo;
public class Test {
	 public static void main(String[] args) throws Exception
	    {
	    	ConnectInfo host = new ConnectInfo();
	    	host.setConnectName("instance01");
	    	host.setHostName("127.0.0.1");
	    	host.setHostPort(8301);
	    	host.setUserName("root");
	    	host.setPassword("root");
	    	host.setCacheable(false);
	    	DBConnect myConn = null;
			myConn = DBConnectManager.getInstance().getConnect(host);
            DBRoot root = DBRoot.getInstance(myConn);
			DBase dbase = root.getCachedDatabaseByName("PUBLIC");
			dbase.loadAllTable();
			Vector<DBTable> cachedTables = dbase.getCachedTables();
			System.out.println("PUBLIC数据库下的数据表：");
			for (DBTable dbTable : cachedTables) {
			System.out.println("名称："+dbTable.getName()+",数据表ID："+dbTable.getID()+",数据表描述："+dbTable.getDesc());
			}
}}

示例运行结果：

PUBLIC数据库下的数据表：
名称：HMI_DEMO,数据表ID：10010012,数据表描述：Demo, read and write
名称：CLUSTER,数据表ID：10010010,数据表描述：Cluster multi instances, read on
名称：OBJECT,数据表ID：10010004,数据表描述：Object stat, read only
名称：SESSION,数据表ID：10010003,数据表描述：Session stat, read only
名称：SYS,数据表ID：10010001,数据表描述：Cpu memroy and disk stat, read o
名称：IOT_METRICS,数据表ID：10010013,数据表描述：Iot metrics
名称：SAMPLE,数据表ID：10010011,数据表描述：Sample, read only
名称：JOB,数据表ID：10010002,数据表描述：Job and task stat, read only
名称：CACHE,数据表ID：10010006,数据表描述：Cache stat, read only
名称：STANDBY,数据表ID：10010008,数据表描述：Hot and backup, read only
名称：VIP,数据表ID：10010009,数据表描述：Virtual ip, read only
名称：LICENSE,数据表ID：10010014,数据表描述：License info
名称：STORAGE,数据表ID：10010005,数据表描述：Storage stat, read only
名称：IMAGE,数据表ID：10010007,数据表描述：Image object and data to other i