本文介绍了如何在没有matlabs数据库工具箱的情况下从matlab访问postgresql数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已尝试使用 pgmex 。不幸的是它不适用于libpq5(matlab立即崩溃)。
I tried already to use pgmex. Unfortunately it doesn't work with libpq5 (matlab immediately crashes).
推荐答案从matlab连接到postgres而不使用数据库工具箱类似于:
To connect to postgres from matlab without the database toolbox do something similar to:
% 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', '<your_postgres_username>'); props.setProperty('password', '<your_postgres_password>'); % Create the database connection (port 5432 is the default postgres chooses % on installation) driver=org.postgresql.Driver; url = 'jdbc:postgresql://<yourhost>:<yourport>\<yourdb>'; conn=driver.connect(url, props); % A test query sql='select * from <table>'; % 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更多推荐
如何在没有matlabs数据库工具箱的情况下从matlab访问postgresql数据库?
发布评论