matlab连接sqlite，sqlite-jdbc jar包下载

最新推荐文章于 2023-02-08 19:05:00 发布

FANtastic_Y

最新推荐文章于 2023-02-08 19:05:00 发布

阅读量660

点赞数

分类专栏：算法文章标签： sqlite jar 数据库

本文链接：https://blog.csdn.net/FANtastic_Y/article/details/117675790

版权

算法专栏收录该内容

9 篇文章 0 订阅

订阅专栏

sqlite-jdbc jar包下载

https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc/3.34.0

matlab建立sqlite数据源

https://ww2.mathworks.cn/help/database/ug/sqlite-jdbc-windows.html

表格形式返回查询结果：

%% Automate Importing Data by Generating Code Using the Database Explorer App
% This code reproduces the data obtained using the Database Explorer app by
% connecting to a database, executing a SQL query, and importing data into the
% MATLAB(R) workspace. To use this code, add the password for connecting to the
% database in the database command.

% Auto-generated by MATLAB Version 9.4 (R2018a) and Database Toolbox Version 8.1 on 27-Aug-2021 22:03:16

%% Set preferences
prefs = setdbprefs('DataReturnFormat');
setdbprefs('DataReturnFormat','table')

%% Make connection to database
conn = database('','','','org.sqlite.JDBC','jdbc:sqlite:F:\databases\sonar.db');

%% Execute query and fetch results
curs = exec(conn,['SELECT count(time)' ...
    'FROM estimate_depths']);
curs = fetch(curs);
data = curs.Data;
close(curs)

%% Close connection to database
close(conn)

%% Restore preferences
setdbprefs('DataReturnFormat',prefs)

%% Clear variables
clear prefs conn curs