如何在没有matlabs数据库工具箱的情况下从matlab访问Postgresql数据库？ - MATLAB爱好者论坛-LabFans.com

poster · 2019-12-10, 20:41

我已经尝试过使用pgmex 。不幸的是，它不适用于libpq5（matlab立即崩溃）。

回答：

要在没有数据库工具箱的情况下从matlab连接到postgres，请执行以下操作：

% Add jar file to classpath (ensure it is present in your current dir) javaclasspath('postgresql-9.0-801.jdbc4.jar'); % Username and password you chose when installing postgres props=java.util.Properties; props.setProperty('user', ''); props.setProperty('password', ''); % Create the database connection (port 5432 is the default postgres chooses % on installation) driver=org.postgresql.Driver; url = 'jdbc:postgresql://:\'; conn=driver.connect(url, props); % A test query sql='select * from '; % Gets all records ps=conn.prepareStatement(sql); rs=ps.executeQuery(); % Read the results into an array of result structs count=0; result=struct; while rs.next() count=count+1; result(count).var1=char(rs.getString(2)); result(count).var2=char(rs.getString(3)); ... end

更多&回答...

2019-12-10, 20:41	#1
poster 高级会员注册日期: 2019-11-21 帖子: 3,006 声望力: 66	如何在没有matlabs数据库工具箱的情况下从matlab访问Postgresql数据库？我已经尝试过使用pgmex 。不幸的是，它不适用于libpq5（matlab立即崩溃）。回答：要在没有数据库工具箱的情况下从matlab连接到postgres，请执行以下操作： % Add jar file to classpath (ensure it is present in your current dir) javaclasspath('postgresql-9.0-801.jdbc4.jar'); % Username and password you chose when installing postgres props=java.util.Properties; props.setProperty('user', ''); props.setProperty('password', ''); % Create the database connection (port 5432 is the default postgres chooses % on installation) driver=org.postgresql.Driver; url = 'jdbc:postgresql://:\'; conn=driver.connect(url, props); % A test query sql='select * from '; % Gets all records ps=conn.prepareStatement(sql); rs=ps.executeQuery(); % Read the results into an array of result structs count=0; result=struct; while rs.next() count=count+1; result(count).var1=char(rs.getString(2)); result(count).var2=char(rs.getString(3)); ... end 更多&回答...