一、加载ProcessDB驱动
<dependency>
<groupId>com.processdb</groupId>
<artifactId>processdb_driver_v2.0</artifactId>
<version>2.0</version>
<scope>system</scope>
<systemPath>xxxx/WebContent/WEBINF/lib/processdb_driver_v2.0.jar</systemPath>
</dependency>
如果没有maven请直接安置jar包
二、配置数据库连接
ConnectInfo host = new ConnectInfo();
host.setConnectName("testConn");
host.setHostName("127.0.0.1");
host.setHostPort(8301);
host.setPassword("root");
host.setUserName("root");
DBConnect myConn = DBConnectManager.getInstance().getConnect(host);
如果myconn不为空,则证明数据库连接成功!
三、进行数据库操作
import java.util.Vector;
import com.processdb.connection.DBConnect;
import com.processdb.connection.DBConnectManager;
import com.processdb.connection.DBPoint;
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);
root.loadAllObjectFromDB();
DBTable table = root.getCachedDatabaseByName("PUBLIC").getCachedTableByName("SYS");
Vector<DBPoint> pointList = table.getCachedPoints();
System.out.println("PUBLIC库下的SYS表的字段名称:");
for (DBPoint dbPoint : pointList) {
System.out.println("名称:"+dbPoint.getName());
}
}}
示例运行结果:
PUBLIC库下的SYS表的字段名称:
名称:PDB_PROC_RUNNING_TIME
名称:PDB_PROC_CPU_USAGE
名称:PDB_OS_TYPE
名称:PDB_NET_WRITE_SPEED
名称:PDB_FREE_DISK
名称:PDB_PROC_MEM_USED
名称:PDB_AVAILABLE_DISK
名称:PDB_DISK_READ_SPEED
名称:PDB_OS_RUNNING_TIME
名称:PDB_PROC_THREAD_COUNT
名称:PDB_DISK_WRITE_SPEED
名称:PDB_NET_READ_SPEED
名称:PDB_HANDLE_COUNT
名称:PDB_OS_CPU_USAGE
名称:PDB_OS_MEM_USAGE