Matlab连接MySQL数据库入门

Borny鼎鼎

已于 2023-07-11 11:21:54 修改

阅读量2.8w

点赞数 1

分类专栏：其他文章标签： matlab

于 2016-12-29 15:26:46 首次发布

本文链接：https://blog.youkuaiyun.com/vinegar93/article/details/53928326

版权

其他专栏收录该内容

18 篇文章

订阅专栏

1、加载MySQL的jdbc驱动

（1）将mysql-connector-java-5.1.28-bin.jar拷贝到D:\Program Files\MATLAB\R2014a\java\jar\toolbox目录；

（2）打开D:\Program Files\MATLAB\R2014a\toolbox\local目录classpath.txt文件，添加用来加载MySQL的jdbc驱动语句，语句如下：

$matlabroot/java/jar/toolbox/mysql-connector-java-5.1.28-bin.jar

2、重启Matlab

3、获取连接对象

>> conn = database('hwd', 'root', '123456', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/hwd')
 
conn =
 
       Instance: 'hwd'
       UserName: 'root'
         Driver: 'com.mysql.jdbc.Driver'
            URL: 'jdbc:mysql://localhost:3306/hwd'
    Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
        Message: []
         Handle: [1x1 com.mysql.jdbc.JDBC4Connection]
        TimeOut: 0
     AutoCommit: 'on'
           Type: 'Database Object'

>>

4、执行SQL语言

（1）查询user表

>> curs = exec(conn, 'select * from user')
 
curs =
 
        Attributes: []
              Data: 0
    DatabaseObject: [1x1 database]
          RowLimit: 0
          SQLQuery: 'select * from user'
           Message: []
              Type: 'Database Cursor Object'
         ResultSet: [1x1 com.mysql.jdbc.JDBC4ResultSet]
            Cursor: [1x1 com.mathworks.toolbox.database.sqlExec]
         Statement: [1x1 com.mysql.jdbc.StatementImpl]
             Fetch: 0

>>

>> curs = fetch(curs)
 
curs =
 
        Attributes: []
              Data: {2x3 cell}
    DatabaseObject: [1x1 database]
          RowLimit: 0
          SQLQuery: 'select * from user'
           Message: []
              Type: 'Database Cursor Object'
         ResultSet: [1x1 com.mysql.jdbc.JDBC4ResultSet]
            Cursor: [1x1 com.mathworks.toolbox.database.sqlExec]
         Statement: [1x1 com.mysql.jdbc.StatementImpl]
             Fetch: [1x1 com.mathworks.toolbox.database.fetchTheData]

>>

（2）返回CELL

>> cur = curs.Data

cur = 

    [1]    'tom'      '123'
    [2]    'jerry'    '456'

>>

（3）取值

>> id = cur(1,1)

id = 

    [1]

>>