Linux matlab mysql,Matlab连接MySQL、PostgreSQL。

首先，下载并按照驱动程序。

然后，edit classpath.txt，在最下面添加驱动程序的具体位置。

C:/Program Files/MATLAB/db_driver/mysql.jar

C:/Program Files/MATLAB/db_driver/pgsql.jar

使用方法：

For MySQL:

db_name        = 'db_name';

db_user_name   = 'db_user';

db_user_pass   = 'db_user_pass';

db_server_ip   = 'db_ip';

db_server_port = '3306';

url            = strcat('jdbc:mysql://', db_server_ip, ':', db_server_port, '/');

dbh            = database(db_name, db_user_name, db_user_pass, 'com.mysql.jdbc.Driver', url);

For PostgreSQL:

db_name        = 'db_name';

db_user_name   = 'db_user';

db_user_pass   = 'db_user_pass';

db_server_ip   = 'db_ip';

db_server_port = '5432';

url            = strcat('jdbc:postgresql://', db_server_ip, ':', db_server_port, '/');

dbh            = database(db_name, db_user_name, db_user_pass, 'org.postgresql.Driver', url);

阅读(811) | 评论(0) | 转发(0) |